DBA Data[Home] [Help]

APPS.GMO_INSTRUCTION_PVT dependencies on GMO_DATATYPES_GRP

Line 96: P_CONTEXT_PARAMETERS IN GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE,

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,
99: X_MSG_COUNT OUT NOCOPY NUMBER,
100: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 123: L_PARAM_REC1 GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_REC_TYPE;

119:
120: L_MODE_PARAM_ERR EXCEPTION;
121: L_DUPLICATE_PARAM_ERR EXCEPTION;
122:
123: L_PARAM_REC1 GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_REC_TYPE;
124: L_PARAM_REC2 GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_REC_TYPE;
125:
126: L_PARAM_NAME1 VARCHAR2(100);
127: L_PARAM_NAME2 VARCHAR2(100);

Line 124: L_PARAM_REC2 GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_REC_TYPE;

120: L_MODE_PARAM_ERR EXCEPTION;
121: L_DUPLICATE_PARAM_ERR EXCEPTION;
122:
123: L_PARAM_REC1 GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_REC_TYPE;
124: L_PARAM_REC2 GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_REC_TYPE;
125:
126: L_PARAM_NAME1 VARCHAR2(100);
127: L_PARAM_NAME2 VARCHAR2(100);
128:

Line 731: P_ENTITY_NAME IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,

