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.INV_PROJECT dependencies on INV_PROJECT

Line 1: PACKAGE BODY inv_project AS

1: PACKAGE BODY inv_project AS
2: /* $Header: INVPRJIB.pls 120.13.12020000.2 2012/10/26 03:00:35 xiameng ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_PROJECT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_PROJECT';

1: PACKAGE BODY inv_project AS
2: /* $Header: INVPRJIB.pls 120.13.12020000.2 2012/10/26 03:00:35 xiameng ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_PROJECT';
5:
6: G_DISPLAYED_SEGMENTS VARCHAR2(1000);
7: G_CONCATENATED_SEGMENTS VARCHAR2(1000);
8: G_PHYSICAL_LOCATOR VARCHAR2(1000);

Line 776: INV_PROJECT.org_project_parameters(v_org_id,

772: v_pm_cost_collection_enabled number;
773: v_project_control_level number;
774: v_success boolean;
775: begin
776: INV_PROJECT.org_project_parameters(v_org_id,
777: v_project_reference_enabled,
778: v_pm_cost_collection_enabled,
779: v_project_control_level,
780: v_success);

Line 805: INV_PROJECT.org_project_parameters(v_org_id,

801: v_pm_cost_collection_enabled number;
802: v_project_control_level number;
803: v_success boolean;
804: begin
805: INV_PROJECT.org_project_parameters(v_org_id,
806: v_project_reference_enabled,
807: v_pm_cost_collection_enabled,
808: v_project_control_level,
809: v_success);

Line 884: p_pkg_name =>'Inv_Project',

880: When Others Then
881:
882: X_return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
883: FND_MSG_PUB.Build_Exc_Msg(
884: p_pkg_name =>'Inv_Project',
885: p_procedure_name => 'Get_project_info_from_Req');
886:
887: End Get_project_info_from_Req;
888:

Line 924: p_pkg_name =>'Inv_Project',

920: When Others Then
921:
922: X_return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
923: FND_MSG_PUB.Build_Exc_Msg(
924: p_pkg_name =>'Inv_Project',
925: p_procedure_name => 'Get_project_info_for_RcvTrx');
926:
927: End Get_project_info_for_RcvTrx;
928:

Line 979: p_pkg_name =>'Inv_Project',

975: When Others Then
976:
977: X_return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
978: FND_MSG_PUB.Build_Exc_Msg(
979: p_pkg_name =>'Inv_Project',
980: p_procedure_name => 'Get_project_loc_for_prj_Req');
981:
982: End Get_project_loc_for_prj_Req;
983:

Line 1024: inv_log_util.trace('set client context : '||l_org_id, 'INV_PROJECT', 9);

1020: end if;
1021:
1022: -- bugfix 4643461 added debug message
1023: if ( nvl(fnd_profile.value('INV_DEBUG_TRACE'), 0) = 1 ) then
1024: inv_log_util.trace('set client context : '||l_org_id, 'INV_PROJECT', 9);
1025: inv_log_util.trace('g_organization_id : '||g_organization_id, 'INV_PROJECT', 9);
1026: end if;
1027:
1028:

Line 1025: inv_log_util.trace('g_organization_id : '||g_organization_id, 'INV_PROJECT', 9);

1021:
1022: -- bugfix 4643461 added debug message
1023: if ( nvl(fnd_profile.value('INV_DEBUG_TRACE'), 0) = 1 ) then
1024: inv_log_util.trace('set client context : '||l_org_id, 'INV_PROJECT', 9);
1025: inv_log_util.trace('g_organization_id : '||g_organization_id, 'INV_PROJECT', 9);
1026: end if;
1027:
1028:
1029: /*END IF;*/

Line 1037: p_pkg_name =>'Inv_Project',

1033: WHEN OTHERS THEN
1034:
1035: X_return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1036: FND_MSG_PUB.Build_Exc_Msg(
1037: p_pkg_name =>'Inv_Project',
1038: p_procedure_name => 'Set_Org_client_info');
1039:
1040: END Set_Org_client_info;
1041:

Line 1549: whereas inv_projectlocator_pu.get_project_number do not require */

1545: BEGIN
1546:
1547: /* The below code is commented because it uses pjm_projects_mtll_v
1548: which requrires mfg_organization_id profile value needs to be set
1549: whereas inv_projectlocator_pu.get_project_number do not require */
1550:
1551: -- If this code is ever uncommneted then the profile mfg_organization_id
1552: -- needs to be set by the calling object otherwise PJM_PROJECTS_MTLL_V
1553: -- will not return a value. Bug 4662395

Line 1564: return INV_ProjectLocator_PUB.GET_PROJECT_NUMBER(p_project_id);

1560: IF (l_debug = 1) THEN
1561: MYDEBUG('GET_PROJECT_NUMBER: RETURNS '||L_PROJECT_NUMBER);
1562: END IF;
1563: RETURN L_PROJECT_NUMBER;*/
1564: return INV_ProjectLocator_PUB.GET_PROJECT_NUMBER(p_project_id);
1565:
1566: END GET_PROJECT_NUMBER;
1567:
1568: FUNCTION GET_TASK_NUMBER(P_TASK_ID IN NUMBER) RETURN VARCHAR2 IS

Line 1582: return INV_ProjectLocator_PUB.GET_TASK_NUMBER(P_TASK_ID);

1578: IF (l_debug = 1) THEN
1579: MYDEBUG('GET_TASK_NUMBER: RETURNS '||L_TASK_NUMBER);
1580: END IF;
1581: RETURN L_TASK_NUMBER;*/
1582: return INV_ProjectLocator_PUB.GET_TASK_NUMBER(P_TASK_ID);
1583:
1584: EXCEPTION
1585: WHEN OTHERS THEN
1586: IF (l_debug = 1) THEN

Line 1599: * INV_PROJECT.GET_LOCSEGS(LOCATOR_ID,ORG_ID)

1595: * These function are used to get the Project/Task Number of the Last Accessed
1596: * combination. They are for use in select statements e.g.
1597: * SELECT ..
1598: * ..
1599: * INV_PROJECT.GET_LOCSEGS(LOCATOR_ID,ORG_ID)
1600: * INV_PROJECT.GET_PROJECT_ID,
1601: * INV_PROJECT.GET_PROJECT_NUMBER,
1602: * INV_PROJECT.GET_TASK_ID,
1603: * INV_PROJECT.GET_TASK_NUMBER,

Line 1600: * INV_PROJECT.GET_PROJECT_ID,

1596: * combination. They are for use in select statements e.g.
1597: * SELECT ..
1598: * ..
1599: * INV_PROJECT.GET_LOCSEGS(LOCATOR_ID,ORG_ID)
1600: * INV_PROJECT.GET_PROJECT_ID,
1601: * INV_PROJECT.GET_PROJECT_NUMBER,
1602: * INV_PROJECT.GET_TASK_ID,
1603: * INV_PROJECT.GET_TASK_NUMBER,
1604: * ..

Line 1601: * INV_PROJECT.GET_PROJECT_NUMBER,

1597: * SELECT ..
1598: * ..
1599: * INV_PROJECT.GET_LOCSEGS(LOCATOR_ID,ORG_ID)
1600: * INV_PROJECT.GET_PROJECT_ID,
1601: * INV_PROJECT.GET_PROJECT_NUMBER,
1602: * INV_PROJECT.GET_TASK_ID,
1603: * INV_PROJECT.GET_TASK_NUMBER,
1604: * ..
1605: * FROM WMS_LICENSE_PLATE_NUMBERS

Line 1602: * INV_PROJECT.GET_TASK_ID,

1598: * ..
1599: * INV_PROJECT.GET_LOCSEGS(LOCATOR_ID,ORG_ID)
1600: * INV_PROJECT.GET_PROJECT_ID,
1601: * INV_PROJECT.GET_PROJECT_NUMBER,
1602: * INV_PROJECT.GET_TASK_ID,
1603: * INV_PROJECT.GET_TASK_NUMBER,
1604: * ..
1605: * FROM WMS_LICENSE_PLATE_NUMBERS
1606: *

Line 1603: * INV_PROJECT.GET_TASK_NUMBER,

1599: * INV_PROJECT.GET_LOCSEGS(LOCATOR_ID,ORG_ID)
1600: * INV_PROJECT.GET_PROJECT_ID,
1601: * INV_PROJECT.GET_PROJECT_NUMBER,
1602: * INV_PROJECT.GET_TASK_ID,
1603: * INV_PROJECT.GET_TASK_NUMBER,
1604: * ..
1605: * FROM WMS_LICENSE_PLATE_NUMBERS
1606: *
1607: */

Line 1689: --Commented For Bug# 7623167 and replaced below: L_CONCAT := 'inv_project.GET_PROJECT_NUMBER('||L_COLNAME||')'; --Changed for bug 3073756

1685:
1686: /* Bug# 7623167: Added the replace fucntion to individual segments for getting the correct concatenated segments
1687: as if a segment is having the occurrence of the seperator then it should be prefixed by a backslash */
1688: IF (L_COLNAME = 'SEGMENT19') THEN
1689: --Commented For Bug# 7623167 and replaced below: L_CONCAT := 'inv_project.GET_PROJECT_NUMBER('||L_COLNAME||')'; --Changed for bug 3073756
1690: L_CONCAT := 'REPLACE(inv_project.GET_PROJECT_NUMBER('||L_COLNAME|| '),''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';
1691: ELSIF(L_COLNAME = 'SEGMENT20') THEN
1692: --Commented For Bug# 7623167 and replaced below: L_CONCAT := 'inv_project.GET_TASK_NUMBER('||L_COLNAME||')'; --Changed for bug 3073756
1693: L_CONCAT := 'REPLACE(inv_project.GET_TASK_NUMBER('||L_COLNAME|| '),''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';

Line 1690: L_CONCAT := 'REPLACE(inv_project.GET_PROJECT_NUMBER('||L_COLNAME|| '),''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';

1686: /* Bug# 7623167: Added the replace fucntion to individual segments for getting the correct concatenated segments
1687: as if a segment is having the occurrence of the seperator then it should be prefixed by a backslash */
1688: IF (L_COLNAME = 'SEGMENT19') THEN
1689: --Commented For Bug# 7623167 and replaced below: L_CONCAT := 'inv_project.GET_PROJECT_NUMBER('||L_COLNAME||')'; --Changed for bug 3073756
1690: L_CONCAT := 'REPLACE(inv_project.GET_PROJECT_NUMBER('||L_COLNAME|| '),''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';
1691: ELSIF(L_COLNAME = 'SEGMENT20') THEN
1692: --Commented For Bug# 7623167 and replaced below: L_CONCAT := 'inv_project.GET_TASK_NUMBER('||L_COLNAME||')'; --Changed for bug 3073756
1693: L_CONCAT := 'REPLACE(inv_project.GET_TASK_NUMBER('||L_COLNAME|| '),''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';
1694: ELSIF (L_VALIDATION_TYPE = 'N' OR L_VALIDATION_TYPE IS NULL) THEN

Line 1692: --Commented For Bug# 7623167 and replaced below: L_CONCAT := 'inv_project.GET_TASK_NUMBER('||L_COLNAME||')'; --Changed for bug 3073756

1688: IF (L_COLNAME = 'SEGMENT19') THEN
1689: --Commented For Bug# 7623167 and replaced below: L_CONCAT := 'inv_project.GET_PROJECT_NUMBER('||L_COLNAME||')'; --Changed for bug 3073756
1690: L_CONCAT := 'REPLACE(inv_project.GET_PROJECT_NUMBER('||L_COLNAME|| '),''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';
1691: ELSIF(L_COLNAME = 'SEGMENT20') THEN
1692: --Commented For Bug# 7623167 and replaced below: L_CONCAT := 'inv_project.GET_TASK_NUMBER('||L_COLNAME||')'; --Changed for bug 3073756
1693: L_CONCAT := 'REPLACE(inv_project.GET_TASK_NUMBER('||L_COLNAME|| '),''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';
1694: ELSIF (L_VALIDATION_TYPE = 'N' OR L_VALIDATION_TYPE IS NULL) THEN
1695: --Commented For Bug# 7623167 and replaced below: L_CONCAT := L_COLNAME;
1696: L_CONCAT := 'REPLACE('||L_COLNAME||',''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';

Line 1693: L_CONCAT := 'REPLACE(inv_project.GET_TASK_NUMBER('||L_COLNAME|| '),''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';

1689: --Commented For Bug# 7623167 and replaced below: L_CONCAT := 'inv_project.GET_PROJECT_NUMBER('||L_COLNAME||')'; --Changed for bug 3073756
1690: L_CONCAT := 'REPLACE(inv_project.GET_PROJECT_NUMBER('||L_COLNAME|| '),''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';
1691: ELSIF(L_COLNAME = 'SEGMENT20') THEN
1692: --Commented For Bug# 7623167 and replaced below: L_CONCAT := 'inv_project.GET_TASK_NUMBER('||L_COLNAME||')'; --Changed for bug 3073756
1693: L_CONCAT := 'REPLACE(inv_project.GET_TASK_NUMBER('||L_COLNAME|| '),''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';
1694: ELSIF (L_VALIDATION_TYPE = 'N' OR L_VALIDATION_TYPE IS NULL) THEN
1695: --Commented For Bug# 7623167 and replaced below: L_CONCAT := L_COLNAME;
1696: L_CONCAT := 'REPLACE('||L_COLNAME||',''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';
1697: ELSE

