DBA Data[Home] [Help]

APPS.PJI_PJP_SUM_DENORM dependencies on PJI_XBS_DENORM

Line 905: it inserts all the data to pji_xbs_Denorm from pa_xbs_Denorm*/

901: ,l_last_update_login
902: );
903: END IF;
904: /* The below insert replaces the call to Pji_Pjp_Sum_Rollup.update_xbs_denorm
905: it inserts all the data to pji_xbs_Denorm from pa_xbs_Denorm*/
906: IF struct_typetab.COUNT <>0 then
907: FORALL i IN struct_typetab.FIRST..struct_typetab.LAST
908: insert into PJI_XBS_DENORM(
909: struct_type

Line 908: insert into PJI_XBS_DENORM(

904: /* The below insert replaces the call to Pji_Pjp_Sum_Rollup.update_xbs_denorm
905: it inserts all the data to pji_xbs_Denorm from pa_xbs_Denorm*/
906: IF struct_typetab.COUNT <>0 then
907: FORALL i IN struct_typetab.FIRST..struct_typetab.LAST
908: insert into PJI_XBS_DENORM(
909: struct_type
910: ,prg_group
911: ,struct_version_id
912: ,sup_project_id

Line 999: insert into PJI_XBS_DENORM

995: and xbs.sub_id=p_wbs_version_id_from;
996: --write_log('inert of PRG line done 1');
997:
998: -- write_log(' first insert into pji 1');
999: insert into PJI_XBS_DENORM
1000: (
1001: STRUCT_TYPE,
1002: PRG_GROUP,
1003: STRUCT_VERSION_ID,

Line 1155: it inserts all the data to pji_xbs_Denorm from pa_xbs_Denorm*/

1151: ,l_last_update_login
1152: );
1153: END IF;
1154: /* The below insert replaces the call to Pji_Pjp_Sum_Rollup.update_xbs_denorm
1155: it inserts all the data to pji_xbs_Denorm from pa_xbs_Denorm*/
1156: IF struct_typetab.COUNT <>0 then
1157: FORALL i IN struct_typetab.FIRST..struct_typetab.LAST
1158: insert into PJI_XBS_DENORM(
1159: struct_type

Line 1158: insert into PJI_XBS_DENORM(

1154: /* The below insert replaces the call to Pji_Pjp_Sum_Rollup.update_xbs_denorm
1155: it inserts all the data to pji_xbs_Denorm from pa_xbs_Denorm*/
1156: IF struct_typetab.COUNT <>0 then
1157: FORALL i IN struct_typetab.FIRST..struct_typetab.LAST
1158: insert into PJI_XBS_DENORM(
1159: struct_type
1160: ,prg_group
1161: ,struct_version_id
1162: ,sup_project_id

Line 1246: insert into PJI_XBS_DENORM

1242: where xbs.struct_version_id is null
1243: and xbs.sup_id=p_wbs_version_id_from
1244: and xbs.sub_id=p_wbs_version_id_from;
1245:
1246: insert into PJI_XBS_DENORM
1247: (
1248: STRUCT_TYPE,
1249: PRG_GROUP,
1250: STRUCT_VERSION_ID,