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_INSTRUCTION_PVT dependencies on FND_TABLE_OF_VARCHAR2_255

Line 91: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,

87: -- the necessary context for definition
88: PROCEDURE CREATE_DEFN_CONTEXT
89: (
90: P_CURR_INSTR_PROCESS_ID IN NUMBER DEFAULT NULL,
91: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,
92: P_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
93: P_ENTITY_DISPLAYNAME IN FND_TABLE_OF_VARCHAR2_255,
94: P_INSTRUCTION_TYPE IN FND_TABLE_OF_VARCHAR2_255,
95: P_MODE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE_UPDATE,

Line 92: P_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,

88: PROCEDURE CREATE_DEFN_CONTEXT
89: (
90: P_CURR_INSTR_PROCESS_ID IN NUMBER DEFAULT NULL,
91: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,
92: P_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
93: P_ENTITY_DISPLAYNAME IN FND_TABLE_OF_VARCHAR2_255,
94: P_INSTRUCTION_TYPE IN FND_TABLE_OF_VARCHAR2_255,
95: P_MODE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE_UPDATE,
96: P_CONTEXT_PARAMETERS IN GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE,

Line 93: P_ENTITY_DISPLAYNAME IN FND_TABLE_OF_VARCHAR2_255,

89: (
90: P_CURR_INSTR_PROCESS_ID IN NUMBER DEFAULT NULL,
91: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,
92: P_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
93: P_ENTITY_DISPLAYNAME IN FND_TABLE_OF_VARCHAR2_255,
94: P_INSTRUCTION_TYPE IN FND_TABLE_OF_VARCHAR2_255,
95: P_MODE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE_UPDATE,
96: P_CONTEXT_PARAMETERS IN GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE,
97: X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER,

Line 94: P_INSTRUCTION_TYPE IN FND_TABLE_OF_VARCHAR2_255,

90: P_CURR_INSTR_PROCESS_ID IN NUMBER DEFAULT NULL,
91: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,
92: P_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
93: P_ENTITY_DISPLAYNAME IN FND_TABLE_OF_VARCHAR2_255,
94: P_INSTRUCTION_TYPE IN FND_TABLE_OF_VARCHAR2_255,
95: P_MODE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE_UPDATE,
96: P_CONTEXT_PARAMETERS IN GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE,
97: X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER,
98: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 745: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;

741: X_MSG_DATA OUT NOCOPY VARCHAR2
742: )
743: IS
744:
745: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
746: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
747: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
748: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
749:

Line 746: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;

742: )
743: IS
744:
745: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
746: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
747: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
748: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
749:
750: BEGIN

Line 747: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;

743: IS
744:
745: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
746: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
747: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
748: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
749:
750: BEGIN
751:

Line 748: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;

744:
745: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
746: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
747: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
748: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
749:
750: BEGIN
751:
752: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();

Line 752: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();

748: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
749:
750: BEGIN
751:
752: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
753: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
754: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
755: L_INSTRUCTION_TYPE := FND_TABLE_OF_VARCHAR2_255();
756:

Line 753: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();

749:
750: BEGIN
751:
752: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
753: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
754: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
755: L_INSTRUCTION_TYPE := FND_TABLE_OF_VARCHAR2_255();
756:
757: FOR J IN 1..P_INSTRUCTION_TYPE.count LOOP

Line 754: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();

750: BEGIN
751:
752: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
753: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
754: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
755: L_INSTRUCTION_TYPE := FND_TABLE_OF_VARCHAR2_255();
756:
757: FOR J IN 1..P_INSTRUCTION_TYPE.count LOOP
758: L_INSTRUCTION_TYPE.EXTEND;

Line 755: L_INSTRUCTION_TYPE := FND_TABLE_OF_VARCHAR2_255();

751:
752: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
753: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
754: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
755: L_INSTRUCTION_TYPE := FND_TABLE_OF_VARCHAR2_255();
756:
757: FOR J IN 1..P_INSTRUCTION_TYPE.count LOOP
758: L_INSTRUCTION_TYPE.EXTEND;
759: L_INSTRUCTION_TYPE(J) := P_INSTRUCTION_TYPE(J);

Line 814: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;

810: X_MSG_COUNT OUT NOCOPY NUMBER,
811: X_MSG_DATA OUT NOCOPY VARCHAR2
812: ) IS
813:
814: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
815: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
816: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
817: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
818:

