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_LIFECYCLES_PVT dependencies on PA_LIFECYCLE_USAGES

Line 327: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into PA_LIFECYCLE_USAGES..');

323: X_ATTRIBUTE15 => NULL
324: );
325:
326: IF(p_debug_mode = 'Y') THEN
327: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into PA_LIFECYCLE_USAGES..');
328: END IF;
329:
330: IF (p_lifecycle_project_usage_type = 'Y') THEN
331: SELECT PA_LIFECYCLE_USAGES_S.NEXTVAL

Line 331: SELECT PA_LIFECYCLE_USAGES_S.NEXTVAL

327: pa_debug.debug('CREATE_LIFECYCLE PVT:Inserting into PA_LIFECYCLE_USAGES..');
328: END IF;
329:
330: IF (p_lifecycle_project_usage_type = 'Y') THEN
331: SELECT PA_LIFECYCLE_USAGES_S.NEXTVAL
332: INTO l_lcyl_usage_id
333: FROM dual;
334:
335: PA_LIFECYCLE_USAGES_PKG.INSERT_ROW(

Line 335: PA_LIFECYCLE_USAGES_PKG.INSERT_ROW(

331: SELECT PA_LIFECYCLE_USAGES_S.NEXTVAL
332: INTO l_lcyl_usage_id
333: FROM dual;
334:
335: PA_LIFECYCLE_USAGES_PKG.INSERT_ROW(
336: X_LIFECYCLE_USAGE_ID => l_lcyl_usage_id ,
337: X_RECORD_VERSION_NUMBER => 1 ,
338: X_LIFECYCLE_ID => l_lifecycle_id ,
339: X_USAGE_TYPE => 'PROJECTS'

Line 344: SELECT PA_LIFECYCLE_USAGES_S.NEXTVAL

340: );
341: END IF;
342:
343: IF (p_lifecycle_product_usage_type = 'Y') THEN
344: SELECT PA_LIFECYCLE_USAGES_S.NEXTVAL
345: INTO l_lcyl_usage_id
346: FROM dual;
347:
348: PA_LIFECYCLE_USAGES_PKG.INSERT_ROW(

Line 348: PA_LIFECYCLE_USAGES_PKG.INSERT_ROW(

344: SELECT PA_LIFECYCLE_USAGES_S.NEXTVAL
345: INTO l_lcyl_usage_id
346: FROM dual;
347:
348: PA_LIFECYCLE_USAGES_PKG.INSERT_ROW(
349: X_LIFECYCLE_USAGE_ID => l_lcyl_usage_id ,
350: X_RECORD_VERSION_NUMBER => 1 ,
351: X_LIFECYCLE_ID => l_lifecycle_id ,
352: X_USAGE_TYPE => 'PRODUCTS'

Line 932: FROM pa_lifecycle_usages

928:
929: cursor l_row_lifecycle_usages
930: IS
931: SELECT LIFECYCLE_USAGE_ID
932: FROM pa_lifecycle_usages
933: WHERE lifecycle_id = P_lifecycle_id;
934:
935:
936: Begin

Line 1111: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_LIFECYCLE_USAGES_PKG.delete_Row');

1107:
1108: PA_PROJ_STRUCTURE_TYPES_PKG.delete_Row(l_rowid);
1109:
1110: IF (p_debug_mode = 'Y') THEN
1111: pa_debug.debug('DELETE_LIFECYCLE_PVT.delete_lifecycle:Calling PA_LIFECYCLE_USAGES_PKG.delete_Row');
1112: END IF;
1113:
1114: OPEN l_row_lifecycle_usages;
1115: LOOP

Line 1118: PA_LIFECYCLE_USAGES_PKG.Delete_Row(l_LIFECYCLE_USAGE_ID);

1114: OPEN l_row_lifecycle_usages;
1115: LOOP
1116: FETCH l_row_lifecycle_usages into l_LIFECYCLE_USAGE_ID;
1117: EXIT WHEN l_row_lifecycle_usages%NOTFOUND;
1118: PA_LIFECYCLE_USAGES_PKG.Delete_Row(l_LIFECYCLE_USAGE_ID);
1119: END LOOP;
1120: CLOSE l_row_lifecycle_usages;
1121:
1122:

Line 1511: From pa_lifecycle_usages

1507: IS
1508: Select 'Y'
1509: From dual
1510: Where exists(Select 'XYZ'
1511: From pa_lifecycle_usages
1512: Where lifecycle_id = P_lifecycle_id
1513: and usage_type = c_usage_project);
1514:
1515: CURSOR l_check_product_csr

Line 1520: From pa_lifecycle_usages

1516: IS
1517: Select 'Y'
1518: From dual
1519: Where exists(Select 'XYZ'
1520: From pa_lifecycle_usages
1521: Where lifecycle_id = P_lifecycle_id
1522: and usage_type = c_usage_product);
1523:
1524: CURSOR l_project_workplan_csr

Line 1685: from pa_lifecycle_usages

1681:
1682: CURSOR get_project_usage
1683: IS
1684: SELECT lifecycle_usage_id
1685: from pa_lifecycle_usages
1686: where lifecycle_id = P_lifecycle_id
1687: AND usage_type=c_project_type;
1688:
1689: CURSOR get_product_usage

Line 1692: from pa_lifecycle_usages

1688:
1689: CURSOR get_product_usage
1690: IS
1691: SELECT lifecycle_usage_id
1692: from pa_lifecycle_usages
1693: where lifecycle_id = P_lifecycle_id
1694: AND usage_type=c_product_type;
1695:
1696: CURSOR l_row_proj_elem_ver_structure

Line 1995: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle:Inserting into PA_LIFECYCLE_USAGES...');

1991:
1992:
1993:
1994: IF(p_debug_mode = 'Y') THEN
1995: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle:Inserting into PA_LIFECYCLE_USAGES...');
1996: END IF;
1997:
1998: IF (l_proj_usg_exists = 'N' AND P_lifecycle_project_usage_type = 'Y') THEN
1999: SELECT PA_LIFECYCLE_USAGES_S.NEXTVAL

Line 1999: SELECT PA_LIFECYCLE_USAGES_S.NEXTVAL

1995: pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle:Inserting into PA_LIFECYCLE_USAGES...');
1996: END IF;
1997:
1998: IF (l_proj_usg_exists = 'N' AND P_lifecycle_project_usage_type = 'Y') THEN
1999: SELECT PA_LIFECYCLE_USAGES_S.NEXTVAL
2000: INTO l_prj_lcyl_usage_id
2001: FROM dual;
2002:
2003: PA_LIFECYCLE_USAGES_PKG.insert_row(

Line 2003: PA_LIFECYCLE_USAGES_PKG.insert_row(

1999: SELECT PA_LIFECYCLE_USAGES_S.NEXTVAL
2000: INTO l_prj_lcyl_usage_id
2001: FROM dual;
2002:
2003: PA_LIFECYCLE_USAGES_PKG.insert_row(
2004: X_lifecycle_usage_id => l_prj_lcyl_usage_id ,
2005: X_RECORD_VERSION_NUMBER => 1 ,
2006: X_lifecycle_ID => P_lifecycle_id ,
2007: X_USAGE_TYPE => c_project_type

Line 2011: PA_LIFECYCLE_USAGES_PKG.delete_Row(l_prj_lcyl_usage_id);

2007: X_USAGE_TYPE => c_project_type
2008: );
2009:
2010: ELSIF (l_proj_usg_exists = 'Y' AND P_lifecycle_project_usage_type = 'N') THEN
2011: PA_LIFECYCLE_USAGES_PKG.delete_Row(l_prj_lcyl_usage_id);
2012:
2013: END IF;
2014:
2015: IF (l_prod_usg_exists = 'N' AND P_lifecycle_product_usage_type = 'Y') THEN

Line 2016: SELECT PA_LIFECYCLE_USAGES_S.NEXTVAL

2012:
2013: END IF;
2014:
2015: IF (l_prod_usg_exists = 'N' AND P_lifecycle_product_usage_type = 'Y') THEN
2016: SELECT PA_LIFECYCLE_USAGES_S.NEXTVAL
2017: INTO l_prd_lcyl_usage_id
2018: FROM dual;
2019:
2020: PA_LIFECYCLE_USAGES_PKG.insert_row(

Line 2020: PA_LIFECYCLE_USAGES_PKG.insert_row(

2016: SELECT PA_LIFECYCLE_USAGES_S.NEXTVAL
2017: INTO l_prd_lcyl_usage_id
2018: FROM dual;
2019:
2020: PA_LIFECYCLE_USAGES_PKG.insert_row(
2021: X_lifecycle_usage_id => l_prd_lcyl_usage_id ,
2022: X_RECORD_VERSION_NUMBER => 1 ,
2023: X_lifecycle_ID => P_lifecycle_id ,
2024: X_USAGE_TYPE => c_product_type

Line 2027: PA_LIFECYCLE_USAGES_PKG.delete_Row(l_prd_lcyl_usage_id);

2023: X_lifecycle_ID => P_lifecycle_id ,
2024: X_USAGE_TYPE => c_product_type
2025: );
2026: ELSIF (l_prod_usg_exists = 'Y' AND P_lifecycle_product_usage_type = 'N') THEN
2027: PA_LIFECYCLE_USAGES_PKG.delete_Row(l_prd_lcyl_usage_id);
2028: END IF;
2029:
2030: EXCEPTION
2031:

Line 2451: where exists( select 'XYZ' from pa_lifecycle_usages

2447: begin
2448: select 'Y'
2449: into l_project_usage_exists
2450: from SYS.DUAL
2451: where exists( select 'XYZ' from pa_lifecycle_usages
2452: where lifecycle_id=P_lifecycle_id AND
2453: usage_type=c_project_type);
2454: exception
2455: when NO_DATA_FOUND then

Line 2464: where exists( select 'XYZ' from pa_lifecycle_usages

2460: begin
2461: select 'Y'
2462: into l_product_usage_exists
2463: from SYS.DUAL
2464: where exists( select 'XYZ' from pa_lifecycle_usages
2465: where lifecycle_id=P_lifecycle_id AND
2466: usage_type=c_product_type);
2467: exception
2468: when NO_DATA_FOUND then