DBA Data[Home] [Help]

APPS.INVUPD2B dependencies on FND_API

Line 5793: filter on template_id to exclude both -1 and FND_API.G_MISS_NUM */

5789: */
5790: -- added this to copy assignment for successfull records and having template id
5791:
5792: /* Fix for bug 11654417 - In the below cursor, modified the
5793: filter on template_id to exclude both -1 and FND_API.G_MISS_NUM */
5794: CURSOR copy_assignment_frm_temp IS
5795: SELECT inventory_item_id,organization_id,template_id
5796: FROM MTL_SYSTEM_ITEMS_INTERFACE
5797: where process_flag =4

Line 5800: AND template_id NOT IN (-1,FND_API.G_MISS_NUM)

5796: FROM MTL_SYSTEM_ITEMS_INTERFACE
5797: where process_flag =4
5798: and transaction_type in ('UPDATE','AUTO_CHILD')
5799: AND template_id IS NOT NULL
5800: AND template_id NOT IN (-1,FND_API.G_MISS_NUM)
5801: and (set_process_id = xset_id or set_process_id = xset_id + 1000000000000);
5802:
5803: x_ret_sts VARCHAR(1);
5804: