APPS.FF_DATA_DICT dependencies on FF_QP_REPORTS

Line 3725: -- INSTALLATION PROCEDURE FOR : FF_QP_REPORTS

3721:
3722: END install_functions;
3723:
3724: --****************************************************************************
3725: -- INSTALLATION PROCEDURE FOR : FF_QP_REPORTS
3726: --****************************************************************************
3727:
3728: PROCEDURE install_qpreports(p_phase IN number)
3729: ----------------------------------------------

Line 3776: hr_legislation.insert_hr_stu_exceptions('ff_qp_reports'

3772:
3773:
3774: rollback to new_qp_report_name;
3775:
3776: hr_legislation.insert_hr_stu_exceptions('ff_qp_reports'
3777: , stu_rec.c_surrogate_key
3778: , exception_type
3779: , stu_rec.c_true_key);
3780:

Line 3817: from ff_qp_reports a

3813:
3814:
3815: select distinct null
3816: into l_null_return
3817: from ff_qp_reports a
3818: where exists
3819: (select null
3820: from hr_s_qp_reports b
3821: where a.qp_report_id = b.qp_report_id

Line 3845: select ff_qp_reports_s.nextval

3841: into v_min_delivered
3842: , v_max_delivered
3843: from hr_s_qp_reports;
3844:
3845: select ff_qp_reports_s.nextval
3846: into v_sequence_number
3847: from dual;
3848:
3849: IF v_sequence_number

Line 3852: hr_legislation.munge_sequence('FF_QP_REPORTS_S',

3848:
3849: IF v_sequence_number
3850: BETWEEN v_min_delivered AND v_max_delivered THEN
3851:
3852: hr_legislation.munge_sequence('FF_QP_REPORTS_S',
3853: v_sequence_number,
3854: v_max_delivered);
3855:
3856: END IF;

Line 3872: from ff_qp_reports

3868: BEGIN
3869:
3870: select distinct qp_report_id
3871: into l_new_surrogate_key
3872: from ff_qp_reports
3873: where qp_report_name = stu_rec.c_true_key
3874: and business_group_id is null
3875: and ( (legislation_code is null and stu_rec.c_leg_code is null)
3876: or (legislation_code = stu_rec.c_leg_code) );

Line 3880: select ff_qp_reports_s.nextval

3876: or (legislation_code = stu_rec.c_leg_code) );
3877:
3878: EXCEPTION WHEN NO_DATA_FOUND THEN
3879:
3880: select ff_qp_reports_s.nextval
3881: into l_new_surrogate_key
3882: from dual;
3883:
3884: END;

Line 4119: from ff_qp_reports a

4115: -- created by a user.
4116:
4117: select distinct null
4118: into l_null_return
4119: from ff_qp_reports a
4120: where a.qp_report_name = stu_rec.c_true_key
4121: and a.business_group_id is not null
4122: and exists (select null from per_business_groups b
4123: where b.business_group_id = a.business_group_id

Line 4149: from ff_qp_reports

4145: BEGIN
4146:
4147: select distinct null
4148: into l_null_return
4149: from ff_qp_reports
4150: where qp_report_name = stu_rec.c_true_key
4151: and nvl(legislation_code,'X') <> nvl(stu_rec.c_leg_code,'X')
4152: and (legislation_code is null
4153: or stu_rec.c_leg_code is null );

Line 4202: update ff_qp_reports

4198: return;
4199: END IF;
4200:
4201:
4202: update ff_qp_reports
4203: set formula_id = stu_rec.formula_id
4204: , formula_type_id = stu_rec.formula_type_id
4205: , qp_report_name = to_char(stu_rec.c_surrogate_key)
4206: , business_group_id = null

Line 4221: insert into ff_qp_reports

4217:
4218: IF NOT SQL%FOUND THEN
4219:
4220:
4221: insert into ff_qp_reports
4222: (qp_report_id
4223: ,formula_id
4224: ,formula_type_id
4225: ,qp_report_name