APPS.ZX_R11I_TAX_PARTNER_PKG dependencies on ZX_LINES

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

1292:
1293: END flush_table_information;
1294:
1295: PROCEDURE COPY_PTNR_TAX_LINE_BEF_UPD
1296: (p_tax_line_id IN ZX_LINES.tax_line_id%type,
1297: x_return_status OUT NOCOPY VARCHAR2) IS
1298:
1299: l_application_id zx_lines.application_id%type;
1300: l_api_name CONSTANT VARCHAR2(80) := 'COPY_PTNR_TAX_LINE_BEF_UPD';

Line 1299: l_application_id zx_lines.application_id%type;

1295: PROCEDURE COPY_PTNR_TAX_LINE_BEF_UPD
1296: (p_tax_line_id IN ZX_LINES.tax_line_id%type,
1297: x_return_status OUT NOCOPY VARCHAR2) IS
1298:
1299: l_application_id zx_lines.application_id%type;
1300: l_api_name CONSTANT VARCHAR2(80) := 'COPY_PTNR_TAX_LINE_BEF_UPD';
1301:
1302: BEGIN
1303:

Line 1316: from zx_lines

1312:
1313: BEGIN
1314: select application_id
1315: into l_application_id
1316: from zx_lines
1317: where tax_line_id = p_tax_line_id;
1318: EXCEPTION
1319: WHEN OTHERS THEN
1320: l_application_id := NULL;

Line 1398: FROM zx_lines zxlines, zx_evnt_cls_mappings zxevnt

1394: zxlines.manually_entered_flag,
1395: zxlines.cancel_flag,
1396: zxlines.delete_flag
1397:
1398: FROM zx_lines zxlines, zx_evnt_cls_mappings zxevnt
1399: WHERE zxlines.tax_line_id = p_tax_line_id
1400: AND zxevnt.event_class_code = zxlines.event_class_code
1401: AND zxevnt.application_id = zxlines.application_id
1402: AND zxevnt.entity_code = zxlines.entity_code;

Line 1495: FROM ZX_LINES_DET_FACTORS

1491: SHIP_THIRD_PTY_ACCT_SITE_ID,
1492: BILL_THIRD_PTY_ACCT_SITE_ID,
1493: RECEIVABLES_TRX_TYPE_ID,
1494: ADJUSTED_DOC_DATE --Bug14756523
1495: FROM ZX_LINES_DET_FACTORS
1496: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID AND
1497: ENTITY_CODE = p_event_class_rec.ENTITY_CODE AND
1498: EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE AND
1499: TRX_ID = p_event_class_rec.TRX_ID;

Line 1545: from zx_lines

1541: select tax_regime_code,
1542: tax_provider_id
1543: into l_regime_code,
1544: l_tax_provider_id
1545: from zx_lines
1546: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID
1547: AND ENTITY_CODE = p_event_class_rec.ENTITY_CODE
1548: AND EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE
1549: AND TRX_ID = p_event_class_rec.TRX_ID

Line 1701: FROM ZX_LINES_DET_FACTORS

1697: ZX_PTNR_NEG_LINES_TAB.SHIP_THIRD_PTY_ACCT_SITE_ID(i),
1698: ZX_PTNR_NEG_LINES_TAB.BILL_THIRD_PTY_ACCT_SITE_ID(i),
1699: ZX_PTNR_NEG_LINES_TAB.RECEIVABLES_TRX_TYPE_ID(i),
1700: ZX_PTNR_NEG_LINES_TAB.ADJUSTED_DOC_DATE(i) --Bug14756523
1701: FROM ZX_LINES_DET_FACTORS
1702: WHERE APPLICATION_ID = p_event_class_rec.APPLICATION_ID AND
1703: ENTITY_CODE = p_event_class_rec.ENTITY_CODE AND
1704: EVENT_CLASS_CODE = p_event_class_rec.EVENT_CLASS_CODE AND
1705: TRX_ID = p_event_class_rec.TRX_ID AND