APPS.PA_LIFECYCLES_PVT dependencies on PA_LIFECYCLE_USAGES_PKG

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