eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMO_DISPENSE_SETUP_PVT dependencies on GMO_DISPENSE_CONFIG

Line 570: X_DISPENSE_CONFIG OUT NOCOPY GMO_DISPENSE_CONFIG%ROWTYPE,

566: (
567: P_INVENTORY_ITEM_ID IN NUMBER,
568: P_ORGANIZATION_ID IN NUMBER,
569: P_RECIPE_ID IN NUMBER,
570: X_DISPENSE_CONFIG OUT NOCOPY GMO_DISPENSE_CONFIG%ROWTYPE,
571: X_INSTRUCTION_DEFINITION_KEY OUT NOCOPY VARCHAR2
572: )
573:
574: IS

Line 583: FROM GMO_DISPENSE_CONFIG

579:
580: --Obtain the dispense configuration for the case where both organization and recipe are specified.
581: BEGIN
582: SELECT * INTO X_DISPENSE_CONFIG
583: FROM GMO_DISPENSE_CONFIG
584: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
585: AND ORGANIZATION_ID = P_ORGANIZATION_ID
586: AND RECIPE_ID = P_RECIPE_ID
587: AND DISPENSE_REQUIRED_FLAG = 'Y'

Line 608: FROM GMO_DISPENSE_CONFIG

604:
605: --Obtain the dispense configuration for the case where organization is specified, but recipe is null.
606: BEGIN
607: SELECT * INTO X_DISPENSE_CONFIG
608: FROM GMO_DISPENSE_CONFIG
609: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
610: AND ORGANIZATION_ID=P_ORGANIZATION_ID
611: AND DISPENSE_REQUIRED_FLAG = 'Y'
612: AND RECIPE_ID IS NULL

Line 632: FROM GMO_DISPENSE_CONFIG

628:
629: --Obtain the dispense configuration for the case where organization and recipe is null.
630: BEGIN
631: SELECT * INTO X_DISPENSE_CONFIG
632: FROM GMO_DISPENSE_CONFIG
633: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
634: AND DISPENSE_REQUIRED_FLAG = 'Y'
635: AND ORGANIZATION_ID IS NULL
636: AND RECIPE_ID IS NULL

Line 669: L_DISPENSE_CONFIG GMO_DISPENSE_CONFIG%ROWTYPE;

665: --This variable would hold the dispense uom value.
666: L_RETURN_VALUE VARCHAR2(240);
667:
668: --This variable would hold the dispense configuration details for the specified item, organization and recipe.
669: L_DISPENSE_CONFIG GMO_DISPENSE_CONFIG%ROWTYPE;
670:
671: --This variable sould hold the instruction key.
672: L_INSTRUCTION_KEY VARCHAR2(240);
673: BEGIN

Line 769: FROM GMO_DISPENSE_CONFIG

765: --Obtain the value of the dispense required flag for the case where organization and recipe are specified.
766: BEGIN
767: SELECT DISPENSE_REQUIRED_FLAG,CONFIG_ID
768: INTO X_IS_DISPENSE_REQUIRED,X_DISPENSE_CONFIG_ID
769: FROM GMO_DISPENSE_CONFIG
770: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
771: AND ORGANIZATION_ID=P_ORGANIZATION_ID
772: AND RECIPE_ID=P_RECIPE_ID
773: AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE,SYSDATE);

Line 790: FROM GMO_DISPENSE_CONFIG

786: --Obtain the value of the dispense required flag for the case where organization is specified, but recipe is null.
787: BEGIN
788: SELECT DISPENSE_REQUIRED_FLAG,CONFIG_ID
789: INTO X_IS_DISPENSE_REQUIRED,X_DISPENSE_CONFIG_ID
790: FROM GMO_DISPENSE_CONFIG
791: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
792: AND ORGANIZATION_ID=P_ORGANIZATION_ID
793: AND RECIPE_ID IS NULL
794: AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE,SYSDATE);

Line 811: FROM GMO_DISPENSE_CONFIG

807: --Obtain the value of the dispense required flag for the case where both organization and recipe are null.
808: BEGIN
809: SELECT DISPENSE_REQUIRED_FLAG,CONFIG_ID
810: INTO X_IS_DISPENSE_REQUIRED,X_DISPENSE_CONFIG_ID
811: FROM GMO_DISPENSE_CONFIG
812: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
813: AND ORGANIZATION_ID IS NULL
814: AND RECIPE_ID IS NULL
815: AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE,SYSDATE);

Line 835: X_DISPENSE_CONFIG OUT NOCOPY GMO_DISPENSE_CONFIG%ROWTYPE,

831: PROCEDURE GET_DISPENSE_CONFIG_INST
832: (
833: P_ENTITY_NAME IN VARCHAR2,
834: P_ENTITY_KEY IN VARCHAR2,
835: X_DISPENSE_CONFIG OUT NOCOPY GMO_DISPENSE_CONFIG%ROWTYPE,
836: X_INSTRUCTION_DEFINITION_KEY OUT NOCOPY VARCHAR2
837: )
838: IS
839:

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 852: SELECT * INTO X_DISPENSE_CONFIG FROM GMO_DISPENSE_CONFIG

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
852: SELECT * INTO X_DISPENSE_CONFIG FROM GMO_DISPENSE_CONFIG
853: WHERE CONFIG_ID = L_DISPENSE_CONFIG_ID;
854:
855: IF (X_DISPENSE_CONFIG.CONFIG_ID IS NOT NULL) THEN
856:

Line 912: FROM GMO_DISPENSE_CONFIG

908: X_MSG_DATA => X_MSG_DATA);
909: ELSE
910: --Check if a dispense setup exists for the specified config ID.
911: SELECT COUNT(*) INTO L_COUNT
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,

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 1029: FROM GMO_DISPENSE_CONFIG

1025: END IF;
1026:
1027: --Check if a dispense setup exists for the specified config ID.
1028: SELECT COUNT(*) INTO L_COUNT
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,

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,