Line 815: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;

811: X_MSG_DATA OUT NOCOPY VARCHAR2
812: ) IS
813:
814: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
815: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
816: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
817: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
818:
819: BEGIN

Line 816: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;

812: ) IS
813:
814: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
815: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
816: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
817: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
818:
819: BEGIN
820:

Line 817: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;

813:
814: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
815: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
816: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
817: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
818:
819: BEGIN
820:
821: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();

Line 821: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();

817: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
818:
819: BEGIN
820:
821: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
822: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
823: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
824: L_INSTRUCTION_TYPE := FND_TABLE_OF_VARCHAR2_255();
825:

Line 822: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();

818:
819: BEGIN
820:
821: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
822: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
823: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
824: L_INSTRUCTION_TYPE := FND_TABLE_OF_VARCHAR2_255();
825:
826: L_ENTITY_NAME.EXTEND;

Line 823: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();

819: BEGIN
820:
821: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
822: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
823: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
824: L_INSTRUCTION_TYPE := FND_TABLE_OF_VARCHAR2_255();
825:
826: L_ENTITY_NAME.EXTEND;
827: L_ENTITY_KEY.EXTEND;

Line 824: L_INSTRUCTION_TYPE := FND_TABLE_OF_VARCHAR2_255();

820:
821: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
822: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
823: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
824: L_INSTRUCTION_TYPE := FND_TABLE_OF_VARCHAR2_255();
825:
826: L_ENTITY_NAME.EXTEND;
827: L_ENTITY_KEY.EXTEND;
828: L_ENTITY_DISPLAYNAME.EXTEND;

Line 872: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;

868: )IS PRAGMA AUTONOMOUS_TRANSACTION;
869:
870: L_COUNT NUMBER;
871:
872: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
873: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
874: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
875: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
876: L_CONTEXT_PARAMETERS GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE;

Line 873: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;

869:
870: L_COUNT NUMBER;
871:
872: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
873: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
874: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
875: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
876: L_CONTEXT_PARAMETERS GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE;
877:

Line 874: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;

870: L_COUNT NUMBER;
871:
872: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
873: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
874: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
875: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
876: L_CONTEXT_PARAMETERS GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE;
877:
878: L_LOOKUP_TYPE VARCHAR2(300);

Line 875: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;

871:
872: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
873: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
874: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
875: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
876: L_CONTEXT_PARAMETERS GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE;
877:
878: L_LOOKUP_TYPE VARCHAR2(300);
879: L_LOOKUP_CODE VARCHAR2(300);

Line 891: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();

887: BEGIN
888:
889: L_API_NAME := 'DELETE_ENTITY_FOR_PROCESS';
890:
891: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
892: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
893: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
894:
895: FOR I IN 1..P_ENTITY_NAME.COUNT LOOP

Line 892: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();

888:
889: L_API_NAME := 'DELETE_ENTITY_FOR_PROCESS';
890:
891: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
892: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
893: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
894:
895: FOR I IN 1..P_ENTITY_NAME.COUNT LOOP
896: L_ENTITY_NAME.EXTEND;

Line 893: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();

889: L_API_NAME := 'DELETE_ENTITY_FOR_PROCESS';
890:
891: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
892: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
893: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
894:
895: FOR I IN 1..P_ENTITY_NAME.COUNT LOOP
896: L_ENTITY_NAME.EXTEND;
897: L_ENTITY_KEY.EXTEND;

Line 906: L_INSTRUCTION_TYPE := FND_TABLE_OF_VARCHAR2_255();

902: L_ENTITY_DISPLAYNAME(I) := '';
903: END LOOP;
904:
905: L_COUNT := 0;
906: L_INSTRUCTION_TYPE := FND_TABLE_OF_VARCHAR2_255();
907:
908: FOR I IN 1..P_ENTITY_NAME.COUNT LOOP
909:
910: L_LOOKUP_TYPE := P_ENTITY_NAME(I);

Line 1396: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,

1392: -- back to permenant tables
1393: PROCEDURE SEND_DEFN_ACKN
1394: (
1395: P_INSTRUCTION_PROCESS_ID IN NUMBER,
1396: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,
1397: P_SOURCE_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
1398: P_TARGET_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
1399: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1400: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 1397: P_SOURCE_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,

1393: PROCEDURE SEND_DEFN_ACKN
1394: (
1395: P_INSTRUCTION_PROCESS_ID IN NUMBER,
1396: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,
1397: P_SOURCE_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
1398: P_TARGET_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
1399: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1400: X_MSG_COUNT OUT NOCOPY NUMBER,
1401: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 1398: P_TARGET_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,

1394: (
1395: P_INSTRUCTION_PROCESS_ID IN NUMBER,
1396: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,
1397: P_SOURCE_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
1398: P_TARGET_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
1399: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1400: X_MSG_COUNT OUT NOCOPY NUMBER,
1401: X_MSG_DATA OUT NOCOPY VARCHAR2
1402: )

Line 1414: L_INSTRUCTION_TYPE_ARR FND_TABLE_OF_VARCHAR2_255;

1410: L_LAST_UPDATE_DATE DATE;
1411: L_LAST_UPDATED_BY NUMBER;
1412: L_LAST_UPDATE_LOGIN NUMBER;
1413:
1414: L_INSTRUCTION_TYPE_ARR FND_TABLE_OF_VARCHAR2_255;
1415: L_CNT NUMBER;
1416:
1417: L_ENTITY_NAME VARCHAR2(200);
1418: L_SOURCE_ENTITY_KEY VARCHAR2(1000);

Line 1488: L_ENTITY_NAME_ARR FND_TABLE_OF_VARCHAR2_255;

1484: L_TEMP_INSTR_DEFN_REC L_TEMP_INSTR_DEFN_CSR%ROWTYPE;
1485: L_TEMP_INSTR_APPR_DEFN_REC L_TEMP_INSTR_APPR_DEFN_CSR%ROWTYPE;
1486: L_TEMP_ENTITY_REC L_TEMP_ENTITY_CSR%ROWTYPE;
1487:
1488: L_ENTITY_NAME_ARR FND_TABLE_OF_VARCHAR2_255;
1489: L_SOURCE_ENTITY_KEY_ARR FND_TABLE_OF_VARCHAR2_255;
1490: L_TARGET_ENTITY_KEY_ARR FND_TABLE_OF_VARCHAR2_255;
1491: L_INSTRUCTION_TYPES FND_TABLE_OF_VARCHAR2_255;
1492:

Line 1489: L_SOURCE_ENTITY_KEY_ARR FND_TABLE_OF_VARCHAR2_255;

1485: L_TEMP_INSTR_APPR_DEFN_REC L_TEMP_INSTR_APPR_DEFN_CSR%ROWTYPE;
1486: L_TEMP_ENTITY_REC L_TEMP_ENTITY_CSR%ROWTYPE;
1487:
1488: L_ENTITY_NAME_ARR FND_TABLE_OF_VARCHAR2_255;
1489: L_SOURCE_ENTITY_KEY_ARR FND_TABLE_OF_VARCHAR2_255;
1490: L_TARGET_ENTITY_KEY_ARR FND_TABLE_OF_VARCHAR2_255;
1491: L_INSTRUCTION_TYPES FND_TABLE_OF_VARCHAR2_255;
1492:
1493: L_ENTITY_INFO_NOTFOUND_ERR EXCEPTION;

Line 1490: L_TARGET_ENTITY_KEY_ARR FND_TABLE_OF_VARCHAR2_255;

1486: L_TEMP_ENTITY_REC L_TEMP_ENTITY_CSR%ROWTYPE;
1487:
1488: L_ENTITY_NAME_ARR FND_TABLE_OF_VARCHAR2_255;
1489: L_SOURCE_ENTITY_KEY_ARR FND_TABLE_OF_VARCHAR2_255;
1490: L_TARGET_ENTITY_KEY_ARR FND_TABLE_OF_VARCHAR2_255;
1491: L_INSTRUCTION_TYPES FND_TABLE_OF_VARCHAR2_255;
1492:
1493: L_ENTITY_INFO_NOTFOUND_ERR EXCEPTION;
1494: L_INSTR_SEQ_COUNT NUMBER;

Line 1491: L_INSTRUCTION_TYPES FND_TABLE_OF_VARCHAR2_255;

1487:
1488: L_ENTITY_NAME_ARR FND_TABLE_OF_VARCHAR2_255;
1489: L_SOURCE_ENTITY_KEY_ARR FND_TABLE_OF_VARCHAR2_255;
1490: L_TARGET_ENTITY_KEY_ARR FND_TABLE_OF_VARCHAR2_255;
1491: L_INSTRUCTION_TYPES FND_TABLE_OF_VARCHAR2_255;
1492:
1493: L_ENTITY_INFO_NOTFOUND_ERR EXCEPTION;
1494: L_INSTR_SEQ_COUNT NUMBER;
1495:

Line 1537: L_SOURCE_ENTITY_KEY_ARR := FND_TABLE_OF_VARCHAR2_255();

1533: -- If P_SOURCE_ENTITY_NAME and P_SOURCE_ENTITY_KEY is null,
1534: -- Then construct it from GMO_INSTR_ATTRIBUTES_T table by querying
1535: -- entity name, entity key and instruction type values
1536:
1537: L_SOURCE_ENTITY_KEY_ARR := FND_TABLE_OF_VARCHAR2_255();
1538: L_INSTRUCTION_TYPE_ARR := FND_TABLE_OF_VARCHAR2_255();
1539: L_ENTITY_NAME_ARR := FND_TABLE_OF_VARCHAR2_255();
1540: L_TARGET_ENTITY_KEY_ARR := FND_TABLE_OF_VARCHAR2_255();
1541:

Line 1538: L_INSTRUCTION_TYPE_ARR := FND_TABLE_OF_VARCHAR2_255();

1534: -- Then construct it from GMO_INSTR_ATTRIBUTES_T table by querying
1535: -- entity name, entity key and instruction type values
1536:
1537: L_SOURCE_ENTITY_KEY_ARR := FND_TABLE_OF_VARCHAR2_255();
1538: L_INSTRUCTION_TYPE_ARR := FND_TABLE_OF_VARCHAR2_255();
1539: L_ENTITY_NAME_ARR := FND_TABLE_OF_VARCHAR2_255();
1540: L_TARGET_ENTITY_KEY_ARR := FND_TABLE_OF_VARCHAR2_255();
1541:
1542: -- check if entity information is passed or not

Line 1539: L_ENTITY_NAME_ARR := FND_TABLE_OF_VARCHAR2_255();

1535: -- entity name, entity key and instruction type values
1536:
1537: L_SOURCE_ENTITY_KEY_ARR := FND_TABLE_OF_VARCHAR2_255();
1538: L_INSTRUCTION_TYPE_ARR := FND_TABLE_OF_VARCHAR2_255();
1539: L_ENTITY_NAME_ARR := FND_TABLE_OF_VARCHAR2_255();
1540: L_TARGET_ENTITY_KEY_ARR := FND_TABLE_OF_VARCHAR2_255();
1541:
1542: -- check if entity information is passed or not
1543: -- if passed used the entity key else use the information from the

Line 1540: L_TARGET_ENTITY_KEY_ARR := FND_TABLE_OF_VARCHAR2_255();

1536:
1537: L_SOURCE_ENTITY_KEY_ARR := FND_TABLE_OF_VARCHAR2_255();
1538: L_INSTRUCTION_TYPE_ARR := FND_TABLE_OF_VARCHAR2_255();
1539: L_ENTITY_NAME_ARR := FND_TABLE_OF_VARCHAR2_255();
1540: L_TARGET_ENTITY_KEY_ARR := FND_TABLE_OF_VARCHAR2_255();
1541:
1542: -- check if entity information is passed or not
1543: -- if passed used the entity key else use the information from the
1544: -- temp table.

Line 1622: L_INSTRUCTION_TYPES := FND_TABLE_OF_VARCHAR2_255();

1618:
1619:
1620: -- This is comma seperated set of instruction types
1621: L_INSTRUCTION_TYPE := L_INSTRUCTION_TYPE_ARR(I);
1622: L_INSTRUCTION_TYPES := FND_TABLE_OF_VARCHAR2_255();
1623: L_INSTRUCTION_TYPES.EXTEND;
1624:
1625: --Instruction Types must be a comma seperated String value
1626: IF(INSTR(L_INSTRUCTION_TYPE,',') > 0) THEN

Line 2177: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;

2173: X_MSG_COUNT OUT NOCOPY NUMBER,
2174: X_MSG_DATA OUT NOCOPY VARCHAR2
2175: )
2176: IS
2177: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
2178: L_SOURCE_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
2179: L_TARGET_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
2180:
2181: BEGIN

Line 2178: L_SOURCE_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;

2174: X_MSG_DATA OUT NOCOPY VARCHAR2
2175: )
2176: IS
2177: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
2178: L_SOURCE_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
2179: L_TARGET_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
2180:
2181: BEGIN
2182:

Line 2179: L_TARGET_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;

2175: )
2176: IS
2177: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
2178: L_SOURCE_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
2179: L_TARGET_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
2180:
2181: BEGIN
2182:
2183: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();

Line 2183: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();

2179: L_TARGET_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
2180:
2181: BEGIN
2182:
2183: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
2184: L_SOURCE_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
2185: L_TARGET_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
2186:
2187: L_ENTITY_NAME.EXTEND;

Line 2184: L_SOURCE_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();

2180:
2181: BEGIN
2182:
2183: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
2184: L_SOURCE_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
2185: L_TARGET_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
2186:
2187: L_ENTITY_NAME.EXTEND;
2188: L_SOURCE_ENTITY_KEY.EXTEND;

Line 2185: L_TARGET_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();

2181: BEGIN
2182:
2183: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
2184: L_SOURCE_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
2185: L_TARGET_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
2186:
2187: L_ENTITY_NAME.EXTEND;
2188: L_SOURCE_ENTITY_KEY.EXTEND;
2189: L_TARGET_ENTITY_KEY.EXTEND;

Line 2223: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;

2219: X_MSG_DATA OUT NOCOPY VARCHAR2
2220: )
2221: IS
2222:
2223: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
2224: L_SOURCE_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
2225: L_TARGET_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
2226:
2227: BEGIN

Line 2224: L_SOURCE_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;

2220: )
2221: IS
2222:
2223: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
2224: L_SOURCE_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
2225: L_TARGET_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
2226:
2227: BEGIN
2228:

Line 2225: L_TARGET_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;

2221: IS
2222:
2223: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
2224: L_SOURCE_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
2225: L_TARGET_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
2226:
2227: BEGIN
2228:
2229: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();

Line 2229: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();

2225: L_TARGET_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
2226:
2227: BEGIN
2228:
2229: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
2230: L_SOURCE_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
2231: L_TARGET_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
2232:
2233:

Line 2230: L_SOURCE_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();

2226:
2227: BEGIN
2228:
2229: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
2230: L_SOURCE_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
2231: L_TARGET_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
2232:
2233:
2234: FOR I IN 1..P_ENTITY_NAME.COUNT LOOP

Line 2231: L_TARGET_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();

2227: BEGIN
2228:
2229: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
2230: L_SOURCE_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
2231: L_TARGET_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
2232:
2233:
2234: FOR I IN 1..P_ENTITY_NAME.COUNT LOOP
2235:

Line 4003: P_TASK_ERECORD_ID IN FND_TABLE_OF_VARCHAR2_255,

3999: (
4000: P_INSTRUCTION_ID IN NUMBER,
4001: P_INSTRUCTION_PROCESS_ID IN NUMBER,
4002: P_ENTITY_KEY IN VARCHAR2 DEFAULT NULL,
4003: P_TASK_ERECORD_ID IN FND_TABLE_OF_VARCHAR2_255,
4004: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,
4005: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,
4006: P_DISABLE_TASK IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.NO,
4007: P_MANUAL_ENTRY IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.NO,

Line 4004: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,

4000: P_INSTRUCTION_ID IN NUMBER,
4001: P_INSTRUCTION_PROCESS_ID IN NUMBER,
4002: P_ENTITY_KEY IN VARCHAR2 DEFAULT NULL,
4003: P_TASK_ERECORD_ID IN FND_TABLE_OF_VARCHAR2_255,
4004: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,
4005: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,
4006: P_DISABLE_TASK IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.NO,
4007: P_MANUAL_ENTRY IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.NO,
4008: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 4005: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,

4001: P_INSTRUCTION_PROCESS_ID IN NUMBER,
4002: P_ENTITY_KEY IN VARCHAR2 DEFAULT NULL,
4003: P_TASK_ERECORD_ID IN FND_TABLE_OF_VARCHAR2_255,
4004: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,
4005: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,
4006: P_DISABLE_TASK IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.NO,
4007: P_MANUAL_ENTRY IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.NO,
4008: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
4009: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 4991: P_CONTEXT_PARAM_NAME IN FND_TABLE_OF_VARCHAR2_255,

4987: (
4988: P_ENTITY_NAME IN VARCHAR2,
4989: P_ENTITY_KEY IN VARCHAR2,
4990: P_INSTRUCTION_TYPE IN VARCHAR2,
4991: P_CONTEXT_PARAM_NAME IN FND_TABLE_OF_VARCHAR2_255,
4992: P_CONTEXT_PARAM_VALUE IN FND_TABLE_OF_VARCHAR2_255,
4993: X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER,
4994: X_INSTRUCTION_SET_ID OUT NOCOPY NUMBER,
4995: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 4992: P_CONTEXT_PARAM_VALUE IN FND_TABLE_OF_VARCHAR2_255,

4988: P_ENTITY_NAME IN VARCHAR2,
4989: P_ENTITY_KEY IN VARCHAR2,
4990: P_INSTRUCTION_TYPE IN VARCHAR2,
4991: P_CONTEXT_PARAM_NAME IN FND_TABLE_OF_VARCHAR2_255,
4992: P_CONTEXT_PARAM_VALUE IN FND_TABLE_OF_VARCHAR2_255,
4993: X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER,
4994: X_INSTRUCTION_SET_ID OUT NOCOPY NUMBER,
4995: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
4996: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 5253: P_CONTEXT_PARAM_NAME IN FND_TABLE_OF_VARCHAR2_255,

5249:
5250: PROCEDURE CREATE_INSTANCE_CONTEXT
5251: (
5252: P_INSTRUCTION_SET_ID IN NUMBER,
5253: P_CONTEXT_PARAM_NAME IN FND_TABLE_OF_VARCHAR2_255,
5254: P_CONTEXT_PARAM_VALUE IN FND_TABLE_OF_VARCHAR2_255,
5255: X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER,
5256: X_ENTITY_NAME OUT NOCOPY VARCHAR2,
5257: X_ENTITY_KEY OUT NOCOPY VARCHAR2,

Line 5254: P_CONTEXT_PARAM_VALUE IN FND_TABLE_OF_VARCHAR2_255,

5250: PROCEDURE CREATE_INSTANCE_CONTEXT
5251: (
5252: P_INSTRUCTION_SET_ID IN NUMBER,
5253: P_CONTEXT_PARAM_NAME IN FND_TABLE_OF_VARCHAR2_255,
5254: P_CONTEXT_PARAM_VALUE IN FND_TABLE_OF_VARCHAR2_255,
5255: X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER,
5256: X_ENTITY_NAME OUT NOCOPY VARCHAR2,
5257: X_ENTITY_KEY OUT NOCOPY VARCHAR2,
5258: X_INSTRUCTION_TYPE OUT NOCOPY VARCHAR2,

Line 5748: P_TASK_ERECORD_ID IN FND_TABLE_OF_VARCHAR2_255,

5744: -- Returns Y or N based on E-record Id validity
5745:
5746: PROCEDURE VALIDATE_TASK_ERECORD_ID
5747: (
5748: P_TASK_ERECORD_ID IN FND_TABLE_OF_VARCHAR2_255,
5749: X_ERECORD_ID_INVALID OUT NOCOPY VARCHAR2,
5750: X_ERECORD_LIST_STR OUT NOCOPY VARCHAR2,
5751: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5752: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 5905: P_ATTRIBUTE_NAME IN FND_TABLE_OF_VARCHAR2_255,

5901:
5902: FUNCTION SET_PROCESS_ATTRIBUTES
5903: (
5904: P_INSTRUCTION_PROCESS_ID IN NUMBER,
5905: P_ATTRIBUTE_NAME IN FND_TABLE_OF_VARCHAR2_255,
5906: P_ATTRIBUTE_VALUE IN FND_TABLE_OF_VARCHAR2_255,
5907: P_ATTRIBUTE_TYPE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_PARAM_INTERNAL
5908: )
5909: RETURN VARCHAR2

Line 5906: P_ATTRIBUTE_VALUE IN FND_TABLE_OF_VARCHAR2_255,

5902: FUNCTION SET_PROCESS_ATTRIBUTES
5903: (
5904: P_INSTRUCTION_PROCESS_ID IN NUMBER,
5905: P_ATTRIBUTE_NAME IN FND_TABLE_OF_VARCHAR2_255,
5906: P_ATTRIBUTE_VALUE IN FND_TABLE_OF_VARCHAR2_255,
5907: P_ATTRIBUTE_TYPE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_PARAM_INTERNAL
5908: )
5909: RETURN VARCHAR2
5910: IS

Line 5982: P_INSTRUCTIONS IN FND_TABLE_OF_VARCHAR2_255,

5978: P_INSTRUCTION_PROCESS_ID IN NUMBER,
5979: P_INSTRUCTION_SET_ID IN NUMBER,
5980: P_INSTRUCTION_ID IN NUMBER,
5981: P_ADD_MODE IN VARCHAR2,
5982: P_INSTRUCTIONS IN FND_TABLE_OF_VARCHAR2_255,
5983: P_INSTRUCTION_NOS IN FND_TABLE_OF_VARCHAR2_255,
5984: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5985: X_MSG_COUNT OUT NOCOPY NUMBER,
5986: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 5983: P_INSTRUCTION_NOS IN FND_TABLE_OF_VARCHAR2_255,

5979: P_INSTRUCTION_SET_ID IN NUMBER,
5980: P_INSTRUCTION_ID IN NUMBER,
5981: P_ADD_MODE IN VARCHAR2,
5982: P_INSTRUCTIONS IN FND_TABLE_OF_VARCHAR2_255,
5983: P_INSTRUCTION_NOS IN FND_TABLE_OF_VARCHAR2_255,
5984: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5985: X_MSG_COUNT OUT NOCOPY NUMBER,
5986: X_MSG_DATA OUT NOCOPY VARCHAR2
5987: )