DBA Data[Home] [Help]

APPS.GMF_VIB dependencies on GMF_LAYER_ID_S

Line 2053: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;

2049:
2050: BEGIN
2051:
2052: -- Create a pseudo product layer in the gmf_incoming_material_layers table.
2053: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;
2054:
2055:
2056: INSERT INTO gmf_incoming_material_layers(
2057: layer_id,

Line 2237: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;

2233: -- End bug 5607069
2234:
2235: IF l_pseudo_prod_layer_id IS NULL THEN
2236: -- Create a pseudo product layer in the gmf_incoming_material_layers table.
2237: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;
2238:
2239: INSERT INTO gmf_incoming_material_layers(
2240: layer_id,
2241: mmt_transaction_id,

Line 2428: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;

2424:
2425: IF l_pseudo_prod_layer_id IS NULL THEN
2426: -- Create a pseudo product layer in the gmf_incoming_material_layers table.
2427: -- Bug 6887598 mmt_organization_id should not be NULL
2428: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;
2429: INSERT INTO gmf_incoming_material_layers(
2430: layer_id,
2431: mmt_transaction_id,
2432: mmt_organization_id, -- B6887598