727:
728: PROCEDURE CREATE_DEFN_CONTEXT
729: (
730: P_CURR_INSTR_PROCESS_ID IN NUMBER DEFAULT NULL,
731: P_ENTITY_NAME IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
732: P_ENTITY_KEY IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
733: P_ENTITY_DISPLAYNAME IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
734: P_INSTRUCTION_TYPE IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
735: P_MODE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE_UPDATE,

Line 732: P_ENTITY_KEY IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,

728: PROCEDURE CREATE_DEFN_CONTEXT
729: (
730: P_CURR_INSTR_PROCESS_ID IN NUMBER DEFAULT NULL,
731: P_ENTITY_NAME IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
732: P_ENTITY_KEY IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
733: P_ENTITY_DISPLAYNAME IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
734: P_INSTRUCTION_TYPE IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
735: P_MODE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE_UPDATE,
736: P_CONTEXT_PARAMETERS IN GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE,

Line 733: P_ENTITY_DISPLAYNAME IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,

729: (
730: P_CURR_INSTR_PROCESS_ID IN NUMBER DEFAULT NULL,
731: P_ENTITY_NAME IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
732: P_ENTITY_KEY IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
733: P_ENTITY_DISPLAYNAME IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
734: P_INSTRUCTION_TYPE IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
735: P_MODE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE_UPDATE,
736: P_CONTEXT_PARAMETERS IN GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE,
737:

Line 734: P_INSTRUCTION_TYPE IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,

730: P_CURR_INSTR_PROCESS_ID IN NUMBER DEFAULT NULL,
731: P_ENTITY_NAME IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
732: P_ENTITY_KEY IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
733: P_ENTITY_DISPLAYNAME IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
734: P_INSTRUCTION_TYPE IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
735: P_MODE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE_UPDATE,
736: P_CONTEXT_PARAMETERS IN GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE,
737:
738: X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER,

Line 736: P_CONTEXT_PARAMETERS IN GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE,

732: P_ENTITY_KEY IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
733: P_ENTITY_DISPLAYNAME IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
734: P_INSTRUCTION_TYPE IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
735: P_MODE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE_UPDATE,
736: P_CONTEXT_PARAMETERS IN GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE,
737:
738: X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER,
739: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
740: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 807: P_CONTEXT_PARAMETERS IN GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE,

803: P_ENTITY_KEY IN VARCHAR2,
804: P_ENTITY_DISPLAYNAME IN VARCHAR2,
805: P_INSTRUCTION_TYPE IN VARCHAR2,
806: P_MODE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE_UPDATE,
807: P_CONTEXT_PARAMETERS IN GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE,
808: X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER,
809: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
810: X_MSG_COUNT OUT NOCOPY NUMBER,
811: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 862: P_ENTITY_NAME IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,

858:
859: PROCEDURE DELETE_ENTITY_FOR_PROCESS
860: (
861: P_CURR_INSTR_PROCESS_ID IN NUMBER,
862: P_ENTITY_NAME IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
863: P_ENTITY_KEY IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
864: X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER,
865: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
866: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 863: P_ENTITY_KEY IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,

859: PROCEDURE DELETE_ENTITY_FOR_PROCESS
860: (
861: P_CURR_INSTR_PROCESS_ID IN NUMBER,
862: P_ENTITY_NAME IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
863: P_ENTITY_KEY IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
864: X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER,
865: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
866: X_MSG_COUNT OUT NOCOPY NUMBER,
867: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 876: L_CONTEXT_PARAMETERS GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE;

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);
880: L_EXIST_INSTR_TYPE BOOLEAN;

Line 2214: P_ENTITY_NAME IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,

2210: -- back to permenant tables
2211: PROCEDURE SEND_DEFN_ACKN
2212: (
2213: P_INSTRUCTION_PROCESS_ID IN NUMBER,
2214: P_ENTITY_NAME IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
2215: P_SOURCE_ENTITY_KEY IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
2216: P_TARGET_ENTITY_KEY IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
2217: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2218: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 2215: P_SOURCE_ENTITY_KEY IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,

2211: PROCEDURE SEND_DEFN_ACKN
2212: (
2213: P_INSTRUCTION_PROCESS_ID IN NUMBER,
2214: P_ENTITY_NAME IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
2215: P_SOURCE_ENTITY_KEY IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
2216: P_TARGET_ENTITY_KEY IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
2217: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2218: X_MSG_COUNT OUT NOCOPY NUMBER,
2219: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 2216: P_TARGET_ENTITY_KEY IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,

2212: (
2213: P_INSTRUCTION_PROCESS_ID IN NUMBER,
2214: P_ENTITY_NAME IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
2215: P_SOURCE_ENTITY_KEY IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
2216: P_TARGET_ENTITY_KEY IN GMO_DATATYPES_GRP.GMO_TABLE_OF_VARCHAR2_255,
2217: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2218: X_MSG_COUNT OUT NOCOPY NUMBER,
2219: X_MSG_DATA OUT NOCOPY VARCHAR2
2220: )

Line 3209: X_INSTRUCTION_TABLE OUT NOCOPY GMO_DATATYPES_GRP.GMO_INSTRUCTION_TBL_TYPE,

3205: (
3206: P_ENTITY_NAME IN VARCHAR2,
3207: P_ENTITY_KEY IN VARCHAR2,
3208: P_INSTRUCTION_TYPE VARCHAR2,
3209: X_INSTRUCTION_TABLE OUT NOCOPY GMO_DATATYPES_GRP.GMO_INSTRUCTION_TBL_TYPE,
3210: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
3211: X_MSG_COUNT OUT NOCOPY NUMBER,
3212: X_MSG_DATA OUT NOCOPY VARCHAR2
3213: )

Line 3216: L_INSTRUCTION_REC GMO_DATATYPES_GRP.GMO_INSTRUCTION_REC_TYPE;

3212: X_MSG_DATA OUT NOCOPY VARCHAR2
3213: )
3214: IS
3215: L_INSTRUCTION_SET_ID NUMBER;
3216: L_INSTRUCTION_REC GMO_DATATYPES_GRP.GMO_INSTRUCTION_REC_TYPE;
3217: L_INSTRUCTION_TBL GMO_DATATYPES_GRP.GMO_INSTRUCTION_TBL_TYPE;
3218:
3219: CURSOR L_INSTR_CSR IS
3220: SELECT INSTR_DEFN.INSTRUCTION_ID, INSTR_DEFN.INSTRUCTION_SET_ID,

Line 3217: L_INSTRUCTION_TBL GMO_DATATYPES_GRP.GMO_INSTRUCTION_TBL_TYPE;

3213: )
3214: IS
3215: L_INSTRUCTION_SET_ID NUMBER;
3216: L_INSTRUCTION_REC GMO_DATATYPES_GRP.GMO_INSTRUCTION_REC_TYPE;
3217: L_INSTRUCTION_TBL GMO_DATATYPES_GRP.GMO_INSTRUCTION_TBL_TYPE;
3218:
3219: CURSOR L_INSTR_CSR IS
3220: SELECT INSTR_DEFN.INSTRUCTION_ID, INSTR_DEFN.INSTRUCTION_SET_ID,
3221: INSTR_DEFN.INSTRUCTION_TEXT,