APPS.JAI_AP_TDS_PROCESSING_PKG dependencies on JAI_AP_TDS_F16_HDRS_ALL

Line 1386: select jai_ap_tds_f16_hdrs_all_s.nextval from dual;

1382: from jai_ap_tds_thhold_trxs
1383: where threshold_trx_id = cp_threshold_trx_id;
1384:
1385: cursor c_get_form16_hdr_id is
1386: select jai_ap_tds_f16_hdrs_all_s.nextval from dual;
1387: /*bduvarag for Bug#5647725*/
1388: CURSOR cur_get_tds_section IS
1389: SELECT decode(p_section_type,'TDS_SECTION','TDS','WCT_SECTION','WCT','ESSI_SECTION','ESI')
1390: FROM dual;

Line 1667: /* insert into jai_ap_tds_f16_hdrs_all */

1663: and regime_code = lv_tds_section/*bduvarag for Bug#5647725*/ /*CSahoo for BUG#5631784*/
1664: ;
1665: end if;
1666:
1667: /* insert into jai_ap_tds_f16_hdrs_all */
1668: IF lv_tds_section = 'TDS' THEN/*bduvarag for Bug#5647725*/
1669: 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));
1670: insert into jai_ap_tds_f16_hdrs_all
1671: (

Line 1669: 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));

1665: end if;
1666:
1667: /* insert into jai_ap_tds_f16_hdrs_all */
1668: IF lv_tds_section = 'TDS' THEN/*bduvarag for Bug#5647725*/
1669: 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));
1670: insert into jai_ap_tds_f16_hdrs_all
1671: (
1672: form16_hdr_id ,
1673: fin_yr ,

Line 1670: insert into jai_ap_tds_f16_hdrs_all

1666:
1667: /* insert into jai_ap_tds_f16_hdrs_all */
1668: IF lv_tds_section = 'TDS' THEN/*bduvarag for Bug#5647725*/
1669: 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));
1670: insert into jai_ap_tds_f16_hdrs_all
1671: (
1672: form16_hdr_id ,
1673: fin_yr ,
1674: org_tan_num ,