DBA Data[Home] [Help]

APPS.GMO_INSTRUCTION_PVT dependencies on FND_TABLE_OF_VARCHAR2_255

Line 38: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,

34:
35: PROCEDURE CREATE_DEFN_CONTEXT
36: (
37: P_CURR_INSTR_PROCESS_ID IN NUMBER DEFAULT NULL,
38: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,
39: P_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
40: P_ENTITY_DISPLAYNAME IN FND_TABLE_OF_VARCHAR2_255,
41: P_INSTRUCTION_TYPE IN FND_TABLE_OF_VARCHAR2_255,
42: P_MODE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE_UPDATE,

Line 39: P_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,

35: PROCEDURE CREATE_DEFN_CONTEXT
36: (
37: P_CURR_INSTR_PROCESS_ID IN NUMBER DEFAULT NULL,
38: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,
39: P_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
40: P_ENTITY_DISPLAYNAME IN FND_TABLE_OF_VARCHAR2_255,
41: P_INSTRUCTION_TYPE IN FND_TABLE_OF_VARCHAR2_255,
42: P_MODE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE_UPDATE,
43: P_CONTEXT_PARAMETERS IN GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE,

Line 40: P_ENTITY_DISPLAYNAME IN FND_TABLE_OF_VARCHAR2_255,

36: (
37: P_CURR_INSTR_PROCESS_ID IN NUMBER DEFAULT NULL,
38: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,
39: P_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
40: P_ENTITY_DISPLAYNAME IN FND_TABLE_OF_VARCHAR2_255,
41: P_INSTRUCTION_TYPE IN FND_TABLE_OF_VARCHAR2_255,
42: P_MODE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE_UPDATE,
43: P_CONTEXT_PARAMETERS IN GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE,
44: X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER,

Line 41: P_INSTRUCTION_TYPE IN FND_TABLE_OF_VARCHAR2_255,

37: P_CURR_INSTR_PROCESS_ID IN NUMBER DEFAULT NULL,
38: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,
39: P_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
40: P_ENTITY_DISPLAYNAME IN FND_TABLE_OF_VARCHAR2_255,
41: P_INSTRUCTION_TYPE IN FND_TABLE_OF_VARCHAR2_255,
42: P_MODE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE_UPDATE,
43: P_CONTEXT_PARAMETERS IN GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE,
44: X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER,
45: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 101: -- FND_TABLE_OF_VARCHAR2_255

97: -- entity name, entity key, entity display names, and Instruction
98: -- types. It is called before definition UI is invoked to create
99: -- the necessary context for definition. This flavor is used by
100: -- GMO_INSTR_GRP PLL Package, as FORMS does not support
101: -- FND_TABLE_OF_VARCHAR2_255
102:
103: -- Start of comments
104: -- API name : CREATE_DEFN_CONTEXT
105: -- Type : Private API

Line 268: -- P_ENTITY_NAME The entity name as FND_TABLE_OF_VARCHAR2_255

264: -- Pre-reqs : None
265: -- Parameters
266:
267: -- P_INSTRUCTION_PROCESS_ID The instruction process id
268: -- P_ENTITY_NAME The entity name as FND_TABLE_OF_VARCHAR2_255
269: -- P_SOURCE_ENTITY_KEY Source entity key
270: -- P_TARGET_ENTITY_KEY Target entity key
271:
272: -- X_RETURN_STATUS The return status based on standard API convention

Line 281: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,

277:
278: PROCEDURE SEND_DEFN_ACKN
279: (
280: P_INSTRUCTION_PROCESS_ID IN NUMBER,
281: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,
282: P_SOURCE_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
283: P_TARGET_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
284: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
285: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 282: P_SOURCE_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,

278: PROCEDURE SEND_DEFN_ACKN
279: (
280: P_INSTRUCTION_PROCESS_ID IN NUMBER,
281: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,
282: P_SOURCE_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
283: P_TARGET_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
284: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
285: X_MSG_COUNT OUT NOCOPY NUMBER,
286: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 283: P_TARGET_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,

279: (
280: P_INSTRUCTION_PROCESS_ID IN NUMBER,
281: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,
282: P_SOURCE_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
283: P_TARGET_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
284: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
285: X_MSG_COUNT OUT NOCOPY NUMBER,
286: X_MSG_DATA OUT NOCOPY VARCHAR2
287: );

Line 304: -- P_ENTITY_NAME The entity name as FND_TABLE_OF_VARCHAR2_255

300: -- Pre-reqs : None
301: -- Parameters
302:
303: -- P_INSTRUCTION_PROCESS_ID The instruction process id
304: -- P_ENTITY_NAME The entity name as FND_TABLE_OF_VARCHAR2_255
305: -- P_SOURCE_ENTITY_KEY Source entity key
306: -- P_TARGET_ENTITY_KEY Target entity key
307:
308: -- X_RETURN_STATUS The return status based on standard API convention

Line 641: P_TASK_ERECORD_ID IN FND_TABLE_OF_VARCHAR2_255,

637: (
638: P_INSTRUCTION_ID IN NUMBER,
639: P_INSTRUCTION_PROCESS_ID IN NUMBER,
640: P_ENTITY_KEY IN VARCHAR2 DEFAULT NULL,
641: P_TASK_ERECORD_ID IN FND_TABLE_OF_VARCHAR2_255,
642: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,
643: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,
644: P_DISABLE_TASK IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.NO,
645: P_MANUAL_ENTRY IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.NO,

Line 642: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,

638: P_INSTRUCTION_ID IN NUMBER,
639: P_INSTRUCTION_PROCESS_ID IN NUMBER,
640: P_ENTITY_KEY IN VARCHAR2 DEFAULT NULL,
641: P_TASK_ERECORD_ID IN FND_TABLE_OF_VARCHAR2_255,
642: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,
643: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,
644: P_DISABLE_TASK IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.NO,
645: P_MANUAL_ENTRY IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.NO,
646: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 643: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,

639: P_INSTRUCTION_PROCESS_ID IN NUMBER,
640: P_ENTITY_KEY IN VARCHAR2 DEFAULT NULL,
641: P_TASK_ERECORD_ID IN FND_TABLE_OF_VARCHAR2_255,
642: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,
643: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,
644: P_DISABLE_TASK IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.NO,
645: P_MANUAL_ENTRY IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.NO,
646: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
647: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 848: P_CONTEXT_PARAM_NAME IN FND_TABLE_OF_VARCHAR2_255,

844: (
845: P_ENTITY_NAME IN VARCHAR2,
846: P_ENTITY_KEY IN VARCHAR2,
847: P_INSTRUCTION_TYPE IN VARCHAR2,
848: P_CONTEXT_PARAM_NAME IN FND_TABLE_OF_VARCHAR2_255,
849: P_CONTEXT_PARAM_VALUE IN FND_TABLE_OF_VARCHAR2_255,
850: X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER,
851: X_INSTRUCTION_SET_ID OUT NOCOPY NUMBER,
852: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 849: P_CONTEXT_PARAM_VALUE IN FND_TABLE_OF_VARCHAR2_255,

845: P_ENTITY_NAME IN VARCHAR2,
846: P_ENTITY_KEY IN VARCHAR2,
847: P_INSTRUCTION_TYPE IN VARCHAR2,
848: P_CONTEXT_PARAM_NAME IN FND_TABLE_OF_VARCHAR2_255,
849: P_CONTEXT_PARAM_VALUE IN FND_TABLE_OF_VARCHAR2_255,
850: X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER,
851: X_INSTRUCTION_SET_ID OUT NOCOPY NUMBER,
852: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
853: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 885: P_CONTEXT_PARAM_NAME IN FND_TABLE_OF_VARCHAR2_255,

881:
882: PROCEDURE CREATE_INSTANCE_CONTEXT
883: (
884: P_INSTRUCTION_SET_ID IN NUMBER,
885: P_CONTEXT_PARAM_NAME IN FND_TABLE_OF_VARCHAR2_255,
886: P_CONTEXT_PARAM_VALUE IN FND_TABLE_OF_VARCHAR2_255,
887: X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER,
888: X_ENTITY_NAME OUT NOCOPY VARCHAR2,
889: X_ENTITY_KEY OUT NOCOPY VARCHAR2,

Line 886: P_CONTEXT_PARAM_VALUE IN FND_TABLE_OF_VARCHAR2_255,

882: PROCEDURE CREATE_INSTANCE_CONTEXT
883: (
884: P_INSTRUCTION_SET_ID IN NUMBER,
885: P_CONTEXT_PARAM_NAME IN FND_TABLE_OF_VARCHAR2_255,
886: P_CONTEXT_PARAM_VALUE IN FND_TABLE_OF_VARCHAR2_255,
887: X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER,
888: X_ENTITY_NAME OUT NOCOPY VARCHAR2,
889: X_ENTITY_KEY OUT NOCOPY VARCHAR2,
890: X_INSTRUCTION_TYPE OUT NOCOPY VARCHAR2,

Line 1043: P_ATTRIBUTE_NAME IN FND_TABLE_OF_VARCHAR2_255,

1039:
1040: FUNCTION SET_PROCESS_ATTRIBUTES
1041: (
1042: P_INSTRUCTION_PROCESS_ID IN NUMBER,
1043: P_ATTRIBUTE_NAME IN FND_TABLE_OF_VARCHAR2_255,
1044: P_ATTRIBUTE_VALUE IN FND_TABLE_OF_VARCHAR2_255,
1045: P_ATTRIBUTE_TYPE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_PARAM_INTERNAL
1046: )
1047: RETURN VARCHAR2;

Line 1044: P_ATTRIBUTE_VALUE IN FND_TABLE_OF_VARCHAR2_255,

1040: FUNCTION SET_PROCESS_ATTRIBUTES
1041: (
1042: P_INSTRUCTION_PROCESS_ID IN NUMBER,
1043: P_ATTRIBUTE_NAME IN FND_TABLE_OF_VARCHAR2_255,
1044: P_ATTRIBUTE_VALUE IN FND_TABLE_OF_VARCHAR2_255,
1045: P_ATTRIBUTE_TYPE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_PARAM_INTERNAL
1046: )
1047: RETURN VARCHAR2;
1048:

Line 1069: P_TASK_ERECORD_ID IN FND_TABLE_OF_VARCHAR2_255,

1065:
1066: -- End of comments
1067:
1068: PROCEDURE VALIDATE_TASK_ERECORD_ID (
1069: P_TASK_ERECORD_ID IN FND_TABLE_OF_VARCHAR2_255,
1070: X_ERECORD_ID_INVALID OUT NOCOPY VARCHAR2,
1071: X_ERECORD_LIST_STR OUT NOCOPY VARCHAR2,
1072: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1073: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 1140: P_INSTRUCTIONS IN FND_TABLE_OF_VARCHAR2_255,

1136: P_INSTRUCTION_PROCESS_ID IN NUMBER,
1137: P_INSTRUCTION_SET_ID IN NUMBER,
1138: P_INSTRUCTION_ID IN NUMBER,
1139: P_ADD_MODE IN VARCHAR2,
1140: P_INSTRUCTIONS IN FND_TABLE_OF_VARCHAR2_255,
1141: P_INSTRUCTION_NOS IN FND_TABLE_OF_VARCHAR2_255,
1142: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1143: X_MSG_COUNT OUT NOCOPY NUMBER,
1144: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 1141: P_INSTRUCTION_NOS IN FND_TABLE_OF_VARCHAR2_255,

1137: P_INSTRUCTION_SET_ID IN NUMBER,
1138: P_INSTRUCTION_ID IN NUMBER,
1139: P_ADD_MODE IN VARCHAR2,
1140: P_INSTRUCTIONS IN FND_TABLE_OF_VARCHAR2_255,
1141: P_INSTRUCTION_NOS IN FND_TABLE_OF_VARCHAR2_255,
1142: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1143: X_MSG_COUNT OUT NOCOPY NUMBER,
1144: X_MSG_DATA OUT NOCOPY VARCHAR2
1145: );