eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AP_TDS_OLD_PKG dependencies on AP_INVOICES_INTERFACE_S

Line 221: lv_source ap_invoices_interface.source%type;--rchandan for bug#4428980

217: ln_prnt_exchange_rate ap_invoices_all.exchange_rate%TYPE; --4333449
218: lv_invoice_num ap_invoices_interface.invoice_num%type; --rchandan for bug#4428980
219: lv_description ap_invoices_interface.description%type;--rchandan for bug#4428980
220: lv_lookup_type_code ap_invoices_interface.invoice_type_lookup_code%type;--rchandan for bug#4428980
221: lv_source ap_invoices_interface.source%type;--rchandan for bug#4428980
222: lv_voucher_num ap_invoices_interface.voucher_num%type;--rchandan for bug#4428980
223: -- End for bug#3536079
224:
225: -- bug#3607133

Line 715: ap_invoices_interface_s.NEXTVAL,

711: group_id /*Bug 4716884 bduvarag*/
712: )
713: VALUES
714: (
715: ap_invoices_interface_s.NEXTVAL,
716: lv_invoice_num,
717: lv_lookup_type_code,
718: v_open_gl_date, -- bug 3109138 TRUNC( SYSDATE ),
719: for_std_invoice_rec.vendor_id,

Line 764: ap_invoices_interface_s.CURRVAL,

760: last_update_login
761: )
762: VALUES
763: (
764: ap_invoices_interface_s.CURRVAL,
765: ap_invoice_lines_interface_s.NEXTVAL,
766: 1, --THERE WILL ALWAYS BE ONLY ONE LINE.
767: lv_lookup_type_code, --rchandan for bug#4428980
768: new_std_invoice_amount,

Line 1186: lv_source ap_invoices_interface.source%type; --rchandan for bug#4428980

1182: ln_taxable_amount JAI_AP_TDS_INVOICES.invoice_amount%type;
1183: lv_invoice_num ap_invoices_interface.invoice_num%type; --rchandan for bug#4428980
1184: lv_description ap_invoices_interface.description%type; --rchandan for bug#4428980
1185: lv_lookup_type_code ap_invoices_interface.invoice_type_lookup_code%TYPE; --rchandan for bug#4428980
1186: lv_source ap_invoices_interface.source%type; --rchandan for bug#4428980
1187: lv_voucher_num ap_invoices_interface.voucher_num%type;--rchandan for bug#4428980
1188: /* ramanand for SQL BIND Compliance */
1189: lv_rtn_tds_inv VARCHAR2(100);
1190: lv_rtn_tds_auth VARCHAR2(100);

Line 1495: ap_invoices_interface_s.NEXTVAL,

1491: group_id /*Bug 4716884*/
1492: )
1493: VALUES
1494: (
1495: ap_invoices_interface_s.NEXTVAL,
1496: lv_rtn_tds_inv, --'RTN/'|| v_tds_inv_num ||'/'||TO_CHAR(v_tds_inv_run_num),
1497: 'STANDARD',
1498: v_prepay_dist_date, -- bug 3112711 kpvs TRUNC( SYSDATE ), --for_std_inv_tds_rec.invoice_date,
1499: for_std_inv_tds_rec.vendor_id,

Line 1547: ap_invoices_interface_s.CURRVAL,

1543: last_update_login
1544: )
1545: VALUES
1546: (
1547: ap_invoices_interface_s.CURRVAL,
1548: ap_invoice_lines_interface_s.NEXTVAL,
1549: 1, --THERE WILL ALWAYS BE ONLY ONE LINE.
1550: lv_lookup_type_code,
1551: v_insertion_amount_tds_si , -- insertion_amount, bug#3469847

Line 1632: ap_invoices_interface_s.NEXTVAL,

1628: group_id /*Bug 4716884*/
1629: )
1630: VALUES
1631: (
1632: ap_invoices_interface_s.NEXTVAL,
1633: lv_invoice_num, --rchandan for bug#4428980
1634: lv_lookup_type_code, --rchandan for bug#4428980
1635: v_prepay_dist_date, -- bug 3112711 kpvs TRUNC( SYSDATE ),
1636: for_std_inv_rec.vendor_id,

Line 1683: ap_invoices_interface_s.CURRVAL,

1679: last_update_login
1680: )
1681: VALUES
1682: (
1683: ap_invoices_interface_s.CURRVAL,
1684: ap_invoice_lines_interface_s.NEXTVAL,
1685: 1, --THERE WILL ALWAYS BE ONLY ONE LINE.
1686: lv_lookup_type_code, --rchandan for bug#4428980
1687: (-1) * insertion_amount,

Line 2654: SELECT ap_invoices_interface_s.NEXTVAL

2650: INTO v_ja_ap_invoices_interface_no
2651: FROM dual;
2652:
2653: v_ap_invoices_interface_no := NULL;
2654: SELECT ap_invoices_interface_s.NEXTVAL
2655: INTO v_ap_invoices_interface_no
2656: FROM dual;
2657:
2658: Open get_prepay_dist_date; -- bug 3112711 kpvs

Line 2720: --for_std_invoice_tds_rec.invoice_num||'/'|| 'CM/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.NEXTVAL),

2716: last_update_login,
2717: group_id /*Bug 4716884*/
2718: ) VALUES (
2719: v_ap_invoices_interface_no,
2720: --for_std_invoice_tds_rec.invoice_num||'/'|| 'CM/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.NEXTVAL),
2721: -- v_tds_cm_num ||'/'|| 'CM/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.NEXTVAL)
2722: lv_tds_cm_num , --v_tds_cm_num ||'/'|| 'CM/' ||TO_CHAR(v_ja_ap_invoices_interface_no),
2723: -- the line below is being commented and replaced by line above by Aparajita on 29 apr 2002 for bug 2338345
2724: -- var_tds_invoice_num||'/'|| 'CM/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.NEXTVAL),

Line 2721: -- v_tds_cm_num ||'/'|| 'CM/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.NEXTVAL)

2717: group_id /*Bug 4716884*/
2718: ) VALUES (
2719: v_ap_invoices_interface_no,
2720: --for_std_invoice_tds_rec.invoice_num||'/'|| 'CM/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.NEXTVAL),
2721: -- v_tds_cm_num ||'/'|| 'CM/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.NEXTVAL)
2722: lv_tds_cm_num , --v_tds_cm_num ||'/'|| 'CM/' ||TO_CHAR(v_ja_ap_invoices_interface_no),
2723: -- the line below is being commented and replaced by line above by Aparajita on 29 apr 2002 for bug 2338345
2724: -- var_tds_invoice_num||'/'|| 'CM/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.NEXTVAL),
2725: 'CREDIT',

Line 2724: -- var_tds_invoice_num||'/'|| 'CM/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.NEXTVAL),

2720: --for_std_invoice_tds_rec.invoice_num||'/'|| 'CM/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.NEXTVAL),
2721: -- v_tds_cm_num ||'/'|| 'CM/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.NEXTVAL)
2722: lv_tds_cm_num , --v_tds_cm_num ||'/'|| 'CM/' ||TO_CHAR(v_ja_ap_invoices_interface_no),
2723: -- the line below is being commented and replaced by line above by Aparajita on 29 apr 2002 for bug 2338345
2724: -- var_tds_invoice_num||'/'|| 'CM/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.NEXTVAL),
2725: 'CREDIT',
2726: v_prepay_dist_date,-- bug 3112711 kpvs --TRUNC( SYSDATE ), --for_std_invoice_tds_rec.invoice_date,
2727: for_std_invoice_tds_rec.vendor_id,
2728: for_std_invoice_tds_rec.vendor_site_id,

Line 2738: -- for_std_invoice_tds_rec.invoice_num||'/'|| 'CM/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.CURRVAL),

2734: for_std_invoice_tds_rec.exchange_date,
2735: for_std_invoice_tds_rec.terms_id,
2736: lv_credit_note_tds, --'CREDIT NOTE FOR TDS AUTHORITY FOR APPLIED AMOUNT OF TAX '||for_std_invoice_tds_rec.invoice_num||' OR '||TO_CHAR(p_invoice_id) ,
2737: 'INDIA TDS', /* --'TDS',--Ramanand for bug#4388958 */
2738: -- for_std_invoice_tds_rec.invoice_num||'/'|| 'CM/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.CURRVAL),
2739: -- lv_invoice_num_cm, --for_std_invoice_tds_rec.invoice_num||'/'|| 'CM/' ||TO_CHAR(v_ja_ap_invoices_interface_no), Harshita for Bug 4870243
2740: for_std_invoice_tds_rec.payment_method_lookup_code,
2741: for_std_invoice_tds_rec.pay_group_lookup_code,
2742: p_org_id,

Line 2817: SELECT ap_invoices_interface_s.NEXTVAL

2813: FROM dual;
2814:
2815: v_ap_invoices_interface_no := NULL;
2816:
2817: SELECT ap_invoices_interface_s.NEXTVAL
2818: INTO v_ap_invoices_interface_no
2819: FROM dual;
2820:
2821: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoices_interface 2 : STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED');

Line 2876: -- 'RTN/'||for_std_invoice_rec.invoice_num|| '/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.NEXTVAL),

2872: invoice_received_date, --Added by pavan on 06-Jun-01
2873: group_id /*Bug 4716884*/
2874: ) VALUES (
2875: v_ap_invoices_interface_no,
2876: -- 'RTN/'||for_std_invoice_rec.invoice_num|| '/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.NEXTVAL),
2877: lv_rtn_invoice_num, --'RTN/'||for_std_invoice_rec.invoice_num|| '/' ||TO_CHAR(v_ja_ap_invoices_interface_no),
2878: 'STANDARD',
2879: v_prepay_dist_date, --bug 3112711 kpvs -- TRUNC(SYSDATE), --for_std_invoice_rec.invoice_date,
2880: for_std_invoice_rec.vendor_id,

Line 2892: -- 'RTN/'||for_std_invoice_rec.invoice_num|| '/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.CURRVAL),

2888: for_std_invoice_rec.exchange_date,
2889: for_std_invoice_rec.terms_id,
2890: lv_standard_invoice_num , --'STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED ON '||for_std_invoice_rec.invoice_num||' OR '||TO_CHAR(p_invoice_id), -- NEW.prepay_id replaced with p_invoice_id
2891: 'INDIA TDS', /* --'TDS', --Ramanand for bug#4388958 */
2892: -- 'RTN/'||for_std_invoice_rec.invoice_num|| '/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.CURRVAL),
2893: -- lv_rtn_invoice_num , --'RTN/'||for_std_invoice_rec.invoice_num|| '/' ||TO_CHAR(v_ja_ap_invoices_interface_no), Harshita for Bug 4870243
2894: for_std_invoice_rec.payment_method_lookup_code,
2895: for_std_invoice_rec.pay_group_lookup_code,
2896: p_org_id,

Line 3114: SELECT ap_invoices_interface_s.NEXTVAL

3110: INTO v_ja_ap_invoices_interface_no
3111: FROM dual;
3112:
3113: v_ap_invoices_interface_no := NULL;
3114: SELECT ap_invoices_interface_s.NEXTVAL
3115: INTO v_ap_invoices_interface_no
3116: FROM dual;
3117:
3118: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoices_interface 3:CREDIT NOTE FOR TDS AUTHORITY FOR APPLIED AMOUNT OF TAX');

Line 3170: -- for_pre_invoice_tds_rec.invoice_num||'/'|| 'CM/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.NEXTVAL),

3166: last_update_login,
3167: group_id /*Bug 4716884*/
3168: ) VALUES (
3169: v_ap_invoices_interface_no,
3170: -- for_pre_invoice_tds_rec.invoice_num||'/'|| 'CM/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.NEXTVAL),
3171: lv_invoice_num, --for_pre_invoice_tds_rec.invoice_num||'/'|| 'CM/' ||TO_CHAR(v_ja_ap_invoices_interface_no),
3172: 'CREDIT',
3173: v_prepay_dist_date, --bug 3112711 kpvs TRUNC( SYSDATE ) --for_std_invoice_tds_rec.invoice_date,
3174: for_pre_invoice_tds_rec.vendor_id,

Line 3185: -- for_pre_invoice_tds_rec.invoice_num||'/'|| 'CM/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.CURRVAL),

3181: for_pre_invoice_tds_rec.exchange_date,
3182: for_pre_invoice_tds_rec.terms_id,
3183: lv_credit_tds_auth, --'CREDIT NOTE FOR TDS AUTHORITY FOR APPLIED AMOUNT OF TAX '||for_pre_invoice_tds_rec.invoice_num||' OR '||TO_CHAR(p_invoice_id) ,
3184: 'INDIA TDS', /* --'TDS',--Ramanand for bug#4388958*/
3185: -- for_pre_invoice_tds_rec.invoice_num||'/'|| 'CM/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.CURRVAL),
3186: -- lv_invoice_num, --for_pre_invoice_tds_rec.invoice_num||'/'|| 'CM/' ||TO_CHAR(v_ja_ap_invoices_interface_no), Harshita for Bug 4870243
3187: for_pre_invoice_tds_rec.payment_method_lookup_code,
3188: for_pre_invoice_tds_rec.pay_group_lookup_code,
3189: p_org_id,

Line 3259: SELECT ap_invoices_interface_s.NEXTVAL

3255: FROM dual;
3256:
3257: v_ap_invoices_interface_no := NULL;
3258:
3259: SELECT ap_invoices_interface_s.NEXTVAL
3260: INTO v_ap_invoices_interface_no
3261: FROM dual;
3262:
3263: Fnd_File.put_line(Fnd_File.LOG,'BEFORE INSERTING INTO ap_invoices_interface 4: STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED');

Line 3317: -- 'RTN/'||for_std_inv_rec_r.invoice_num|| '/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.NEXTVAL),

3313: invoice_received_date, --Added by pavan on 06-Jun-01
3314: group_id /*Bug 4716884*/
3315: ) VALUES (
3316: v_ap_invoices_interface_no,
3317: -- 'RTN/'||for_std_inv_rec_r.invoice_num|| '/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.NEXTVAL),
3318: lv_rtn_invoice_num , --'RTN/'||for_std_inv_rec_r.invoice_num|| '/' ||TO_CHAR(v_ja_ap_invoices_interface_no),
3319: 'STANDARD',
3320: v_prepay_dist_date, --bug 3112711 kpvs TRUNC(SYSDATE), --for_std_invoice_rec.invoice_date,
3321: for_std_inv_rec_r.vendor_id,

Line 3333: -- 'RTN/'||for_std_inv_rec_r.invoice_num|| '/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.CURRVAL),

3329: for_std_inv_rec_r.exchange_date,
3330: for_std_inv_rec_r.terms_id,
3331: lv_standard_return_excess, --'STANDARD INVOICE FOR RETURNING EXCESS TDS DEDUCTED ON '||for_std_inv_rec_r.invoice_num||' OR '||TO_CHAR(p_invoice_id) ,/**** NEW.prepay_id replaced with p_invoice_id*******/
3332: 'INDIA TDS', /*--'TDS', --Ramanand for bug#4388958*/
3333: -- 'RTN/'||for_std_inv_rec_r.invoice_num|| '/' ||TO_CHAR(ja_in_ap_invoices_interface_s1.CURRVAL),
3334: --lv_rtn_invoice_num, --'RTN/'||for_std_inv_rec_r.invoice_num|| '/' ||TO_CHAR(v_ja_ap_invoices_interface_no), Harshita for Bug 4870243
3335: for_std_inv_rec_r.payment_method_lookup_code,
3336: for_std_inv_rec_r.pay_group_lookup_code,
3337: p_org_id,