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_ST_REVERSE_PROCESS dependencies on JAI_AP_MATCH_INV_TAXES

Line 65: G_MATCH_PRODUCT_TABLE CONSTANT VARCHAR2(30) := 'JAI_AP_MATCH_INV_TAXES';

61: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
62:
63: G_JAI_APPLICATION_ID CONSTANT NUMBER := 7000;
64: G_PRODUCT_TABLE CONSTANT VARCHAR2(30) := 'JAI_CMN_DOCUMENT_TAXES';
65: G_MATCH_PRODUCT_TABLE CONSTANT VARCHAR2(30) := 'JAI_AP_MATCH_INV_TAXES';
66:
67:
68: --==========================================================================
69: -- FUNCTION NAME:

Line 3097: from jai_ap_match_inv_taxes

3093:
3094: Cursor c_match_tax_lines (p_invoice_id number) is /*Added by nprashar for bug # 12832424*/
3095: select invoice_id, po_distribution_id, invoice_distribution_id, rcv_transaction_id,invoice_line_number,
3096: parent_invoice_distribution_id
3097: from jai_ap_match_inv_taxes
3098: where line_type_lookup_code = 'MISCELLANEOUS'
3099: and invoice_id = p_invoice_id
3100: and parent_invoice_line_number = pn_invoice_line_number
3101: and po_distribution_id = po_dist_id;

Line 3628: lv_modvat_flag jai_ap_match_inv_taxes.recoverable_flag%type;

3624:
3625: ln_lines_to_insert number;
3626: ln_nrec_tax_amt number;
3627: ln_rec_tax_amt number;
3628: lv_modvat_flag jai_ap_match_inv_taxes.recoverable_flag%type;
3629:
3630: lv_excise_costing_flag varchar2 (1);
3631:
3632: lv_tax_type varchar2(5);

Line 3848: from JAI_AP_MATCH_INV_TAXES jam,jai_cmn_taxes_all jct

3844: cursor c_get_orig_tax_line
3845: (p_orig_invoice_id number, p_orig_invoice_dist_id number, p_tax_id number) is
3846: -- 5763527 , Added SUM as there can be two tax lines against the same tax_id because of partialy recoverable taxes
3847: select sum(jam.tax_amount) tax_amount-- project costing fwd porting
3848: from JAI_AP_MATCH_INV_TAXES jam,jai_cmn_taxes_all jct
3849: where p_orig_invoice_id = p_orig_invoice_id
3850: and parent_invoice_distribution_id = p_orig_invoice_dist_id
3851: and jam.tax_id = p_tax_id
3852: --start additions for bug#10167393

Line 4501: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');

