DBA Data[Home] [Help]

APPS.PA_LIFECYCLES_PVT dependencies on PA_LIFECYCLE_USAGES_S

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