APPS.PJM_TASK_AUTO_ASSIGN dependencies on PJM_TASK_ATTR_USAGES

Line 270: TYPE t_AttributeTable IS TABLE OF pjm_task_attr_usages.attribute_code%TYPE

266: L_task_id NUMBER;
267: L_category_id NUMBER;
268: L_procured VARCHAR2(1);
269: i NUMBER := 1;
270: TYPE t_AttributeTable IS TABLE OF pjm_task_attr_usages.attribute_code%TYPE
271: INDEX BY BINARY_INTEGER;
272: v_Attributes t_AttributeTable;
273:
274: CURSOR c1 IS

Line 276: FROM pjm_task_attr_usages

272: v_Attributes t_AttributeTable;
273:
274: CURSOR c1 IS
275: SELECT attribute_code
276: FROM pjm_task_attr_usages
277: WHERE assignment_type = 'MATERIAL'
278: ORDER BY sequence_number;
279:
280: CURSOR c2 ( C_org_id NUMBER

Line 397: TYPE t_AttributeTable IS TABLE OF pjm_task_attr_usages.attribute_code%TYPE

393:
394: L_task_id NUMBER;
395: L_wip_entity VARCHAR2(240);
396: i NUMBER := 1;
397: TYPE t_AttributeTable IS TABLE OF pjm_task_attr_usages.attribute_code%TYPE
398: INDEX BY BINARY_INTEGER;
399: v_Attributes t_AttributeTable;
400:
401: CURSOR c1 IS

Line 403: FROM pjm_task_attr_usages

399: v_Attributes t_AttributeTable;
400:
401: CURSOR c1 IS
402: SELECT attribute_code
403: FROM pjm_task_attr_usages
404: WHERE assignment_type = 'RESOURCE'
405: ORDER BY sequence_number;
406:
407: CURSOR c2 ( C_org_id NUMBER

Line 527: TYPE t_AttributeTable IS TABLE OF pjm_task_attr_usages.attribute_code%TYPE

523: L_task_id NUMBER;
524: L_category_id NUMBER;
525: L_wip_entity VARCHAR2(240);
526: i NUMBER := 1;
527: TYPE t_AttributeTable IS TABLE OF pjm_task_attr_usages.attribute_code%TYPE
528: INDEX BY BINARY_INTEGER;
529: v_Attributes t_AttributeTable;
530:
531: CURSOR c1 IS

Line 533: FROM pjm_task_attr_usages

529: v_Attributes t_AttributeTable;
530:
531: CURSOR c1 IS
532: SELECT attribute_code
533: FROM pjm_task_attr_usages
534: WHERE assignment_type = 'WIPMAT'
535: ORDER BY sequence_number;
536:
537: CURSOR c2 ( C_org_id NUMBER