DBA Data[Home] [Help]

APPS.GMO_INSTRUCTION_GRP dependencies on FND_TABLE_OF_VARCHAR2_255

Line 13: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,

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,

Line 14: P_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,

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,

Line 15: P_ENTITY_DISPLAYNAME IN FND_TABLE_OF_VARCHAR2_255,

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

Line 16: P_INSTRUCTION_TYPE IN FND_TABLE_OF_VARCHAR2_255,

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:

Line 123: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;

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:

Line 124: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;

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

Line 125: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;

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:

Line 126: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;

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.

Line 143: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();

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:

Line 144: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();

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

Line 145: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();

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;

Line 146: L_INSTRUCTION_TYPE := FND_TABLE_OF_VARCHAR2_255();

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);

Line 339: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;

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:

Line 340: L_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;

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

Line 341: L_ENTITY_DISPLAYNAME FND_TABLE_OF_VARCHAR2_255;

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.

Line 342: L_INSTRUCTION_TYPE FND_TABLE_OF_VARCHAR2_255;

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

Line 358: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();

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:

Line 359: L_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();

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;

Line 360: L_ENTITY_DISPLAYNAME := FND_TABLE_OF_VARCHAR2_255();

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;

Line 361: L_INSTRUCTION_TYPE := FND_TABLE_OF_VARCHAR2_255();

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;

Line 555: L_ENTITY_NAME FND_TABLE_OF_VARCHAR2_255;

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

Line 556: L_SOURCE_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;

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.

Line 557: L_TARGET_ENTITY_KEY FND_TABLE_OF_VARCHAR2_255;

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

Line 573: L_ENTITY_NAME := FND_TABLE_OF_VARCHAR2_255();

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;

Line 574: L_SOURCE_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();

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;

Line 575: L_TARGET_ENTITY_KEY := FND_TABLE_OF_VARCHAR2_255();

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;

Line 654: P_ENTITY_NAME IN FND_TABLE_OF_VARCHAR2_255,

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:

Line 655: P_SOURCE_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255,

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

Line 656: P_TARGET_ENTITY_KEY IN FND_TABLE_OF_VARCHAR2_255

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:

Line 1274: P_TASK_ERECORD_ID IN FND_TABLE_OF_VARCHAR2_255,

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: )

Line 1275: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,

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;

Line 1276: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,

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: