DBA Data[Home] [Help]

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.10 2006/09/04 10:48:34 ramarava noship $ */
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.10 2006/09/04 10:48:34 ramarava noship $ */
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 771: INV_PROJECT.org_project_parameters(v_org_id,

767: v_pm_cost_collection_enabled number;
768: v_project_control_level number;
769: v_success boolean;
770: begin
771: INV_PROJECT.org_project_parameters(v_org_id,
772: v_project_reference_enabled,
773: v_pm_cost_collection_enabled,
774: v_project_control_level,
775: v_success);

Line 800: INV_PROJECT.org_project_parameters(v_org_id,

796: v_pm_cost_collection_enabled number;
797: v_project_control_level number;
798: v_success boolean;
799: begin
800: INV_PROJECT.org_project_parameters(v_org_id,
801: v_project_reference_enabled,
802: v_pm_cost_collection_enabled,
803: v_project_control_level,
804: v_success);

Line 879: p_pkg_name =>'Inv_Project',

875: When Others Then
876:
877: X_return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
878: FND_MSG_PUB.Build_Exc_Msg(
879: p_pkg_name =>'Inv_Project',
880: p_procedure_name => 'Get_project_info_from_Req');
881:
882: End Get_project_info_from_Req;
883:

Line 919: p_pkg_name =>'Inv_Project',

915: When Others Then
916:
917: X_return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
918: FND_MSG_PUB.Build_Exc_Msg(
919: p_pkg_name =>'Inv_Project',
920: p_procedure_name => 'Get_project_info_for_RcvTrx');
921:
922: End Get_project_info_for_RcvTrx;
923:

Line 974: p_pkg_name =>'Inv_Project',

970: When Others Then
971:
972: X_return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
973: FND_MSG_PUB.Build_Exc_Msg(
974: p_pkg_name =>'Inv_Project',
975: p_procedure_name => 'Get_project_loc_for_prj_Req');
976:
977: End Get_project_loc_for_prj_Req;
978:

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

1015: end if;
1016:
1017: -- bugfix 4643461 added debug message
1018: if ( nvl(fnd_profile.value('INV_DEBUG_TRACE'), 0) = 1 ) then
1019: inv_log_util.trace('set client context : '||l_org_id, 'INV_PROJECT', 9);
1020: inv_log_util.trace('g_organization_id : '||g_organization_id, 'INV_PROJECT', 9);
1021: end if;
1022:
1023:

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

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

Line 1032: p_pkg_name =>'Inv_Project',

1028: WHEN OTHERS THEN
1029:
1030: X_return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1031: FND_MSG_PUB.Build_Exc_Msg(
1032: p_pkg_name =>'Inv_Project',
1033: p_procedure_name => 'Set_Org_client_info');
1034:
1035: END Set_Org_client_info;
1036:

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

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

Line 1559: return INV_ProjectLocator_PUB.GET_PROJECT_NUMBER(p_project_id);

1555: IF (l_debug = 1) THEN
1556: MYDEBUG('GET_PROJECT_NUMBER: RETURNS '||L_PROJECT_NUMBER);
1557: END IF;
1558: RETURN L_PROJECT_NUMBER;*/
1559: return INV_ProjectLocator_PUB.GET_PROJECT_NUMBER(p_project_id);
1560:
1561: END GET_PROJECT_NUMBER;
1562:
1563: FUNCTION GET_TASK_NUMBER(P_TASK_ID IN NUMBER) RETURN VARCHAR2 IS

Line 1577: return INV_ProjectLocator_PUB.GET_TASK_NUMBER(P_TASK_ID);

1573: IF (l_debug = 1) THEN
1574: MYDEBUG('GET_TASK_NUMBER: RETURNS '||L_TASK_NUMBER);
1575: END IF;
1576: RETURN L_TASK_NUMBER;*/
1577: return INV_ProjectLocator_PUB.GET_TASK_NUMBER(P_TASK_ID);
1578:
1579: EXCEPTION
1580: WHEN OTHERS THEN
1581: IF (l_debug = 1) THEN

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

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

Line 1595: * INV_PROJECT.GET_PROJECT_ID,

1591: * combination. They are for use in select statements e.g.
1592: * SELECT ..
1593: * ..
1594: * INV_PROJECT.GET_LOCSEGS(LOCATOR_ID,ORG_ID)
1595: * INV_PROJECT.GET_PROJECT_ID,
1596: * INV_PROJECT.GET_PROJECT_NUMBER,
1597: * INV_PROJECT.GET_TASK_ID,
1598: * INV_PROJECT.GET_TASK_NUMBER,
1599: * ..

Line 1596: * INV_PROJECT.GET_PROJECT_NUMBER,

1592: * SELECT ..
1593: * ..
1594: * INV_PROJECT.GET_LOCSEGS(LOCATOR_ID,ORG_ID)
1595: * INV_PROJECT.GET_PROJECT_ID,
1596: * INV_PROJECT.GET_PROJECT_NUMBER,
1597: * INV_PROJECT.GET_TASK_ID,
1598: * INV_PROJECT.GET_TASK_NUMBER,
1599: * ..
1600: * FROM WMS_LICENSE_PLATE_NUMBERS

Line 1597: * INV_PROJECT.GET_TASK_ID,

1593: * ..
1594: * INV_PROJECT.GET_LOCSEGS(LOCATOR_ID,ORG_ID)
1595: * INV_PROJECT.GET_PROJECT_ID,
1596: * INV_PROJECT.GET_PROJECT_NUMBER,
1597: * INV_PROJECT.GET_TASK_ID,
1598: * INV_PROJECT.GET_TASK_NUMBER,
1599: * ..
1600: * FROM WMS_LICENSE_PLATE_NUMBERS
1601: *

Line 1598: * INV_PROJECT.GET_TASK_NUMBER,

1594: * INV_PROJECT.GET_LOCSEGS(LOCATOR_ID,ORG_ID)
1595: * INV_PROJECT.GET_PROJECT_ID,
1596: * INV_PROJECT.GET_PROJECT_NUMBER,
1597: * INV_PROJECT.GET_TASK_ID,
1598: * INV_PROJECT.GET_TASK_NUMBER,
1599: * ..
1600: * FROM WMS_LICENSE_PLATE_NUMBERS
1601: *
1602: */

Line 1677: L_CONCAT := 'inv_project.GET_PROJECT_NUMBER('||L_COLNAME||')'; --Changed for bug 3073756

1673: EXIT WHEN CUR_SEG%NOTFOUND;
1674: L_ROWNUM := L_ROWNUM + 1;
1675: IF (L_FIRST_TIME) THEN
1676: IF (L_COLNAME = 'SEGMENT19') THEN
1677: L_CONCAT := 'inv_project.GET_PROJECT_NUMBER('||L_COLNAME||')'; --Changed for bug 3073756
1678: ELSIF(L_COLNAME = 'SEGMENT20') THEN
1679: L_CONCAT := 'inv_project.GET_TASK_NUMBER('||L_COLNAME||')'; --Changed for bug 3073756
1680: ELSIF (L_VALIDATION_TYPE = 'N' OR L_VALIDATION_TYPE IS NULL) THEN
1681: L_CONCAT := L_COLNAME;

Line 1679: L_CONCAT := 'inv_project.GET_TASK_NUMBER('||L_COLNAME||')'; --Changed for bug 3073756

1675: IF (L_FIRST_TIME) THEN
1676: IF (L_COLNAME = 'SEGMENT19') THEN
1677: L_CONCAT := 'inv_project.GET_PROJECT_NUMBER('||L_COLNAME||')'; --Changed for bug 3073756
1678: ELSIF(L_COLNAME = 'SEGMENT20') THEN
1679: L_CONCAT := 'inv_project.GET_TASK_NUMBER('||L_COLNAME||')'; --Changed for bug 3073756
1680: ELSIF (L_VALIDATION_TYPE = 'N' OR L_VALIDATION_TYPE IS NULL) THEN
1681: L_CONCAT := L_COLNAME;
1682: ELSE
1683: L_CONCAT := NULL;

Line 1693: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'inv_project.GET_PROJECT_NUMBER('||L_COLNAME||')';

1689: ELSE
1690: IF (L_CONCAT IS NULL) THEN
1691: L_CONCAT := NULL;
1692: ELSIF (L_COLNAME = 'SEGMENT19') THEN
1693: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'inv_project.GET_PROJECT_NUMBER('||L_COLNAME||')';
1694: ELSIF(L_COLNAME = 'SEGMENT20') THEN
1695: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'inv_project.GET_TASK_NUMBER('||L_COLNAME||')';
1696: ELSIF (L_VALIDATION_TYPE = 'N' OR L_VALIDATION_TYPE IS NULL) AND L_CONCAT IS NOT NULL THEN
1697: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || L_COLNAME;

Line 1695: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'inv_project.GET_TASK_NUMBER('||L_COLNAME||')';

1691: L_CONCAT := NULL;
1692: ELSIF (L_COLNAME = 'SEGMENT19') THEN
1693: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'inv_project.GET_PROJECT_NUMBER('||L_COLNAME||')';
1694: ELSIF(L_COLNAME = 'SEGMENT20') THEN
1695: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || 'inv_project.GET_TASK_NUMBER('||L_COLNAME||')';
1696: ELSIF (L_VALIDATION_TYPE = 'N' OR L_VALIDATION_TYPE IS NULL) AND L_CONCAT IS NOT NULL THEN
1697: L_CONCAT := L_CONCAT || '||' || '''' || L_DELIM || '''' || '||' || L_COLNAME;
1698: ELSE
1699: L_CONCAT := NULL;

Line 2065: END inv_project;

2061: END get_pjm_locsegs;
2062:
2063:
2064:
2065: END inv_project;