4497: ap_invoice_dist_all_rec.distribution_class := lv_dist_class;
4498: ap_invoice_dist_all_rec.dist_match_type := r_ap_dist.dist_match_type;
4499: Insert_ap_inv_dst_line(ap_invoice_dist_all_rec);
4500:
4501: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
4502:
4503: INSERT INTO JAI_AP_MATCH_INV_TAXES
4504: (
4505: tax_distribution_id,

Line 4503: INSERT INTO JAI_AP_MATCH_INV_TAXES

4499: Insert_ap_inv_dst_line(ap_invoice_dist_all_rec);
4500:
4501: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
4502:
4503: INSERT INTO JAI_AP_MATCH_INV_TAXES
4504: (
4505: tax_distribution_id,
4506:
4507: assets_tracking_flag,

Line 4543: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,

4539: , line_no
4540: )
4541: VALUES
4542: (
4543: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,
4544: v_assets_tracking_flag,
4545: inv_id,
4546: cur_items_rec.po_header_id,
4547: cur_items_rec.po_line_id,

Line 5106: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');

5102: ap_invoice_dist_all_rec.distribution_class := lv_dist_class;
5103: ap_invoice_dist_all_rec.dist_match_type := for_dist_insertion_rec.dist_match_type;
5104: Insert_ap_inv_dst_line(ap_invoice_dist_all_rec);
5105:
5106: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
5107: INSERT INTO JAI_AP_MATCH_INV_TAXES
5108: (
5109: tax_distribution_id,
5110: exchange_rate_variance,

Line 5107: INSERT INTO JAI_AP_MATCH_INV_TAXES

5103: ap_invoice_dist_all_rec.dist_match_type := for_dist_insertion_rec.dist_match_type;
5104: Insert_ap_inv_dst_line(ap_invoice_dist_all_rec);
5105:
5106: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name, 'Before inserting into JAI_AP_MATCH_INV_TAXES ');
5107: INSERT INTO JAI_AP_MATCH_INV_TAXES
5108: (
5109: tax_distribution_id,
5110: exchange_rate_variance,
5111: assets_tracking_flag,

Line 5149: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,

5145: )
5146:
5147: VALUES
5148: (
5149: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,
5150: null,
5151: v_assets_tracking_flag,
5152: inv_id,
5153: cur_items_rec.po_header_id, /* All references to r_cur_items_rec have been replaced by cur_items_rec */

Line 5708: lv_modvat_flag jai_ap_match_inv_taxes.recoverable_flag%type;

5704:
5705: ln_lines_to_insert number;
5706: ln_nrec_tax_amt number;
5707: ln_rec_tax_amt number;
5708: lv_modvat_flag jai_ap_match_inv_taxes.recoverable_flag%type;
5709:
5710: lv_excise_costing_flag varchar2 (1);
5711: lv_tax_type varchar2(5);
5712: lv_tax_line_amount NUMBER := 0;

Line 6299: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name,'Before inserting into JAI_AP_MATCH_INV_TAXES');

6295: END IF;
6296: Insert_ap_inv_dst_line(ap_invoice_dist_all_rec);
6297:
6298:
6299: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name,'Before inserting into JAI_AP_MATCH_INV_TAXES');
6300: INSERT INTO JAI_AP_MATCH_INV_TAXES
6301: (
6302: tax_distribution_id,
6303: exchange_rate_variance,

Line 6300: INSERT INTO JAI_AP_MATCH_INV_TAXES

6296: Insert_ap_inv_dst_line(ap_invoice_dist_all_rec);
6297:
6298:
6299: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name,'Before inserting into JAI_AP_MATCH_INV_TAXES');
6300: INSERT INTO JAI_AP_MATCH_INV_TAXES
6301: (
6302: tax_distribution_id,
6303: exchange_rate_variance,
6304: assets_tracking_flag,

Line 6340: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,

6336: ,line_no
6337: )
6338: VALUES
6339: (
6340: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,
6341: null,
6342: v_assets_tracking_flag ,
6343: inv_id,
6344: cur_items_rec.po_header_id,

Line 6830: 'Before inserting into JAI_AP_MATCH_INV_TAXES tax id ' || i.tax_id );

6826: Insert_ap_inv_dst_line(ap_invoice_dist_all_rec);
6827:
6828:
6829: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name,
6830: 'Before inserting into JAI_AP_MATCH_INV_TAXES tax id ' || i.tax_id );
6831: INSERT INTO JAI_AP_MATCH_INV_TAXES
6832: (
6833: tax_distribution_id,
6834: exchange_rate_variance,

Line 6831: INSERT INTO JAI_AP_MATCH_INV_TAXES

6827:
6828:
6829: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name,
6830: 'Before inserting into JAI_AP_MATCH_INV_TAXES tax id ' || i.tax_id );
6831: INSERT INTO JAI_AP_MATCH_INV_TAXES
6832: (
6833: tax_distribution_id,
6834: exchange_rate_variance,
6835: assets_tracking_flag,

Line 6871: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,

6867: ,line_no
6868: )
6869: VALUES
6870: (
6871: JAI_AP_MATCH_INV_TAXES_S.NEXTVAL,
6872: null,
6873: v_assets_tracking_flag ,
6874: inv_id,
6875: cur_items_rec.po_header_id,