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.ZX_VERTEX_TAX_SERVICE_PKG dependencies on ZX_PTNR_NEG_LINE_GT

Line 958: FROM ZX_PTNR_NEG_LINE_GT;

954: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
955: BEGIN
956: SELECT count(*)
957: INTO l_cnt_of_ptnr_neg_line_gt
958: FROM ZX_PTNR_NEG_LINE_GT;
959: EXCEPTION WHEN OTHERS THEN
960: l_cnt_of_ptnr_neg_line_gt := 0;
961: END;
962: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 1429: DELETE FROM zx_ptnr_neg_line_gt

1425: return;
1426: END IF;
1427:
1428: BEGIN
1429: DELETE FROM zx_ptnr_neg_line_gt
1430: WHERE event_class_mapping_id = pg_doc_type_id_tab(I) and
1431: trx_id = pg_trx_id_tab(I) and
1432: trx_line_id = pg_trx_line_id_tab(I) and
1433: trx_level_type = pg_trx_level_type_tab(I);

Line 1911: arp_line_amount ZX_PTNR_NEG_LINE_GT.line_amt%type;

1907:
1908: PROCEDURE SET_PARAMETERS(x_return_status OUT NOCOPY VARCHAR2) IS
1909:
1910: /*Following variables used during line deletion process.*/
1911: arp_line_amount ZX_PTNR_NEG_LINE_GT.line_amt%type;
1912: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;
1913: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;
1914: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;
1915: arp_trx_date ZX_PTNR_NEG_LINE_GT.trx_date%type;

Line 1912: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;

1908: PROCEDURE SET_PARAMETERS(x_return_status OUT NOCOPY VARCHAR2) IS
1909:
1910: /*Following variables used during line deletion process.*/
1911: arp_line_amount ZX_PTNR_NEG_LINE_GT.line_amt%type;
1912: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;
1913: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;
1914: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;
1915: arp_trx_date ZX_PTNR_NEG_LINE_GT.trx_date%type;
1916: arp_exemption_control_flag ZX_PTNR_NEG_LINE_GT.exemption_control_flag%type;

Line 1913: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;

1909:
1910: /*Following variables used during line deletion process.*/
1911: arp_line_amount ZX_PTNR_NEG_LINE_GT.line_amt%type;
1912: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;
1913: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;
1914: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;
1915: arp_trx_date ZX_PTNR_NEG_LINE_GT.trx_date%type;
1916: arp_exemption_control_flag ZX_PTNR_NEG_LINE_GT.exemption_control_flag%type;
1917: arp_ship_to_grphy_type1 varchar2(30);

Line 1914: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;

1910: /*Following variables used during line deletion process.*/
1911: arp_line_amount ZX_PTNR_NEG_LINE_GT.line_amt%type;
1912: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;
1913: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;
1914: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;
1915: arp_trx_date ZX_PTNR_NEG_LINE_GT.trx_date%type;
1916: arp_exemption_control_flag ZX_PTNR_NEG_LINE_GT.exemption_control_flag%type;
1917: arp_ship_to_grphy_type1 varchar2(30);
1918: arp_ship_to_grphy_value1 varchar2(30);

Line 1915: arp_trx_date ZX_PTNR_NEG_LINE_GT.trx_date%type;

1911: arp_line_amount ZX_PTNR_NEG_LINE_GT.line_amt%type;
1912: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;
1913: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;
1914: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;
1915: arp_trx_date ZX_PTNR_NEG_LINE_GT.trx_date%type;
1916: arp_exemption_control_flag ZX_PTNR_NEG_LINE_GT.exemption_control_flag%type;
1917: arp_ship_to_grphy_type1 varchar2(30);
1918: arp_ship_to_grphy_value1 varchar2(30);
1919: arp_ship_to_grphy_type2 varchar2(30);

Line 1916: arp_exemption_control_flag ZX_PTNR_NEG_LINE_GT.exemption_control_flag%type;

1912: arp_quantity ZX_PTNR_NEG_LINE_GT.trx_line_quantity%type;
1913: arp_trx_id ZX_PTNR_NEG_LINE_GT.trx_id%type;
1914: arp_trx_number ZX_PTNR_NEG_LINE_GT.trx_number%type;
1915: arp_trx_date ZX_PTNR_NEG_LINE_GT.trx_date%type;
1916: arp_exemption_control_flag ZX_PTNR_NEG_LINE_GT.exemption_control_flag%type;
1917: arp_ship_to_grphy_type1 varchar2(30);
1918: arp_ship_to_grphy_value1 varchar2(30);
1919: arp_ship_to_grphy_type2 varchar2(30);
1920: arp_ship_to_grphy_value2 varchar2(30);

Line 2493: FROM ZX_PTNR_NEG_LINE_GT

2489: arp_transaction_date,
2490: arp_adjusted_doc_date,
2491: arp_trx_date,
2492: arp_exemption_control_flag
2493: FROM ZX_PTNR_NEG_LINE_GT
2494: WHERE trx_line_id= pg_trx_line_id_tab(I);
2495:
2496:
2497: IF substrb(nvl(arp_ship_from_add,'XXXXXXXXX'), 2,9)='XXXXXXXXX' THEN

Line 3966: FROM zx_ptnr_neg_line_gt

3962: l_neg_line_gt_exists := 0;
3963: BEGIN
3964: SELECT 1
3965: INTO l_neg_line_gt_exists
3966: FROM zx_ptnr_neg_line_gt
3967: WHERE event_class_mapping_id = p_evnt_cls_mapping_id
3968: AND trx_id = p_transaction_id
3969: AND trx_line_id = p_transaction_line_id
3970: AND trx_level_type = p_trx_level_type;

Line 3976: /* For given transaction line id, record already exists in zx_ptnr_neg_line_gt, then there is no need to recreate it */

3972: WHEN OTHERS THEN
3973: l_neg_line_gt_exists := 0;
3974: END;
3975:
3976: /* For given transaction line id, record already exists in zx_ptnr_neg_line_gt, then there is no need to recreate it */
3977:
3978: IF l_neg_line_gt_exists <> 0 THEN
3979: RETURN;
3980: END IF;

Line 4706: FROM ZX_PTNR_NEG_LINE_GT;

4702: 'l_cnt_of_loc_info_gt = '||l_cnt_of_loc_info_gt);
4703: BEGIN
4704: SELECT count(*)
4705: INTO l_cnt_of_neg_line_gt
4706: FROM ZX_PTNR_NEG_LINE_GT;
4707: EXCEPTION WHEN OTHERS THEN
4708: l_cnt_of_neg_line_gt := 0;
4709: END;
4710: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4776: FROM ZX_PTNR_NEG_LINE_GT

4772: END;
4773: BEGIN
4774: SELECT trx_line_id
4775: BULK COLLECT INTO pg_trx_line_id_tab
4776: FROM ZX_PTNR_NEG_LINE_GT
4777: WHERE event_class_mapping_id = x_transaction_rec.document_type_id
4778: AND trx_id = x_transaction_rec.transaction_id;
4779: END;
4780: