APPS.JG_ZZ_VAT_REP_FINAL_REPORTING dependencies on JG_ZZ_VAT_REP_STATUS

Line 37: ln_reporting_status_id_ap jg_zz_vat_rep_status.reporting_status_id%type;

33: pv_source in varchar2
34: )
35: is
36:
37: ln_reporting_status_id_ap jg_zz_vat_rep_status.reporting_status_id%type;
38: ln_reporting_status_id_ar jg_zz_vat_rep_status.reporting_status_id%type;
39: ln_reporting_status_id_gl jg_zz_vat_rep_status.reporting_status_id%type;
40: lv_return_status varchar2(1);
41: lv_return_message varchar2(254);

Line 38: ln_reporting_status_id_ar jg_zz_vat_rep_status.reporting_status_id%type;

34: )
35: is
36:
37: ln_reporting_status_id_ap jg_zz_vat_rep_status.reporting_status_id%type;
38: ln_reporting_status_id_ar jg_zz_vat_rep_status.reporting_status_id%type;
39: ln_reporting_status_id_gl jg_zz_vat_rep_status.reporting_status_id%type;
40: lv_return_status varchar2(1);
41: lv_return_message varchar2(254);
42: ln_final_reporting_id number;

Line 39: ln_reporting_status_id_gl jg_zz_vat_rep_status.reporting_status_id%type;

35: is
36:
37: ln_reporting_status_id_ap jg_zz_vat_rep_status.reporting_status_id%type;
38: ln_reporting_status_id_ar jg_zz_vat_rep_status.reporting_status_id%type;
39: ln_reporting_status_id_gl jg_zz_vat_rep_status.reporting_status_id%type;
40: lv_return_status varchar2(1);
41: lv_return_message varchar2(254);
42: ln_final_reporting_id number;
43: lv_enable_allocations_flag jg_zz_vat_rep_entities.enable_allocations_flag%type;

Line 73: from jg_zz_vat_rep_status

69: where
70: reporting_status_id in
71: (
72: select reporting_status_id
73: from jg_zz_vat_rep_status
74: Where vat_reporting_entity_id = cpn_vat_reporting_entity_id
75: and tax_calendar_period = cpv_tax_calendar_period
76: and ( (cpv_source = 'ALL') OR (cpv_source <> 'ALL' and source = cpv_source) )
77: );

Line 87: Select jg_zz_vat_rep_status_s3.nextval

83: from jg_zz_vat_rep_entities
84: where vat_reporting_entity_id = pn_vat_reporting_entity_id;
85:
86: cursor c_get_final_reporting_id is
87: Select jg_zz_vat_rep_status_s3.nextval
88: From dual;
89:
90:
91: cur_rec_jg_zz_vat_rep_entities c_jg_zz_vat_rep_entities%rowtype;

Line 95: FROM JG_ZZ_VAT_REP_STATUS RPS

91: cur_rec_jg_zz_vat_rep_entities c_jg_zz_vat_rep_entities%rowtype;
92:
93: CURSOR c_get_last_rep_period_status (pn_vat_reporting_entity_id number,pn_period varchar2) is
94: SELECT 'Y'
95: FROM JG_ZZ_VAT_REP_STATUS RPS
96: WHERE RPS.VAT_REPORTING_ENTITY_ID= pn_vat_reporting_entity_id
97: AND RPS.TAX_CALENDAR_PERIOD = pn_period
98: AND RPS.period_start_date >
99: NVL((SELECT glp.end_date

Line 226: from jg_zz_vat_rep_status

222: last_update_login = fnd_global.login_id
223: where reporting_status_id in
224: (
225: select reporting_status_id
226: from jg_zz_vat_rep_status
227: Where vat_reporting_entity_id = pn_vat_reporting_entity_id
228: and tax_calendar_period = pv_tax_calendar_period
229: and ( (pv_source = 'ALL') OR (pv_source <> 'ALL' and source = pv_source) )
230: );