APPS.ZX_SRVC_TYP_PKG dependencies on ZX_DETAIL_TAX_LINES_GT

Line 3022: -- Insert into zx_detail_tax_lines_gt for partners

3018: -- PRIVATE PROCEDURE
3019: -- insert_detail_tax_lines_gt
3020: --
3021: -- DESCRIPTION
3022: -- Insert into zx_detail_tax_lines_gt for partners
3023: --
3024: -- CALLED BY
3025: -- override_tax_lines
3026: -- reverse_document

Line 3047: INSERT INTO ZX_DETAIL_TAX_LINES_GT(

3043: /*Set the return status to Success */
3044: x_return_status := FND_API.G_RET_STS_SUCCESS;
3045:
3046: BEGIN
3047: INSERT INTO ZX_DETAIL_TAX_LINES_GT(
3048: tax_line_id,
3049: internal_organization_id,
3050: application_id,
3051: entity_code,

Line 8676: delete from zx_detail_tax_lines_gt

8672: AND entity_code = p_event_class_rec.entity_code
8673: AND event_class_code = p_event_class_rec.event_class_code
8674: AND trx_id = p_event_class_rec.trx_id;
8675:
8676: delete from zx_detail_tax_lines_gt
8677: WHERE application_id = p_event_class_rec.application_id
8678: AND entity_code = p_event_class_rec.entity_code
8679: AND event_class_code = p_event_class_rec.event_class_code
8680: AND trx_id = p_event_class_rec.trx_id;

Line 13126: FROM ZX_DETAIL_TAX_LINES_GT zdtlg,

13122: zdtlg.tax_regime_code,
13123: zdtlg.tax_provider_id,
13124: regimes.effective_from,
13125: regimes.effective_to
13126: FROM ZX_DETAIL_TAX_LINES_GT zdtlg,
13127: ZX_REGIMES_B regimes
13128: WHERE zdtlg.application_id = p_event_class_rec.application_id
13129: AND zdtlg.entity_code = p_event_class_rec.entity_code
13130: AND zdtlg.event_class_code = p_event_class_rec.event_class_code

Line 13183: INSERT INTO ZX_DETAIL_TAX_LINES_GT

13179: IF p_event_class_rec.record_flag ='Y' AND
13180: p_event_class_rec.record_for_partners_flag = 'Y' THEN
13181:
13182: /*Commented due to GSCC error - need to provide all column names for insert
13183: INSERT INTO ZX_DETAIL_TAX_LINES_GT
13184: SELECT * from ZX_LINES
13185: WHERE application_id = p_event_class_rec.application_id
13186: AND entity_code = p_event_class_rec.entity_code
13187: AND event_class_code = p_event_class_rec.event_class_code

Line 13319: /* The deleted tax lines are inserted into ZX_DETAIL_TAX_LINES_GT

13315: END IF;
13316: RETURN;
13317: END IF;
13318:
13319: /* The deleted tax lines are inserted into ZX_DETAIL_TAX_LINES_GT
13320: for tax lines synchronization view needed for partner service.
13321: But, eBTax service ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines
13322: creates tax lines for the records remaining in the
13323: ZX_DETAIL_TAX_LINES_GT. This results in tax line not getting

Line 13323: ZX_DETAIL_TAX_LINES_GT. This results in tax line not getting

13319: /* The deleted tax lines are inserted into ZX_DETAIL_TAX_LINES_GT
13320: for tax lines synchronization view needed for partner service.
13321: But, eBTax service ZX_TRL_MANAGE_TAX_PKG.Create_Detail_Lines
13322: creates tax lines for the records remaining in the
13323: ZX_DETAIL_TAX_LINES_GT. This results in tax line not getting
13324: deleted from zx_lines when partner created tax line is deleted.
13325: Hence, following delete is being issued. */
13326:
13327: BEGIN

Line 13328: DELETE FROM ZX_DETAIL_TAX_LINES_GT

13324: deleted from zx_lines when partner created tax line is deleted.
13325: Hence, following delete is being issued. */
13326:
13327: BEGIN
13328: DELETE FROM ZX_DETAIL_TAX_LINES_GT
13329: WHERE application_id = p_event_class_rec.application_id
13330: AND entity_code = p_event_class_rec.entity_code
13331: AND event_class_code = p_event_class_rec.event_class_code
13332: AND trx_id = p_event_class_rec.trx_id