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: --
3975: --
3976: -- Standard who
3977: --
3978:
3979: x_created_by := FND_GLOBAL.USER_ID;
3980: x_last_updated_by := FND_GLOBAL.USER_ID;
3981: x_last_update_login := FND_GLOBAL.LOGIN_ID;
3982:
3983: SELECT cost_plus_structure_type
3976: -- Standard who
3977: --
3978:
3979: x_created_by := FND_GLOBAL.USER_ID;
3980: x_last_updated_by := FND_GLOBAL.USER_ID;
3981: x_last_update_login := FND_GLOBAL.LOGIN_ID;
3982:
3983: SELECT cost_plus_structure_type
3984: INTO structure_type
3977: --
3978:
3979: x_created_by := FND_GLOBAL.USER_ID;
3980: x_last_updated_by := FND_GLOBAL.USER_ID;
3981: x_last_update_login := FND_GLOBAL.LOGIN_ID;
3982:
3983: SELECT cost_plus_structure_type
3984: INTO structure_type
3985: FROM pa_cost_plus_structures
4188:
4189: --
4190: -- Get the standard who information
4191: --
4192: x_last_updated_by := FND_GLOBAL.USER_ID;
4193: x_last_update_login := FND_GLOBAL.LOGIN_ID;
4194: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
4195: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
4196: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
4189: --
4190: -- Get the standard who information
4191: --
4192: x_last_updated_by := FND_GLOBAL.USER_ID;
4193: x_last_update_login := FND_GLOBAL.LOGIN_ID;
4194: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
4195: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
4196: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
4197:
4190: -- Get the standard who information
4191: --
4192: x_last_updated_by := FND_GLOBAL.USER_ID;
4193: x_last_update_login := FND_GLOBAL.LOGIN_ID;
4194: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
4195: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
4196: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
4197:
4198: -- l_burden_profile := nvl(fnd_profile.value('PA_ENHANCED_BURDENING'),'N'); /*2933915 */
4191: --
4192: x_last_updated_by := FND_GLOBAL.USER_ID;
4193: x_last_update_login := FND_GLOBAL.LOGIN_ID;
4194: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
4195: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
4196: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
4197:
4198: -- l_burden_profile := nvl(fnd_profile.value('PA_ENHANCED_BURDENING'),'N'); /*2933915 */
4199: l_burden_profile := pa_utils2.IsEnhancedBurdeningEnabled;
4192: x_last_updated_by := FND_GLOBAL.USER_ID;
4193: x_last_update_login := FND_GLOBAL.LOGIN_ID;
4194: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
4195: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
4196: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
4197:
4198: -- l_burden_profile := nvl(fnd_profile.value('PA_ENHANCED_BURDENING'),'N'); /*2933915 */
4199: l_burden_profile := pa_utils2.IsEnhancedBurdeningEnabled;
4200:
5226:
5227: --
5228: -- Get the standard who information
5229: --
5230: x_last_updated_by := FND_GLOBAL.USER_ID;
5231: x_last_update_login := FND_GLOBAL.LOGIN_ID;
5232: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
5233: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
5234: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
5227: --
5228: -- Get the standard who information
5229: --
5230: x_last_updated_by := FND_GLOBAL.USER_ID;
5231: x_last_update_login := FND_GLOBAL.LOGIN_ID;
5232: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
5233: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
5234: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
5235:
5228: -- Get the standard who information
5229: --
5230: x_last_updated_by := FND_GLOBAL.USER_ID;
5231: x_last_update_login := FND_GLOBAL.LOGIN_ID;
5232: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
5233: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
5234: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
5235:
5236: -- l_burden_profile := nvl(fnd_profile.value('PA_ENHANCED_BURDENING'),'N'); /*2933915*/
5229: --
5230: x_last_updated_by := FND_GLOBAL.USER_ID;
5231: x_last_update_login := FND_GLOBAL.LOGIN_ID;
5232: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
5233: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
5234: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
5235:
5236: -- l_burden_profile := nvl(fnd_profile.value('PA_ENHANCED_BURDENING'),'N'); /*2933915*/
5237: l_burden_profile := pa_utils2.IsEnhancedBurdeningEnabled;
5230: x_last_updated_by := FND_GLOBAL.USER_ID;
5231: x_last_update_login := FND_GLOBAL.LOGIN_ID;
5232: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
5233: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
5234: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
5235:
5236: -- l_burden_profile := nvl(fnd_profile.value('PA_ENHANCED_BURDENING'),'N'); /*2933915*/
5237: l_burden_profile := pa_utils2.IsEnhancedBurdeningEnabled;
5238:
6702:
6703: --
6704: -- Get the standard who information
6705: --
6706: x_last_updated_by := FND_GLOBAL.USER_ID;
6707: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6708: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6709: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
6710: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
6703: --
6704: -- Get the standard who information
6705: --
6706: x_last_updated_by := FND_GLOBAL.USER_ID;
6707: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6708: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6709: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
6710: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
6711:
6704: -- Get the standard who information
6705: --
6706: x_last_updated_by := FND_GLOBAL.USER_ID;
6707: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6708: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6709: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
6710: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
6711:
6712: ei_count := 0;
6705: --
6706: x_last_updated_by := FND_GLOBAL.USER_ID;
6707: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6708: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6709: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
6710: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
6711:
6712: ei_count := 0;
6713: /*
6706: x_last_updated_by := FND_GLOBAL.USER_ID;
6707: x_last_update_login := FND_GLOBAL.LOGIN_ID;
6708: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
6709: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
6710: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
6711:
6712: ei_count := 0;
6713: /*
6714: IF (cost_adj_reason IS NOT NULL)
7022:
7023: --
7024: -- Get the standard who information
7025: --
7026: x_last_updated_by := FND_GLOBAL.USER_ID;
7027: x_last_update_login := FND_GLOBAL.LOGIN_ID;
7028: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
7029: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
7030: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
7023: --
7024: -- Get the standard who information
7025: --
7026: x_last_updated_by := FND_GLOBAL.USER_ID;
7027: x_last_update_login := FND_GLOBAL.LOGIN_ID;
7028: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
7029: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
7030: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
7031:
7024: -- Get the standard who information
7025: --
7026: x_last_updated_by := FND_GLOBAL.USER_ID;
7027: x_last_update_login := FND_GLOBAL.LOGIN_ID;
7028: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
7029: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
7030: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
7031:
7032: FOR org_id_rec in org_cursor /*Loop for all the children (including impacted org) of the impacted org*/
7025: --
7026: x_last_updated_by := FND_GLOBAL.USER_ID;
7027: x_last_update_login := FND_GLOBAL.LOGIN_ID;
7028: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
7029: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
7030: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
7031:
7032: FOR org_id_rec in org_cursor /*Loop for all the children (including impacted org) of the impacted org*/
7033: LOOP
7026: x_last_updated_by := FND_GLOBAL.USER_ID;
7027: x_last_update_login := FND_GLOBAL.LOGIN_ID;
7028: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
7029: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
7030: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
7031:
7032: FOR org_id_rec in org_cursor /*Loop for all the children (including impacted org) of the impacted org*/
7033: LOOP
7034:
7099:
7100: --
7101: -- Get the standard who information
7102: --
7103: x_last_updated_by := FND_GLOBAL.USER_ID;
7104: x_last_update_login := FND_GLOBAL.LOGIN_ID;
7105: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
7106: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
7107: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
7100: --
7101: -- Get the standard who information
7102: --
7103: x_last_updated_by := FND_GLOBAL.USER_ID;
7104: x_last_update_login := FND_GLOBAL.LOGIN_ID;
7105: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
7106: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
7107: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
7108:
7101: -- Get the standard who information
7102: --
7103: x_last_updated_by := FND_GLOBAL.USER_ID;
7104: x_last_update_login := FND_GLOBAL.LOGIN_ID;
7105: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
7106: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
7107: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
7108:
7109: --
7102: --
7103: x_last_updated_by := FND_GLOBAL.USER_ID;
7104: x_last_update_login := FND_GLOBAL.LOGIN_ID;
7105: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
7106: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
7107: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
7108:
7109: --
7110: -- Set the compiled set to history
7103: x_last_updated_by := FND_GLOBAL.USER_ID;
7104: x_last_update_login := FND_GLOBAL.LOGIN_ID;
7105: x_request_id := FND_GLOBAL.CONC_REQUEST_ID;
7106: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
7107: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
7108:
7109: --
7110: -- Set the compiled set to history
7111: --