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.PA_PROJECT_INTEGRATION_PUB dependencies on TASK_IN_OBJ

Line 61: --L_TASKS_IN_OBJ TASK_IN_OBJ;

57: L_PROJECT_OUT_OBJ SYSTEM.PROJECT_OUT_OBJ;
58:
59: L_PROJECT_OUT_TBL SYSTEM.PROJECT_OUT_OBJ_TBL;
60:
61: --L_TASKS_IN_OBJ TASK_IN_OBJ;
62: --L_TASKS_OUT_OBJ TASK_OUT_OBJ;
63: --L_STRUCTURE_IN_OBJ STRUCTURE_IN_OBJ;
64: -- Tables
65:

Line 1486: L_TASK_IN_OBJ_TABLE SYSTEM.TASK_IN_OBJ_TBL;

1482:
1483: L_TASK_IN_REC pa_project_pub.TASK_IN_REC_TYPE;
1484: L_TASKS_IN_REC_TBL pa_project_pub.TASK_IN_TBL_TYPE;
1485: L_STRUCTURE_IN_OBJ SYSTEM.STRUCTURE_IN_OBJ;
1486: L_TASK_IN_OBJ_TABLE SYSTEM.TASK_IN_OBJ_TBL;
1487: L_TASK_IN_OBJ SYSTEM.TASK_IN_OBJ;
1488: L_COUNTER NUMBER := 1;
1489:
1490: T_TASK_IN_OBJ_TABLE SYSTEM.TASK_IN_OBJ_TBL;

Line 1487: L_TASK_IN_OBJ SYSTEM.TASK_IN_OBJ;

1483: L_TASK_IN_REC pa_project_pub.TASK_IN_REC_TYPE;
1484: L_TASKS_IN_REC_TBL pa_project_pub.TASK_IN_TBL_TYPE;
1485: L_STRUCTURE_IN_OBJ SYSTEM.STRUCTURE_IN_OBJ;
1486: L_TASK_IN_OBJ_TABLE SYSTEM.TASK_IN_OBJ_TBL;
1487: L_TASK_IN_OBJ SYSTEM.TASK_IN_OBJ;
1488: L_COUNTER NUMBER := 1;
1489:
1490: T_TASK_IN_OBJ_TABLE SYSTEM.TASK_IN_OBJ_TBL;
1491:

Line 1490: T_TASK_IN_OBJ_TABLE SYSTEM.TASK_IN_OBJ_TBL;

1486: L_TASK_IN_OBJ_TABLE SYSTEM.TASK_IN_OBJ_TBL;
1487: L_TASK_IN_OBJ SYSTEM.TASK_IN_OBJ;
1488: L_COUNTER NUMBER := 1;
1489:
1490: T_TASK_IN_OBJ_TABLE SYSTEM.TASK_IN_OBJ_TBL;
1491:
1492: --l_RES_ASSIGN_OBJ_TBL PROJECT_RES_ASSIGN_OBJ_TBL ;
1493: l_PLANNED_OBJECT SYSTEM.PROJECT_TASK_PLANNED_OBJ ;
1494: l_EARNED_OBJECT SYSTEM.PROJECT_TASK_EARNED_OBJ ;

Line 1521: T_TASK_IN_OBJ_TABLE := L_STRUCTURE_IN_OBJ.TASK_IN_OBJ_TABLE;

1517: log_pvt('LOAD_PROEJCT','START PROECDURE ');
1518:
1519: l_project_in_obj := p_project_in_obj;
1520: l_STRUCTURE_IN_OBJ := l_PROJECT_IN_OBJ.STRUCTURE_IN_OBJECT;
1521: T_TASK_IN_OBJ_TABLE := L_STRUCTURE_IN_OBJ.TASK_IN_OBJ_TABLE;
1522:
1523:
1524:
1525: --------START Convert fnd_api.g_miss* to pa g_miss -----------------------------

Line 1916: if ( l_return_status = 'S' AND T_TASK_IN_OBJ_TABLE is not null) then

