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 263: l_unavail_mat fnd_table_of_varchar2_255;

259: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
260: X_MSG_COUNT OUT NOCOPY NUMBER,
261: X_MSG_DATA OUT NOCOPY VARCHAR2)
262: IS
263: l_unavail_mat fnd_table_of_varchar2_255;
264: BEGIN
265: GET_STEP_MATERIAL_AVAILABILITY (
266: P_BATCHSTEP_ID => P_BATCHSTEP_ID,
267: X_MATERIAL_AVAILABLE => X_MATERIAL_AVAILABLE,

Line 278: X_UNAVAL_MATERIAL_ID OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,

274: END;
275:
276: PROCEDURE GET_STEP_MATERIAL_AVAILABILITY (P_BATCHSTEP_ID IN NUMBER,
277: X_MATERIAL_AVAILABLE OUT NOCOPY VARCHAR2,
278: X_UNAVAL_MATERIAL_ID OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
279: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
280: X_MSG_COUNT OUT NOCOPY NUMBER,
281: X_MSG_DATA OUT NOCOPY VARCHAR2)
282:

Line 325: X_UNAVAL_MATERIAL_ID := new FND_TABLE_OF_VARCHAR2_255();

321: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
322: RAISE BATCH_SHORTAGE_ERR;
323: end if;
324:
325: X_UNAVAL_MATERIAL_ID := new FND_TABLE_OF_VARCHAR2_255();
326: k := 0;
327:
328: for i in 1 .. l_exception_tbl.count loop
329: l_material_detail_id := l_exception_tbl(i).MATERIAL_DETAIL_ID;

Line 487: procedure LOCK_STEP (P_BATCHSTEP_ID IN FND_TABLE_OF_VARCHAR2_255,

483: END LOCK_STEP;
484:
485: --This procdeure would lock the (array) step and do an autonomous commit..
486:
487: procedure LOCK_STEP (P_BATCHSTEP_ID IN FND_TABLE_OF_VARCHAR2_255,
488: P_REQUESTER IN NUMBER,
489: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
490: X_MSG_COUNT OUT NOCOPY NUMBER,
491: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 646: procedure UNLOCK_STEP (P_BATCHSTEP_ID IN FND_TABLE_OF_VARCHAR2_255,

642: END UNLOCK_STEP;
643:
644: --This procdeure would unlock the step.
645:
646: procedure UNLOCK_STEP (P_BATCHSTEP_ID IN FND_TABLE_OF_VARCHAR2_255,
647: P_REQUESTER IN NUMBER,
648: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
649: X_MSG_COUNT OUT NOCOPY NUMBER,
650: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 922: X_INVALID_INSTR OUT NOCOPY FND_TABLE_OF_VARCHAR2_255

918: P_ENTITY_NAME IN VARCHAR2,
919: P_ENTITY_KEY IN VARCHAR2,
920: P_INSTRUCTION_SET_ID IN NUMBER,
921: X_ATTRIBUTE_STATUS OUT NOCOPY VARCHAR2,
922: X_INVALID_INSTR OUT NOCOPY FND_TABLE_OF_VARCHAR2_255
923: )
924:
925: IS
926:

Line 948: l_invalid_instr fnd_table_of_varchar2_255;

944: l_instr_number varchar2(200);
945:
946: l_min_assoc varchar2(1);
947:
948: l_invalid_instr fnd_table_of_varchar2_255;
949: j binary_integer;
950:
951: l_return_status varchar2(1);
952: l_msg_count number;

Line 975: l_invalid_instr := fnd_table_of_varchar2_255();

971: cursor get_task is select task_name from gmo_instr_task_defn_b where task_id = l_task_id;
972:
973: BEGIN
974:
975: l_invalid_instr := fnd_table_of_varchar2_255();
976: j := 0;
977:
978: open get_instr_details;
979: loop

Line 1180: l_invalid_instr fnd_table_of_varchar2_255;

1176: l_msg_data varchar2(4000);
1177: instruction_create_err exception;
1178:
1179: l_entity_display_name varchar2(255);
1180: l_invalid_instr fnd_table_of_varchar2_255;
1181: l_invalid_instr_master fnd_table_of_varchar2_255;
1182: l_invalid_entity_master fnd_table_of_varchar2_255;
1183:
1184: j binary_integer;

Line 1181: l_invalid_instr_master fnd_table_of_varchar2_255;

1177: instruction_create_err exception;
1178:
1179: l_entity_display_name varchar2(255);
1180: l_invalid_instr fnd_table_of_varchar2_255;
1181: l_invalid_instr_master fnd_table_of_varchar2_255;
1182: l_invalid_entity_master fnd_table_of_varchar2_255;
1183:
1184: j binary_integer;
1185: k binary_integer;

Line 1182: l_invalid_entity_master fnd_table_of_varchar2_255;

1178:
1179: l_entity_display_name varchar2(255);
1180: l_invalid_instr fnd_table_of_varchar2_255;
1181: l_invalid_instr_master fnd_table_of_varchar2_255;
1182: l_invalid_entity_master fnd_table_of_varchar2_255;
1183:
1184: j binary_integer;
1185: k binary_integer;
1186: l_attribute_Status varchar2(1);

Line 1260: l_invalid_entity_master := fnd_table_of_varchar2_255();

1256:
1257:
1258: j := 0;
1259: k := 0;
1260: l_invalid_entity_master := fnd_table_of_varchar2_255();
1261: l_invalid_instr_master := fnd_table_of_varchar2_255();
1262:
1263: open c_get_steps;
1264: loop

Line 1261: l_invalid_instr_master := fnd_table_of_varchar2_255();

1257:
1258: j := 0;
1259: k := 0;
1260: l_invalid_entity_master := fnd_table_of_varchar2_255();
1261: l_invalid_instr_master := fnd_table_of_varchar2_255();
1262:
1263: open c_get_steps;
1264: loop
1265: fetch c_get_steps into l_batchstep_id, l_routingstep_id, l_oprn_id, l_entity_display_name;

Line 2628: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,

2624: P_TASK IN VARCHAR2,
2625: P_TASK_ATTRIBUTE IN VARCHAR2 ,
2626: P_INSTRUCTION_ID IN NUMBER ,
2627: P_INSTRUCTION_PROCESS_ID IN NUMBER ,
2628: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,
2629: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,
2630: P_TASK_ERECORD IN FND_TABLE_OF_VARCHAR2_255,
2631: P_REQUESTER IN NUMBER,
2632: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 2629: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,

2625: P_TASK_ATTRIBUTE IN VARCHAR2 ,
2626: P_INSTRUCTION_ID IN NUMBER ,
2627: P_INSTRUCTION_PROCESS_ID IN NUMBER ,
2628: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,
2629: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,
2630: P_TASK_ERECORD IN FND_TABLE_OF_VARCHAR2_255,
2631: P_REQUESTER IN NUMBER,
2632: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2633: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 2630: P_TASK_ERECORD IN FND_TABLE_OF_VARCHAR2_255,

2626: P_INSTRUCTION_ID IN NUMBER ,
2627: P_INSTRUCTION_PROCESS_ID IN NUMBER ,
2628: P_TASK_IDENTIFIER IN FND_TABLE_OF_VARCHAR2_255,
2629: P_TASK_VALUE IN FND_TABLE_OF_VARCHAR2_255,
2630: P_TASK_ERECORD IN FND_TABLE_OF_VARCHAR2_255,
2631: P_REQUESTER IN NUMBER,
2632: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2633: X_MSG_COUNT OUT NOCOPY NUMBER,
2634: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 2881: X_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,

2877:
2878: --Bug 5224634: start
2879: procedure GET_BATCHSTEP_NODES ( P_BATCH_ID IN NUMBER,
2880: P_BATCHSTEP_ID IN NUMBER,
2881: X_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2882: X_ENTITY_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2883: X_ENTITY_KEY OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2884: X_ENTITY_LEVEL OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2885: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 2882: X_ENTITY_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,

2878: --Bug 5224634: start
2879: procedure GET_BATCHSTEP_NODES ( P_BATCH_ID IN NUMBER,
2880: P_BATCHSTEP_ID IN NUMBER,
2881: X_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2882: X_ENTITY_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2883: X_ENTITY_KEY OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2884: X_ENTITY_LEVEL OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2885: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2886: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 2883: X_ENTITY_KEY OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,

2879: procedure GET_BATCHSTEP_NODES ( P_BATCH_ID IN NUMBER,
2880: P_BATCHSTEP_ID IN NUMBER,
2881: X_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2882: X_ENTITY_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2883: X_ENTITY_KEY OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2884: X_ENTITY_LEVEL OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2885: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2886: X_MSG_COUNT OUT NOCOPY NUMBER,
2887: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 2884: X_ENTITY_LEVEL OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,

2880: P_BATCHSTEP_ID IN NUMBER,
2881: X_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2882: X_ENTITY_NAME OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2883: X_ENTITY_KEY OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2884: X_ENTITY_LEVEL OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
2885: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2886: X_MSG_COUNT OUT NOCOPY NUMBER,
2887: X_MSG_DATA OUT NOCOPY VARCHAR2)
2888: IS

Line 2890: t_name fnd_table_of_varchar2_255;

2886: X_MSG_COUNT OUT NOCOPY NUMBER,
2887: X_MSG_DATA OUT NOCOPY VARCHAR2)
2888: IS
2889:
2890: t_name fnd_table_of_varchar2_255;
2891: t_entity_name fnd_table_of_varchar2_255;
2892: t_entity_key fnd_table_of_varchar2_255;
2893: t_entity_level fnd_table_of_varchar2_255;
2894:

Line 2891: t_entity_name fnd_table_of_varchar2_255;

2887: X_MSG_DATA OUT NOCOPY VARCHAR2)
2888: IS
2889:
2890: t_name fnd_table_of_varchar2_255;
2891: t_entity_name fnd_table_of_varchar2_255;
2892: t_entity_key fnd_table_of_varchar2_255;
2893: t_entity_level fnd_table_of_varchar2_255;
2894:
2895: l_entity_name varchar2(255);

Line 2892: t_entity_key fnd_table_of_varchar2_255;

2888: IS
2889:
2890: t_name fnd_table_of_varchar2_255;
2891: t_entity_name fnd_table_of_varchar2_255;
2892: t_entity_key fnd_table_of_varchar2_255;
2893: t_entity_level fnd_table_of_varchar2_255;
2894:
2895: l_entity_name varchar2(255);
2896: l_entity_key varchar2(255);

Line 2893: t_entity_level fnd_table_of_varchar2_255;

2889:
2890: t_name fnd_table_of_varchar2_255;
2891: t_entity_name fnd_table_of_varchar2_255;
2892: t_entity_key fnd_table_of_varchar2_255;
2893: t_entity_level fnd_table_of_varchar2_255;
2894:
2895: l_entity_name varchar2(255);
2896: l_entity_key varchar2(255);
2897:

Line 2932: t_name := fnd_table_of_varchar2_255();

2928:
2929:
2930: begin
2931:
2932: t_name := fnd_table_of_varchar2_255();
2933: t_entity_name := fnd_table_of_varchar2_255();
2934: t_entity_key := fnd_table_of_varchar2_255();
2935: t_entity_level := fnd_table_of_varchar2_255();
2936:

Line 2933: t_entity_name := fnd_table_of_varchar2_255();

2929:
2930: begin
2931:
2932: t_name := fnd_table_of_varchar2_255();
2933: t_entity_name := fnd_table_of_varchar2_255();
2934: t_entity_key := fnd_table_of_varchar2_255();
2935: t_entity_level := fnd_table_of_varchar2_255();
2936:
2937: x_name := fnd_table_of_varchar2_255();

Line 2934: t_entity_key := fnd_table_of_varchar2_255();

2930: begin
2931:
2932: t_name := fnd_table_of_varchar2_255();
2933: t_entity_name := fnd_table_of_varchar2_255();
2934: t_entity_key := fnd_table_of_varchar2_255();
2935: t_entity_level := fnd_table_of_varchar2_255();
2936:
2937: x_name := fnd_table_of_varchar2_255();
2938: x_entity_name := fnd_table_of_varchar2_255();

Line 2935: t_entity_level := fnd_table_of_varchar2_255();

2931:
2932: t_name := fnd_table_of_varchar2_255();
2933: t_entity_name := fnd_table_of_varchar2_255();
2934: t_entity_key := fnd_table_of_varchar2_255();
2935: t_entity_level := fnd_table_of_varchar2_255();
2936:
2937: x_name := fnd_table_of_varchar2_255();
2938: x_entity_name := fnd_table_of_varchar2_255();
2939: x_entity_key := fnd_table_of_varchar2_255();

Line 2937: x_name := fnd_table_of_varchar2_255();

2933: t_entity_name := fnd_table_of_varchar2_255();
2934: t_entity_key := fnd_table_of_varchar2_255();
2935: t_entity_level := fnd_table_of_varchar2_255();
2936:
2937: x_name := fnd_table_of_varchar2_255();
2938: x_entity_name := fnd_table_of_varchar2_255();
2939: x_entity_key := fnd_table_of_varchar2_255();
2940: x_entity_level := fnd_table_of_varchar2_255();
2941:

Line 2938: x_entity_name := fnd_table_of_varchar2_255();

2934: t_entity_key := fnd_table_of_varchar2_255();
2935: t_entity_level := fnd_table_of_varchar2_255();
2936:
2937: x_name := fnd_table_of_varchar2_255();
2938: x_entity_name := fnd_table_of_varchar2_255();
2939: x_entity_key := fnd_table_of_varchar2_255();
2940: x_entity_level := fnd_table_of_varchar2_255();
2941:
2942: l_counter := 0;

Line 2939: x_entity_key := fnd_table_of_varchar2_255();

2935: t_entity_level := fnd_table_of_varchar2_255();
2936:
2937: x_name := fnd_table_of_varchar2_255();
2938: x_entity_name := fnd_table_of_varchar2_255();
2939: x_entity_key := fnd_table_of_varchar2_255();
2940: x_entity_level := fnd_table_of_varchar2_255();
2941:
2942: l_counter := 0;
2943:

Line 2940: x_entity_level := fnd_table_of_varchar2_255();

2936:
2937: x_name := fnd_table_of_varchar2_255();
2938: x_entity_name := fnd_table_of_varchar2_255();
2939: x_entity_key := fnd_table_of_varchar2_255();
2940: x_entity_level := fnd_table_of_varchar2_255();
2941:
2942: l_counter := 0;
2943:
2944: open c_get_oprn;

Line 3089: l_invalid_instr fnd_table_of_varchar2_255;

3085: l_msg_data varchar2(4000);
3086: instruction_create_err exception;
3087:
3088: l_entity_display_name varchar2(255);
3089: l_invalid_instr fnd_table_of_varchar2_255;
3090: l_invalid_instr_master fnd_table_of_varchar2_255;
3091: l_invalid_entity_master fnd_table_of_varchar2_255;
3092:
3093: j binary_integer;

Line 3090: l_invalid_instr_master fnd_table_of_varchar2_255;

3086: instruction_create_err exception;
3087:
3088: l_entity_display_name varchar2(255);
3089: l_invalid_instr fnd_table_of_varchar2_255;
3090: l_invalid_instr_master fnd_table_of_varchar2_255;
3091: l_invalid_entity_master fnd_table_of_varchar2_255;
3092:
3093: j binary_integer;
3094: k binary_integer;

Line 3091: l_invalid_entity_master fnd_table_of_varchar2_255;

3087:
3088: l_entity_display_name varchar2(255);
3089: l_invalid_instr fnd_table_of_varchar2_255;
3090: l_invalid_instr_master fnd_table_of_varchar2_255;
3091: l_invalid_entity_master fnd_table_of_varchar2_255;
3092:
3093: j binary_integer;
3094: k binary_integer;
3095: l_attribute_Status varchar2(1);

Line 3132: l_invalid_entity_master := fnd_table_of_varchar2_255();

3128: BEGIN
3129:
3130: j := 0;
3131: k := 0;
3132: l_invalid_entity_master := fnd_table_of_varchar2_255();
3133: l_invalid_instr_master := fnd_table_of_varchar2_255();
3134:
3135: open c_get_steps;
3136: loop

Line 3133: l_invalid_instr_master := fnd_table_of_varchar2_255();

3129:
3130: j := 0;
3131: k := 0;
3132: l_invalid_entity_master := fnd_table_of_varchar2_255();
3133: l_invalid_instr_master := fnd_table_of_varchar2_255();
3134:
3135: open c_get_steps;
3136: loop
3137: fetch c_get_steps into l_batchstep_id, l_routingstep_id, l_oprn_id, l_entity_display_name;