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

Line 218: l_unavail_mat fnd_table_of_varchar2_255;

214: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
215: X_MSG_COUNT OUT NOCOPY NUMBER,
216: X_MSG_DATA OUT NOCOPY VARCHAR2)
217: IS
218: l_unavail_mat fnd_table_of_varchar2_255;
219: BEGIN
220: GET_STEP_MATERIAL_AVAILABILITY (
221: P_BATCHSTEP_ID => P_BATCHSTEP_ID,
222: X_MATERIAL_AVAILABLE => X_MATERIAL_AVAILABLE,

Line 233: X_UNAVAL_MATERIAL_ID OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,

229: END;
230:
231: PROCEDURE GET_STEP_MATERIAL_AVAILABILITY (P_BATCHSTEP_ID IN NUMBER,
232: X_MATERIAL_AVAILABLE OUT NOCOPY VARCHAR2,
233: X_UNAVAL_MATERIAL_ID OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
234: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
235: X_MSG_COUNT OUT NOCOPY NUMBER,
236: X_MSG_DATA OUT NOCOPY VARCHAR2)
237:

Line 280: X_UNAVAL_MATERIAL_ID := new FND_TABLE_OF_VARCHAR2_255();

276: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
277: RAISE BATCH_SHORTAGE_ERR;
278: end if;
279:
280: X_UNAVAL_MATERIAL_ID := new FND_TABLE_OF_VARCHAR2_255();
281: k := 0;
282:
283: for i in 1 .. l_exception_tbl.count loop
284: l_material_detail_id := l_exception_tbl(i).MATERIAL_DETAIL_ID;

Line 442: procedure LOCK_STEP (P_BATCHSTEP_ID IN FND_TABLE_OF_VARCHAR2_255,

438: END LOCK_STEP;
439:
440: --This procdeure would lock the (array) step and do an autonomous commit..
441:
442: procedure LOCK_STEP (P_BATCHSTEP_ID IN FND_TABLE_OF_VARCHAR2_255,
443: P_REQUESTER IN NUMBER,
444: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
445: X_MSG_COUNT OUT NOCOPY NUMBER,
446: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 601: procedure UNLOCK_STEP (P_BATCHSTEP_ID IN FND_TABLE_OF_VARCHAR2_255,

597: END UNLOCK_STEP;
598:
599: --This procdeure would unlock the step.
600:
601: procedure UNLOCK_STEP (P_BATCHSTEP_ID IN FND_TABLE_OF_VARCHAR2_255,
602: P_REQUESTER IN NUMBER,
603: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
604: X_MSG_COUNT OUT NOCOPY NUMBER,
605: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 877: X_INVALID_INSTR OUT NOCOPY FND_TABLE_OF_VARCHAR2_255

873: P_ENTITY_NAME IN VARCHAR2,
874: P_ENTITY_KEY IN VARCHAR2,
875: P_INSTRUCTION_SET_ID IN NUMBER,
876: X_ATTRIBUTE_STATUS OUT NOCOPY VARCHAR2,
877: X_INVALID_INSTR OUT NOCOPY FND_TABLE_OF_VARCHAR2_255
878: )
879:
880: IS
881:

Line 903: l_invalid_instr fnd_table_of_varchar2_255;

899: l_instr_number varchar2(200);
900:
901: l_min_assoc varchar2(1);
902:
903: l_invalid_instr fnd_table_of_varchar2_255;
904: j binary_integer;
905:
906: l_return_status varchar2(1);
907: l_msg_count number;

Line 930: l_invalid_instr := fnd_table_of_varchar2_255();

926: cursor get_task is select task_name from gmo_instr_task_defn_b where task_id = l_task_id;
927:
928: BEGIN
929:
930: l_invalid_instr := fnd_table_of_varchar2_255();
931: j := 0;
932:
933: open get_instr_details;
934: loop

Line 1135: l_invalid_instr fnd_table_of_varchar2_255;

1131: l_msg_data varchar2(4000);
1132: instruction_create_err exception;
1133:
1134: l_entity_display_name varchar2(255);
1135: l_invalid_instr fnd_table_of_varchar2_255;
1136: l_invalid_instr_master fnd_table_of_varchar2_255;
1137: l_invalid_entity_master fnd_table_of_varchar2_255;
1138:
1139: j binary_integer;

Line 1136: l_invalid_instr_master fnd_table_of_varchar2_255;

1132: instruction_create_err exception;
1133:
1134: l_entity_display_name varchar2(255);
1135: l_invalid_instr fnd_table_of_varchar2_255;
1136: l_invalid_instr_master fnd_table_of_varchar2_255;
1137: l_invalid_entity_master fnd_table_of_varchar2_255;
1138:
1139: j binary_integer;
1140: k binary_integer;

Line 1137: l_invalid_entity_master fnd_table_of_varchar2_255;

1133:
1134: l_entity_display_name varchar2(255);
1135: l_invalid_instr fnd_table_of_varchar2_255;
1136: l_invalid_instr_master fnd_table_of_varchar2_255;
1137: l_invalid_entity_master fnd_table_of_varchar2_255;
1138:
1139: j binary_integer;
1140: k binary_integer;
1141: l_attribute_Status varchar2(1);

Line 1215: l_invalid_entity_master := fnd_table_of_varchar2_255();

1211:
1212:
1213: j := 0;
1214: k := 0;
1215: l_invalid_entity_master := fnd_table_of_varchar2_255();
1216: l_invalid_instr_master := fnd_table_of_varchar2_255();
1217:
1218: open c_get_steps;
1219: loop

Line 1216: l_invalid_instr_master := fnd_table_of_varchar2_255();

1212:
1213: j := 0;
1214: k := 0;
1215: l_invalid_entity_master := fnd_table_of_varchar2_255();
1216: l_invalid_instr_master := fnd_table_of_varchar2_255();
1217:
1218: open c_get_steps;
1219: loop
1220: fetch c_get_steps into l_batchstep_id, l_routingstep_id, l_oprn_id, l_entity_display_name;

Line 2583: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,

2579: P_TASK IN VARCHAR2,
2580: P_TASK_ATTRIBUTE IN VARCHAR2 ,
2581: P_INSTRUCTION_ID IN NUMBER ,
2582: P_INSTRUCTION_PROCESS_ID IN NUMBER ,
2583: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,
2584: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,
2585: P_TASK_ERECORD IN FND_TABLE_OF_VARCHAR2_255,
2586: P_REQUESTER IN NUMBER,
2587: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 2584: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,

2580: P_TASK_ATTRIBUTE IN VARCHAR2 ,
2581: P_INSTRUCTION_ID IN NUMBER ,
2582: P_INSTRUCTION_PROCESS_ID IN NUMBER ,
2583: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,
2584: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,
2585: P_TASK_ERECORD IN FND_TABLE_OF_VARCHAR2_255,
2586: P_REQUESTER IN NUMBER,
2587: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2588: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 2585: P_TASK_ERECORD IN FND_TABLE_OF_VARCHAR2_255,

2581: P_INSTRUCTION_ID IN NUMBER ,
2582: P_INSTRUCTION_PROCESS_ID IN NUMBER ,
2583: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,
2584: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,
2585: P_TASK_ERECORD IN FND_TABLE_OF_VARCHAR2_255,
2586: P_REQUESTER IN NUMBER,
2587: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2588: X_MSG_COUNT OUT NOCOPY NUMBER,
2589: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 2836: X_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,

2832:
2833: --Bug 5224634: start
2834: procedure GET_BATCHSTEP_NODES ( P_BATCH_ID IN NUMBER,
2835: P_BATCHSTEP_ID IN NUMBER,
2836: X_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2837: X_ENTITY_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2838: X_ENTITY_KEY OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2839: X_ENTITY_LEVEL OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2840: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 2837: X_ENTITY_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,

2833: --Bug 5224634: start
2834: procedure GET_BATCHSTEP_NODES ( P_BATCH_ID IN NUMBER,
2835: P_BATCHSTEP_ID IN NUMBER,
2836: X_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2837: X_ENTITY_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2838: X_ENTITY_KEY OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2839: X_ENTITY_LEVEL OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2840: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2841: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 2838: X_ENTITY_KEY OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,

2834: procedure GET_BATCHSTEP_NODES ( P_BATCH_ID IN NUMBER,
2835: P_BATCHSTEP_ID IN NUMBER,
2836: X_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2837: X_ENTITY_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2838: X_ENTITY_KEY OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2839: X_ENTITY_LEVEL OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2840: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2841: X_MSG_COUNT OUT NOCOPY NUMBER,
2842: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 2839: X_ENTITY_LEVEL OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,

2835: P_BATCHSTEP_ID IN NUMBER,
2836: X_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2837: X_ENTITY_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2838: X_ENTITY_KEY OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2839: X_ENTITY_LEVEL OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2840: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2841: X_MSG_COUNT OUT NOCOPY NUMBER,
2842: X_MSG_DATA OUT NOCOPY VARCHAR2)
2843: IS

Line 2845: t_name fnd_table_of_varchar2_255;

2841: X_MSG_COUNT OUT NOCOPY NUMBER,
2842: X_MSG_DATA OUT NOCOPY VARCHAR2)
2843: IS
2844:
2845: t_name fnd_table_of_varchar2_255;
2846: t_entity_name fnd_table_of_varchar2_255;
2847: t_entity_key fnd_table_of_varchar2_255;
2848: t_entity_level fnd_table_of_varchar2_255;
2849:

Line 2846: t_entity_name fnd_table_of_varchar2_255;

2842: X_MSG_DATA OUT NOCOPY VARCHAR2)
2843: IS
2844:
2845: t_name fnd_table_of_varchar2_255;
2846: t_entity_name fnd_table_of_varchar2_255;
2847: t_entity_key fnd_table_of_varchar2_255;
2848: t_entity_level fnd_table_of_varchar2_255;
2849:
2850: l_entity_name varchar2(255);

Line 2847: t_entity_key fnd_table_of_varchar2_255;

2843: IS
2844:
2845: t_name fnd_table_of_varchar2_255;
2846: t_entity_name fnd_table_of_varchar2_255;
2847: t_entity_key fnd_table_of_varchar2_255;
2848: t_entity_level fnd_table_of_varchar2_255;
2849:
2850: l_entity_name varchar2(255);
2851: l_entity_key varchar2(255);

Line 2848: t_entity_level fnd_table_of_varchar2_255;

2844:
2845: t_name fnd_table_of_varchar2_255;
2846: t_entity_name fnd_table_of_varchar2_255;
2847: t_entity_key fnd_table_of_varchar2_255;
2848: t_entity_level fnd_table_of_varchar2_255;
2849:
2850: l_entity_name varchar2(255);
2851: l_entity_key varchar2(255);
2852:

Line 2887: t_name := fnd_table_of_varchar2_255();

2883:
2884:
2885: begin
2886:
2887: t_name := fnd_table_of_varchar2_255();
2888: t_entity_name := fnd_table_of_varchar2_255();
2889: t_entity_key := fnd_table_of_varchar2_255();
2890: t_entity_level := fnd_table_of_varchar2_255();
2891:

Line 2888: t_entity_name := fnd_table_of_varchar2_255();

2884:
2885: begin
2886:
2887: t_name := fnd_table_of_varchar2_255();
2888: t_entity_name := fnd_table_of_varchar2_255();
2889: t_entity_key := fnd_table_of_varchar2_255();
2890: t_entity_level := fnd_table_of_varchar2_255();
2891:
2892: x_name := fnd_table_of_varchar2_255();

Line 2889: t_entity_key := fnd_table_of_varchar2_255();

2885: begin
2886:
2887: t_name := fnd_table_of_varchar2_255();
2888: t_entity_name := fnd_table_of_varchar2_255();
2889: t_entity_key := fnd_table_of_varchar2_255();
2890: t_entity_level := fnd_table_of_varchar2_255();
2891:
2892: x_name := fnd_table_of_varchar2_255();
2893: x_entity_name := fnd_table_of_varchar2_255();

Line 2890: t_entity_level := fnd_table_of_varchar2_255();

2886:
2887: t_name := fnd_table_of_varchar2_255();
2888: t_entity_name := fnd_table_of_varchar2_255();
2889: t_entity_key := fnd_table_of_varchar2_255();
2890: t_entity_level := fnd_table_of_varchar2_255();
2891:
2892: x_name := fnd_table_of_varchar2_255();
2893: x_entity_name := fnd_table_of_varchar2_255();
2894: x_entity_key := fnd_table_of_varchar2_255();

Line 2892: x_name := fnd_table_of_varchar2_255();

2888: t_entity_name := fnd_table_of_varchar2_255();
2889: t_entity_key := fnd_table_of_varchar2_255();
2890: t_entity_level := fnd_table_of_varchar2_255();
2891:
2892: x_name := fnd_table_of_varchar2_255();
2893: x_entity_name := fnd_table_of_varchar2_255();
2894: x_entity_key := fnd_table_of_varchar2_255();
2895: x_entity_level := fnd_table_of_varchar2_255();
2896:

Line 2893: x_entity_name := fnd_table_of_varchar2_255();

2889: t_entity_key := fnd_table_of_varchar2_255();
2890: t_entity_level := fnd_table_of_varchar2_255();
2891:
2892: x_name := fnd_table_of_varchar2_255();
2893: x_entity_name := fnd_table_of_varchar2_255();
2894: x_entity_key := fnd_table_of_varchar2_255();
2895: x_entity_level := fnd_table_of_varchar2_255();
2896:
2897: l_counter := 0;

Line 2894: x_entity_key := fnd_table_of_varchar2_255();

2890: t_entity_level := fnd_table_of_varchar2_255();
2891:
2892: x_name := fnd_table_of_varchar2_255();
2893: x_entity_name := fnd_table_of_varchar2_255();
2894: x_entity_key := fnd_table_of_varchar2_255();
2895: x_entity_level := fnd_table_of_varchar2_255();
2896:
2897: l_counter := 0;
2898:

Line 2895: x_entity_level := fnd_table_of_varchar2_255();

2891:
2892: x_name := fnd_table_of_varchar2_255();
2893: x_entity_name := fnd_table_of_varchar2_255();
2894: x_entity_key := fnd_table_of_varchar2_255();
2895: x_entity_level := fnd_table_of_varchar2_255();
2896:
2897: l_counter := 0;
2898:
2899: open c_get_oprn;

Line 3044: l_invalid_instr fnd_table_of_varchar2_255;

3040: l_msg_data varchar2(4000);
3041: instruction_create_err exception;
3042:
3043: l_entity_display_name varchar2(255);
3044: l_invalid_instr fnd_table_of_varchar2_255;
3045: l_invalid_instr_master fnd_table_of_varchar2_255;
3046: l_invalid_entity_master fnd_table_of_varchar2_255;
3047:
3048: j binary_integer;

Line 3045: l_invalid_instr_master fnd_table_of_varchar2_255;

3041: instruction_create_err exception;
3042:
3043: l_entity_display_name varchar2(255);
3044: l_invalid_instr fnd_table_of_varchar2_255;
3045: l_invalid_instr_master fnd_table_of_varchar2_255;
3046: l_invalid_entity_master fnd_table_of_varchar2_255;
3047:
3048: j binary_integer;
3049: k binary_integer;

Line 3046: l_invalid_entity_master fnd_table_of_varchar2_255;

3042:
3043: l_entity_display_name varchar2(255);
3044: l_invalid_instr fnd_table_of_varchar2_255;
3045: l_invalid_instr_master fnd_table_of_varchar2_255;
3046: l_invalid_entity_master fnd_table_of_varchar2_255;
3047:
3048: j binary_integer;
3049: k binary_integer;
3050: l_attribute_Status varchar2(1);

Line 3087: l_invalid_entity_master := fnd_table_of_varchar2_255();

3083: BEGIN
3084:
3085: j := 0;
3086: k := 0;
3087: l_invalid_entity_master := fnd_table_of_varchar2_255();
3088: l_invalid_instr_master := fnd_table_of_varchar2_255();
3089:
3090: open c_get_steps;
3091: loop

Line 3088: l_invalid_instr_master := fnd_table_of_varchar2_255();

3084:
3085: j := 0;
3086: k := 0;
3087: l_invalid_entity_master := fnd_table_of_varchar2_255();
3088: l_invalid_instr_master := fnd_table_of_varchar2_255();
3089:
3090: open c_get_steps;
3091: loop
3092: fetch c_get_steps into l_batchstep_id, l_routingstep_id, l_oprn_id, l_entity_display_name;