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_VALIDATE_API_PKG dependencies on ZX_TRX_HEADERS_GT

Line 162: SELECT count(1) INTO l_count_header FROM zx_trx_headers_gt;

158: 'ZX.PL/SQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
159: 'ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR(+)');
160: END IF;
161:
162: SELECT count(1) INTO l_count_header FROM zx_trx_headers_gt;
163:
164: SELECT count(1) INTO l_count_lines FROM ZX_TRANSACTION_LINES_GT;
165:
166: SELECT count(1) INTO l_count_tax_lines FROM ZX_IMPORT_TAX_LINES_GT;

Line 172: 'Count of ZX_TRX_HEADERS_GT '||to_char(l_count_header));

168: SELECT count(1) INTO l_count_link_gt FROM ZX_TRX_TAX_LINK_GT;
169:
170: IF ( g_level_statement >= g_current_runtime_level) THEN
171: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
172: 'Count of ZX_TRX_HEADERS_GT '||to_char(l_count_header));
173: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
174: 'Count of ZX_TRANSACTION_LINES_GT '||to_char(l_count_lines));
175: FND_LOG.STRING(g_level_statement,'ZX_VALIDATEAPI_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
176: 'Count of ZX_IMPORT_TAX_LINES_GT '||to_char(l_count_tax_lines));

Line 195: ZX_TRX_HEADERS_GT Header

191: SELECT
192: legal_entity_id , internal_organization_id
193: INTO l_le_id, l_ou_id
194: FROM
195: ZX_TRX_HEADERS_GT Header
196: WHERE rownum = 1;
197:
198: EXCEPTION
199:

Line 410: l_le_id ZX_TRX_HEADERS_GT.legal_entity_id%Type;

406: PROCEDURE Default_Tax_Attr(x_return_status OUT NOCOPY VARCHAR2) IS
407:
408: l_owner_table_code ZX_FC_TYPES_B.owner_table_code%Type;
409: l_owner_id_num ZX_FC_TYPES_B.owner_id_num%Type;
410: l_le_id ZX_TRX_HEADERS_GT.legal_entity_id%Type;
411: l_org_id ZX_TRX_HEADERS_GT.internal_organization_id%Type;
412: l_effective_date Date;
413: l_return_status varchar2(30);
414:

Line 411: l_org_id ZX_TRX_HEADERS_GT.internal_organization_id%Type;

407:
408: l_owner_table_code ZX_FC_TYPES_B.owner_table_code%Type;
409: l_owner_id_num ZX_FC_TYPES_B.owner_id_num%Type;
410: l_le_id ZX_TRX_HEADERS_GT.legal_entity_id%Type;
411: l_org_id ZX_TRX_HEADERS_GT.internal_organization_id%Type;
412: l_effective_date Date;
413: l_return_status varchar2(30);
414:
415: --Bug 5018766 : Added for Defaulting the Tax Dates on the Newly added columns in zx_transaction_lines_gt

Line 443: from zx_trx_headers_gt header,

439: COALESCE(header.related_doc_date,
440: header.provnl_tax_determination_date,
441: Lines.adjusted_doc_date,
442: header.trx_date) subscription_date
443: from zx_trx_headers_gt header,
444: zx_transaction_lines_gt lines
445: where header.application_id = lines.application_id
446: and header.ENTITY_CODE = lines.ENTITY_CODE
447: and header.EVENT_CLASS_CODE = lines.EVENT_CLASS_CODE

Line 517: UPDATE ZX_TRX_HEADERS_GT Header

513: 'ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR:
514: Defaulting for Taxation Country');
515: END IF;
516:
517: UPDATE ZX_TRX_HEADERS_GT Header
518: SET default_taxation_country =
519: (SELECT le.country
520: FROM
521: XLE_FIRSTPARTY_INFORMATION_V le

Line 554: ZX_TRX_HEADERS_GT Header,

550: TaxLines_gt.trx_id trx_id,
551: TaxLines_gt.summary_tax_line_number summary_tax_line_number
552: FROM ZX_FC_COUNTRY_DEFAULTS ContDef,
553: ZX_IMPORT_TAX_LINES_GT TaxLines_gt,
554: ZX_TRX_HEADERS_GT Header,
555: ZX_TRANSACTION_LINES_GT Lines,
556: ZX_RATES_B rates,
557: ZX_SUBSCRIPTION_DETAILS sd_rates
558: WHERE TaxLines_gt.tax_rate_code = rates.tax_rate_code(+)

Line 671: ZX_TRX_HEADERS_GT Header,

667: TaxLines_gt.trx_id trx_id,
668: TaxLines_gt.summary_tax_line_number summary_tax_line_number
669: FROM ZX_FC_COUNTRY_DEFAULTS ContDef,
670: ZX_IMPORT_TAX_LINES_GT TaxLines_gt,
671: ZX_TRX_HEADERS_GT Header,
672: ZX_TRANSACTION_LINES_GT Lines,
673: ZX_RATES_B rates,
674: ZX_SUBSCRIPTION_DETAILS sd_rates
675: WHERE TaxLines_gt.tax_rate_id = rates.tax_rate_id(+)

Line 786: ZX_TRX_HEADERS_GT Header,

782: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines
783: SET tax_status_code =
784: (SELECT Status.tax_status_code
785: FROM ZX_STATUS_B Status,
786: ZX_TRX_HEADERS_GT Header,
787: ZX_TRANSACTION_LINES_GT Lines,
788: ZX_SUBSCRIPTION_DETAILS sd_status,
789: ZX_RATES_B rates,
790: ZX_SUBSCRIPTION_DETAILS sd_rates

Line 927: ZX_TRX_HEADERS_GT Header,

923: SET tax_provider_id =
924: (SELECT srvc.srvc_provider_id
925: FROM ZX_SRVC_SUBSCRIPTIONS srvc,
926: ZX_REGIMES_USAGES reg,
927: ZX_TRX_HEADERS_GT Header,
928: ZX_TRANSACTION_LINES_GT Lines,
929: ZX_EVNT_CLS_MAPPINGS mapp
930: WHERE reg.tax_regime_code = TaxLines.tax_regime_code
931: AND srvc.regime_usage_id = reg.regime_usage_id

Line 1015: ZX_TRX_HEADERS_GT Header,

1011: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines
1012: SET tax_jurisdiction_code =
1013: (SELECT jur.TAX_JURISDICTION_CODE
1014: FROM ZX_JURISDICTIONS_B Jur,
1015: ZX_TRX_HEADERS_GT Header,
1016: ZX_TRANSACTION_LINES_GT Lines,
1017: ZX_RATES_B rates,
1018: ZX_SUBSCRIPTION_DETAILS sd_rates
1019: WHERE

Line 1145: zx_trx_headers_gt header,

1141: TaxLines.event_class_code event_class_code,
1142: TaxLines.trx_id trx_id,
1143: TaxLines.summary_tax_line_number summary_tax_line_number
1144: FROM zx_rates_b rates,
1145: zx_trx_headers_gt header,
1146: zx_transaction_lines_gt lines,
1147: zx_subscription_details sd_rates,
1148: zx_import_tax_lines_gt taxlines
1149: WHERE TaxLines.tax_regime_Code = rates.tax_regime_code(+)

Line 1257: zx_trx_headers_gt header,

1253: TaxLines.event_class_code event_class_code,
1254: TaxLines.trx_id trx_id,
1255: TaxLines.summary_tax_line_number summary_tax_line_number
1256: FROM zx_rates_b rates,
1257: zx_trx_headers_gt header,
1258: zx_transaction_lines_gt lines,
1259: zx_subscription_details sd_rates,
1260: zx_import_tax_lines_gt taxlines
1261: WHERE TaxLines.tax_regime_Code = rates.tax_regime_code(+)

Line 1414: ZX_TRX_HEADERS_GT Header,

1410: TaxLines.trx_id,
1411: TaxLines.trx_line_id
1412: FROM ZX_TRX_TAX_LINK_GT TaxLink,
1413: ZX_IMPORT_TAX_LINES_GT TaxLines,
1414: ZX_TRX_HEADERS_GT Header,
1415: ZX_TRANSACTION_LINES_GT Lines,
1416: ZX_TAXES_B tax,
1417: zx_rates_b rate,
1418: zx_subscription_details sd_tax,

Line 1623: ZX_TRX_HEADERS_GT header,

1619: lines_gt.trx_line_id,
1620: lines_gt.trx_level_type
1621:
1622: FROM
1623: ZX_TRX_HEADERS_GT header,
1624: ZX_EVNT_CLS_MAPPINGS evntmap,
1625: ZX_TRANSACTION_LINES_GT lines_gt,
1626: ZX_FC_PRODUCT_CATEGORIES_V fc_prodcat,
1627: ZX_FC_CODES_B fc_user,

Line 1675: FROM ZX_TRX_HEADERS_GT header,

1671: header.trx_id,
1672: lines_gt.trx_line_id,
1673: lines_gt.trx_level_type,
1674: taxlines_gt.summary_tax_line_number
1675: FROM ZX_TRX_HEADERS_GT header,
1676: ZX_REGIMES_B regime ,
1677: ZX_TAXES_B tax ,
1678: ZX_STATUS_B status ,
1679: -- ZX_RATES_B rate ,

Line 1899: --Validations for ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT

1895: 'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR.BEGIN',
1896: 'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR(+)');
1897: END IF;
1898:
1899: --Validations for ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT
1900: IF ( g_level_event >= g_current_runtime_level) THEN
1901: FND_LOG.STRING(g_level_event,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1902: 'Validations for zx_trx_headers_gt and zx_transaction_lines_gt');
1903: END IF;

Line 1902: 'Validations for zx_trx_headers_gt and zx_transaction_lines_gt');

1898:
1899: --Validations for ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT
1900: IF ( g_level_event >= g_current_runtime_level) THEN
1901: FND_LOG.STRING(g_level_event,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1902: 'Validations for zx_trx_headers_gt and zx_transaction_lines_gt');
1903: END IF;
1904:
1905: -- Select the key columns and write into fnd log for debug purpose
1906: IF ( g_level_statement >= g_current_runtime_level) THEN

Line 1982: 'Before insertion into ZX_VALIDATION_ERRORS_GT - zx_trx_headers_gt and zx_transaction_lines_gt');

1978: END IF; -- End of debug checking
1979:
1980: IF ( g_level_statement >= g_current_runtime_level) THEN
1981: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
1982: 'Before insertion into ZX_VALIDATION_ERRORS_GT - zx_trx_headers_gt and zx_transaction_lines_gt');
1983: END IF;
1984:
1985: /******************** Split the Header and Line Level Validations : Bug 4703541******/
1986: /** 1. Validations for the zx_trx_headers_gt related **/

Line 1986: / 1. Validations for the zx_trx_headers_gt related /

1982: 'Before insertion into ZX_VALIDATION_ERRORS_GT - zx_trx_headers_gt and zx_transaction_lines_gt');
1983: END IF;
1984:
1985: /******************** Split the Header and Line Level Validations : Bug 4703541******/
1986: /** 1. Validations for the zx_trx_headers_gt related **/
1987:
1988: INSERT ALL
1989: WHEN (ZX_ROUND_PARTY_MISSING = 'Y') THEN
1990: INTO ZX_VALIDATION_ERRORS_GT(

Line 2367: ZX_TRX_HEADERS_GT header,

2363: THEN 'Y'
2364: ELSE NULL
2365: END ZX_DOC_LVL_RECALC_FLAG_INVALID
2366: FROM
2367: ZX_TRX_HEADERS_GT header,
2368: ZX_EVNT_CLS_MAPPINGS evntmap,
2369: ZX_FC_DOCUMENT_FISCAL_V fc_doc,
2370: FND_TERRITORIES fnd_terr
2371: WHERE

Line 4155: ZX_TRX_HEADERS_GT header,

4151: THEN 'Y'
4152: ELSE NULL END
4153: END TAX_RATE_CODE_NOT_ACTIVE
4154: FROM
4155: ZX_TRX_HEADERS_GT header,
4156: ZX_EVNT_CLS_MAPPINGS evntmap,
4157: ZX_TRANSACTION_LINES_GT lines_gt,
4158: ZX_FC_PRODUCT_CATEGORIES_V fc_prodcat,
4159: ZX_FC_CODES_B fc_user,

Line 5395: FROM ZX_TRX_HEADERS_GT header,

5391: ELSE NULL
5392: END ZX_IMP_TAX_RATE_AMT_MISMATCH
5393:
5394: /* end bug 3676878 */
5395: FROM ZX_TRX_HEADERS_GT header,
5396: ZX_REGIMES_B regime ,
5397: ZX_TAXES_B tax ,
5398: ZX_STATUS_B status ,
5399: -- ZX_RATES_B rate ,

Line 5768: zx_trx_headers_gt header,

5764: )
5765: ) THEN 'Y' ELSE 'N' END
5766: ELSE 'N' END STATUS_SUBSCR_NOT_EFFECTIVE
5767: from
5768: zx_trx_headers_gt header,
5769: zx_transaction_lines_gt lines_gt,
5770: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
5771: ZX_REGIMES_B regime ,
5772: ZX_TAXES_B tax ,

Line 6161: FROM ZX_TRX_HEADERS_GT header,

6157: THEN NULL
6158: ELSE 'Y' END
6159: ELSE NULL
6160: END DEFAULT_RATE_CODE_NOT_EXISTS
6161: FROM ZX_TRX_HEADERS_GT header,
6162: ZX_RATES_B rate ,
6163: zx_rates_b off_rate,
6164: zx_import_tax_lines_gt temp_gt,
6165: ZX_IMPORT_TAX_LINES_GT taxlines_gt,

Line 6421: FROM ZX_TRX_HEADERS_GT header,

6417: -- Check Rate Code is Active
6418: CASE WHEN rate.tax_rate_id IS NOT NULL AND rate.active_flag = 'Y'
6419: THEN 'N'
6420: ELSE 'Y' END TAX_RATE_NOT_ACTIVE
6421: FROM ZX_TRX_HEADERS_GT header,
6422: ZX_RATES_B rate ,
6423: zx_rates_b off_rate,
6424: zx_import_tax_lines_gt temp_gt,
6425: ZX_IMPORT_TAX_LINES_GT taxlines_gt,

Line 6738: update zx_trx_headers_gt set validation_check_flag = 'N' where

6734: END IF;
6735:
6736: -- Bug Fix # 4184091
6737: -- As per the email communication from vidya, changed the flag value from Y to N
6738: update zx_trx_headers_gt set validation_check_flag = 'N' where
6739: trx_id in (select trx_id from zx_validation_errors_gt);
6740:
6741: IF ( SQL%ROWCOUNT > 0 ) THEN
6742: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 6745: 'Updated the validation_check_flag to N in zx_trx_headers_gt for '||to_char(SQL%ROWCOUNT)||' trx_ids ');

6741: IF ( SQL%ROWCOUNT > 0 ) THEN
6742: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6743: IF ( g_level_statement >= g_current_runtime_level) THEN
6744: FND_LOG.STRING(g_level_statement,'ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
6745: 'Updated the validation_check_flag to N in zx_trx_headers_gt for '||to_char(SQL%ROWCOUNT)||' trx_ids ');
6746: END IF;
6747: END IF ;
6748:
6749: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 6798: FROM ZX_TRX_HEADERS_GT header,

6794: header.trx_id,
6795: lines_gt.trx_line_id,
6796: lines_gt.trx_level_type
6797:
6798: FROM ZX_TRX_HEADERS_GT header,
6799: ZX_TRANSACTION_LINES_GT lines_gt
6800:
6801: WHERE lines_gt.application_id = header.application_id
6802: AND lines_gt.entity_code = header.entity_code

Line 7141: -- Also check in zx trx headers gt if this doc is already present

7137:
7138: -- Check for existence of related documents in zx lines det factors table
7139: -- Since the Selection is at the granularity of the transaction lines, also check for existence of
7140: -- error record in validaiton errors gt to avoid inserting header level errors multiple times
7141: -- Also check in zx trx headers gt if this doc is already present
7142: nvl2( header.related_doc_trx_id,
7143: CASE WHEN ((NOT EXISTS
7144: (SELECT 1 FROM ZX_LINES_DET_FACTORS
7145: WHERE application_id = header.related_doc_application_id

Line 7158: (SELECT 1 FROM ZX_TRX_HEADERS_GT

7154: AND trx_id = lines_gt.trx_id
7155: AND trx_line_id < lines_gt.trx_line_id
7156: AND trx_level_type = lines_gt.trx_level_type))
7157: AND ( NOT EXISTS
7158: (SELECT 1 FROM ZX_TRX_HEADERS_GT
7159: WHERE application_id = header.related_doc_application_id
7160: AND entity_code = header.related_doc_entity_code
7161: AND event_class_code = header.related_doc_event_class_code
7162: AND trx_id = header.related_doc_trx_id)))

Line 7311: FROM ZX_TRX_HEADERS_GT header,

7307: THEN 'Y'
7308: ELSE NULL END,
7309: NULL) ZX_SOURCE_DOC_MISSING
7310:
7311: FROM ZX_TRX_HEADERS_GT header,
7312: ZX_TRANSACTION_LINES_GT lines_gt
7313:
7314: WHERE lines_gt.application_id = header.application_id
7315: AND lines_gt.entity_code = header.entity_code

Line 7413: ZX_TRX_HEADERS_GT.ship_third_pty_acct_site_id%TYPE

7409: -- Bug#5066122
7410: -- add structures here to avoid changing spec
7411: --
7412: TYPE ship_thd_pty_acct_ste_id_tbl IS TABLE OF
7413: ZX_TRX_HEADERS_GT.ship_third_pty_acct_site_id%TYPE
7414: INDEX BY BINARY_INTEGER;
7415:
7416: TYPE bill_thd_pty_acct_ste_id_tbl IS TABLE OF
7417: ZX_TRX_HEADERS_GT.bill_third_pty_acct_site_id%TYPE

Line 7417: ZX_TRX_HEADERS_GT.bill_third_pty_acct_site_id%TYPE

7413: ZX_TRX_HEADERS_GT.ship_third_pty_acct_site_id%TYPE
7414: INDEX BY BINARY_INTEGER;
7415:
7416: TYPE bill_thd_pty_acct_ste_id_tbl IS TABLE OF
7417: ZX_TRX_HEADERS_GT.bill_third_pty_acct_site_id%TYPE
7418: INDEX BY BINARY_INTEGER;
7419:
7420: l_ship_thd_pty_acct_ste_id_tbl SHIP_THD_PTY_ACCT_STE_ID_TBL;
7421: l_bill_thd_pty_acct_ste_id_tbl BILL_THD_PTY_ACCT_STE_ID_TBL;

Line 7476: FROM ZX_TRX_HEADERS_GT H,

7472: L.defaulting_attribute9,
7473: L.defaulting_attribute10
7474: -- L.input_tax_classification_code, --Bug 4919842
7475: -- L.output_tax_classification_code --Bug 4919842
7476: FROM ZX_TRX_HEADERS_GT H,
7477: ZX_TRANSACTION_LINES_GT L
7478: WHERE L.application_id = H.application_id
7479: AND L.entity_code = H.entity_code
7480: AND L.event_class_code = H.event_class_code

Line 7577: -- from zx_trx_headers_gt and zx_transaction_lines_gt

7573: l_definforec := l_definforec_null;
7574:
7575: --
7576: -- populate fields in the record with values
7577: -- from zx_trx_headers_gt and zx_transaction_lines_gt
7578: --
7579: -- Bug#4310278- replace line_location_id with
7580: -- ref_doc columns
7581:

Line 8158: ZX_TRX_HEADERS_GT Header

8154: HISTORICAL_TAX_CODE_ID ,
8155: USER_UPD_DET_FACTORS_FLAG -- Bug 4703541
8156: FROM
8157: ZX_TRANSACTION_LINES_GT Lines,
8158: ZX_TRX_HEADERS_GT Header
8159:
8160: WHERE
8161:
8162: Lines.application_id = Header.application_id

Line 8171: l_prev_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;

8167: x_return_status VARCHAR2(20);
8168: l_error_buffer VARCHAR2(240);
8169: l_event_class_rec ZX_API_PUB.event_class_rec_type;
8170:
8171: l_prev_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;
8172: l_prev_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;
8173: l_prev_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;
8174: l_prev_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;
8175:

Line 8172: l_prev_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;

8168: l_error_buffer VARCHAR2(240);
8169: l_event_class_rec ZX_API_PUB.event_class_rec_type;
8170:
8171: l_prev_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;
8172: l_prev_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;
8173: l_prev_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;
8174: l_prev_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;
8175:
8176: l_cur_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;

Line 8173: l_prev_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;

8169: l_event_class_rec ZX_API_PUB.event_class_rec_type;
8170:
8171: l_prev_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;
8172: l_prev_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;
8173: l_prev_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;
8174: l_prev_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;
8175:
8176: l_cur_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;
8177: l_cur_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;

Line 8174: l_prev_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;

8170:
8171: l_prev_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;
8172: l_prev_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;
8173: l_prev_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;
8174: l_prev_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;
8175:
8176: l_cur_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;
8177: l_cur_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;
8178: l_cur_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;

Line 8176: l_cur_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;

8172: l_prev_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;
8173: l_prev_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;
8174: l_prev_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;
8175:
8176: l_cur_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;
8177: l_cur_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;
8178: l_cur_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;
8179: l_cur_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;
8180:

Line 8177: l_cur_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;

8173: l_prev_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;
8174: l_prev_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;
8175:
8176: l_cur_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;
8177: l_cur_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;
8178: l_cur_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;
8179: l_cur_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;
8180:
8181: -- Bug 4703541

Line 8178: l_cur_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;

8174: l_prev_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;
8175:
8176: l_cur_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;
8177: l_cur_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;
8178: l_cur_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;
8179: l_cur_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;
8180:
8181: -- Bug 4703541
8182: -- global_structure_rec ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_rec_type;

Line 8179: l_cur_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;

8175:
8176: l_cur_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;
8177: l_cur_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;
8178: l_cur_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;
8179: l_cur_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;
8180:
8181: -- Bug 4703541
8182: -- global_structure_rec ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_rec_type;
8183:

Line 8729: UPDATE ZX_TRX_HEADERS_GT

8725: AND z.trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_ID(i)
8726: AND z.trx_line_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_ID(i);
8727:
8728: FORALL i IN 1..nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID.last,0)
8729: UPDATE ZX_TRX_HEADERS_GT
8730: SET TAX_INVOICE_NUMBER =
8731: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_INVOICE_NUMBER(i),
8732: TAX_INVOICE_DATE =
8733: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_INVOICE_DATE(i),