1912:
1913: ---------- task start -----------------------------------------------
1914:
1915:
1916: if ( l_return_status = 'S' AND T_TASK_IN_OBJ_TABLE is not null) then
1917:
1918: if (T_TASK_IN_OBJ_TABLE.count > 0) then
1919:
1920: wbs_order (

Line 1918: if (T_TASK_IN_OBJ_TABLE.count > 0) then

1914:
1915:
1916: if ( l_return_status = 'S' AND T_TASK_IN_OBJ_TABLE is not null) then
1917:
1918: if (T_TASK_IN_OBJ_TABLE.count > 0) then
1919:
1920: wbs_order (
1921: P_TASK_IN_OBJ_TABLE => T_TASK_IN_OBJ_TABLE,
1922: P_PROJECT_IN_REC => L_PROJECT_IN_REC,

Line 1921: P_TASK_IN_OBJ_TABLE => T_TASK_IN_OBJ_TABLE,

1917:
1918: if (T_TASK_IN_OBJ_TABLE.count > 0) then
1919:
1920: wbs_order (
1921: P_TASK_IN_OBJ_TABLE => T_TASK_IN_OBJ_TABLE,
1922: P_PROJECT_IN_REC => L_PROJECT_IN_REC,
1923: P_STRUCTURE_IN_REC => L_STRUCTURE_IN_REC,
1924: X_TASK_IN_OBJ_TABLE => L_TASK_IN_OBJ_TABLE,
1925: X_DELETE_TASK_ID_TBL => LL_DELETE_TASK_ID_TBL,

Line 1924: X_TASK_IN_OBJ_TABLE => L_TASK_IN_OBJ_TABLE,

1920: wbs_order (
1921: P_TASK_IN_OBJ_TABLE => T_TASK_IN_OBJ_TABLE,
1922: P_PROJECT_IN_REC => L_PROJECT_IN_REC,
1923: P_STRUCTURE_IN_REC => L_STRUCTURE_IN_REC,
1924: X_TASK_IN_OBJ_TABLE => L_TASK_IN_OBJ_TABLE,
1925: X_DELETE_TASK_ID_TBL => LL_DELETE_TASK_ID_TBL,
1926: X_DELETE_TASK_ver_ID_TBL => LL_DELETE_TASK_VER_ID_TBL
1927: );
1928:

Line 1929: log_pvt('LOAD_PROEJCT',' L_TASK_IN_OBJ_TABLE.count '|| L_TASK_IN_OBJ_TABLE.count);

1925: X_DELETE_TASK_ID_TBL => LL_DELETE_TASK_ID_TBL,
1926: X_DELETE_TASK_ver_ID_TBL => LL_DELETE_TASK_VER_ID_TBL
1927: );
1928:
1929: log_pvt('LOAD_PROEJCT',' L_TASK_IN_OBJ_TABLE.count '|| L_TASK_IN_OBJ_TABLE.count);
1930:
1931: FOR i in L_TASK_IN_OBJ_TABLE.FIRST .. L_TASK_IN_OBJ_TABLE.LAST LOOP
1932:
1933:

Line 1931: FOR i in L_TASK_IN_OBJ_TABLE.FIRST .. L_TASK_IN_OBJ_TABLE.LAST LOOP

1927: );
1928:
1929: log_pvt('LOAD_PROEJCT',' L_TASK_IN_OBJ_TABLE.count '|| L_TASK_IN_OBJ_TABLE.count);
1930:
1931: FOR i in L_TASK_IN_OBJ_TABLE.FIRST .. L_TASK_IN_OBJ_TABLE.LAST LOOP
1932:
1933:
1934: L_TASK_IN_OBJ := L_TASK_IN_OBJ_TABLE(i);
1935:

Line 1934: L_TASK_IN_OBJ := L_TASK_IN_OBJ_TABLE(i);

1930:
1931: FOR i in L_TASK_IN_OBJ_TABLE.FIRST .. L_TASK_IN_OBJ_TABLE.LAST LOOP
1932:
1933:
1934: L_TASK_IN_OBJ := L_TASK_IN_OBJ_TABLE(i);
1935:
1936: log_pvt('LOAD_PROEJCT',' TASK_REF '||L_TASK_IN_OBJ.PM_TASK_REFERENCE||' PA_TASK_ID '||L_TASK_IN_OBJ.PA_TASK_ID || ' parent_task_id '|| L_TASK_in_obj.PA_PARENT_TASK_ID );
1937: log_pvt('LOAD_PROEJCT',' L_TASK_in_obj.PA_TASK_NUMBER '||L_TASK_in_obj.PA_TASK_NUMBER||' PA_TASK_ID '||L_TASK_IN_OBJ.PA_TASK_ID || ' parent_task_id '|| L_TASK_in_obj.PA_PARENT_TASK_ID );
1938:

Line 1936: log_pvt('LOAD_PROEJCT',' TASK_REF '||L_TASK_IN_OBJ.PM_TASK_REFERENCE||' PA_TASK_ID '||L_TASK_IN_OBJ.PA_TASK_ID || ' parent_task_id '|| L_TASK_in_obj.PA_PARENT_TASK_ID );

1932:
1933:
1934: L_TASK_IN_OBJ := L_TASK_IN_OBJ_TABLE(i);
1935:
1936: log_pvt('LOAD_PROEJCT',' TASK_REF '||L_TASK_IN_OBJ.PM_TASK_REFERENCE||' PA_TASK_ID '||L_TASK_IN_OBJ.PA_TASK_ID || ' parent_task_id '|| L_TASK_in_obj.PA_PARENT_TASK_ID );
1937: log_pvt('LOAD_PROEJCT',' L_TASK_in_obj.PA_TASK_NUMBER '||L_TASK_in_obj.PA_TASK_NUMBER||' PA_TASK_ID '||L_TASK_IN_OBJ.PA_TASK_ID || ' parent_task_id '|| L_TASK_in_obj.PA_PARENT_TASK_ID );
1938:
1939: l_res_assign_tbl := L_TASK_IN_OBJ.RES_ASSIGN_OBJ_TBL;
1940:

Line 1937: log_pvt('LOAD_PROEJCT',' L_TASK_in_obj.PA_TASK_NUMBER '||L_TASK_in_obj.PA_TASK_NUMBER||' PA_TASK_ID '||L_TASK_IN_OBJ.PA_TASK_ID || ' parent_task_id '|| L_TASK_in_obj.PA_PARENT_TASK_ID );

1933:
1934: L_TASK_IN_OBJ := L_TASK_IN_OBJ_TABLE(i);
1935:
1936: log_pvt('LOAD_PROEJCT',' TASK_REF '||L_TASK_IN_OBJ.PM_TASK_REFERENCE||' PA_TASK_ID '||L_TASK_IN_OBJ.PA_TASK_ID || ' parent_task_id '|| L_TASK_in_obj.PA_PARENT_TASK_ID );
1937: log_pvt('LOAD_PROEJCT',' L_TASK_in_obj.PA_TASK_NUMBER '||L_TASK_in_obj.PA_TASK_NUMBER||' PA_TASK_ID '||L_TASK_IN_OBJ.PA_TASK_ID || ' parent_task_id '|| L_TASK_in_obj.PA_PARENT_TASK_ID );
1938:
1939: l_res_assign_tbl := L_TASK_IN_OBJ.RES_ASSIGN_OBJ_TBL;
1940:
1941: -- IMPORTANT NOTE :

Line 1939: l_res_assign_tbl := L_TASK_IN_OBJ.RES_ASSIGN_OBJ_TBL;

1935:
1936: log_pvt('LOAD_PROEJCT',' TASK_REF '||L_TASK_IN_OBJ.PM_TASK_REFERENCE||' PA_TASK_ID '||L_TASK_IN_OBJ.PA_TASK_ID || ' parent_task_id '|| L_TASK_in_obj.PA_PARENT_TASK_ID );
1937: log_pvt('LOAD_PROEJCT',' L_TASK_in_obj.PA_TASK_NUMBER '||L_TASK_in_obj.PA_TASK_NUMBER||' PA_TASK_ID '||L_TASK_IN_OBJ.PA_TASK_ID || ' parent_task_id '|| L_TASK_in_obj.PA_PARENT_TASK_ID );
1938:
1939: l_res_assign_tbl := L_TASK_IN_OBJ.RES_ASSIGN_OBJ_TBL;
1940:
1941: -- IMPORTANT NOTE :
1942: --- Always getting task_id as null / g_pa_miss_num. Will realy on pm_task_reference for task updates.
1943: --- This allows to support use case where a task is deleted in EBS , but exist in P6.

Line 1952: if ( L_TASK_in_obj.PA_TASK_ID = FND_API.G_MISS_NUM ) then

1948: --
1949:
1950: /**
1951:
1952: if ( L_TASK_in_obj.PA_TASK_ID = FND_API.G_MISS_NUM ) then
1953: L_TASK_IN_REC.PA_TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1954: else
1955: L_TASK_IN_REC.PA_TASK_ID := L_TASK_IN_OBJ.PA_TASK_ID;
1956: end if;

Line 1955: L_TASK_IN_REC.PA_TASK_ID := L_TASK_IN_OBJ.PA_TASK_ID;

1951:
1952: if ( L_TASK_in_obj.PA_TASK_ID = FND_API.G_MISS_NUM ) then
1953: L_TASK_IN_REC.PA_TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1954: else
1955: L_TASK_IN_REC.PA_TASK_ID := L_TASK_IN_OBJ.PA_TASK_ID;
1956: end if;
1957: **/
1958:
1959: L_TASK_IN_REC.PA_TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

Line 1962: if ( L_TASK_in_obj.TASK_NAME = FND_API.G_MISS_CHAR ) then

1958:
1959: L_TASK_IN_REC.PA_TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1960:
1961:
1962: if ( L_TASK_in_obj.TASK_NAME = FND_API.G_MISS_CHAR ) then
1963: L_TASK_IN_REC.TASK_NAME := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1964: else
1965: L_TASK_IN_REC.TASK_NAME := L_TASK_IN_OBJ.TASK_NAME;
1966: L_TASK_IN_REC.LONG_TASK_NAME := L_TASK_IN_OBJ.TASK_NAME;

Line 1965: L_TASK_IN_REC.TASK_NAME := L_TASK_IN_OBJ.TASK_NAME;

1961:
1962: if ( L_TASK_in_obj.TASK_NAME = FND_API.G_MISS_CHAR ) then
1963: L_TASK_IN_REC.TASK_NAME := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1964: else
1965: L_TASK_IN_REC.TASK_NAME := L_TASK_IN_OBJ.TASK_NAME;
1966: L_TASK_IN_REC.LONG_TASK_NAME := L_TASK_IN_OBJ.TASK_NAME;
1967: end if;
1968:
1969: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.TASK_NAME '|| L_TASK_IN_REC.TASK_NAME);

Line 1966: L_TASK_IN_REC.LONG_TASK_NAME := L_TASK_IN_OBJ.TASK_NAME;

1962: if ( L_TASK_in_obj.TASK_NAME = FND_API.G_MISS_CHAR ) then
1963: L_TASK_IN_REC.TASK_NAME := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1964: else
1965: L_TASK_IN_REC.TASK_NAME := L_TASK_IN_OBJ.TASK_NAME;
1966: L_TASK_IN_REC.LONG_TASK_NAME := L_TASK_IN_OBJ.TASK_NAME;
1967: end if;
1968:
1969: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.TASK_NAME '|| L_TASK_IN_REC.TASK_NAME);
1970:

Line 1971: if ( L_TASK_in_obj.PA_TASK_NUMBER = FND_API.G_MISS_CHAR ) then

1967: end if;
1968:
1969: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.TASK_NAME '|| L_TASK_IN_REC.TASK_NAME);
1970:
1971: if ( L_TASK_in_obj.PA_TASK_NUMBER = FND_API.G_MISS_CHAR ) then
1972: L_TASK_IN_REC.PA_TASK_NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1973: else
1974: L_TASK_IN_REC.PA_TASK_NUMBER := L_TASK_IN_OBJ.PA_TASK_NUMBER;
1975: end if;

Line 1974: L_TASK_IN_REC.PA_TASK_NUMBER := L_TASK_IN_OBJ.PA_TASK_NUMBER;

1970:
1971: if ( L_TASK_in_obj.PA_TASK_NUMBER = FND_API.G_MISS_CHAR ) then
1972: L_TASK_IN_REC.PA_TASK_NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1973: else
1974: L_TASK_IN_REC.PA_TASK_NUMBER := L_TASK_IN_OBJ.PA_TASK_NUMBER;
1975: end if;
1976:
1977: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.PA_TASK_NUMBER '|| L_TASK_IN_REC.PA_TASK_NUMBER);
1978: if ( L_TASK_in_obj.TASK_DESCRIPTION = FND_API.G_MISS_CHAR ) then

Line 1978: if ( L_TASK_in_obj.TASK_DESCRIPTION = FND_API.G_MISS_CHAR ) then

1974: L_TASK_IN_REC.PA_TASK_NUMBER := L_TASK_IN_OBJ.PA_TASK_NUMBER;
1975: end if;
1976:
1977: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.PA_TASK_NUMBER '|| L_TASK_IN_REC.PA_TASK_NUMBER);
1978: if ( L_TASK_in_obj.TASK_DESCRIPTION = FND_API.G_MISS_CHAR ) then
1979: L_TASK_IN_REC.TASK_DESCRIPTION := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1980: else
1981: L_TASK_IN_REC.TASK_DESCRIPTION := L_TASK_IN_OBJ.TASK_DESCRIPTION;
1982: end if;

Line 1981: L_TASK_IN_REC.TASK_DESCRIPTION := L_TASK_IN_OBJ.TASK_DESCRIPTION;

1977: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.PA_TASK_NUMBER '|| L_TASK_IN_REC.PA_TASK_NUMBER);
1978: if ( L_TASK_in_obj.TASK_DESCRIPTION = FND_API.G_MISS_CHAR ) then
1979: L_TASK_IN_REC.TASK_DESCRIPTION := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1980: else
1981: L_TASK_IN_REC.TASK_DESCRIPTION := L_TASK_IN_OBJ.TASK_DESCRIPTION;
1982: end if;
1983:
1984: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.TASK_DESCRIPTION '|| L_TASK_IN_REC.TASK_DESCRIPTION);
1985: if ( L_TASK_in_obj.PM_TASK_REFERENCE = FND_API.G_MISS_CHAR ) then

Line 1985: if ( L_TASK_in_obj.PM_TASK_REFERENCE = FND_API.G_MISS_CHAR ) then

1981: L_TASK_IN_REC.TASK_DESCRIPTION := L_TASK_IN_OBJ.TASK_DESCRIPTION;
1982: end if;
1983:
1984: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.TASK_DESCRIPTION '|| L_TASK_IN_REC.TASK_DESCRIPTION);
1985: if ( L_TASK_in_obj.PM_TASK_REFERENCE = FND_API.G_MISS_CHAR ) then
1986: L_TASK_IN_REC.PM_TASK_REFERENCE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1987: else
1988: L_TASK_IN_REC.PM_TASK_REFERENCE := L_TASK_IN_OBJ.PM_TASK_REFERENCE;
1989: end if;

Line 1988: L_TASK_IN_REC.PM_TASK_REFERENCE := L_TASK_IN_OBJ.PM_TASK_REFERENCE;

1984: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.TASK_DESCRIPTION '|| L_TASK_IN_REC.TASK_DESCRIPTION);
1985: if ( L_TASK_in_obj.PM_TASK_REFERENCE = FND_API.G_MISS_CHAR ) then
1986: L_TASK_IN_REC.PM_TASK_REFERENCE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1987: else
1988: L_TASK_IN_REC.PM_TASK_REFERENCE := L_TASK_IN_OBJ.PM_TASK_REFERENCE;
1989: end if;
1990:
1991: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.PM_TASK_REFERENCE '|| L_TASK_IN_REC.PM_TASK_REFERENCE);
1992: if ( L_TASK_in_obj.PM_PARENT_TASK_REFERENCE = FND_API.G_MISS_CHAR ) then

Line 1992: if ( L_TASK_in_obj.PM_PARENT_TASK_REFERENCE = FND_API.G_MISS_CHAR ) then

1988: L_TASK_IN_REC.PM_TASK_REFERENCE := L_TASK_IN_OBJ.PM_TASK_REFERENCE;
1989: end if;
1990:
1991: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.PM_TASK_REFERENCE '|| L_TASK_IN_REC.PM_TASK_REFERENCE);
1992: if ( L_TASK_in_obj.PM_PARENT_TASK_REFERENCE = FND_API.G_MISS_CHAR ) then
1993: L_TASK_IN_REC.PM_PARENT_TASK_REFERENCE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1994: else
1995: L_TASK_IN_REC.PM_PARENT_TASK_REFERENCE := L_TASK_IN_OBJ.PM_PARENT_TASK_REFERENCE;
1996: end if;

Line 1995: L_TASK_IN_REC.PM_PARENT_TASK_REFERENCE := L_TASK_IN_OBJ.PM_PARENT_TASK_REFERENCE;

1991: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.PM_TASK_REFERENCE '|| L_TASK_IN_REC.PM_TASK_REFERENCE);
1992: if ( L_TASK_in_obj.PM_PARENT_TASK_REFERENCE = FND_API.G_MISS_CHAR ) then
1993: L_TASK_IN_REC.PM_PARENT_TASK_REFERENCE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1994: else
1995: L_TASK_IN_REC.PM_PARENT_TASK_REFERENCE := L_TASK_IN_OBJ.PM_PARENT_TASK_REFERENCE;
1996: end if;
1997:
1998: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.PM_PARENT_TASK_REFERENCE '||L_TASK_IN_REC.PM_PARENT_TASK_REFERENCE);
1999: /**

Line 2000: if ( L_TASK_in_obj.PA_PARENT_TASK_ID = FND_API.G_MISS_NUM ) then

1996: end if;
1997:
1998: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.PM_PARENT_TASK_REFERENCE '||L_TASK_IN_REC.PM_PARENT_TASK_REFERENCE);
1999: /**
2000: if ( L_TASK_in_obj.PA_PARENT_TASK_ID = FND_API.G_MISS_NUM ) then
2001: L_TASK_IN_REC.PA_PARENT_TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2002: else
2003: L_TASK_IN_REC.PA_PARENT_TASK_ID := L_TASK_IN_OBJ.PA_PARENT_TASK_ID;
2004: end if;

Line 2003: L_TASK_IN_REC.PA_PARENT_TASK_ID := L_TASK_IN_OBJ.PA_PARENT_TASK_ID;

1999: /**
2000: if ( L_TASK_in_obj.PA_PARENT_TASK_ID = FND_API.G_MISS_NUM ) then
2001: L_TASK_IN_REC.PA_PARENT_TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2002: else
2003: L_TASK_IN_REC.PA_PARENT_TASK_ID := L_TASK_IN_OBJ.PA_PARENT_TASK_ID;
2004: end if;
2005: **/
2006:
2007: L_TASK_IN_REC.PA_PARENT_TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

Line 2010: if ( L_TASK_in_obj.TASK_START_DATE = FND_API.G_MISS_DATE ) then

2006:
2007: L_TASK_IN_REC.PA_PARENT_TASK_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2008:
2009:
2010: if ( L_TASK_in_obj.TASK_START_DATE = FND_API.G_MISS_DATE ) then
2011: L_TASK_IN_REC.TASK_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2012: else
2013: L_TASK_IN_REC.TASK_START_DATE := trunc(L_TASK_IN_OBJ.TASK_START_DATE);
2014: end if;

Line 2013: L_TASK_IN_REC.TASK_START_DATE := trunc(L_TASK_IN_OBJ.TASK_START_DATE);

2009:
2010: if ( L_TASK_in_obj.TASK_START_DATE = FND_API.G_MISS_DATE ) then
2011: L_TASK_IN_REC.TASK_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2012: else
2013: L_TASK_IN_REC.TASK_START_DATE := trunc(L_TASK_IN_OBJ.TASK_START_DATE);
2014: end if;
2015:
2016: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.TASK_START_DATE '|| L_TASK_IN_REC.TASK_START_DATE);
2017:

Line 2018: if ( L_TASK_in_obj.TASK_COMPLETION_DATE = FND_API.G_MISS_DATE ) then

2014: end if;
2015:
2016: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.TASK_START_DATE '|| L_TASK_IN_REC.TASK_START_DATE);
2017:
2018: if ( L_TASK_in_obj.TASK_COMPLETION_DATE = FND_API.G_MISS_DATE ) then
2019: L_TASK_IN_REC.TASK_COMPLETION_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2020: else
2021: L_TASK_IN_REC.TASK_COMPLETION_DATE := trunc(nvl(trunc(L_TASK_IN_OBJ.TASK_COMPLETION_DATE), L_PROJECT_IN_REC.COMPLETION_DATE));
2022: end if;

Line 2021: L_TASK_IN_REC.TASK_COMPLETION_DATE := trunc(nvl(trunc(L_TASK_IN_OBJ.TASK_COMPLETION_DATE), L_PROJECT_IN_REC.COMPLETION_DATE));

2017:
2018: if ( L_TASK_in_obj.TASK_COMPLETION_DATE = FND_API.G_MISS_DATE ) then
2019: L_TASK_IN_REC.TASK_COMPLETION_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE;
2020: else
2021: L_TASK_IN_REC.TASK_COMPLETION_DATE := trunc(nvl(trunc(L_TASK_IN_OBJ.TASK_COMPLETION_DATE), L_PROJECT_IN_REC.COMPLETION_DATE));
2022: end if;
2023:
2024:
2025: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.TASK_COMPLETION_DATE '|| L_TASK_IN_REC.TASK_COMPLETION_DATE);

Line 2026: --L_RES_ASSIGN_OBJ_TBL := l_task_in_obj.res_assign_obj_tbl;

2022: end if;
2023:
2024:
2025: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.TASK_COMPLETION_DATE '|| L_TASK_IN_REC.TASK_COMPLETION_DATE);
2026: --L_RES_ASSIGN_OBJ_TBL := l_task_in_obj.res_assign_obj_tbl;
2027: L_PLANNED_OBJECT := l_task_in_obj.planned_object;
2028: L_EARNED_OBJECT := l_task_in_obj.earned_object;
2029: L_TASK_EST_OBJECT := l_task_in_obj.task_est_object;
2030: L_TASK_PER_COMP_OBJECT := l_task_in_obj.task_per_comp_object;

Line 2027: L_PLANNED_OBJECT := l_task_in_obj.planned_object;

2023:
2024:
2025: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.TASK_COMPLETION_DATE '|| L_TASK_IN_REC.TASK_COMPLETION_DATE);
2026: --L_RES_ASSIGN_OBJ_TBL := l_task_in_obj.res_assign_obj_tbl;
2027: L_PLANNED_OBJECT := l_task_in_obj.planned_object;
2028: L_EARNED_OBJECT := l_task_in_obj.earned_object;
2029: L_TASK_EST_OBJECT := l_task_in_obj.task_est_object;
2030: L_TASK_PER_COMP_OBJECT := l_task_in_obj.task_per_comp_object;
2031:

Line 2028: L_EARNED_OBJECT := l_task_in_obj.earned_object;

2024:
2025: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.TASK_COMPLETION_DATE '|| L_TASK_IN_REC.TASK_COMPLETION_DATE);
2026: --L_RES_ASSIGN_OBJ_TBL := l_task_in_obj.res_assign_obj_tbl;
2027: L_PLANNED_OBJECT := l_task_in_obj.planned_object;
2028: L_EARNED_OBJECT := l_task_in_obj.earned_object;
2029: L_TASK_EST_OBJECT := l_task_in_obj.task_est_object;
2030: L_TASK_PER_COMP_OBJECT := l_task_in_obj.task_per_comp_object;
2031:
2032: -- Never to update EAC values for current working version. AMEHROTR. Bug 8790577.

Line 2029: L_TASK_EST_OBJECT := l_task_in_obj.task_est_object;

2025: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.TASK_COMPLETION_DATE '|| L_TASK_IN_REC.TASK_COMPLETION_DATE);
2026: --L_RES_ASSIGN_OBJ_TBL := l_task_in_obj.res_assign_obj_tbl;
2027: L_PLANNED_OBJECT := l_task_in_obj.planned_object;
2028: L_EARNED_OBJECT := l_task_in_obj.earned_object;
2029: L_TASK_EST_OBJECT := l_task_in_obj.task_est_object;
2030: L_TASK_PER_COMP_OBJECT := l_task_in_obj.task_per_comp_object;
2031:
2032: -- Never to update EAC values for current working version. AMEHROTR. Bug 8790577.
2033: L_TASK_EST_OBJECT.EAC_LABOR_QTY := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

Line 2030: L_TASK_PER_COMP_OBJECT := l_task_in_obj.task_per_comp_object;

2026: --L_RES_ASSIGN_OBJ_TBL := l_task_in_obj.res_assign_obj_tbl;
2027: L_PLANNED_OBJECT := l_task_in_obj.planned_object;
2028: L_EARNED_OBJECT := l_task_in_obj.earned_object;
2029: L_TASK_EST_OBJECT := l_task_in_obj.task_est_object;
2030: L_TASK_PER_COMP_OBJECT := l_task_in_obj.task_per_comp_object;
2031:
2032: -- Never to update EAC values for current working version. AMEHROTR. Bug 8790577.
2033: L_TASK_EST_OBJECT.EAC_LABOR_QTY := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
2034: L_TASK_EST_OBJECT.EAC_LABOR_COST := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;

Line 2131: ll_task_com_id_tbl(l_counter) := L_TASK_IN_OBJ.aia_common_id;

2127:
2128: log_pvt('LOAD_PROEJCT',' L_TASK_IN_REC.percent_complete '|| L_TASK_IN_REC.percent_complete);
2129:
2130:
2131: ll_task_com_id_tbl(l_counter) := L_TASK_IN_OBJ.aia_common_id;
2132:
2133: ll_task_id_ref_tbl( L_TASK_IN_REC.PM_TASK_REFERENCE) := l_counter;
2134:
2135:

Line 2321: P_TASK_IN_OBJ_TABLE IN SYSTEM.TASK_IN_OBJ_TBL,

2317: END LOAD_PROJECT_IN_REC;
2318:
2319:
2320: PROCEDURE wbs_order (
2321: P_TASK_IN_OBJ_TABLE IN SYSTEM.TASK_IN_OBJ_TBL,
2322: P_PROJECT_IN_REC IN PA_PROJECT_PUB.PROJECT_IN_REC_TYPE ,
2323: P_STRUCTURE_IN_REC IN PA_PROJECT_PUB.STRUCTURE_IN_REC_TYPE,
2324: X_TASK_IN_OBJ_TABLE OUT NOCOPY SYSTEM.TASK_IN_OBJ_TBL,
2325: X_DELETE_TASK_VER_ID_TBL OUT NOCOPY G_NUM_TBL,

Line 2324: X_TASK_IN_OBJ_TABLE OUT NOCOPY SYSTEM.TASK_IN_OBJ_TBL,

2320: PROCEDURE wbs_order (
2321: P_TASK_IN_OBJ_TABLE IN SYSTEM.TASK_IN_OBJ_TBL,
2322: P_PROJECT_IN_REC IN PA_PROJECT_PUB.PROJECT_IN_REC_TYPE ,
2323: P_STRUCTURE_IN_REC IN PA_PROJECT_PUB.STRUCTURE_IN_REC_TYPE,
2324: X_TASK_IN_OBJ_TABLE OUT NOCOPY SYSTEM.TASK_IN_OBJ_TBL,
2325: X_DELETE_TASK_VER_ID_TBL OUT NOCOPY G_NUM_TBL,
2326: X_DELETE_TASK_ID_TBL OUT NOCOPY G_NUM_TBL
2327: ) IS
2328:

Line 2339: tl_task_in_obj_table SYSTEM.TASK_IN_OBJ_TBL;

2335:
2336: l_task_id_tbl g_num_tbl;
2337: l_list_tbl g_num_tbl;
2338:
2339: tl_task_in_obj_table SYSTEM.TASK_IN_OBJ_TBL;
2340: f_task_in_obj_table SYSTEM.TASK_IN_OBJ_TBL;
2341: tl_task_in_obj SYSTEM.TASK_IN_OBJ;
2342:
2343: l_proj_ref varchar2(100);

Line 2340: f_task_in_obj_table SYSTEM.TASK_IN_OBJ_TBL;

2336: l_task_id_tbl g_num_tbl;
2337: l_list_tbl g_num_tbl;
2338:
2339: tl_task_in_obj_table SYSTEM.TASK_IN_OBJ_TBL;
2340: f_task_in_obj_table SYSTEM.TASK_IN_OBJ_TBL;
2341: tl_task_in_obj SYSTEM.TASK_IN_OBJ;
2342:
2343: l_proj_ref varchar2(100);
2344:

Line 2341: tl_task_in_obj SYSTEM.TASK_IN_OBJ;

2337: l_list_tbl g_num_tbl;
2338:
2339: tl_task_in_obj_table SYSTEM.TASK_IN_OBJ_TBL;
2340: f_task_in_obj_table SYSTEM.TASK_IN_OBJ_TBL;
2341: tl_task_in_obj SYSTEM.TASK_IN_OBJ;
2342:
2343: l_proj_ref varchar2(100);
2344:
2345: BEGIN

Line 2348: tl_task_in_obj_table := SYSTEM.TASK_IN_OBJ_TBL();

2344:
2345: BEGIN
2346:
2347: log_pvt('WBS_ORDER','001');
2348: tl_task_in_obj_table := SYSTEM.TASK_IN_OBJ_TBL();
2349:
2350:
2351:
2352: log_pvt('WBS_ORDER','001a'||P_TASK_IN_OBJ_TABLE.count);

Line 2352: log_pvt('WBS_ORDER','001a'||P_TASK_IN_OBJ_TABLE.count);

2348: tl_task_in_obj_table := SYSTEM.TASK_IN_OBJ_TBL();
2349:
2350:
2351:
2352: log_pvt('WBS_ORDER','001a'||P_TASK_IN_OBJ_TABLE.count);
2353: FOR i in P_TASK_IN_OBJ_TABLE.FIRST .. P_TASK_IN_OBJ_TABLE.LAST LOOP
2354: log_pvt('WBS_ORDER','001b');
2355: TL_TASK_IN_OBJ := P_TASK_IN_OBJ_TABLE(i);
2356:

Line 2353: FOR i in P_TASK_IN_OBJ_TABLE.FIRST .. P_TASK_IN_OBJ_TABLE.LAST LOOP

2349:
2350:
2351:
2352: log_pvt('WBS_ORDER','001a'||P_TASK_IN_OBJ_TABLE.count);
2353: FOR i in P_TASK_IN_OBJ_TABLE.FIRST .. P_TASK_IN_OBJ_TABLE.LAST LOOP
2354: log_pvt('WBS_ORDER','001b');
2355: TL_TASK_IN_OBJ := P_TASK_IN_OBJ_TABLE(i);
2356:
2357: l_task_ref_tbl(i) := TL_TASK_IN_OBJ.PM_TASK_REFERENCE;

Line 2355: TL_TASK_IN_OBJ := P_TASK_IN_OBJ_TABLE(i);

2351:
2352: log_pvt('WBS_ORDER','001a'||P_TASK_IN_OBJ_TABLE.count);
2353: FOR i in P_TASK_IN_OBJ_TABLE.FIRST .. P_TASK_IN_OBJ_TABLE.LAST LOOP
2354: log_pvt('WBS_ORDER','001b');
2355: TL_TASK_IN_OBJ := P_TASK_IN_OBJ_TABLE(i);
2356:
2357: l_task_ref_tbl(i) := TL_TASK_IN_OBJ.PM_TASK_REFERENCE;
2358: l_parent_ref_tbl(i) := TL_TASK_IN_OBJ.PM_PARENT_TASK_REFERENCE;
2359: l_task_id_tbl(i) := TL_TASK_IN_OBJ.PA_TASK_ID;

Line 2357: l_task_ref_tbl(i) := TL_TASK_IN_OBJ.PM_TASK_REFERENCE;

2353: FOR i in P_TASK_IN_OBJ_TABLE.FIRST .. P_TASK_IN_OBJ_TABLE.LAST LOOP
2354: log_pvt('WBS_ORDER','001b');
2355: TL_TASK_IN_OBJ := P_TASK_IN_OBJ_TABLE(i);
2356:
2357: l_task_ref_tbl(i) := TL_TASK_IN_OBJ.PM_TASK_REFERENCE;
2358: l_parent_ref_tbl(i) := TL_TASK_IN_OBJ.PM_PARENT_TASK_REFERENCE;
2359: l_task_id_tbl(i) := TL_TASK_IN_OBJ.PA_TASK_ID;
2360: l_list_tbl(i) := i;
2361: log_pvt('WBS_ORDER',' l_task_id_tbl(i) '|| l_task_id_tbl(i)||' l_task_ref_tbl(i) '||l_task_ref_tbl(i)||' l_parent_ref_tbl(i) '||l_parent_ref_tbl(i));

Line 2358: l_parent_ref_tbl(i) := TL_TASK_IN_OBJ.PM_PARENT_TASK_REFERENCE;

2354: log_pvt('WBS_ORDER','001b');
2355: TL_TASK_IN_OBJ := P_TASK_IN_OBJ_TABLE(i);
2356:
2357: l_task_ref_tbl(i) := TL_TASK_IN_OBJ.PM_TASK_REFERENCE;
2358: l_parent_ref_tbl(i) := TL_TASK_IN_OBJ.PM_PARENT_TASK_REFERENCE;
2359: l_task_id_tbl(i) := TL_TASK_IN_OBJ.PA_TASK_ID;
2360: l_list_tbl(i) := i;
2361: log_pvt('WBS_ORDER',' l_task_id_tbl(i) '|| l_task_id_tbl(i)||' l_task_ref_tbl(i) '||l_task_ref_tbl(i)||' l_parent_ref_tbl(i) '||l_parent_ref_tbl(i));
2362: END LOOP;

Line 2359: l_task_id_tbl(i) := TL_TASK_IN_OBJ.PA_TASK_ID;

2355: TL_TASK_IN_OBJ := P_TASK_IN_OBJ_TABLE(i);
2356:
2357: l_task_ref_tbl(i) := TL_TASK_IN_OBJ.PM_TASK_REFERENCE;
2358: l_parent_ref_tbl(i) := TL_TASK_IN_OBJ.PM_PARENT_TASK_REFERENCE;
2359: l_task_id_tbl(i) := TL_TASK_IN_OBJ.PA_TASK_ID;
2360: l_list_tbl(i) := i;
2361: log_pvt('WBS_ORDER',' l_task_id_tbl(i) '|| l_task_id_tbl(i)||' l_task_ref_tbl(i) '||l_task_ref_tbl(i)||' l_parent_ref_tbl(i) '||l_parent_ref_tbl(i));
2362: END LOOP;
2363:

Line 2389: tl_task_in_obj_table.extend(l_list_tbl.count);

2385: connect by prior task_ref = parent_task_ref;
2386:
2387: log_pvt('WBS_ORDER','001' || 'l_list_tbl.count '||l_list_tbl.count );
2388:
2389: tl_task_in_obj_table.extend(l_list_tbl.count);
2390:
2391: for i in l_list_tbl.first .. l_list_tbl.last loop
2392:
2393: -- log_pvt('WBS_ORDER',' l_list_tbl(i) '||l_list_tbl(i));

Line 2395: tl_task_in_obj_table(i) := P_TASK_IN_OBJ_TABLE(l_list_tbl(i));

2391: for i in l_list_tbl.first .. l_list_tbl.last loop
2392:
2393: -- log_pvt('WBS_ORDER',' l_list_tbl(i) '||l_list_tbl(i));
2394:
2395: tl_task_in_obj_table(i) := P_TASK_IN_OBJ_TABLE(l_list_tbl(i));
2396:
2397: end loop;
2398:
2399: -- commit;

Line 2401: X_TASK_IN_OBJ_TABLE := tl_task_in_obj_table;

2397: end loop;
2398:
2399: -- commit;
2400:
2401: X_TASK_IN_OBJ_TABLE := tl_task_in_obj_table;
2402:
2403: --i:= 10/0;
2404:
2405: -- log_pvt('WBS_ORDER','001');