APPS.ZX_R11I_TAX_PARTNER_PKG dependencies on ZX_LINES

Line 1264: (p_tax_line_id IN ZX_LINES.tax_line_id%type,

1260:
1261: END flush_table_information;
1262:
1263: PROCEDURE COPY_PTNR_TAX_LINE_BEF_UPD
1264: (p_tax_line_id IN ZX_LINES.tax_line_id%type,
1265: x_return_status OUT NOCOPY VARCHAR2) IS
1266:
1267: l_application_id zx_lines.application_id%type;
1268: l_api_name CONSTANT VARCHAR2(80) := 'COPY_PTNR_TAX_LINE_BEF_UPD';

Line 1267: l_application_id zx_lines.application_id%type;

1263: PROCEDURE COPY_PTNR_TAX_LINE_BEF_UPD
1264: (p_tax_line_id IN ZX_LINES.tax_line_id%type,
1265: x_return_status OUT NOCOPY VARCHAR2) IS
1266:
1267: l_application_id zx_lines.application_id%type;
1268: l_api_name CONSTANT VARCHAR2(80) := 'COPY_PTNR_TAX_LINE_BEF_UPD';
1269:
1270: BEGIN
1271:

Line 1284: from zx_lines

1280:
1281: BEGIN
1282: select application_id
1283: into l_application_id
1284: from zx_lines
1285: where tax_line_id = p_tax_line_id;
1286: EXCEPTION
1287: WHEN OTHERS THEN
1288: l_application_id := NULL;

Line 1366: FROM zx_lines zxlines, zx_evnt_cls_mappings zxevnt

1362: zxlines.manually_entered_flag,
1363: zxlines.cancel_flag,
1364: zxlines.delete_flag
1365:
1366: FROM zx_lines zxlines, zx_evnt_cls_mappings zxevnt
1367: WHERE zxlines.tax_line_id = p_tax_line_id
1368: AND zxevnt.event_class_code = zxlines.event_class_code
1369: AND zxevnt.application_id = zxlines.application_id
1370: AND zxevnt.entity_code = zxlines.entity_code;

Line 1462: FROM ZX_LINES_DET_FACTORS

1458: SHIP_TO_CUST_ACCT_SITE_USE_ID,
1459: SHIP_THIRD_PTY_ACCT_SITE_ID,
1460: BILL_THIRD_PTY_ACCT_SITE_ID,
1461: RECEIVABLES_TRX_TYPE_ID
1462: FROM ZX_LINES_DET_FACTORS
1463: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID AND
1464: ENTITY_CODE = p_event_class_rec.ENTITY_CODE AND
1465: EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE AND
1466: TRX_ID = p_event_class_rec.TRX_ID;

Line 1512: from zx_lines

1508: select tax_regime_code,
1509: tax_provider_id
1510: into l_regime_code,
1511: l_tax_provider_id
1512: from zx_lines
1513: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
1514: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
1515: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
1516: AND TRX_ID = p_event_class_rec.TRX_ID

Line 1665: FROM ZX_LINES_DET_FACTORS

1661: ZX_PTNR_NEG_LINES_TAB.SHIP_TO_CUST_ACCT_SITE_USE_ID(i),
1662: ZX_PTNR_NEG_LINES_TAB.SHIP_THIRD_PTY_ACCT_SITE_ID(i),
1663: ZX_PTNR_NEG_LINES_TAB.BILL_THIRD_PTY_ACCT_SITE_ID(i),
1664: ZX_PTNR_NEG_LINES_TAB.RECEIVABLES_TRX_TYPE_ID(i)
1665: FROM ZX_LINES_DET_FACTORS
1666: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID AND
1667: ENTITY_CODE = p_event_class_rec.ENTITY_CODE AND
1668: EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE AND
1669: TRX_ID = p_event_class_rec.TRX_ID AND