DBA Data[Home] [Help]

APPS.ZX_R11I_TAX_PARTNER_PKG dependencies on ZX_PTNR_NEG_LINE_GT

Line 1280: /* This initialization of zx_ptnr_neg_line_gt is incorrect.

1276: zx_ptnr_neg_lines_tab.SHIP_TO_CUST_ACCT_SITE_USE_ID.DELETE;
1277: zx_ptnr_neg_lines_tab.RECEIVABLES_TRX_TYPE_ID.DELETE;
1278: zx_ptnr_neg_lines_tab.ADJUSTED_DOC_DATE.DELETE; --Bug14756523
1279:
1280: /* This initialization of zx_ptnr_neg_line_gt is incorrect.
1281: When multiple item lines are updated, "COPY_PTNR_TAX_LINE_BEF_UPD" is called
1282: individually for each item line updated. Hence, subsequent calls delete the
1283: earlier records inserted in zx_ptnr_neg_line_gt.
1284: As far as updating multiple item lines is concerned, records are deleted from

Line 1283: earlier records inserted in zx_ptnr_neg_line_gt.

1279:
1280: /* This initialization of zx_ptnr_neg_line_gt is incorrect.
1281: When multiple item lines are updated, "COPY_PTNR_TAX_LINE_BEF_UPD" is called
1282: individually for each item line updated. Hence, subsequent calls delete the
1283: earlier records inserted in zx_ptnr_neg_line_gt.
1284: As far as updating multiple item lines is concerned, records are deleted from
1285: zx_ptnr_neg_line_gt after each line update in zxvtxsrvcpkgb.pls */
1286:
1287: -- delete from zx_ptnr_neg_line_gt;

Line 1285: zx_ptnr_neg_line_gt after each line update in zxvtxsrvcpkgb.pls */

1281: When multiple item lines are updated, "COPY_PTNR_TAX_LINE_BEF_UPD" is called
1282: individually for each item line updated. Hence, subsequent calls delete the
1283: earlier records inserted in zx_ptnr_neg_line_gt.
1284: As far as updating multiple item lines is concerned, records are deleted from
1285: zx_ptnr_neg_line_gt after each line update in zxvtxsrvcpkgb.pls */
1286:
1287: -- delete from zx_ptnr_neg_line_gt;
1288:
1289: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1287: -- delete from zx_ptnr_neg_line_gt;

1283: earlier records inserted in zx_ptnr_neg_line_gt.
1284: As far as updating multiple item lines is concerned, records are deleted from
1285: zx_ptnr_neg_line_gt after each line update in zxvtxsrvcpkgb.pls */
1286:
1287: -- delete from zx_ptnr_neg_line_gt;
1288:
1289: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1290: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME || ': ' ||l_api_name||'(-)');
1291: END IF;

Line 1848: ' Inserting into zx_ptnr_neg_line_gt');

1844: END IF;
1845:
1846: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1847: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
1848: ' Inserting into zx_ptnr_neg_line_gt');
1849: END IF;
1850:
1851: FORALL i IN zx_ptnr_neg_lines_tab.application_id.FIRST .. zx_ptnr_neg_lines_tab.application_id.LAST
1852:

Line 1853: Insert into zx_ptnr_neg_line_gt(

1849: END IF;
1850:
1851: FORALL i IN zx_ptnr_neg_lines_tab.application_id.FIRST .. zx_ptnr_neg_lines_tab.application_id.LAST
1852:
1853: Insert into zx_ptnr_neg_line_gt(
1854: INTERNAL_ORGANIZATION_ID,
1855: EVENT_CLASS_MAPPING_ID,
1856: TRX_ID,
1857: ENTITY_CODE,

Line 2038: FROM zx_ptnr_neg_line_gt

2034: ZX_PTNR_NEG_LINES_TAB.RECEIVABLES_TRX_TYPE_ID(i),
2035: ZX_PTNR_NEG_LINES_TAB.ADJUSTED_DOC_DATE(i) --Bug14756523
2036: FROM DUAL
2037: WHERE NOT EXISTS (SELECT 'Y'
2038: FROM zx_ptnr_neg_line_gt
2039: WHERE application_id = ZX_PTNR_NEG_LINES_TAB.APPLICATION_ID(i)
2040: AND entity_code = ZX_PTNR_NEG_LINES_TAB.ENTITY_CODE(i)
2041: AND event_class_code = ZX_PTNR_NEG_LINES_TAB.EVENT_CLASS_CODE(i)
2042: AND trx_id = ZX_PTNR_NEG_LINES_TAB.TRX_ID(i)

Line 2246: ' updating zx_ptnr_neg_line_gt');

2242: END IF;
2243:
2244: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2245: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2246: ' updating zx_ptnr_neg_line_gt');
2247: END IF;
2248:
2249: FORALL i IN zx_ptnr_neg_lines_tab.application_id.FIRST .. zx_ptnr_neg_lines_tab.application_id.LAST
2250: Update ZX_PTNR_NEG_LINE_GT SET

Line 2250: Update ZX_PTNR_NEG_LINE_GT SET

2246: ' updating zx_ptnr_neg_line_gt');
2247: END IF;
2248:
2249: FORALL i IN zx_ptnr_neg_lines_tab.application_id.FIRST .. zx_ptnr_neg_lines_tab.application_id.LAST
2250: Update ZX_PTNR_NEG_LINE_GT SET
2251: LINE_EXT_VARCHAR_ATTRIBUTE1 = ZX_PTNR_NEG_LINES_TAB.LINE_EXT_VARCHAR_ATTRIBUTE1(i) ,
2252: LINE_EXT_VARCHAR_ATTRIBUTE2 = ZX_PTNR_NEG_LINES_TAB.LINE_EXT_VARCHAR_ATTRIBUTE2(i) ,
2253: LINE_EXT_VARCHAR_ATTRIBUTE3 = ZX_PTNR_NEG_LINES_TAB.LINE_EXT_VARCHAR_ATTRIBUTE3(i) ,
2254: LINE_EXT_VARCHAR_ATTRIBUTE4 = ZX_PTNR_NEG_LINES_TAB.LINE_EXT_VARCHAR_ATTRIBUTE4(i) ,