APPS.GMO_DISPENSE_SETUP_PVT dependencies on GMO_DISPENSE_CONFIG_INST

Line 847: FROM GMO_DISPENSE_CONFIG_INST

843:
844: X_INSTRUCTION_DEFINITION_KEY := NULL;
845:
846: SELECT DISPENSE_CONFIG_ID INTO L_DISPENSE_CONFIG_ID
847: FROM GMO_DISPENSE_CONFIG_INST
848: WHERE ENTITY_NAME = P_ENTITY_NAME
849: AND ENTITY_KEY = P_ENTITY_KEY;
850:
851: IF L_DISPENSE_CONFIG_ID IS NOT NULL THEN

Line 916: INSERT INTO GMO_DISPENSE_CONFIG_INST(INSTANCE_ID,

912: FROM GMO_DISPENSE_CONFIG
913: WHERE CONFIG_ID = P_DISPENSE_CONFIG_ID;
914:
915: IF L_COUNT > 0 THEN
916: INSERT INTO GMO_DISPENSE_CONFIG_INST(INSTANCE_ID,
917: DISPENSE_CONFIG_ID,
918: ENTITY_NAME,
919: ENTITY_KEY,
920: CREATION_DATE,

Line 926: VALUES (GMO_DISPENSE_CONFIG_INST_S.NEXTVAL,

922: LAST_UPDATE_DATE,
923: LAST_UPDATED_BY,
924: LAST_UPDATE_LOGIN)
925:
926: VALUES (GMO_DISPENSE_CONFIG_INST_S.NEXTVAL,
927: P_DISPENSE_CONFIG_ID,
928: P_ENTITY_NAME,
929: P_ENTITY_KEY,
930: SYSDATE,

Line 1033: INSERT INTO GMO_DISPENSE_CONFIG_INST(INSTANCE_ID,

1029: FROM GMO_DISPENSE_CONFIG
1030: WHERE CONFIG_ID = P_DISPENSE_CONFIG_ID;
1031:
1032: IF L_COUNT > 0 THEN
1033: INSERT INTO GMO_DISPENSE_CONFIG_INST(INSTANCE_ID,
1034: DISPENSE_CONFIG_ID,
1035: ENTITY_NAME,
1036: ENTITY_KEY,
1037: CREATION_DATE,

Line 1043: VALUES (GMO_DISPENSE_CONFIG_INST_S.NEXTVAL,

1039: LAST_UPDATE_DATE,
1040: LAST_UPDATED_BY,
1041: LAST_UPDATE_LOGIN)
1042:
1043: VALUES (GMO_DISPENSE_CONFIG_INST_S.NEXTVAL,
1044: P_DISPENSE_CONFIG_ID,
1045: P_ENTITY_NAME,
1046: P_ENTITY_KEY,
1047: SYSDATE,