189:
190: --
191: -- Get the standard who information
192: --
193: x_created_by := FND_GLOBAL.USER_ID;
194: x_last_updated_by := FND_GLOBAL.USER_ID;
195: x_last_update_login := FND_GLOBAL.LOGIN_ID;
196: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
197: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
190: --
191: -- Get the standard who information
192: --
193: x_created_by := FND_GLOBAL.USER_ID;
194: x_last_updated_by := FND_GLOBAL.USER_ID;
195: x_last_update_login := FND_GLOBAL.LOGIN_ID;
196: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
197: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
198: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
191: -- Get the standard who information
192: --
193: x_created_by := FND_GLOBAL.USER_ID;
194: x_last_updated_by := FND_GLOBAL.USER_ID;
195: x_last_update_login := FND_GLOBAL.LOGIN_ID;
196: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
197: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
198: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
199:
192: --
193: x_created_by := FND_GLOBAL.USER_ID;
194: x_last_updated_by := FND_GLOBAL.USER_ID;
195: x_last_update_login := FND_GLOBAL.LOGIN_ID;
196: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
197: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
198: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
199:
200:
193: x_created_by := FND_GLOBAL.USER_ID;
194: x_last_updated_by := FND_GLOBAL.USER_ID;
195: x_last_update_login := FND_GLOBAL.LOGIN_ID;
196: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
197: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
198: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
199:
200:
201: -- Get the standard who information
194: x_last_updated_by := FND_GLOBAL.USER_ID;
195: x_last_update_login := FND_GLOBAL.LOGIN_ID;
196: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
197: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
198: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
199:
200:
201: -- Get the standard who information
202: --
969: i.e ready_to_compile_flag is <>'Y'/'X')*/
970: --
971: -- Get the standard who information
972: --
973: x_last_updated_by := FND_GLOBAL.USER_ID;
974: x_last_update_login := FND_GLOBAL.LOGIN_ID;
975: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
976: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
977: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
970: --
971: -- Get the standard who information
972: --
973: x_last_updated_by := FND_GLOBAL.USER_ID;
974: x_last_update_login := FND_GLOBAL.LOGIN_ID;
975: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
976: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
977: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
978: x_created_by := FND_GLOBAL.USER_ID;
971: -- Get the standard who information
972: --
973: x_last_updated_by := FND_GLOBAL.USER_ID;
974: x_last_update_login := FND_GLOBAL.LOGIN_ID;
975: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
976: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
977: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
978: x_created_by := FND_GLOBAL.USER_ID;
979:
972: --
973: x_last_updated_by := FND_GLOBAL.USER_ID;
974: x_last_update_login := FND_GLOBAL.LOGIN_ID;
975: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
976: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
977: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
978: x_created_by := FND_GLOBAL.USER_ID;
979:
980: /* 3033195 */
973: x_last_updated_by := FND_GLOBAL.USER_ID;
974: x_last_update_login := FND_GLOBAL.LOGIN_ID;
975: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
976: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
977: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
978: x_created_by := FND_GLOBAL.USER_ID;
979:
980: /* 3033195 */
981:
974: x_last_update_login := FND_GLOBAL.LOGIN_ID;
975: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
976: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
977: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
978: x_created_by := FND_GLOBAL.USER_ID;
979:
980: /* 3033195 */
981:
982: /*S.N. 4590268*/
1241: G_RATE_SCH_REVISION_ID := rate_sch_rev_id;
1242: --
1243: -- Get the standard who information
1244: --
1245: x_last_updated_by := FND_GLOBAL.USER_ID;
1246: x_last_update_login := FND_GLOBAL.LOGIN_ID;
1247: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1248: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
1249: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1242: --
1243: -- Get the standard who information
1244: --
1245: x_last_updated_by := FND_GLOBAL.USER_ID;
1246: x_last_update_login := FND_GLOBAL.LOGIN_ID;
1247: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1248: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
1249: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1250: l_created_by := -999999;
1243: -- Get the standard who information
1244: --
1245: x_last_updated_by := FND_GLOBAL.USER_ID;
1246: x_last_update_login := FND_GLOBAL.LOGIN_ID;
1247: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1248: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
1249: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1250: l_created_by := -999999;
1251: --
1244: --
1245: x_last_updated_by := FND_GLOBAL.USER_ID;
1246: x_last_update_login := FND_GLOBAL.LOGIN_ID;
1247: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1248: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
1249: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1250: l_created_by := -999999;
1251: --
1252: -- Set the compilation time in the rate schedule revision
1245: x_last_updated_by := FND_GLOBAL.USER_ID;
1246: x_last_update_login := FND_GLOBAL.LOGIN_ID;
1247: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1248: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
1249: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1250: l_created_by := -999999;
1251: --
1252: -- Set the compilation time in the rate schedule revision
1253: --
3945: --
3946: -- Standard who
3947: --
3948:
3949: x_created_by := FND_GLOBAL.USER_ID;
3950: x_last_updated_by := FND_GLOBAL.USER_ID;
3951: x_last_update_login := FND_GLOBAL.LOGIN_ID;
3952:
3953: SELECT cost_plus_structure_type
3946: -- Standard who
3947: --
3948:
3949: x_created_by := FND_GLOBAL.USER_ID;
3950: x_last_updated_by := FND_GLOBAL.USER_ID;
3951: x_last_update_login := FND_GLOBAL.LOGIN_ID;
3952:
3953: SELECT cost_plus_structure_type
3954: INTO structure_type
3947: --
3948:
3949: x_created_by := FND_GLOBAL.USER_ID;
3950: x_last_updated_by := FND_GLOBAL.USER_ID;
3951: x_last_update_login := FND_GLOBAL.LOGIN_ID;
3952:
3953: SELECT cost_plus_structure_type
3954: INTO structure_type
3955: FROM pa_cost_plus_structures
4158:
4159: --
4160: -- Get the standard who information
4161: --
4162: x_last_updated_by := FND_GLOBAL.USER_ID;
4163: x_last_update_login := FND_GLOBAL.LOGIN_ID;
4164: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
4165: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
4166: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
4159: --
4160: -- Get the standard who information
4161: --
4162: x_last_updated_by := FND_GLOBAL.USER_ID;
4163: x_last_update_login := FND_GLOBAL.LOGIN_ID;
4164: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
4165: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
4166: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
4167:
4160: -- Get the standard who information
4161: --
4162: x_last_updated_by := FND_GLOBAL.USER_ID;
4163: x_last_update_login := FND_GLOBAL.LOGIN_ID;
4164: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
4165: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
4166: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
4167:
4168: -- l_burden_profile := nvl(fnd_profile.value('PA_ENHANCED_BURDENING'),'N'); /*2933915 */
4161: --
4162: x_last_updated_by := FND_GLOBAL.USER_ID;
4163: x_last_update_login := FND_GLOBAL.LOGIN_ID;
4164: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
4165: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
4166: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
4167:
4168: -- l_burden_profile := nvl(fnd_profile.value('PA_ENHANCED_BURDENING'),'N'); /*2933915 */
4169: l_burden_profile := pa_utils2.IsEnhancedBurdeningEnabled;
4162: x_last_updated_by := FND_GLOBAL.USER_ID;
4163: x_last_update_login := FND_GLOBAL.LOGIN_ID;
4164: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
4165: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
4166: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
4167:
4168: -- l_burden_profile := nvl(fnd_profile.value('PA_ENHANCED_BURDENING'),'N'); /*2933915 */
4169: l_burden_profile := pa_utils2.IsEnhancedBurdeningEnabled;
4170:
5196:
5197: --
5198: -- Get the standard who information
5199: --
5200: x_last_updated_by := FND_GLOBAL.USER_ID;
5201: x_last_update_login := FND_GLOBAL.LOGIN_ID;
5202: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
5203: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
5204: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
5197: --
5198: -- Get the standard who information
5199: --
5200: x_last_updated_by := FND_GLOBAL.USER_ID;
5201: x_last_update_login := FND_GLOBAL.LOGIN_ID;
5202: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
5203: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
5204: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
5205:
5198: -- Get the standard who information
5199: --
5200: x_last_updated_by := FND_GLOBAL.USER_ID;
5201: x_last_update_login := FND_GLOBAL.LOGIN_ID;
5202: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
5203: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
5204: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
5205:
5206: -- l_burden_profile := nvl(fnd_profile.value('PA_ENHANCED_BURDENING'),'N'); /*2933915*/
5199: --
5200: x_last_updated_by := FND_GLOBAL.USER_ID;
5201: x_last_update_login := FND_GLOBAL.LOGIN_ID;
5202: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
5203: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
5204: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
5205:
5206: -- l_burden_profile := nvl(fnd_profile.value('PA_ENHANCED_BURDENING'),'N'); /*2933915*/
5207: l_burden_profile := pa_utils2.IsEnhancedBurdeningEnabled;
5200: x_last_updated_by := FND_GLOBAL.USER_ID;
5201: x_last_update_login := FND_GLOBAL.LOGIN_ID;
5202: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
5203: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
5204: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
5205:
5206: -- l_burden_profile := nvl(fnd_profile.value('PA_ENHANCED_BURDENING'),'N'); /*2933915*/
5207: l_burden_profile := pa_utils2.IsEnhancedBurdeningEnabled;
5208:
6475:
6476: --
6477: -- Get the standard who information
6478: --
6479: x_last_updated_by := FND_GLOBAL.USER_ID;
6480: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6481: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6482: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
6483: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
6476: --
6477: -- Get the standard who information
6478: --
6479: x_last_updated_by := FND_GLOBAL.USER_ID;
6480: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6481: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6482: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
6483: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
6484:
6477: -- Get the standard who information
6478: --
6479: x_last_updated_by := FND_GLOBAL.USER_ID;
6480: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6481: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6482: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
6483: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
6484:
6485: ei_count := 0;
6478: --
6479: x_last_updated_by := FND_GLOBAL.USER_ID;
6480: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6481: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6482: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
6483: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
6484:
6485: ei_count := 0;
6486: /*
6479: x_last_updated_by := FND_GLOBAL.USER_ID;
6480: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6481: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6482: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
6483: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
6484:
6485: ei_count := 0;
6486: /*
6487: IF (cost_adj_reason IS NOT NULL)
6795:
6796: --
6797: -- Get the standard who information
6798: --
6799: x_last_updated_by := FND_GLOBAL.USER_ID;
6800: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6801: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6802: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
6803: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
6796: --
6797: -- Get the standard who information
6798: --
6799: x_last_updated_by := FND_GLOBAL.USER_ID;
6800: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6801: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6802: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
6803: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
6804:
6797: -- Get the standard who information
6798: --
6799: x_last_updated_by := FND_GLOBAL.USER_ID;
6800: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6801: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6802: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
6803: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
6804:
6805: FOR org_id_rec in org_cursor /*Loop for all the children (including impacted org) of the impacted org*/
6798: --
6799: x_last_updated_by := FND_GLOBAL.USER_ID;
6800: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6801: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6802: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
6803: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
6804:
6805: FOR org_id_rec in org_cursor /*Loop for all the children (including impacted org) of the impacted org*/
6806: LOOP
6799: x_last_updated_by := FND_GLOBAL.USER_ID;
6800: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6801: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6802: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
6803: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
6804:
6805: FOR org_id_rec in org_cursor /*Loop for all the children (including impacted org) of the impacted org*/
6806: LOOP
6807:
6872:
6873: --
6874: -- Get the standard who information
6875: --
6876: x_last_updated_by := FND_GLOBAL.USER_ID;
6877: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6878: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6879: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
6880: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
6873: --
6874: -- Get the standard who information
6875: --
6876: x_last_updated_by := FND_GLOBAL.USER_ID;
6877: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6878: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6879: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
6880: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
6881:
6874: -- Get the standard who information
6875: --
6876: x_last_updated_by := FND_GLOBAL.USER_ID;
6877: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6878: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6879: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
6880: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
6881:
6882: --
6875: --
6876: x_last_updated_by := FND_GLOBAL.USER_ID;
6877: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6878: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6879: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
6880: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
6881:
6882: --
6883: -- Set the compiled set to history
6876: x_last_updated_by := FND_GLOBAL.USER_ID;
6877: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6878: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6879: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
6880: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
6881:
6882: --
6883: -- Set the compiled set to history
6884: --