APPS.FF_DATA_DICT dependencies on FF_QP_REPORTS

Line 3674: -- INSTALLATION PROCEDURE FOR : FF_QP_REPORTS

3670:
3671: END install_functions;
3672:
3673: --****************************************************************************
3674: -- INSTALLATION PROCEDURE FOR : FF_QP_REPORTS
3675: --****************************************************************************
3676:
3677: PROCEDURE install_qpreports(p_phase IN number)
3678: ----------------------------------------------

Line 3725: hr_legislation.insert_hr_stu_exceptions('ff_qp_reports'

3721:
3722:
3723: rollback to new_qp_report_name;
3724:
3725: hr_legislation.insert_hr_stu_exceptions('ff_qp_reports'
3726: , stu_rec.c_surrogate_key
3727: , exception_type
3728: , stu_rec.c_true_key);
3729:

Line 3766: from ff_qp_reports a

3762:
3763:
3764: select distinct null
3765: into l_null_return
3766: from ff_qp_reports a
3767: where exists
3768: (select null
3769: from hr_s_qp_reports b
3770: where a.qp_report_id = b.qp_report_id

Line 3794: select ff_qp_reports_s.nextval

3790: into v_min_delivered
3791: , v_max_delivered
3792: from hr_s_qp_reports;
3793:
3794: select ff_qp_reports_s.nextval
3795: into v_sequence_number
3796: from dual;
3797:
3798: IF v_sequence_number

Line 3801: hr_legislation.munge_sequence('FF_QP_REPORTS_S',

3797:
3798: IF v_sequence_number
3799: BETWEEN v_min_delivered AND v_max_delivered THEN
3800:
3801: hr_legislation.munge_sequence('FF_QP_REPORTS_S',
3802: v_sequence_number,
3803: v_max_delivered);
3804:
3805: END IF;

Line 3821: from ff_qp_reports

3817: BEGIN
3818:
3819: select distinct qp_report_id
3820: into l_new_surrogate_key
3821: from ff_qp_reports
3822: where qp_report_name = stu_rec.c_true_key
3823: and business_group_id is null
3824: and ( (legislation_code is null and stu_rec.c_leg_code is null)
3825: or (legislation_code = stu_rec.c_leg_code) );

Line 3829: select ff_qp_reports_s.nextval

3825: or (legislation_code = stu_rec.c_leg_code) );
3826:
3827: EXCEPTION WHEN NO_DATA_FOUND THEN
3828:
3829: select ff_qp_reports_s.nextval
3830: into l_new_surrogate_key
3831: from dual;
3832:
3833: END;

Line 4068: from ff_qp_reports a

4064: -- created by a user.
4065:
4066: select distinct null
4067: into l_null_return
4068: from ff_qp_reports a
4069: where a.qp_report_name = stu_rec.c_true_key
4070: and a.business_group_id is not null
4071: and exists (select null from per_business_groups b
4072: where b.business_group_id = a.business_group_id

Line 4098: from ff_qp_reports

4094: BEGIN
4095:
4096: select distinct null
4097: into l_null_return
4098: from ff_qp_reports
4099: where qp_report_name = stu_rec.c_true_key
4100: and nvl(legislation_code,'X') <> nvl(stu_rec.c_leg_code,'X')
4101: and (legislation_code is null
4102: or stu_rec.c_leg_code is null );

Line 4151: update ff_qp_reports

4147: return;
4148: END IF;
4149:
4150:
4151: update ff_qp_reports
4152: set formula_id = stu_rec.formula_id
4153: , formula_type_id = stu_rec.formula_type_id
4154: , qp_report_name = to_char(stu_rec.c_surrogate_key)
4155: , business_group_id = null

Line 4170: insert into ff_qp_reports

4166:
4167: IF NOT SQL%FOUND THEN
4168:
4169:
4170: insert into ff_qp_reports
4171: (qp_report_id
4172: ,formula_id
4173: ,formula_type_id
4174: ,qp_report_name