APPS.IGF_GR_GEN_XML dependencies on IGF_GR_RFMS

Line 22: p_base_id IN IGF_GR_RFMS_ALL.BASE_ID%TYPE,

18: p_report_entity_id IN VARCHAR2,
19: p_rep_dummy IN VARCHAR2,
20: p_attend_entity_id IN VARCHAR2,
21: p_atd_dummy IN VARCHAR2,
22: p_base_id IN IGF_GR_RFMS_ALL.BASE_ID%TYPE,
23: p_per_dummy IN NUMBER,
24: p_persid_grp IN NUMBER
25: );
26:

Line 39: CURSOR cur_rfms ( cp_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,

35: p_document_id VARCHAR2);
36:
37: PROCEDURE set_nls_fmt(PARAM in VARCHAR2);
38:
39: CURSOR cur_rfms ( cp_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
40: cp_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE,
41: cp_rep_entity_id_txt igf_gr_rfms.rep_entity_id_txt%TYPE,
42: cp_atd_entity_id_txt igf_gr_rfms.atd_entity_id_txt%TYPE,
43: cp_base_id igf_gr_rfms.base_id%TYPE

Line 40: cp_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE,

36:
37: PROCEDURE set_nls_fmt(PARAM in VARCHAR2);
38:
39: CURSOR cur_rfms ( cp_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
40: cp_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE,
41: cp_rep_entity_id_txt igf_gr_rfms.rep_entity_id_txt%TYPE,
42: cp_atd_entity_id_txt igf_gr_rfms.atd_entity_id_txt%TYPE,
43: cp_base_id igf_gr_rfms.base_id%TYPE
44: ) IS

Line 41: cp_rep_entity_id_txt igf_gr_rfms.rep_entity_id_txt%TYPE,

37: PROCEDURE set_nls_fmt(PARAM in VARCHAR2);
38:
39: CURSOR cur_rfms ( cp_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
40: cp_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE,
41: cp_rep_entity_id_txt igf_gr_rfms.rep_entity_id_txt%TYPE,
42: cp_atd_entity_id_txt igf_gr_rfms.atd_entity_id_txt%TYPE,
43: cp_base_id igf_gr_rfms.base_id%TYPE
44: ) IS
45: SELECT rfms.*

Line 42: cp_atd_entity_id_txt igf_gr_rfms.atd_entity_id_txt%TYPE,

38:
39: CURSOR cur_rfms ( cp_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
40: cp_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE,
41: cp_rep_entity_id_txt igf_gr_rfms.rep_entity_id_txt%TYPE,
42: cp_atd_entity_id_txt igf_gr_rfms.atd_entity_id_txt%TYPE,
43: cp_base_id igf_gr_rfms.base_id%TYPE
44: ) IS
45: SELECT rfms.*
46: FROM IGF_GR_RFMS RFMS

Line 43: cp_base_id igf_gr_rfms.base_id%TYPE

39: CURSOR cur_rfms ( cp_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
40: cp_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE,
41: cp_rep_entity_id_txt igf_gr_rfms.rep_entity_id_txt%TYPE,
42: cp_atd_entity_id_txt igf_gr_rfms.atd_entity_id_txt%TYPE,
43: cp_base_id igf_gr_rfms.base_id%TYPE
44: ) IS
45: SELECT rfms.*
46: FROM IGF_GR_RFMS RFMS
47: WHERE rfms.ci_cal_type = cp_ci_cal_type

Line 46: FROM IGF_GR_RFMS RFMS

42: cp_atd_entity_id_txt igf_gr_rfms.atd_entity_id_txt%TYPE,
43: cp_base_id igf_gr_rfms.base_id%TYPE
44: ) IS
45: SELECT rfms.*
46: FROM IGF_GR_RFMS RFMS
47: WHERE rfms.ci_cal_type = cp_ci_cal_type
48: AND rfms.ci_sequence_number = cp_ci_sequence_number
49: AND NVL(rfms.rep_entity_id_txt, '-1') = NVL(cp_rep_entity_id_txt, NVL(rfms.rep_entity_id_txt, '-1'))
50: AND NVL(rfms.atd_entity_id_txt, '-1') = NVL(cp_atd_entity_id_txt, NVL(rfms.atd_entity_id_txt, '-1'))