DBA Data[Home] [Help]

APPS.PA_WORK_TYPES_PKG dependencies on PA_INSTALL

Line 123: IF ((sql%rowcount > 0) AND (NVL(PA_INSTALL.is_pji_licensed(),'N')='Y')) THEN

119: );
120:
121: /** If PJI is installed then we need to insert record into PA_PJI_PROJ_EVENTS_LOG table
122: ** for every insert/update/delete in pa_work_types_b **/
123: IF ((sql%rowcount > 0) AND (NVL(PA_INSTALL.is_pji_licensed(),'N')='Y')) THEN
124: l_pji_rowid := null;
125: l_pji_event_id := null;
126:
127: PA_PJI_PROJ_EVENTS_LOG_PKG.Insert_Row(

Line 469: IF ((l_sql_rowcount > 0) AND (NVL(PA_INSTALL.is_pji_licensed(),'N')='Y')) THEN

465: l_sql_rowcount := sql%rowcount;
466:
467: /** If PJI is installed then we need to insert record into PA_PJI_PROJ_EVENTS_LOG table
468: ** for every insert/update/delete in pa_work_types_b **/
469: IF ((l_sql_rowcount > 0) AND (NVL(PA_INSTALL.is_pji_licensed(),'N')='Y')) THEN
470: l_pji_rowid := null;
471: l_pji_event_id := null;
472:
473: PA_PJI_PROJ_EVENTS_LOG_PKG.Insert_Row(

Line 577: IF ((l_sql_rowcount > 0) AND (NVL(PA_INSTALL.is_pji_licensed(),'N')='Y')) THEN

573: l_sql_rowcount := sql%rowcount ;
574:
575: /** If PJI is installed then we need to insert record into PA_PJI_PROJ_EVENTS_LOG table
576: ** for every insert/update/delete in pa_work_types_b **/
577: IF ((l_sql_rowcount > 0) AND (NVL(PA_INSTALL.is_pji_licensed(),'N')='Y')) THEN
578: l_pji_rowid := null;
579: l_pji_event_id := null;
580:
581: PA_PJI_PROJ_EVENTS_LOG_PKG.Insert_Row(