DBA Data[Home] [Help]

APPS.INV_INVIRILC_XMLP_PKG dependencies on MTL_TASK_V

Line 536: L_TASK_ID MTL_TASK_V.TASK_ID%TYPE;

532: CNT NUMBER := 0;
533: L_LOC_LEFT_STR VARCHAR2(820);
534: L_LOC_RIGHT_STR VARCHAR2(820);
535: L_PROJECT_ID MTL_PROJECT_V.PROJECT_ID%TYPE;
536: L_TASK_ID MTL_TASK_V.TASK_ID%TYPE;
537: L_PROJECT_NUMBER MTL_PROJECT_V.PROJECT_NUMBER%TYPE;
538: L_TASK_NUMBER MTL_TASK_V.TASK_NUMBER%TYPE;
539: L_LOC_DATA VARCHAR2(820);
540: L_DELIMITER VARCHAR2(10);

Line 538: L_TASK_NUMBER MTL_TASK_V.TASK_NUMBER%TYPE;

534: L_LOC_RIGHT_STR VARCHAR2(820);
535: L_PROJECT_ID MTL_PROJECT_V.PROJECT_ID%TYPE;
536: L_TASK_ID MTL_TASK_V.TASK_ID%TYPE;
537: L_PROJECT_NUMBER MTL_PROJECT_V.PROJECT_NUMBER%TYPE;
538: L_TASK_NUMBER MTL_TASK_V.TASK_NUMBER%TYPE;
539: L_LOC_DATA VARCHAR2(820);
540: L_DELIMITER VARCHAR2(10);
541: BEGIN
542: BEGIN

Line 670: MTL_TASK_V

666: SELECT
667: TASK_NUMBER
668: INTO L_TASK_NUMBER
669: FROM
670: MTL_TASK_V
671: WHERE PROJECT_ID = L_PROJECT_ID
672: AND TASK_ID = L_TASK_ID;
673: EXCEPTION
674: WHEN OTHERS THEN