{"id":18083,"date":"2019-03-30T21:06:48","date_gmt":"2019-03-31T00:06:48","guid":{"rendered":"https:\/\/orabr.com\/?p=18083"},"modified":"2019-03-31T09:39:02","modified_gmt":"2019-03-31T12:39:02","slug":"oracle-ebs-app-criar-lookup-via-pl-sql-backend","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=18083","title":{"rendered":"[ORACLE EBS\/APPS] CRIAR LOOKUP VIA PL\/SQL BACKEND"},"content":{"rendered":"\n

 fnd_lookup_types_pkg.insert_row\n(x_rowid                  => ln_rowid,                               \nx_lookup_type             => 'XXTEST',--Lookup Type\nx_security_group_id       => 0,       --Security Group Id\nx_view_application_id     => 0,       -- Application Id (0-AOL)\nx_application_id          => 0,       -- Application Id (0-AOL)\nx_customization_level     => 'U',     --User\nx_meaning                 => 'XXTEST',--Meaning for Lookup\nx_description             => 'XXTEST',--Description for Lookup\nx_creation_date           => SYSDATE,\nx_created_by              => -1,\nx_last_update_date        => SYSDATE,\nx_last_updated_by         => -1,\nx_last_update_login       => -1\n);\n\nfnd_lookup_values_pkg.insert_row\n (x_rowid                   => ln_rowid1,\n x_lookup_type              => 'XXTEST', \n x_security_group_id        => 0,\n x_view_application_id      => 0,\n x_lookup_code              => 'XXHR_INFO',\n x_tag                      => NULL,\n x_attribute_category       => NULL,\n x_attribute1               => NULL,\n x_attribute2               => NULL,\n x_attribute3               => NULL,\n x_attribute4               => NULL,\n x_enabled_flag             => 'Y',\n x_start_date_active        => TO_DATE ('01-JAN-1950','DD-MON-YYYY'),\n x_end_date_active          => NULL,\n x_territory_code           => NULL,\n x_attribute5               => NULL,\n x_attribute6               => NULL,\n x_attribute7               => NULL,\n x_attribute8               => NULL,\n x_attribute9               => NULL,\n x_attribute10              => NULL,\n x_attribute11              => NULL,\n x_attribute12              => NULL,\n x_attribute13              => NULL,\n x_attribute14              => NULL,\n x_attribute15              => NULL,\n x_meaning                  => 'XXHR Information',--Lookup Meaning\n x_description              => NULL,\n x_creation_date            => SYSDATE,\n x_created_by               => -1,\n x_last_update_date         => SYSDATE,\n x_last_updated_by          => -1,\n x_last_update_login        => -1\n );<\/code><\/pre>\n\n\n\n<\/figure>\n<\/HTML><\/HTML>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[],"class_list":["post-18083","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/18083","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=18083"}],"version-history":[{"count":5,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/18083\/revisions"}],"predecessor-version":[{"id":18090,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/18083\/revisions\/18090"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=18083"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=18083"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=18083"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}