3343: g_orig_org_id_fnl_tbl(l_atgrp_final_index) := g_orig_org_id_tmp_tbl(grp_no_index);
3344: g_global_flag_fnl_tbl(l_atgrp_final_index) := g_global_flag_tmp_tbl(grp_no_index);
3345: ELSE
3346: g_creation_date_final_tbl(l_atgrp_final_index) := sysdate;
3347: g_created_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
3348:
3349: END IF;
3350:
3351: ---------------- Added for PL/SQL Pattern Search
3349: END IF;
3350:
3351: ---------------- Added for PL/SQL Pattern Search
3352: g_last_update_date_final_tbl(l_atgrp_final_index) := sysdate;
3353: g_last_updated_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
3354: g_last_update_login_final_tbl(l_atgrp_final_index) := FND_GLOBAL.LOGIN_ID;
3355: g_program_appl_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.PROG_APPL_ID;
3356: g_program_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
3357: g_program_upd_date_final_tbl(l_atgrp_final_index) := sysdate;
3350:
3351: ---------------- Added for PL/SQL Pattern Search
3352: g_last_update_date_final_tbl(l_atgrp_final_index) := sysdate;
3353: g_last_updated_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
3354: g_last_update_login_final_tbl(l_atgrp_final_index) := FND_GLOBAL.LOGIN_ID;
3355: g_program_appl_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.PROG_APPL_ID;
3356: g_program_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
3357: g_program_upd_date_final_tbl(l_atgrp_final_index) := sysdate;
3358: g_request_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_REQUEST_ID;
3351: ---------------- Added for PL/SQL Pattern Search
3352: g_last_update_date_final_tbl(l_atgrp_final_index) := sysdate;
3353: g_last_updated_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
3354: g_last_update_login_final_tbl(l_atgrp_final_index) := FND_GLOBAL.LOGIN_ID;
3355: g_program_appl_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.PROG_APPL_ID;
3356: g_program_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
3357: g_program_upd_date_final_tbl(l_atgrp_final_index) := sysdate;
3358: g_request_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_REQUEST_ID;
3359: end if; -- l_other_grp_exists = 'Y' and grp_no_index = -1
3352: g_last_update_date_final_tbl(l_atgrp_final_index) := sysdate;
3353: g_last_updated_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;
3354: g_last_update_login_final_tbl(l_atgrp_final_index) := FND_GLOBAL.LOGIN_ID;
3355: g_program_appl_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.PROG_APPL_ID;
3356: g_program_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
3357: g_program_upd_date_final_tbl(l_atgrp_final_index) := sysdate;
3358: g_request_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_REQUEST_ID;
3359: end if; -- l_other_grp_exists = 'Y' and grp_no_index = -1
3360:
3354: g_last_update_login_final_tbl(l_atgrp_final_index) := FND_GLOBAL.LOGIN_ID;
3355: g_program_appl_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.PROG_APPL_ID;
3356: g_program_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
3357: g_program_upd_date_final_tbl(l_atgrp_final_index) := sysdate;
3358: g_request_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_REQUEST_ID;
3359: end if; -- l_other_grp_exists = 'Y' and grp_no_index = -1
3360:
3361: grp_no_index := g_qual_grouping_no_tmp_tbl.next(grp_no_index);
3362:
3915: g_pattern_pat_type_final_tbl(l_pattern_final_index) := p_pattern_type;
3916: g_pattern_pat_string_final_tbl(l_pattern_final_index) := p_pat_string;
3917:
3918: g_pattern_cr_dt_final_tbl(l_pattern_final_index) := sysdate;
3919: g_pattern_cr_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
3920: g_pattern_lst_up_dt_final_tbl(l_pattern_final_index) := sysdate;
3921: g_pattern_lt_up_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
3922: g_pattern_lt_up_lg_final_tbl(l_pattern_final_index) := FND_GLOBAL.LOGIN_ID;
3923: g_pattern_pr_ap_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.PROG_APPL_ID;
3917:
3918: g_pattern_cr_dt_final_tbl(l_pattern_final_index) := sysdate;
3919: g_pattern_cr_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
3920: g_pattern_lst_up_dt_final_tbl(l_pattern_final_index) := sysdate;
3921: g_pattern_lt_up_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
3922: g_pattern_lt_up_lg_final_tbl(l_pattern_final_index) := FND_GLOBAL.LOGIN_ID;
3923: g_pattern_pr_ap_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.PROG_APPL_ID;
3924: g_pattern_pr_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
3925: g_pattern_pr_up_dt_final_tbl(l_pattern_final_index) := sysdate;
3918: g_pattern_cr_dt_final_tbl(l_pattern_final_index) := sysdate;
3919: g_pattern_cr_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
3920: g_pattern_lst_up_dt_final_tbl(l_pattern_final_index) := sysdate;
3921: g_pattern_lt_up_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
3922: g_pattern_lt_up_lg_final_tbl(l_pattern_final_index) := FND_GLOBAL.LOGIN_ID;
3923: g_pattern_pr_ap_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.PROG_APPL_ID;
3924: g_pattern_pr_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
3925: g_pattern_pr_up_dt_final_tbl(l_pattern_final_index) := sysdate;
3926: g_pattern_req_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_REQUEST_ID;
3919: g_pattern_cr_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
3920: g_pattern_lst_up_dt_final_tbl(l_pattern_final_index) := sysdate;
3921: g_pattern_lt_up_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
3922: g_pattern_lt_up_lg_final_tbl(l_pattern_final_index) := FND_GLOBAL.LOGIN_ID;
3923: g_pattern_pr_ap_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.PROG_APPL_ID;
3924: g_pattern_pr_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
3925: g_pattern_pr_up_dt_final_tbl(l_pattern_final_index) := sysdate;
3926: g_pattern_req_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_REQUEST_ID;
3927: end if;
3920: g_pattern_lst_up_dt_final_tbl(l_pattern_final_index) := sysdate;
3921: g_pattern_lt_up_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;
3922: g_pattern_lt_up_lg_final_tbl(l_pattern_final_index) := FND_GLOBAL.LOGIN_ID;
3923: g_pattern_pr_ap_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.PROG_APPL_ID;
3924: g_pattern_pr_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
3925: g_pattern_pr_up_dt_final_tbl(l_pattern_final_index) := sysdate;
3926: g_pattern_req_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_REQUEST_ID;
3927: end if;
3928: end loop; --k in 1..g_pattern_grouping_no_tmp_tbl.count
3922: g_pattern_lt_up_lg_final_tbl(l_pattern_final_index) := FND_GLOBAL.LOGIN_ID;
3923: g_pattern_pr_ap_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.PROG_APPL_ID;
3924: g_pattern_pr_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;
3925: g_pattern_pr_up_dt_final_tbl(l_pattern_final_index) := sysdate;
3926: g_pattern_req_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_REQUEST_ID;
3927: end if;
3928: end loop; --k in 1..g_pattern_grouping_no_tmp_tbl.count
3929: populate_patterns;
3930: end if; -- l_pattern_to_be_created = 'Y'
4134: VALUES
4135: (p_pattern_id,
4136: j.pricing_phase_id,
4137: sysdate,
4138: FND_GLOBAL.USER_ID,
4139: sysdate,
4140: FND_GLOBAL.USER_ID,
4141: FND_GLOBAL.LOGIN_ID,
4142: FND_GLOBAL.PROG_APPL_ID,
4136: j.pricing_phase_id,
4137: sysdate,
4138: FND_GLOBAL.USER_ID,
4139: sysdate,
4140: FND_GLOBAL.USER_ID,
4141: FND_GLOBAL.LOGIN_ID,
4142: FND_GLOBAL.PROG_APPL_ID,
4143: FND_GLOBAL.CONC_PROGRAM_ID,
4144: sysdate,
4137: sysdate,
4138: FND_GLOBAL.USER_ID,
4139: sysdate,
4140: FND_GLOBAL.USER_ID,
4141: FND_GLOBAL.LOGIN_ID,
4142: FND_GLOBAL.PROG_APPL_ID,
4143: FND_GLOBAL.CONC_PROGRAM_ID,
4144: sysdate,
4145: FND_GLOBAL.CONC_REQUEST_ID
4138: FND_GLOBAL.USER_ID,
4139: sysdate,
4140: FND_GLOBAL.USER_ID,
4141: FND_GLOBAL.LOGIN_ID,
4142: FND_GLOBAL.PROG_APPL_ID,
4143: FND_GLOBAL.CONC_PROGRAM_ID,
4144: sysdate,
4145: FND_GLOBAL.CONC_REQUEST_ID
4146: );
4139: sysdate,
4140: FND_GLOBAL.USER_ID,
4141: FND_GLOBAL.LOGIN_ID,
4142: FND_GLOBAL.PROG_APPL_ID,
4143: FND_GLOBAL.CONC_PROGRAM_ID,
4144: sysdate,
4145: FND_GLOBAL.CONC_REQUEST_ID
4146: );
4147:
4141: FND_GLOBAL.LOGIN_ID,
4142: FND_GLOBAL.PROG_APPL_ID,
4143: FND_GLOBAL.CONC_PROGRAM_ID,
4144: sysdate,
4145: FND_GLOBAL.CONC_REQUEST_ID
4146: );
4147:
4148: if g_call_from_setup <> 'Y' then
4149: commit;
4185: VALUES
4186: (p_pattern_id,
4187: 1,
4188: sysdate,
4189: FND_GLOBAL.USER_ID,
4190: sysdate,
4191: FND_GLOBAL.USER_ID,
4192: FND_GLOBAL.LOGIN_ID,
4193: FND_GLOBAL.PROG_APPL_ID,
4187: 1,
4188: sysdate,
4189: FND_GLOBAL.USER_ID,
4190: sysdate,
4191: FND_GLOBAL.USER_ID,
4192: FND_GLOBAL.LOGIN_ID,
4193: FND_GLOBAL.PROG_APPL_ID,
4194: FND_GLOBAL.CONC_PROGRAM_ID,
4195: sysdate,
4188: sysdate,
4189: FND_GLOBAL.USER_ID,
4190: sysdate,
4191: FND_GLOBAL.USER_ID,
4192: FND_GLOBAL.LOGIN_ID,
4193: FND_GLOBAL.PROG_APPL_ID,
4194: FND_GLOBAL.CONC_PROGRAM_ID,
4195: sysdate,
4196: FND_GLOBAL.CONC_REQUEST_ID
4189: FND_GLOBAL.USER_ID,
4190: sysdate,
4191: FND_GLOBAL.USER_ID,
4192: FND_GLOBAL.LOGIN_ID,
4193: FND_GLOBAL.PROG_APPL_ID,
4194: FND_GLOBAL.CONC_PROGRAM_ID,
4195: sysdate,
4196: FND_GLOBAL.CONC_REQUEST_ID
4197: );
4190: sysdate,
4191: FND_GLOBAL.USER_ID,
4192: FND_GLOBAL.LOGIN_ID,
4193: FND_GLOBAL.PROG_APPL_ID,
4194: FND_GLOBAL.CONC_PROGRAM_ID,
4195: sysdate,
4196: FND_GLOBAL.CONC_REQUEST_ID
4197: );
4198:
4192: FND_GLOBAL.LOGIN_ID,
4193: FND_GLOBAL.PROG_APPL_ID,
4194: FND_GLOBAL.CONC_PROGRAM_ID,
4195: sysdate,
4196: FND_GLOBAL.CONC_REQUEST_ID
4197: );
4198:
4199: if g_call_from_setup <> 'Y' then
4200: commit;
4245: VALUES
4246: (p_pattern_id,
4247: p_pricing_phase_id,
4248: sysdate,
4249: FND_GLOBAL.USER_ID,
4250: sysdate,
4251: FND_GLOBAL.USER_ID,
4252: FND_GLOBAL.LOGIN_ID,
4253: FND_GLOBAL.PROG_APPL_ID,
4247: p_pricing_phase_id,
4248: sysdate,
4249: FND_GLOBAL.USER_ID,
4250: sysdate,
4251: FND_GLOBAL.USER_ID,
4252: FND_GLOBAL.LOGIN_ID,
4253: FND_GLOBAL.PROG_APPL_ID,
4254: FND_GLOBAL.CONC_PROGRAM_ID,
4255: sysdate,
4248: sysdate,
4249: FND_GLOBAL.USER_ID,
4250: sysdate,
4251: FND_GLOBAL.USER_ID,
4252: FND_GLOBAL.LOGIN_ID,
4253: FND_GLOBAL.PROG_APPL_ID,
4254: FND_GLOBAL.CONC_PROGRAM_ID,
4255: sysdate,
4256: FND_GLOBAL.CONC_REQUEST_ID
4249: FND_GLOBAL.USER_ID,
4250: sysdate,
4251: FND_GLOBAL.USER_ID,
4252: FND_GLOBAL.LOGIN_ID,
4253: FND_GLOBAL.PROG_APPL_ID,
4254: FND_GLOBAL.CONC_PROGRAM_ID,
4255: sysdate,
4256: FND_GLOBAL.CONC_REQUEST_ID
4257: );
4250: sysdate,
4251: FND_GLOBAL.USER_ID,
4252: FND_GLOBAL.LOGIN_ID,
4253: FND_GLOBAL.PROG_APPL_ID,
4254: FND_GLOBAL.CONC_PROGRAM_ID,
4255: sysdate,
4256: FND_GLOBAL.CONC_REQUEST_ID
4257: );
4258:
4252: FND_GLOBAL.LOGIN_ID,
4253: FND_GLOBAL.PROG_APPL_ID,
4254: FND_GLOBAL.CONC_PROGRAM_ID,
4255: sysdate,
4256: FND_GLOBAL.CONC_REQUEST_ID
4257: );
4258:
4259: if g_call_from_setup <> 'Y' then
4260: commit;