DBA Data[Home] [Help]

APPS.INV_INVIRILC_XMLP_PKG dependencies on MTL_PROJECT_V

Line 535: L_PROJECT_ID MTL_PROJECT_V.PROJECT_ID%TYPE;

531: L_LOC_TEMP VARCHAR2(820);
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);

Line 537: L_PROJECT_NUMBER MTL_PROJECT_V.PROJECT_NUMBER%TYPE;

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);
541: BEGIN

Line 614: MTL_PROJECT_V

610: SELECT
611: PROJECT_NUMBER
612: INTO L_PROJECT_NUMBER
613: FROM
614: MTL_PROJECT_V
615: WHERE PROJECT_ID = L_PROJECT_ID;
616: EXCEPTION
617: WHEN OTHERS THEN
618: RETURN (P_LOC);