DBA Data[Home] [Help]

APPS.QP_PS_ATTR_GRP_PVT dependencies on FND_GLOBAL

Line 3347: g_created_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;

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

Line 3353: g_last_updated_by_final_tbl(l_atgrp_final_index) := FND_GLOBAL.USER_ID;

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;

Line 3354: g_last_update_login_final_tbl(l_atgrp_final_index) := FND_GLOBAL.LOGIN_ID;

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;

Line 3355: g_program_appl_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.PROG_APPL_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

Line 3356: g_program_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_PROGRAM_ID;

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:

Line 3358: g_request_id_final_tbl(l_atgrp_final_index) := FND_GLOBAL.CONC_REQUEST_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:
3361: grp_no_index := g_qual_grouping_no_tmp_tbl.next(grp_no_index);
3362:

Line 3919: g_pattern_cr_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_ID;

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;

Line 3921: g_pattern_lt_up_by_final_tbl(l_pattern_final_index) := FND_GLOBAL.USER_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;

Line 3922: g_pattern_lt_up_lg_final_tbl(l_pattern_final_index) := FND_GLOBAL.LOGIN_ID;

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;

Line 3923: g_pattern_pr_ap_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.PROG_APPL_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;

Line 3924: g_pattern_pr_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_PROGRAM_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;
3928: end loop; --k in 1..g_pattern_grouping_no_tmp_tbl.count

Line 3926: g_pattern_req_id_final_tbl(l_pattern_final_index) := FND_GLOBAL.CONC_REQUEST_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
3929: populate_patterns;
3930: end if; -- l_pattern_to_be_created = 'Y'

Line 4138: FND_GLOBAL.USER_ID,

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,

Line 4140: FND_GLOBAL.USER_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,

Line 4141: FND_GLOBAL.LOGIN_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,
4145: FND_GLOBAL.CONC_REQUEST_ID

Line 4142: FND_GLOBAL.PROG_APPL_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: );

Line 4143: FND_GLOBAL.CONC_PROGRAM_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: );
4147:

Line 4145: FND_GLOBAL.CONC_REQUEST_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:
4148: if g_call_from_setup <> 'Y' then
4149: commit;

Line 4189: FND_GLOBAL.USER_ID,

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,

Line 4191: FND_GLOBAL.USER_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,

Line 4192: FND_GLOBAL.LOGIN_ID,

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

Line 4193: FND_GLOBAL.PROG_APPL_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: );

Line 4194: FND_GLOBAL.CONC_PROGRAM_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: );
4198:

Line 4196: FND_GLOBAL.CONC_REQUEST_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:
4199: if g_call_from_setup <> 'Y' then
4200: commit;

Line 4249: FND_GLOBAL.USER_ID,

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,

Line 4251: FND_GLOBAL.USER_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,

Line 4252: FND_GLOBAL.LOGIN_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,
4256: FND_GLOBAL.CONC_REQUEST_ID

Line 4253: FND_GLOBAL.PROG_APPL_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: );

Line 4254: FND_GLOBAL.CONC_PROGRAM_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: );
4258:

Line 4256: FND_GLOBAL.CONC_REQUEST_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:
4259: if g_call_from_setup <> 'Y' then
4260: commit;