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 PROJECT_IN_OBJ

Line 29: ,P_PROJECTS_IN IN SYSTEM.PROJECT_IN_OBJ_TBL

25: X_CP_REQUEST_OBJ_TBL OUT NOCOPY SYSTEM.PROJ_CP_REQ_OBJ_TBL
26: ,X_PROJECTS_OUT OUT NOCOPY SYSTEM.PROJECT_OUT_OBJ_TBL
27: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
28: ,P_SYNC_MODE IN CHAR := 'S'
29: ,P_PROJECTS_IN IN SYSTEM.PROJECT_IN_OBJ_TBL
30: )
31: IS
32:
33:

Line 56: L_PROJECT_IN_OBJ SYSTEM.PROJECT_IN_OBJ ;

52: --L_STRUCTURE_IN_REC STRUCTURE_IN_REC_TYPE;
53:
54: --Objects
55:
56: L_PROJECT_IN_OBJ SYSTEM.PROJECT_IN_OBJ ;
57: L_PROJECT_OUT_OBJ SYSTEM.PROJECT_OUT_OBJ;
58:
59: L_PROJECT_OUT_TBL SYSTEM.PROJECT_OUT_OBJ_TBL;
60:

Line 278: L_PROJECT_IN_OBJ := P_PROJECTS_IN(i);

274: g_res_counter := 0;
275:
276: ---- initializing the out variables -------------------
277:
278: L_PROJECT_IN_OBJ := P_PROJECTS_IN(i);
279:
280: log_pvt('MAIN','i: '||i||' project_id '||L_PROJECT_IN_OBJ.pa_project_id);
281: log_pvt('MAIN','i: '||i||' pm_project_reference '||L_PROJECT_IN_OBJ.pm_project_reference);
282:

Line 280: log_pvt('MAIN','i: '||i||' project_id '||L_PROJECT_IN_OBJ.pa_project_id);

276: ---- initializing the out variables -------------------
277:
278: L_PROJECT_IN_OBJ := P_PROJECTS_IN(i);
279:
280: log_pvt('MAIN','i: '||i||' project_id '||L_PROJECT_IN_OBJ.pa_project_id);
281: log_pvt('MAIN','i: '||i||' pm_project_reference '||L_PROJECT_IN_OBJ.pm_project_reference);
282:
283: --g_res_id_ref_tbl('1001') := 2;
284:

Line 281: log_pvt('MAIN','i: '||i||' pm_project_reference '||L_PROJECT_IN_OBJ.pm_project_reference);

277:
278: L_PROJECT_IN_OBJ := P_PROJECTS_IN(i);
279:
280: log_pvt('MAIN','i: '||i||' project_id '||L_PROJECT_IN_OBJ.pa_project_id);
281: log_pvt('MAIN','i: '||i||' pm_project_reference '||L_PROJECT_IN_OBJ.pm_project_reference);
282:
283: --g_res_id_ref_tbl('1001') := 2;
284:
285: log_pvt('MAIN','Before load_project_in_reec ');

Line 288: P_PROJECT_IN_OBJ => L_PROJECT_IN_OBJ ,

284:
285: log_pvt('MAIN','Before load_project_in_reec ');
286:
287: LOAD_PROJECT_IN_REC(
288: P_PROJECT_IN_OBJ => L_PROJECT_IN_OBJ ,
289: x_project_in_rec => L_PROJECT_IN_REC,
290: x_task_in_tbl => L_TASKS_IN_REC_TBL,
291: x_structure_in_rec => L_STRUCTURE_IN_REC,
292: x_task_com_id_tbl => l_task_com_id_tbl,

Line 306: L_PROJECT_OUT_OBJ.AIA_COMMON_ID := L_PROJECT_IN_OBJ.AIA_COMMON_ID;

302: --end;
303: log_pvt('MAIN','After load_project_in_reec ');
304:
305:
306: L_PROJECT_OUT_OBJ.AIA_COMMON_ID := L_PROJECT_IN_OBJ.AIA_COMMON_ID;
307: L_PROJECT_OUT_OBJ.msg_data := li_return_message;
308: L_PROJECT_OUT_OBJ.RETURN_STATUS := li_return_status ;
309: L_PROJECT_OUT_OBJ.PM_PROJECT_REFERENCE := L_PROJECT_IN_REC.PM_PROJECT_REFERENCE;
310: L_PROJECT_OUT_OBJ.PA_PROJECT_NUMBER := L_PROJECT_IN_REC.PA_PROJECT_NUMBER;

Line 1444: P_PROJECT_IN_OBJ IN SYSTEM.PROJECT_IN_OBJ ,

1440:
1441: END SYNC_PROJECTS;
1442:
1443: PROCEDURE LOAD_PROJECT_IN_REC (
1444: P_PROJECT_IN_OBJ IN SYSTEM.PROJECT_IN_OBJ ,
1445: x_project_in_rec OUT NOCOPY pa_project_pub.project_in_rec_type,
1446: x_task_in_tbl OUT NOCOPY pa_project_pub.task_in_tbl_type,
1447: x_structure_in_rec OUT NOCOPY pa_project_pub.structure_in_rec_type,
1448: x_task_com_id_tbl OUT NOCOPY task_com_id_tbl_type,

Line 1457: -- FUNCTION LOAD_PROJECT_IN_REC ( l_PROJECT_IN_OBJ IN PROJECT_IN_OBJ )

1453: x_delete_task_id_tbl OUT NOCOPY g_num_tbl,
1454: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1455: x_RETURN_MESSAGE OUT NOCOPY VARCHAR2 ) IS
1456:
1457: -- FUNCTION LOAD_PROJECT_IN_REC ( l_PROJECT_IN_OBJ IN PROJECT_IN_OBJ )
1458: -- RETURN pa_project_pub.PROJECT_IN_REC_TYPE IS
1459:
1460: -- Records
1461: L_PROJECT_IN_REC pa_project_pub.PROJECT_IN_REC_TYPE ;

Line 1463: L_PROJECT_IN_OBJ SYSTEM.PROJECT_IN_OBJ ;

1459:
1460: -- Records
1461: L_PROJECT_IN_REC pa_project_pub.PROJECT_IN_REC_TYPE ;
1462: --Objects
1463: L_PROJECT_IN_OBJ SYSTEM.PROJECT_IN_OBJ ;
1464:
1465:
1466: ll_task_com_id_tbl task_com_id_tbl_type ;
1467: ll_task_id_ref_tbl task_id_ref_tbl_type ;

Line 1519: l_project_in_obj := p_project_in_obj;

1515: BEGIN
1516:
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:

Line 1520: l_STRUCTURE_IN_OBJ := l_PROJECT_IN_OBJ.STRUCTURE_IN_OBJECT;

1516:
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:

Line 1527: if ( l_project_in_obj.PA_PROJECT_ID = FND_API.G_MISS_NUM ) then

1523:
1524:
1525: --------START Convert fnd_api.g_miss* to pa g_miss -----------------------------
1526:
1527: if ( l_project_in_obj.PA_PROJECT_ID = FND_API.G_MISS_NUM ) then
1528:
1529: l_project_in_obj.PA_PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1530:
1531: end if;

Line 1529: l_project_in_obj.PA_PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

1525: --------START Convert fnd_api.g_miss* to pa g_miss -----------------------------
1526:
1527: if ( l_project_in_obj.PA_PROJECT_ID = FND_API.G_MISS_NUM ) then
1528:
1529: l_project_in_obj.PA_PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1530:
1531: end if;
1532:
1533: if ( l_project_in_obj.PA_PROJECT_NUMBER = FND_API.G_MISS_CHAR ) then

Line 1533: if ( l_project_in_obj.PA_PROJECT_NUMBER = FND_API.G_MISS_CHAR ) then

1529: l_project_in_obj.PA_PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1530:
1531: end if;
1532:
1533: if ( l_project_in_obj.PA_PROJECT_NUMBER = FND_API.G_MISS_CHAR ) then
1534:
1535: l_project_in_obj.PA_PROJECT_NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1536:
1537: end if;

Line 1535: l_project_in_obj.PA_PROJECT_NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

1531: end if;
1532:
1533: if ( l_project_in_obj.PA_PROJECT_NUMBER = FND_API.G_MISS_CHAR ) then
1534:
1535: l_project_in_obj.PA_PROJECT_NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1536:
1537: end if;
1538:
1539:

Line 1540: if ( l_project_in_obj.PROJECT_NAME = FND_API.G_MISS_CHAR ) then

1536:
1537: end if;
1538:
1539:
1540: if ( l_project_in_obj.PROJECT_NAME = FND_API.G_MISS_CHAR ) then
1541:
1542: l_project_in_obj.PROJECT_NAME := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1543:
1544: end if;

Line 1542: l_project_in_obj.PROJECT_NAME := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

1538:
1539:
1540: if ( l_project_in_obj.PROJECT_NAME = FND_API.G_MISS_CHAR ) then
1541:
1542: l_project_in_obj.PROJECT_NAME := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1543:
1544: end if;
1545:
1546: if ( l_project_in_obj.pm_project_reference = FND_API.G_MISS_CHAR ) then

Line 1546: if ( l_project_in_obj.pm_project_reference = FND_API.G_MISS_CHAR ) then

1542: l_project_in_obj.PROJECT_NAME := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1543:
1544: end if;
1545:
1546: if ( l_project_in_obj.pm_project_reference = FND_API.G_MISS_CHAR ) then
1547:
1548: l_project_in_obj.pm_project_reference := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1549:
1550: end if;

Line 1548: l_project_in_obj.pm_project_reference := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;

1544: end if;
1545:
1546: if ( l_project_in_obj.pm_project_reference = FND_API.G_MISS_CHAR ) then
1547:
1548: l_project_in_obj.pm_project_reference := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1549:
1550: end if;
1551:
1552: if ( l_project_in_obj.DESCRIPTION = FND_API.G_MISS_CHAR ) then

Line 1552: if ( l_project_in_obj.DESCRIPTION = FND_API.G_MISS_CHAR ) then

1548: l_project_in_obj.pm_project_reference := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR;
1549:
1550: end if;
1551:
1552: if ( l_project_in_obj.DESCRIPTION = FND_API.G_MISS_CHAR ) then
1553:
1554: l_project_in_obj.DESCRIPTION := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1555:
1556: end if;

Line 1554: l_project_in_obj.DESCRIPTION := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

1550: end if;
1551:
1552: if ( l_project_in_obj.DESCRIPTION = FND_API.G_MISS_CHAR ) then
1553:
1554: l_project_in_obj.DESCRIPTION := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1555:
1556: end if;
1557:
1558: --log_pvt('LOAD_PROEJCT','init 01 ');

Line 1560: if ( l_project_in_obj.PROJECT_STATUS = FND_API.G_MISS_CHAR ) then

1556: end if;
1557:
1558: --log_pvt('LOAD_PROEJCT','init 01 ');
1559:
1560: if ( l_project_in_obj.PROJECT_STATUS = FND_API.G_MISS_CHAR ) then
1561:
1562: l_project_in_obj.PROJECT_STATUS := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1563:
1564: end if;

Line 1562: l_project_in_obj.PROJECT_STATUS := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

1558: --log_pvt('LOAD_PROEJCT','init 01 ');
1559:
1560: if ( l_project_in_obj.PROJECT_STATUS = FND_API.G_MISS_CHAR ) then
1561:
1562: l_project_in_obj.PROJECT_STATUS := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1563:
1564: end if;
1565:
1566: if ( l_project_in_obj.START_DATE = FND_API.G_MISS_DATE ) then

Line 1566: if ( l_project_in_obj.START_DATE = FND_API.G_MISS_DATE ) then

1562: l_project_in_obj.PROJECT_STATUS := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1563:
1564: end if;
1565:
1566: if ( l_project_in_obj.START_DATE = FND_API.G_MISS_DATE ) then
1567:
1568: l_project_in_obj.START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1569:
1570: end if;

Line 1568: l_project_in_obj.START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;

1564: end if;
1565:
1566: if ( l_project_in_obj.START_DATE = FND_API.G_MISS_DATE ) then
1567:
1568: l_project_in_obj.START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1569:
1570: end if;
1571:
1572: if ( l_project_in_obj.COMPLETION_DATE = FND_API.G_MISS_DATE ) then

Line 1572: if ( l_project_in_obj.COMPLETION_DATE = FND_API.G_MISS_DATE ) then

1568: l_project_in_obj.START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1569:
1570: end if;
1571:
1572: if ( l_project_in_obj.COMPLETION_DATE = FND_API.G_MISS_DATE ) then
1573:
1574: l_project_in_obj.COMPLETION_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1575:
1576: end if;

Line 1574: l_project_in_obj.COMPLETION_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;

1570: end if;
1571:
1572: if ( l_project_in_obj.COMPLETION_DATE = FND_API.G_MISS_DATE ) then
1573:
1574: l_project_in_obj.COMPLETION_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1575:
1576: end if;
1577:
1578: --log_pvt('LOAD_PROEJCT','init 02 ');

Line 1580: if ( l_project_in_obj.ACTUAL_START_DATE = FND_API.G_MISS_DATE ) then

1576: end if;
1577:
1578: --log_pvt('LOAD_PROEJCT','init 02 ');
1579:
1580: if ( l_project_in_obj.ACTUAL_START_DATE = FND_API.G_MISS_DATE ) then
1581:
1582: l_project_in_obj.ACTUAL_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1583:
1584: end if;

Line 1582: l_project_in_obj.ACTUAL_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;

1578: --log_pvt('LOAD_PROEJCT','init 02 ');
1579:
1580: if ( l_project_in_obj.ACTUAL_START_DATE = FND_API.G_MISS_DATE ) then
1581:
1582: l_project_in_obj.ACTUAL_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1583:
1584: end if;
1585:
1586:

Line 1587: if ( l_project_in_obj.ACTUAL_FINISH_DATE = FND_API.G_MISS_DATE ) then

1583:
1584: end if;
1585:
1586:
1587: if ( l_project_in_obj.ACTUAL_FINISH_DATE = FND_API.G_MISS_DATE ) then
1588:
1589: l_project_in_obj.ACTUAL_FINISH_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1590:
1591: end if;

Line 1589: l_project_in_obj.ACTUAL_FINISH_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;

1585:
1586:
1587: if ( l_project_in_obj.ACTUAL_FINISH_DATE = FND_API.G_MISS_DATE ) then
1588:
1589: l_project_in_obj.ACTUAL_FINISH_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1590:
1591: end if;
1592:
1593:

Line 1594: if ( l_project_in_obj.EARLY_START_DATE = FND_API.G_MISS_DATE ) then

1590:
1591: end if;
1592:
1593:
1594: if ( l_project_in_obj.EARLY_START_DATE = FND_API.G_MISS_DATE ) then
1595:
1596: l_project_in_obj.EARLY_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1597:
1598: end if;

Line 1596: l_project_in_obj.EARLY_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;

1592:
1593:
1594: if ( l_project_in_obj.EARLY_START_DATE = FND_API.G_MISS_DATE ) then
1595:
1596: l_project_in_obj.EARLY_START_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1597:
1598: end if;
1599:
1600:

Line 1601: if ( l_project_in_obj.EARLY_FINISH_DATE = FND_API.G_MISS_DATE ) then

1597:
1598: end if;
1599:
1600:
1601: if ( l_project_in_obj.EARLY_FINISH_DATE = FND_API.G_MISS_DATE ) then
1602:
1603: l_project_in_obj.EARLY_FINISH_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1604:
1605: end if;

Line 1603: l_project_in_obj.EARLY_FINISH_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;

1599:
1600:
1601: if ( l_project_in_obj.EARLY_FINISH_DATE = FND_API.G_MISS_DATE ) then
1602:
1603: l_project_in_obj.EARLY_FINISH_DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ;
1604:
1605: end if;
1606:
1607:

Line 1609: if ( l_project_in_obj.MAX_WBS_LEVEL = FND_API.G_MISS_NUM ) then

1605: end if;
1606:
1607:
1608: --log_pvt('LOAD_PROEJCT','init 03 ');
1609: if ( l_project_in_obj.MAX_WBS_LEVEL = FND_API.G_MISS_NUM ) then
1610:
1611: l_project_in_obj.MAX_WBS_LEVEL := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1612:
1613: end if;

Line 1611: l_project_in_obj.MAX_WBS_LEVEL := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

1607:
1608: --log_pvt('LOAD_PROEJCT','init 03 ');
1609: if ( l_project_in_obj.MAX_WBS_LEVEL = FND_API.G_MISS_NUM ) then
1610:
1611: l_project_in_obj.MAX_WBS_LEVEL := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1612:
1613: end if;
1614:
1615: --log_pvt('LOAD_PROEJCT','init 03a ');

Line 1617: if ( l_project_in_obj.COST_CHG_QTY_INDICATOR = FND_API.G_MISS_CHAR ) then

1613: end if;
1614:
1615: --log_pvt('LOAD_PROEJCT','init 03a ');
1616:
1617: if ( l_project_in_obj.COST_CHG_QTY_INDICATOR = FND_API.G_MISS_CHAR ) then
1618:
1619: l_project_in_obj.COST_CHG_QTY_INDICATOR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1620:
1621: end if;

Line 1619: l_project_in_obj.COST_CHG_QTY_INDICATOR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

1615: --log_pvt('LOAD_PROEJCT','init 03a ');
1616:
1617: if ( l_project_in_obj.COST_CHG_QTY_INDICATOR = FND_API.G_MISS_CHAR ) then
1618:
1619: l_project_in_obj.COST_CHG_QTY_INDICATOR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1620:
1621: end if;
1622:
1623: --log_pvt('LOAD_PROEJCT','init 03b ');

Line 1625: if ( l_project_in_obj.CREATED_FROM_PROJECT_ID = FND_API.G_MISS_NUM ) then

1621: end if;
1622:
1623: --log_pvt('LOAD_PROEJCT','init 03b ');
1624:
1625: if ( l_project_in_obj.CREATED_FROM_PROJECT_ID = FND_API.G_MISS_NUM ) then
1626:
1627: l_project_in_obj.CREATED_FROM_PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1628:
1629: end if;

Line 1627: l_project_in_obj.CREATED_FROM_PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

1623: --log_pvt('LOAD_PROEJCT','init 03b ');
1624:
1625: if ( l_project_in_obj.CREATED_FROM_PROJECT_ID = FND_API.G_MISS_NUM ) then
1626:
1627: l_project_in_obj.CREATED_FROM_PROJECT_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1628:
1629: end if;
1630:
1631: --log_pvt('LOAD_PROEJCT','init 03 c');

Line 1632: if ( l_project_in_obj.CREATED_FROM_PROJECT_NUMBER = FND_API.G_MISS_CHAR ) then

1628:
1629: end if;
1630:
1631: --log_pvt('LOAD_PROEJCT','init 03 c');
1632: if ( l_project_in_obj.CREATED_FROM_PROJECT_NUMBER = FND_API.G_MISS_CHAR ) then
1633:
1634: l_project_in_obj.CREATED_FROM_PROJECT_NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1635:
1636: end if;

Line 1634: l_project_in_obj.CREATED_FROM_PROJECT_NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

1630:
1631: --log_pvt('LOAD_PROEJCT','init 03 c');
1632: if ( l_project_in_obj.CREATED_FROM_PROJECT_NUMBER = FND_API.G_MISS_CHAR ) then
1633:
1634: l_project_in_obj.CREATED_FROM_PROJECT_NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1635:
1636: end if;
1637:
1638: --log_pvt('LOAD_PROEJCT','init 03 d');

Line 1639: if ( l_project_in_obj.PROJECT_ORGANIZATION_ID = FND_API.G_MISS_NUM ) then

1635:
1636: end if;
1637:
1638: --log_pvt('LOAD_PROEJCT','init 03 d');
1639: if ( l_project_in_obj.PROJECT_ORGANIZATION_ID = FND_API.G_MISS_NUM ) then
1640:
1641: l_project_in_obj.PROJECT_ORGANIZATION_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1642:
1643: end if;

Line 1641: l_project_in_obj.PROJECT_ORGANIZATION_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

1637:
1638: --log_pvt('LOAD_PROEJCT','init 03 d');
1639: if ( l_project_in_obj.PROJECT_ORGANIZATION_ID = FND_API.G_MISS_NUM ) then
1640:
1641: l_project_in_obj.PROJECT_ORGANIZATION_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1642:
1643: end if;
1644:
1645: --log_pvt('LOAD_PROEJCT','init 03 e');

Line 1646: if ( l_project_in_obj.ORG_ID = FND_API.G_MISS_NUM ) then

1642:
1643: end if;
1644:
1645: --log_pvt('LOAD_PROEJCT','init 03 e');
1646: if ( l_project_in_obj.ORG_ID = FND_API.G_MISS_NUM ) then
1647:
1648: l_project_in_obj.ORG_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1649:
1650: end if;

Line 1648: l_project_in_obj.ORG_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

1644:
1645: --log_pvt('LOAD_PROEJCT','init 03 e');
1646: if ( l_project_in_obj.ORG_ID = FND_API.G_MISS_NUM ) then
1647:
1648: l_project_in_obj.ORG_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1649:
1650: end if;
1651:
1652: --log_pvt('LOAD_PROEJCT','init 03 fa');

Line 1654: if ( l_project_in_obj.EPS_CLASS_CODE = FND_API.G_MISS_CHAR ) then

1650: end if;
1651:
1652: --log_pvt('LOAD_PROEJCT','init 03 fa');
1653:
1654: if ( l_project_in_obj.EPS_CLASS_CODE = FND_API.G_MISS_CHAR ) then
1655:
1656: l_project_in_obj.EPS_CLASS_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1657:
1658: end if;

Line 1656: l_project_in_obj.EPS_CLASS_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

1652: --log_pvt('LOAD_PROEJCT','init 03 fa');
1653:
1654: if ( l_project_in_obj.EPS_CLASS_CODE = FND_API.G_MISS_CHAR ) then
1655:
1656: l_project_in_obj.EPS_CLASS_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1657:
1658: end if;
1659:
1660:

Line 1662: if ( l_project_in_obj.PROJECT_TYPE_CODE = FND_API.G_MISS_CHAR ) then

1658: end if;
1659:
1660:
1661: --log_pvt('LOAD_PROEJCT','init 03 ');
1662: if ( l_project_in_obj.PROJECT_TYPE_CODE = FND_API.G_MISS_CHAR ) then
1663:
1664: l_project_in_obj.PROJECT_TYPE_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1665:
1666: end if;

Line 1664: l_project_in_obj.PROJECT_TYPE_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

1660:
1661: --log_pvt('LOAD_PROEJCT','init 03 ');
1662: if ( l_project_in_obj.PROJECT_TYPE_CODE = FND_API.G_MISS_CHAR ) then
1663:
1664: l_project_in_obj.PROJECT_TYPE_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1665:
1666: end if;
1667:
1668: --log_pvt('LOAD_PROEJCT','init 04 ');

Line 1669: if ( l_project_in_obj.ORIGINAL_BUDGET_AMOUNT = FND_API.G_MISS_NUM ) then

1665:
1666: end if;
1667:
1668: --log_pvt('LOAD_PROEJCT','init 04 ');
1669: if ( l_project_in_obj.ORIGINAL_BUDGET_AMOUNT = FND_API.G_MISS_NUM ) then
1670:
1671: l_project_in_obj.ORIGINAL_BUDGET_AMOUNT := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1672:
1673: end if;

Line 1671: l_project_in_obj.ORIGINAL_BUDGET_AMOUNT := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

1667:
1668: --log_pvt('LOAD_PROEJCT','init 04 ');
1669: if ( l_project_in_obj.ORIGINAL_BUDGET_AMOUNT = FND_API.G_MISS_NUM ) then
1670:
1671: l_project_in_obj.ORIGINAL_BUDGET_AMOUNT := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1672:
1673: end if;
1674:
1675: if ( l_project_in_obj.BUDGET_AMOUNT = FND_API.G_MISS_NUM ) then

Line 1675: if ( l_project_in_obj.BUDGET_AMOUNT = FND_API.G_MISS_NUM ) then

1671: l_project_in_obj.ORIGINAL_BUDGET_AMOUNT := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1672:
1673: end if;
1674:
1675: if ( l_project_in_obj.BUDGET_AMOUNT = FND_API.G_MISS_NUM ) then
1676:
1677: l_project_in_obj.BUDGET_AMOUNT := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1678:
1679: end if;

Line 1677: l_project_in_obj.BUDGET_AMOUNT := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;

1673: end if;
1674:
1675: if ( l_project_in_obj.BUDGET_AMOUNT = FND_API.G_MISS_NUM ) then
1676:
1677: l_project_in_obj.BUDGET_AMOUNT := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ;
1678:
1679: end if;
1680:
1681:

Line 1682: if ( l_project_in_obj.PROJECT_CURRENCY_CODE = FND_API.G_MISS_CHAR ) then

1678:
1679: end if;
1680:
1681:
1682: if ( l_project_in_obj.PROJECT_CURRENCY_CODE = FND_API.G_MISS_CHAR ) then
1683:
1684: l_project_in_obj.PROJECT_CURRENCY_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1685:
1686: end if;

Line 1684: l_project_in_obj.PROJECT_CURRENCY_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

1680:
1681:
1682: if ( l_project_in_obj.PROJECT_CURRENCY_CODE = FND_API.G_MISS_CHAR ) then
1683:
1684: l_project_in_obj.PROJECT_CURRENCY_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1685:
1686: end if;
1687:
1688:

Line 1689: if ( l_project_in_obj.ACTIVITY_TRACKING_INDICATOR = FND_API.G_MISS_CHAR ) then

1685:
1686: end if;
1687:
1688:
1689: if ( l_project_in_obj.ACTIVITY_TRACKING_INDICATOR = FND_API.G_MISS_CHAR ) then
1690:
1691: l_project_in_obj.ACTIVITY_TRACKING_INDICATOR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1692:
1693: end if;

Line 1691: l_project_in_obj.ACTIVITY_TRACKING_INDICATOR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

1687:
1688:
1689: if ( l_project_in_obj.ACTIVITY_TRACKING_INDICATOR = FND_API.G_MISS_CHAR ) then
1690:
1691: l_project_in_obj.ACTIVITY_TRACKING_INDICATOR := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1692:
1693: end if;
1694:
1695:

Line 1696: if ( l_project_in_obj.RES_ASS_TRACK_LEV_CODE = FND_API.G_MISS_CHAR ) then

1692:
1693: end if;
1694:
1695:
1696: if ( l_project_in_obj.RES_ASS_TRACK_LEV_CODE = FND_API.G_MISS_CHAR ) then
1697:
1698: l_project_in_obj.RES_ASS_TRACK_LEV_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1699:
1700: end if;

Line 1698: l_project_in_obj.RES_ASS_TRACK_LEV_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;

1694:
1695:
1696: if ( l_project_in_obj.RES_ASS_TRACK_LEV_CODE = FND_API.G_MISS_CHAR ) then
1697:
1698: l_project_in_obj.RES_ASS_TRACK_LEV_CODE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR ;
1699:
1700: end if;
1701:
1702: --log_pvt('LOAD_PROEJCT','init 05 ');

Line 1708: log_pvt('LOAD_PROEJCT','Before created_from_poroject_number'|| l_PROJECT_IN_OBJ.created_from_project_number );

1704: --STRUCTURE_IN_OBJECT STRUCTURE_IN_OBJ
1705:
1706: --------END Convert fnd_api.g_miss* to pa g_miss -----------------------------
1707:
1708: log_pvt('LOAD_PROEJCT','Before created_from_poroject_number'|| l_PROJECT_IN_OBJ.created_from_project_number );
1709:
1710: l_return_status := 'S';
1711: l_return_message := null;
1712:

Line 1713: IF ( nvl(l_PROJECT_IN_OBJ.PA_PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

1709:
1710: l_return_status := 'S';
1711: l_return_message := null;
1712:
1713: IF ( nvl(l_PROJECT_IN_OBJ.PA_PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1714: = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
1715:
1716: begin
1717: select project_id into l_create_from_project_id

Line 1719: where segment1 = l_PROJECT_IN_OBJ.created_from_project_number;

1715:
1716: begin
1717: select project_id into l_create_from_project_id
1718: from pa_projects_all
1719: where segment1 = l_PROJECT_IN_OBJ.created_from_project_number;
1720: exception
1721: when others then
1722: log_pvt('MAIN','raise 5000');
1723: l_create_from_project_id := -9999;

Line 1729: ,p_value1 => l_project_in_obj.created_from_project_number

1725: pa_utils.add_message
1726: ( p_app_short_name => 'PA'-- new message for AA TRACKING
1727: ,p_msg_name => 'PA_SOURCE_TEMPLATE_INVALID_AMG'
1728: ,p_token1 => 'PROJECT'
1729: ,p_value1 => l_project_in_obj.created_from_project_number
1730: );
1731: l_return_message := 'PA_SOURCE_TEMPLATE_INVALID_AMG';
1732:
1733: end ;

Line 1740: log_pvt('LOAD_PROEJCT',' l_PROJECT_IN_OBJ.PA_PROJECT_ID '||l_PROJECT_IN_OBJ.PA_PROJECT_ID);

1736:
1737: log_pvt('LOAD_PROEJCT','After getting from_project_id '||l_create_from_project_id);
1738:
1739:
1740: log_pvt('LOAD_PROEJCT',' l_PROJECT_IN_OBJ.PA_PROJECT_ID '||l_PROJECT_IN_OBJ.PA_PROJECT_ID);
1741:
1742: if ( l_return_status = 'S' ) then
1743: begin
1744:

Line 1745: IF ( l_PROJECT_IN_OBJ.PA_PROJECT_ID IS NOT NULL

1741:
1742: if ( l_return_status = 'S' ) then
1743: begin
1744:
1745: IF ( l_PROJECT_IN_OBJ.PA_PROJECT_ID IS NOT NULL
1746: AND l_PROJECT_IN_OBJ.PA_PROJECT_ID <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1747: AND l_return_status = 'S' ) then
1748:
1749: select decode(PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN(l_PROJECT_IN_OBJ.PA_PROJECT_ID ), 'N',

Line 1746: AND l_PROJECT_IN_OBJ.PA_PROJECT_ID <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1742: if ( l_return_status = 'S' ) then
1743: begin
1744:
1745: IF ( l_PROJECT_IN_OBJ.PA_PROJECT_ID IS NOT NULL
1746: AND l_PROJECT_IN_OBJ.PA_PROJECT_ID <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1747: AND l_return_status = 'S' ) then
1748:
1749: select decode(PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN(l_PROJECT_IN_OBJ.PA_PROJECT_ID ), 'N',
1750: 'FINANCIAL', structure_type), receive_task , structure_type

Line 1749: select decode(PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN(l_PROJECT_IN_OBJ.PA_PROJECT_ID ), 'N',

1745: IF ( l_PROJECT_IN_OBJ.PA_PROJECT_ID IS NOT NULL
1746: AND l_PROJECT_IN_OBJ.PA_PROJECT_ID <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1747: AND l_return_status = 'S' ) then
1748:
1749: select decode(PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN(l_PROJECT_IN_OBJ.PA_PROJECT_ID ), 'N',
1750: 'FINANCIAL', structure_type), receive_task , structure_type
1751: into l_struct_type , l_receive_task , l_setup_struct_type
1752: from pa_integration_settings
1753: where project_id = l_PROJECT_IN_OBJ.PA_PROJECT_ID

Line 1753: where project_id = l_PROJECT_IN_OBJ.PA_PROJECT_ID

1749: select decode(PA_PROJ_TASK_STRUC_PUB.IS_WP_SEPARATE_FROM_FN(l_PROJECT_IN_OBJ.PA_PROJECT_ID ), 'N',
1750: 'FINANCIAL', structure_type), receive_task , structure_type
1751: into l_struct_type , l_receive_task , l_setup_struct_type
1752: from pa_integration_settings
1753: where project_id = l_PROJECT_IN_OBJ.PA_PROJECT_ID
1754: and enable_integration = 'Y';
1755:
1756: else
1757:

Line 1801: L_PROJECT_IN_REC.PA_PROJECT_ID := l_PROJECT_IN_OBJ.PA_PROJECT_ID ;

1797: log_pvt('LOAD_PROEJCT','After getting Integration settings '||l_return_message);
1798:
1799: if ( l_return_status = 'S' ) then
1800:
1801: L_PROJECT_IN_REC.PA_PROJECT_ID := l_PROJECT_IN_OBJ.PA_PROJECT_ID ;
1802: L_PROJECT_IN_REC.PA_PROJECT_NUMBER := l_PROJECT_IN_OBJ.PA_PROJECT_NUMBER ;
1803: L_PROJECT_IN_REC.pm_project_reference := l_PROJECT_IN_OBJ.pm_project_reference ;
1804: L_PROJECT_IN_REC.PROJECT_NAME := l_PROJECT_IN_OBJ.PROJECT_NAME ;
1805: L_PROJECT_IN_REC.project_status_code := l_PROJECT_IN_OBJ.PROJECT_STATUS ;

Line 1802: L_PROJECT_IN_REC.PA_PROJECT_NUMBER := l_PROJECT_IN_OBJ.PA_PROJECT_NUMBER ;

1798:
1799: if ( l_return_status = 'S' ) then
1800:
1801: L_PROJECT_IN_REC.PA_PROJECT_ID := l_PROJECT_IN_OBJ.PA_PROJECT_ID ;
1802: L_PROJECT_IN_REC.PA_PROJECT_NUMBER := l_PROJECT_IN_OBJ.PA_PROJECT_NUMBER ;
1803: L_PROJECT_IN_REC.pm_project_reference := l_PROJECT_IN_OBJ.pm_project_reference ;
1804: L_PROJECT_IN_REC.PROJECT_NAME := l_PROJECT_IN_OBJ.PROJECT_NAME ;
1805: L_PROJECT_IN_REC.project_status_code := l_PROJECT_IN_OBJ.PROJECT_STATUS ;
1806: L_PROJECT_IN_REC.description := l_project_in_obj.DESCRIPTION;

Line 1803: L_PROJECT_IN_REC.pm_project_reference := l_PROJECT_IN_OBJ.pm_project_reference ;

1799: if ( l_return_status = 'S' ) then
1800:
1801: L_PROJECT_IN_REC.PA_PROJECT_ID := l_PROJECT_IN_OBJ.PA_PROJECT_ID ;
1802: L_PROJECT_IN_REC.PA_PROJECT_NUMBER := l_PROJECT_IN_OBJ.PA_PROJECT_NUMBER ;
1803: L_PROJECT_IN_REC.pm_project_reference := l_PROJECT_IN_OBJ.pm_project_reference ;
1804: L_PROJECT_IN_REC.PROJECT_NAME := l_PROJECT_IN_OBJ.PROJECT_NAME ;
1805: L_PROJECT_IN_REC.project_status_code := l_PROJECT_IN_OBJ.PROJECT_STATUS ;
1806: L_PROJECT_IN_REC.description := l_project_in_obj.DESCRIPTION;
1807:

Line 1804: L_PROJECT_IN_REC.PROJECT_NAME := l_PROJECT_IN_OBJ.PROJECT_NAME ;

1800:
1801: L_PROJECT_IN_REC.PA_PROJECT_ID := l_PROJECT_IN_OBJ.PA_PROJECT_ID ;
1802: L_PROJECT_IN_REC.PA_PROJECT_NUMBER := l_PROJECT_IN_OBJ.PA_PROJECT_NUMBER ;
1803: L_PROJECT_IN_REC.pm_project_reference := l_PROJECT_IN_OBJ.pm_project_reference ;
1804: L_PROJECT_IN_REC.PROJECT_NAME := l_PROJECT_IN_OBJ.PROJECT_NAME ;
1805: L_PROJECT_IN_REC.project_status_code := l_PROJECT_IN_OBJ.PROJECT_STATUS ;
1806: L_PROJECT_IN_REC.description := l_project_in_obj.DESCRIPTION;
1807:
1808: L_PROJECT_IN_REC.START_DATE := trunc(l_PROJECT_IN_OBJ.START_DATE) ;

Line 1805: L_PROJECT_IN_REC.project_status_code := l_PROJECT_IN_OBJ.PROJECT_STATUS ;

1801: L_PROJECT_IN_REC.PA_PROJECT_ID := l_PROJECT_IN_OBJ.PA_PROJECT_ID ;
1802: L_PROJECT_IN_REC.PA_PROJECT_NUMBER := l_PROJECT_IN_OBJ.PA_PROJECT_NUMBER ;
1803: L_PROJECT_IN_REC.pm_project_reference := l_PROJECT_IN_OBJ.pm_project_reference ;
1804: L_PROJECT_IN_REC.PROJECT_NAME := l_PROJECT_IN_OBJ.PROJECT_NAME ;
1805: L_PROJECT_IN_REC.project_status_code := l_PROJECT_IN_OBJ.PROJECT_STATUS ;
1806: L_PROJECT_IN_REC.description := l_project_in_obj.DESCRIPTION;
1807:
1808: L_PROJECT_IN_REC.START_DATE := trunc(l_PROJECT_IN_OBJ.START_DATE) ;
1809: L_PROJECT_IN_REC.COMPLETION_DATE := trunc(l_PROJECT_IN_OBJ.COMPLETION_DATE) ;

Line 1806: L_PROJECT_IN_REC.description := l_project_in_obj.DESCRIPTION;

1802: L_PROJECT_IN_REC.PA_PROJECT_NUMBER := l_PROJECT_IN_OBJ.PA_PROJECT_NUMBER ;
1803: L_PROJECT_IN_REC.pm_project_reference := l_PROJECT_IN_OBJ.pm_project_reference ;
1804: L_PROJECT_IN_REC.PROJECT_NAME := l_PROJECT_IN_OBJ.PROJECT_NAME ;
1805: L_PROJECT_IN_REC.project_status_code := l_PROJECT_IN_OBJ.PROJECT_STATUS ;
1806: L_PROJECT_IN_REC.description := l_project_in_obj.DESCRIPTION;
1807:
1808: L_PROJECT_IN_REC.START_DATE := trunc(l_PROJECT_IN_OBJ.START_DATE) ;
1809: L_PROJECT_IN_REC.COMPLETION_DATE := trunc(l_PROJECT_IN_OBJ.COMPLETION_DATE) ;
1810: L_PROJECT_IN_REC.ACTUAL_START_DATE := trunc(l_PROJECT_IN_OBJ.ACTUAL_START_DATE) ;

Line 1808: L_PROJECT_IN_REC.START_DATE := trunc(l_PROJECT_IN_OBJ.START_DATE) ;

1804: L_PROJECT_IN_REC.PROJECT_NAME := l_PROJECT_IN_OBJ.PROJECT_NAME ;
1805: L_PROJECT_IN_REC.project_status_code := l_PROJECT_IN_OBJ.PROJECT_STATUS ;
1806: L_PROJECT_IN_REC.description := l_project_in_obj.DESCRIPTION;
1807:
1808: L_PROJECT_IN_REC.START_DATE := trunc(l_PROJECT_IN_OBJ.START_DATE) ;
1809: L_PROJECT_IN_REC.COMPLETION_DATE := trunc(l_PROJECT_IN_OBJ.COMPLETION_DATE) ;
1810: L_PROJECT_IN_REC.ACTUAL_START_DATE := trunc(l_PROJECT_IN_OBJ.ACTUAL_START_DATE) ;
1811: L_PROJECT_IN_REC.ACTUAL_FINISH_DATE := trunc(l_PROJECT_IN_OBJ.ACTUAL_FINISH_DATE) ;
1812: L_PROJECT_IN_REC.EARLY_START_DATE := trunc(l_PROJECT_IN_OBJ.EARLY_START_DATE) ;

Line 1809: L_PROJECT_IN_REC.COMPLETION_DATE := trunc(l_PROJECT_IN_OBJ.COMPLETION_DATE) ;

1805: L_PROJECT_IN_REC.project_status_code := l_PROJECT_IN_OBJ.PROJECT_STATUS ;
1806: L_PROJECT_IN_REC.description := l_project_in_obj.DESCRIPTION;
1807:
1808: L_PROJECT_IN_REC.START_DATE := trunc(l_PROJECT_IN_OBJ.START_DATE) ;
1809: L_PROJECT_IN_REC.COMPLETION_DATE := trunc(l_PROJECT_IN_OBJ.COMPLETION_DATE) ;
1810: L_PROJECT_IN_REC.ACTUAL_START_DATE := trunc(l_PROJECT_IN_OBJ.ACTUAL_START_DATE) ;
1811: L_PROJECT_IN_REC.ACTUAL_FINISH_DATE := trunc(l_PROJECT_IN_OBJ.ACTUAL_FINISH_DATE) ;
1812: L_PROJECT_IN_REC.EARLY_START_DATE := trunc(l_PROJECT_IN_OBJ.EARLY_START_DATE) ;
1813: L_PROJECT_IN_REC.EARLY_FINISH_DATE := trunc(l_PROJECT_IN_OBJ.EARLY_FINISH_DATE) ;

Line 1810: L_PROJECT_IN_REC.ACTUAL_START_DATE := trunc(l_PROJECT_IN_OBJ.ACTUAL_START_DATE) ;

1806: L_PROJECT_IN_REC.description := l_project_in_obj.DESCRIPTION;
1807:
1808: L_PROJECT_IN_REC.START_DATE := trunc(l_PROJECT_IN_OBJ.START_DATE) ;
1809: L_PROJECT_IN_REC.COMPLETION_DATE := trunc(l_PROJECT_IN_OBJ.COMPLETION_DATE) ;
1810: L_PROJECT_IN_REC.ACTUAL_START_DATE := trunc(l_PROJECT_IN_OBJ.ACTUAL_START_DATE) ;
1811: L_PROJECT_IN_REC.ACTUAL_FINISH_DATE := trunc(l_PROJECT_IN_OBJ.ACTUAL_FINISH_DATE) ;
1812: L_PROJECT_IN_REC.EARLY_START_DATE := trunc(l_PROJECT_IN_OBJ.EARLY_START_DATE) ;
1813: L_PROJECT_IN_REC.EARLY_FINISH_DATE := trunc(l_PROJECT_IN_OBJ.EARLY_FINISH_DATE) ;
1814:

Line 1811: L_PROJECT_IN_REC.ACTUAL_FINISH_DATE := trunc(l_PROJECT_IN_OBJ.ACTUAL_FINISH_DATE) ;

1807:
1808: L_PROJECT_IN_REC.START_DATE := trunc(l_PROJECT_IN_OBJ.START_DATE) ;
1809: L_PROJECT_IN_REC.COMPLETION_DATE := trunc(l_PROJECT_IN_OBJ.COMPLETION_DATE) ;
1810: L_PROJECT_IN_REC.ACTUAL_START_DATE := trunc(l_PROJECT_IN_OBJ.ACTUAL_START_DATE) ;
1811: L_PROJECT_IN_REC.ACTUAL_FINISH_DATE := trunc(l_PROJECT_IN_OBJ.ACTUAL_FINISH_DATE) ;
1812: L_PROJECT_IN_REC.EARLY_START_DATE := trunc(l_PROJECT_IN_OBJ.EARLY_START_DATE) ;
1813: L_PROJECT_IN_REC.EARLY_FINISH_DATE := trunc(l_PROJECT_IN_OBJ.EARLY_FINISH_DATE) ;
1814:
1815: IF ( nvl(l_PROJECT_IN_OBJ.PA_PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

Line 1812: L_PROJECT_IN_REC.EARLY_START_DATE := trunc(l_PROJECT_IN_OBJ.EARLY_START_DATE) ;

1808: L_PROJECT_IN_REC.START_DATE := trunc(l_PROJECT_IN_OBJ.START_DATE) ;
1809: L_PROJECT_IN_REC.COMPLETION_DATE := trunc(l_PROJECT_IN_OBJ.COMPLETION_DATE) ;
1810: L_PROJECT_IN_REC.ACTUAL_START_DATE := trunc(l_PROJECT_IN_OBJ.ACTUAL_START_DATE) ;
1811: L_PROJECT_IN_REC.ACTUAL_FINISH_DATE := trunc(l_PROJECT_IN_OBJ.ACTUAL_FINISH_DATE) ;
1812: L_PROJECT_IN_REC.EARLY_START_DATE := trunc(l_PROJECT_IN_OBJ.EARLY_START_DATE) ;
1813: L_PROJECT_IN_REC.EARLY_FINISH_DATE := trunc(l_PROJECT_IN_OBJ.EARLY_FINISH_DATE) ;
1814:
1815: IF ( nvl(l_PROJECT_IN_OBJ.PA_PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1816: = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then

Line 1813: L_PROJECT_IN_REC.EARLY_FINISH_DATE := trunc(l_PROJECT_IN_OBJ.EARLY_FINISH_DATE) ;

1809: L_PROJECT_IN_REC.COMPLETION_DATE := trunc(l_PROJECT_IN_OBJ.COMPLETION_DATE) ;
1810: L_PROJECT_IN_REC.ACTUAL_START_DATE := trunc(l_PROJECT_IN_OBJ.ACTUAL_START_DATE) ;
1811: L_PROJECT_IN_REC.ACTUAL_FINISH_DATE := trunc(l_PROJECT_IN_OBJ.ACTUAL_FINISH_DATE) ;
1812: L_PROJECT_IN_REC.EARLY_START_DATE := trunc(l_PROJECT_IN_OBJ.EARLY_START_DATE) ;
1813: L_PROJECT_IN_REC.EARLY_FINISH_DATE := trunc(l_PROJECT_IN_OBJ.EARLY_FINISH_DATE) ;
1814:
1815: IF ( nvl(l_PROJECT_IN_OBJ.PA_PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1816: = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
1817:

Line 1815: IF ( nvl(l_PROJECT_IN_OBJ.PA_PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)

1811: L_PROJECT_IN_REC.ACTUAL_FINISH_DATE := trunc(l_PROJECT_IN_OBJ.ACTUAL_FINISH_DATE) ;
1812: L_PROJECT_IN_REC.EARLY_START_DATE := trunc(l_PROJECT_IN_OBJ.EARLY_START_DATE) ;
1813: L_PROJECT_IN_REC.EARLY_FINISH_DATE := trunc(l_PROJECT_IN_OBJ.EARLY_FINISH_DATE) ;
1814:
1815: IF ( nvl(l_PROJECT_IN_OBJ.PA_PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1816: = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
1817:
1818: L_PROJECT_IN_REC.PROJECT_CURRENCY_CODE := l_PROJECT_IN_OBJ.PROJECT_CURRENCY_CODE ;
1819: END IF;

Line 1818: L_PROJECT_IN_REC.PROJECT_CURRENCY_CODE := l_PROJECT_IN_OBJ.PROJECT_CURRENCY_CODE ;

1814:
1815: IF ( nvl(l_PROJECT_IN_OBJ.PA_PROJECT_ID,PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
1816: = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
1817:
1818: L_PROJECT_IN_REC.PROJECT_CURRENCY_CODE := l_PROJECT_IN_OBJ.PROJECT_CURRENCY_CODE ;
1819: END IF;
1820: gl_currency_code := l_PROJECT_IN_OBJ.PROJECT_CURRENCY_CODE ;
1821:
1822: L_PROJECT_IN_REC.CREATED_FROM_PROJECT_ID := L_CREATE_FROM_PROJECT_ID ;

Line 1820: gl_currency_code := l_PROJECT_IN_OBJ.PROJECT_CURRENCY_CODE ;

1816: = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
1817:
1818: L_PROJECT_IN_REC.PROJECT_CURRENCY_CODE := l_PROJECT_IN_OBJ.PROJECT_CURRENCY_CODE ;
1819: END IF;
1820: gl_currency_code := l_PROJECT_IN_OBJ.PROJECT_CURRENCY_CODE ;
1821:
1822: L_PROJECT_IN_REC.CREATED_FROM_PROJECT_ID := L_CREATE_FROM_PROJECT_ID ;
1823:
1824: log_pvt('LOAD_PROEJCT',' L_PROJECT_IN_REC.description '||L_PROJECT_IN_REC.description);

Line 1858: IF ( l_PROJECT_IN_OBJ.PA_PROJECT_ID IS NOT NULL

1854:
1855:
1856: L_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1857:
1858: IF ( l_PROJECT_IN_OBJ.PA_PROJECT_ID IS NOT NULL
1859: AND l_PROJECT_IN_OBJ.PA_PROJECT_ID <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
1860:
1861: begin
1862:

Line 1859: AND l_PROJECT_IN_OBJ.PA_PROJECT_ID <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then

1855:
1856: L_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM;
1857:
1858: IF ( l_PROJECT_IN_OBJ.PA_PROJECT_ID IS NOT NULL
1859: AND l_PROJECT_IN_OBJ.PA_PROJECT_ID <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
1860:
1861: begin
1862:
1863: if ( l_setup_struct_type = 'FINANCIAL') then

Line 1865: L_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_PROJECT_IN_OBJ.PA_PROJECT_ID);

1861: begin
1862:
1863: if ( l_setup_struct_type = 'FINANCIAL') then
1864:
1865: L_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_PROJECT_IN_OBJ.PA_PROJECT_ID);
1866:
1867: else
1868: select ppevs.element_version_id
1869: into L_STRUCTURE_IN_REC.STRUCTURE_VERSION_ID

Line 1874: and ppevs.project_id = l_PROJECT_IN_OBJ.PA_PROJECT_ID

1870: from pa_proj_elem_ver_structure ppevs,
1871: pa_proj_structure_types ppst,
1872: pa_structure_types pst
1873: where ppevs.proj_element_id = ppst.proj_element_id
1874: and ppevs.project_id = l_PROJECT_IN_OBJ.PA_PROJECT_ID
1875: and ( ( ppevs.status_code = 'STRUCTURE_WORKING' AND
1876: exists ( select 'x' from pa_proj_workplan_attr w1
1877: where w1.project_id = ppevs.project_id
1878: and w1.wp_enable_version_flag = 'Y' ) )