9: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
10: X_MSG_COUNT OUT NOCOPY NUMBER,
11: X_MSG_DATA OUT NOCOPY VARCHAR2,
12: P_CURR_INSTR_PROCESS_ID IN NUMBER DEFAULT NULL,
13: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,
14: P_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
15: P_ENTITY_DISPLAYNAME IN FND_TABLE_OF_VARCHAR2_255,
16: P_INSTRUCTION_TYPE IN FND_TABLE_OF_VARCHAR2_255,
17: P_MODE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE_UPDATE,
10: X_MSG_COUNT OUT NOCOPY NUMBER,
11: X_MSG_DATA OUT NOCOPY VARCHAR2,
12: P_CURR_INSTR_PROCESS_ID IN NUMBER DEFAULT NULL,
13: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,
14: P_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
15: P_ENTITY_DISPLAYNAME IN FND_TABLE_OF_VARCHAR2_255,
16: P_INSTRUCTION_TYPE IN FND_TABLE_OF_VARCHAR2_255,
17: P_MODE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE_UPDATE,
18: P_CONTEXT_PARAMETERS IN GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE,
11: X_MSG_DATA OUT NOCOPY VARCHAR2,
12: P_CURR_INSTR_PROCESS_ID IN NUMBER DEFAULT NULL,
13: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,
14: P_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
15: P_ENTITY_DISPLAYNAME IN FND_TABLE_OF_VARCHAR2_255,
16: P_INSTRUCTION_TYPE IN FND_TABLE_OF_VARCHAR2_255,
17: P_MODE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE_UPDATE,
18: P_CONTEXT_PARAMETERS IN GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE,
19: X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER
12: P_CURR_INSTR_PROCESS_ID IN NUMBER DEFAULT NULL,
13: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,
14: P_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
15: P_ENTITY_DISPLAYNAME IN FND_TABLE_OF_VARCHAR2_255,
16: P_INSTRUCTION_TYPE IN FND_TABLE_OF_VARCHAR2_255,
17: P_MODE IN VARCHAR2 DEFAULT GMO_CONSTANTS_GRP.G_INSTR_DEFN_MODE_UPDATE,
18: P_CONTEXT_PARAMETERS IN GMO_DATATYPES_GRP.GMO_DEFINITION_PARAM_TBL_TYPE,
19: X_INSTRUCTION_PROCESS_ID OUT NOCOPY NUMBER
20:
119:
120: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_DEFN_CONTEXT';
121: l_api_version CONSTANT NUMBER := 1.0;
122:
123: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
124: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
125: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
126: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
127:
120: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_DEFN_CONTEXT';
121: l_api_version CONSTANT NUMBER := 1.0;
122:
123: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
124: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
125: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
126: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
127:
128: BEGIN
121: l_api_version CONSTANT NUMBER := 1.0;
122:
123: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
124: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
125: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
126: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
127:
128: BEGIN
129:
122:
123: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
124: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
125: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
126: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
127:
128: BEGIN
129:
130: -- Standard call to check for call compatibility.
139:
140: -- Initialize API return status to success
141: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
142:
143: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
144: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
145: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
146: L_INSTRUCTION_TYPE := FND_TABLE_OF_VARCHAR2_255();
147:
140: -- Initialize API return status to success
141: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
142:
143: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
144: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
145: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
146: L_INSTRUCTION_TYPE := FND_TABLE_OF_VARCHAR2_255();
147:
148: FOR J IN 1..P_INSTRUCTION_TYPE.count LOOP
141: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
142:
143: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
144: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
145: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
146: L_INSTRUCTION_TYPE := FND_TABLE_OF_VARCHAR2_255();
147:
148: FOR J IN 1..P_INSTRUCTION_TYPE.count LOOP
149: L_INSTRUCTION_TYPE.EXTEND;
142:
143: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
144: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
145: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
146: L_INSTRUCTION_TYPE := FND_TABLE_OF_VARCHAR2_255();
147:
148: FOR J IN 1..P_INSTRUCTION_TYPE.count LOOP
149: L_INSTRUCTION_TYPE.EXTEND;
150: L_INSTRUCTION_TYPE(J) := P_INSTRUCTION_TYPE(J);
335:
336: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_DEFN_CONTEXT';
337: l_api_version CONSTANT NUMBER := 1.0;
338:
339: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
340: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
341: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
342: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
343:
336: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_DEFN_CONTEXT';
337: l_api_version CONSTANT NUMBER := 1.0;
338:
339: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
340: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
341: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
342: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
343:
344: BEGIN
337: l_api_version CONSTANT NUMBER := 1.0;
338:
339: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
340: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
341: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
342: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
343:
344: BEGIN
345: -- Standard call to check for call compatibility.
338:
339: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
340: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
341: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;
342: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;
343:
344: BEGIN
345: -- Standard call to check for call compatibility.
346: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
354:
355: -- Initialize API return status to success
356: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
357:
358: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
359: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
360: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
361: L_INSTRUCTION_TYPE := FND_TABLE_OF_VARCHAR2_255();
362:
355: -- Initialize API return status to success
356: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
357:
358: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
359: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
360: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
361: L_INSTRUCTION_TYPE := FND_TABLE_OF_VARCHAR2_255();
362:
363: L_ENTITY_NAME.EXTEND;
356: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
357:
358: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
359: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
360: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
361: L_INSTRUCTION_TYPE := FND_TABLE_OF_VARCHAR2_255();
362:
363: L_ENTITY_NAME.EXTEND;
364: L_ENTITY_KEY.EXTEND;
357:
358: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
359: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
360: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();
361: L_INSTRUCTION_TYPE := FND_TABLE_OF_VARCHAR2_255();
362:
363: L_ENTITY_NAME.EXTEND;
364: L_ENTITY_KEY.EXTEND;
365: L_ENTITY_DISPLAYNAME.EXTEND;
551:
552: l_api_name CONSTANT VARCHAR2(30) := 'SEND_DEFN_ACKN';
553: l_api_version CONSTANT NUMBER := 1.0;
554:
555: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
556: L_SOURCE_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
557: L_TARGET_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
558:
559: BEGIN
552: l_api_name CONSTANT VARCHAR2(30) := 'SEND_DEFN_ACKN';
553: l_api_version CONSTANT NUMBER := 1.0;
554:
555: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
556: L_SOURCE_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
557: L_TARGET_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
558:
559: BEGIN
560: -- Standard call to check for call compatibility.
553: l_api_version CONSTANT NUMBER := 1.0;
554:
555: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;
556: L_SOURCE_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
557: L_TARGET_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;
558:
559: BEGIN
560: -- Standard call to check for call compatibility.
561: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
569:
570: -- Initialize API return status to success
571: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
572:
573: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
574: L_SOURCE_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
575: L_TARGET_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
576:
577: L_ENTITY_NAME.EXTEND;
570: -- Initialize API return status to success
571: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
572:
573: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
574: L_SOURCE_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
575: L_TARGET_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
576:
577: L_ENTITY_NAME.EXTEND;
578: L_SOURCE_ENTITY_KEY.EXTEND;
571: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
572:
573: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();
574: L_SOURCE_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
575: L_TARGET_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();
576:
577: L_ENTITY_NAME.EXTEND;
578: L_SOURCE_ENTITY_KEY.EXTEND;
579: L_TARGET_ENTITY_KEY.EXTEND;
650: X_MSG_COUNT OUT NOCOPY NUMBER,
651: X_MSG_DATA OUT NOCOPY VARCHAR2,
652:
653: P_INSTRUCTION_PROCESS_ID IN NUMBER,
654: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,
655: P_SOURCE_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
656: P_TARGET_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255
657: )
658:
651: X_MSG_DATA OUT NOCOPY VARCHAR2,
652:
653: P_INSTRUCTION_PROCESS_ID IN NUMBER,
654: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,
655: P_SOURCE_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
656: P_TARGET_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255
657: )
658:
659: IS
652:
653: P_INSTRUCTION_PROCESS_ID IN NUMBER,
654: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,
655: P_SOURCE_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,
656: P_TARGET_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255
657: )
658:
659: IS
660:
1270:
1271: P_INSTRUCTION_ID IN NUMBER,
1272: P_INSTRUCTION_PROCESS_ID IN NUMBER,
1273: P_ENTITY_KEY IN VARCHAR2 DEFAULT NULL,
1274: P_TASK_ERECORD_ID IN FND_TABLE_OF_VARCHAR2_255,
1275: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,
1276: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,
1277: P_DISABLE_TASK IN VARCHAR2 DEFAULT 'N'
1278: )
1271: P_INSTRUCTION_ID IN NUMBER,
1272: P_INSTRUCTION_PROCESS_ID IN NUMBER,
1273: P_ENTITY_KEY IN VARCHAR2 DEFAULT NULL,
1274: P_TASK_ERECORD_ID IN FND_TABLE_OF_VARCHAR2_255,
1275: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,
1276: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,
1277: P_DISABLE_TASK IN VARCHAR2 DEFAULT 'N'
1278: )
1279: IS PRAGMA AUTONOMOUS_TRANSACTION;
1272: P_INSTRUCTION_PROCESS_ID IN NUMBER,
1273: P_ENTITY_KEY IN VARCHAR2 DEFAULT NULL,
1274: P_TASK_ERECORD_ID IN FND_TABLE_OF_VARCHAR2_255,
1275: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,
1276: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,
1277: P_DISABLE_TASK IN VARCHAR2 DEFAULT 'N'
1278: )
1279: IS PRAGMA AUTONOMOUS_TRANSACTION;
1280: