APPS.JAI_AP_TDS_PROCESSING_PKG dependencies on JAI_AP_TDS_F16_HDRS_ALL

Line 1402: select jai_ap_tds_f16_hdrs_all_s.nextval from dual;

1398: from jai_ap_tds_thhold_trxs
1399: where threshold_trx_id = cp_threshold_trx_id;
1400:
1401: cursor c_get_form16_hdr_id is
1402: select jai_ap_tds_f16_hdrs_all_s.nextval from dual;
1403: /*bduvarag for Bug#5647725*/
1404: CURSOR cur_get_tds_section IS
1405: SELECT decode(p_section_type,'TDS_SECTION','TDS','WCT_SECTION','WCT','ESSI_SECTION','ESI')
1406: FROM dual;

Line 1732: /* insert into jai_ap_tds_f16_hdrs_all */

1728: and regime_code = lv_tds_section/*bduvarag for Bug#5647725*/ /*CSahoo for BUG#5631784*/
1729: ;
1730: end if;
1731:
1732: /* insert into jai_ap_tds_f16_hdrs_all */
1733: IF lv_tds_section = 'TDS' THEN/*bduvarag for Bug#5647725*/
1734: Fnd_File.put_line(Fnd_File.LOG, 'Inserting record in jai_ap_tds_f16_hdrs_all with form16_hdr_id : ' || to_char(ln_form16_hdr_id));
1735: insert into jai_ap_tds_f16_hdrs_all
1736: (

Line 1734: Fnd_File.put_line(Fnd_File.LOG, 'Inserting record in jai_ap_tds_f16_hdrs_all with form16_hdr_id : ' || to_char(ln_form16_hdr_id));

1730: end if;
1731:
1732: /* insert into jai_ap_tds_f16_hdrs_all */
1733: IF lv_tds_section = 'TDS' THEN/*bduvarag for Bug#5647725*/
1734: Fnd_File.put_line(Fnd_File.LOG, 'Inserting record in jai_ap_tds_f16_hdrs_all with form16_hdr_id : ' || to_char(ln_form16_hdr_id));
1735: insert into jai_ap_tds_f16_hdrs_all
1736: (
1737: form16_hdr_id ,
1738: fin_yr ,

Line 1735: insert into jai_ap_tds_f16_hdrs_all

1731:
1732: /* insert into jai_ap_tds_f16_hdrs_all */
1733: IF lv_tds_section = 'TDS' THEN/*bduvarag for Bug#5647725*/
1734: Fnd_File.put_line(Fnd_File.LOG, 'Inserting record in jai_ap_tds_f16_hdrs_all with form16_hdr_id : ' || to_char(ln_form16_hdr_id));
1735: insert into jai_ap_tds_f16_hdrs_all
1736: (
1737: form16_hdr_id ,
1738: fin_yr ,
1739: org_tan_num ,