Line 1711: --Commented For Bug# 7623167 and replaced below: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'inv_project.GET_PROJECT_NUMBER('||L_COLNAME||')';

1707: ELSE
1708: IF (L_CONCAT IS NULL) THEN
1709: L_CONCAT := NULL;
1710: ELSIF (L_COLNAME = 'SEGMENT19') THEN
1711: --Commented For Bug# 7623167 and replaced below: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'inv_project.GET_PROJECT_NUMBER('||L_COLNAME||')';
1712: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'REPLACE(inv_project.GET_PROJECT_NUMBER('||L_COLNAME|| '),''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';
1713: ELSIF(L_COLNAME = 'SEGMENT20') THEN
1714: --Commented For Bug# 7623167 and replaced below: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'inv_project.GET_TASK_NUMBER('||L_COLNAME||')';
1715: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'REPLACE(inv_project.GET_TASK_NUMBER('||L_COLNAME|| '),''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';

Line 1712: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'REPLACE(inv_project.GET_PROJECT_NUMBER('||L_COLNAME|| '),''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';

1708: IF (L_CONCAT IS NULL) THEN
1709: L_CONCAT := NULL;
1710: ELSIF (L_COLNAME = 'SEGMENT19') THEN
1711: --Commented For Bug# 7623167 and replaced below: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'inv_project.GET_PROJECT_NUMBER('||L_COLNAME||')';
1712: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'REPLACE(inv_project.GET_PROJECT_NUMBER('||L_COLNAME|| '),''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';
1713: ELSIF(L_COLNAME = 'SEGMENT20') THEN
1714: --Commented For Bug# 7623167 and replaced below: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'inv_project.GET_TASK_NUMBER('||L_COLNAME||')';
1715: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'REPLACE(inv_project.GET_TASK_NUMBER('||L_COLNAME|| '),''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';
1716: ELSIF (L_VALIDATION_TYPE = 'N' OR L_VALIDATION_TYPE IS NULL) AND L_CONCAT IS NOT NULL THEN

Line 1714: --Commented For Bug# 7623167 and replaced below: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'inv_project.GET_TASK_NUMBER('||L_COLNAME||')';

1710: ELSIF (L_COLNAME = 'SEGMENT19') THEN
1711: --Commented For Bug# 7623167 and replaced below: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'inv_project.GET_PROJECT_NUMBER('||L_COLNAME||')';
1712: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'REPLACE(inv_project.GET_PROJECT_NUMBER('||L_COLNAME|| '),''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';
1713: ELSIF(L_COLNAME = 'SEGMENT20') THEN
1714: --Commented For Bug# 7623167 and replaced below: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'inv_project.GET_TASK_NUMBER('||L_COLNAME||')';
1715: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'REPLACE(inv_project.GET_TASK_NUMBER('||L_COLNAME|| '),''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';
1716: ELSIF (L_VALIDATION_TYPE = 'N' OR L_VALIDATION_TYPE IS NULL) AND L_CONCAT IS NOT NULL THEN
1717: --Commented For Bug# 7623167 and replaced below: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || L_COLNAME;
1718: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'REPLACE('||L_COLNAME||',''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';

Line 1715: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'REPLACE(inv_project.GET_TASK_NUMBER('||L_COLNAME|| '),''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';

1711: --Commented For Bug# 7623167 and replaced below: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'inv_project.GET_PROJECT_NUMBER('||L_COLNAME||')';
1712: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'REPLACE(inv_project.GET_PROJECT_NUMBER('||L_COLNAME|| '),''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';
1713: ELSIF(L_COLNAME = 'SEGMENT20') THEN
1714: --Commented For Bug# 7623167 and replaced below: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'inv_project.GET_TASK_NUMBER('||L_COLNAME||')';
1715: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'REPLACE(inv_project.GET_TASK_NUMBER('||L_COLNAME|| '),''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';
1716: ELSIF (L_VALIDATION_TYPE = 'N' OR L_VALIDATION_TYPE IS NULL) AND L_CONCAT IS NOT NULL THEN
1717: --Commented For Bug# 7623167 and replaced below: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || L_COLNAME;
1718: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'REPLACE('||L_COLNAME||',''' || L_DELIM || ''',''' || L_BSLASH_DELIM || ''')';
1719:

Line 2095: END inv_project;

2091: END get_pjm_locsegs;
2092:
2093:
2094:
2095: END inv_project;