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 189: SELECT count(1) INTO l_count_header FROM zx_trx_headers_gt;

185: SELECT count(1) INTO l_count_link_gt FROM ZX_TRX_TAX_LINK_GT;
186:
187: IF ( g_level_statement >= g_current_runtime_level) THEN
188:
189: SELECT count(1) INTO l_count_header FROM zx_trx_headers_gt;
190: SELECT count(1) INTO l_count_lines FROM zx_transaction_lines_gt;
191:
192: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
193: 'Count of ZX_TRX_HEADERS_GT : '||to_char(l_count_header));

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

189: SELECT count(1) INTO l_count_header FROM zx_trx_headers_gt;
190: SELECT count(1) INTO l_count_lines FROM zx_transaction_lines_gt;
191:
192: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
193: 'Count of ZX_TRX_HEADERS_GT : '||to_char(l_count_header));
194: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
195: 'Count of ZX_TRANSACTION_LINES_GT : '||to_char(l_count_lines));
196: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_AND_VALIDATE_TAX_ATTR',
197: 'Count of ZX_IMPORT_TAX_LINES_GT - Total Tax Lines : '||to_char(l_count_tax_lines));

Line 223: FROM ZX_TRX_HEADERS_GT Header

219:
220: BEGIN
221: SELECT legal_entity_id , internal_organization_id
222: INTO l_le_id, l_ou_id
223: FROM ZX_TRX_HEADERS_GT Header
224: WHERE rownum = 1;
225: EXCEPTION
226: WHEN NO_DATA_FOUND THEN
227: IF (g_level_exception >= g_current_runtime_level ) THEN

Line 500: l_le_id ZX_TRX_HEADERS_GT.legal_entity_id%Type;

496: PROCEDURE Default_Tax_Attr(x_return_status OUT NOCOPY VARCHAR2) IS
497:
498: l_owner_table_code ZX_FC_TYPES_B.owner_table_code%Type;
499: l_owner_id_num ZX_FC_TYPES_B.owner_id_num%Type;
500: l_le_id ZX_TRX_HEADERS_GT.legal_entity_id%Type;
501: l_org_id ZX_TRX_HEADERS_GT.internal_organization_id%Type;
502: l_effective_date Date;
503: l_return_status varchar2(30);
504:

Line 501: l_org_id ZX_TRX_HEADERS_GT.internal_organization_id%Type;

497:
498: l_owner_table_code ZX_FC_TYPES_B.owner_table_code%Type;
499: l_owner_id_num ZX_FC_TYPES_B.owner_id_num%Type;
500: l_le_id ZX_TRX_HEADERS_GT.legal_entity_id%Type;
501: l_org_id ZX_TRX_HEADERS_GT.internal_organization_id%Type;
502: l_effective_date Date;
503: l_return_status varchar2(30);
504:
505: --Bug 5018766 : Added for Defaulting the Tax Dates on the Newly added columns in zx_transaction_lines_gt

Line 533: FROM zx_trx_headers_gt header,

529: COALESCE(header.related_doc_date,
530: header.provnl_tax_determination_date,
531: Lines.adjusted_doc_date,
532: header.trx_date) subscription_date
533: FROM zx_trx_headers_gt header,
534: zx_transaction_lines_gt lines
535: WHERE header.application_id = lines.application_id
536: AND header.entity_code = lines.entity_code
537: AND header.event_class_code = lines.event_class_code

Line 630: ZX_TRX_HEADERS_GT Header,

626: TaxLines_gt.event_class_code event_class_code,
627: TaxLines_gt.trx_id trx_id,
628: TaxLines_gt.summary_tax_line_number summary_tax_line_number
629: FROM ZX_IMPORT_TAX_LINES_GT TaxLines_gt,
630: ZX_TRX_HEADERS_GT Header,
631: ZX_TRANSACTION_LINES_GT Lines
632: WHERE TaxLines_gt.application_id = Header.application_id
633: AND TaxLines_gt.entity_code = Header.entity_code
634: AND TaxLines_gt.event_class_code = Header.event_class_code

Line 682: ZX_TRX_HEADERS_GT Header,

678: TaxLines_gt.event_class_code event_class_code,
679: TaxLines_gt.trx_id trx_id,
680: TaxLines_gt.summary_tax_line_number summary_tax_line_number
681: FROM ZX_IMPORT_TAX_LINES_GT TaxLines_gt,
682: ZX_TRX_HEADERS_GT Header,
683: ZX_TRANSACTION_LINES_GT Lines
684: WHERE TaxLines_gt.application_id = Header.application_id
685: AND TaxLines_gt.entity_code = Header.entity_code
686: AND TaxLines_gt.event_class_code = Header.event_class_code

Line 749: ZX_TRX_HEADERS_GT Header,

745: TaxLines_gt.event_class_code event_class_code,
746: TaxLines_gt.trx_id trx_id,
747: TaxLines_gt.summary_tax_line_number summary_tax_line_number
748: FROM ZX_IMPORT_TAX_LINES_GT TaxLines_gt,
749: ZX_TRX_HEADERS_GT Header,
750: ZX_TRANSACTION_LINES_GT Lines
751: WHERE TaxLines_gt.application_id = Header.application_id
752: AND TaxLines_gt.entity_code = Header.entity_code
753: AND TaxLines_gt.event_class_code = Header.event_class_code

Line 794: 'Defaulting for Taxation Country in ZX_TRX_HEADERS_GT');

790: --Defaulting for Taxation Country
791: IF (g_level_statement >= g_current_runtime_level ) THEN
792: FND_LOG.STRING(g_level_statement,
793: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
794: 'Defaulting for Taxation Country in ZX_TRX_HEADERS_GT');
795: END IF;
796:
797: UPDATE ZX_TRX_HEADERS_GT Header
798: SET default_taxation_country =

Line 797: UPDATE ZX_TRX_HEADERS_GT Header

793: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.DEFAULT_TAX_ATTR',
794: 'Defaulting for Taxation Country in ZX_TRX_HEADERS_GT');
795: END IF;
796:
797: UPDATE ZX_TRX_HEADERS_GT Header
798: SET default_taxation_country =
799: (SELECT le.country
800: FROM XLE_FIRSTPARTY_INFORMATION_V le
801: WHERE le.legal_entity_id = Header.legal_entity_id

Line 842: ZX_TRX_HEADERS_GT Header,

838: TaxLines_gt.trx_id trx_id,
839: TaxLines_gt.summary_tax_line_number summary_tax_line_number
840: FROM ZX_FC_COUNTRY_DEFAULTS ContDef,
841: ZX_IMPORT_TAX_LINES_GT TaxLines_gt,
842: ZX_TRX_HEADERS_GT Header,
843: --ZX_TRANSACTION_LINES_GT Lines,
844: ZX_RATES_B rates,
845: ZX_SUBSCRIPTION_DETAILS sd_rates
846: WHERE TaxLines_gt.tax_rate_code = rates.tax_rate_code(+)

Line 973: ZX_TRX_HEADERS_GT Header,

969: TaxLines_gt.trx_id trx_id,
970: TaxLines_gt.summary_tax_line_number summary_tax_line_number
971: FROM ZX_FC_COUNTRY_DEFAULTS ContDef,
972: ZX_IMPORT_TAX_LINES_GT TaxLines_gt,
973: ZX_TRX_HEADERS_GT Header,
974: --ZX_TRANSACTION_LINES_GT Lines,
975: ZX_RATES_B rates,
976: ZX_SUBSCRIPTION_DETAILS sd_rates
977: WHERE TaxLines_gt.tax_rate_id = rates.tax_rate_id(+)

Line 1099: ZX_TRX_HEADERS_GT Header,

1095: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines
1096: SET tax_status_code =
1097: (SELECT Status.tax_status_code
1098: FROM ZX_STATUS_B Status,
1099: ZX_TRX_HEADERS_GT Header,
1100: --ZX_TRANSACTION_LINES_GT Lines,
1101: ZX_SUBSCRIPTION_DETAILS sd_status,
1102: ZX_RATES_B rates,
1103: ZX_SUBSCRIPTION_DETAILS sd_rates

Line 1245: ZX_TRX_HEADERS_GT Header,

1241: SET tax_provider_id =
1242: (SELECT /*+ leading (mapp) */ srvc.srvc_provider_id
1243: FROM ZX_SRVC_SUBSCRIPTIONS srvc,
1244: ZX_REGIMES_USAGES reg,
1245: ZX_TRX_HEADERS_GT Header,
1246: --ZX_TRANSACTION_LINES_GT Lines,
1247: ZX_EVNT_CLS_MAPPINGS mapp
1248: WHERE reg.tax_regime_code = TaxLines.tax_regime_code
1249: AND srvc.regime_usage_id = reg.regime_usage_id

Line 1345: ZX_TRX_HEADERS_GT Header,

1341: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines
1342: SET tax_jurisdiction_code =
1343: (SELECT jur.TAX_JURISDICTION_CODE
1344: FROM ZX_JURISDICTIONS_B Jur,
1345: ZX_TRX_HEADERS_GT Header,
1346: --ZX_TRANSACTION_LINES_GT Lines,
1347: ZX_RATES_B rates,
1348: ZX_SUBSCRIPTION_DETAILS sd_rates
1349: WHERE Jur.tax = TaxLines.Tax

Line 1482: zx_trx_headers_gt header,

1478: TaxLines_gt.event_class_code event_class_code,
1479: TaxLines_gt.trx_id trx_id,
1480: TaxLines_gt.summary_tax_line_number summary_tax_line_number
1481: FROM zx_rates_b rates,
1482: zx_trx_headers_gt header,
1483: --zx_transaction_lines_gt lines,
1484: zx_subscription_details sd_rates,
1485: zx_import_tax_lines_gt taxlines_gt
1486: WHERE TaxLines_gt.tax_regime_Code = rates.tax_regime_code(+)

Line 1624: zx_trx_headers_gt header,

1620: TaxLines_gt.event_class_code event_class_code,
1621: TaxLines_gt.trx_id trx_id,
1622: TaxLines_gt.summary_tax_line_number summary_tax_line_number
1623: FROM zx_rates_b rates,
1624: zx_trx_headers_gt header,
1625: --zx_transaction_lines_gt lines,
1626: zx_subscription_details sd_rates,
1627: zx_import_tax_lines_gt taxlines_gt
1628: WHERE TaxLines_gt.tax_regime_Code = rates.tax_regime_code(+)

Line 1756: ZX_TRX_HEADERS_GT Header,

1752: TaxLines.trx_id,
1753: TaxLines.trx_line_id
1754: FROM ZX_TRX_TAX_LINK_GT TaxLink,
1755: ZX_IMPORT_TAX_LINES_GT TaxLines,
1756: ZX_TRX_HEADERS_GT Header,
1757: ZX_TRANSACTION_LINES_GT Lines,
1758: ZX_TAXES_B tax,
1759: zx_rates_b rate,
1760: zx_subscription_details sd_tax,

Line 1968: FROM ZX_TRX_HEADERS_GT header,

1964: header.event_class_code,
1965: header.trx_id,
1966: lines_gt.trx_line_id,
1967: lines_gt.trx_level_type
1968: FROM ZX_TRX_HEADERS_GT header,
1969: ZX_EVNT_CLS_MAPPINGS evntmap,
1970: ZX_TRANSACTION_LINES_GT lines_gt,
1971: ZX_FC_PRODUCT_CATEGORIES_V fc_prodcat,
1972: ZX_FC_CODES_B fc_user,

Line 2013: FROM ZX_TRX_HEADERS_GT header,

2009: header.trx_id,
2010: lines_gt.trx_line_id,
2011: lines_gt.trx_level_type,
2012: taxlines_gt.summary_tax_line_number
2013: FROM ZX_TRX_HEADERS_GT header,
2014: ZX_REGIMES_B regime ,
2015: ZX_TAXES_B tax ,
2016: ZX_STATUS_B status ,
2017: -- ZX_RATES_B rate ,

Line 2225: --Validations for ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT

2221: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR.BEGIN',
2222: 'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR(+)');
2223: END IF;
2224:
2225: --Validations for ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT
2226: IF (g_level_statement >= g_current_runtime_level) THEN
2227: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
2228: 'Validations for ZX_TRX_HEADERS_GT and ZX_TRANSACTION_LINES_GT');
2229: END IF;

Line 2228: 'Validations for ZX_TRX_HEADERS_GT and ZX_TRANSACTION_LINES_GT');

2224:
2225: --Validations for ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT
2226: IF (g_level_statement >= g_current_runtime_level) THEN
2227: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
2228: 'Validations for ZX_TRX_HEADERS_GT and ZX_TRANSACTION_LINES_GT');
2229: END IF;
2230:
2231: -- Select the key columns and write into fnd log for debug purpose
2232: IF ( g_level_statement >= g_current_runtime_level) THEN

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

2276: END IF; -- End of debug checking
2277:
2278:
2279: /******************** Split the Header and Line Level Validations : Bug 4703541******/
2280: /** 1. Validations for the zx_trx_headers_gt related **/
2281: IF ( g_level_statement >= g_current_runtime_level) THEN
2282: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
2283: 'Running Header Related Validations : ZX_TRX_HEADERS_GT');
2284: END IF;

Line 2283: 'Running Header Related Validations : ZX_TRX_HEADERS_GT');

2279: /******************** Split the Header and Line Level Validations : Bug 4703541******/
2280: /** 1. Validations for the zx_trx_headers_gt related **/
2281: IF ( g_level_statement >= g_current_runtime_level) THEN
2282: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
2283: 'Running Header Related Validations : ZX_TRX_HEADERS_GT');
2284: END IF;
2285:
2286: INSERT ALL
2287: WHEN (ZX_ROUND_PARTY_MISSING = 'Y') THEN

Line 2659: ZX_TRX_HEADERS_GT header,

2655: THEN 'Y'
2656: ELSE NULL
2657: END ZX_DOC_LVL_RECALC_FLAG_INVALID
2658: FROM
2659: ZX_TRX_HEADERS_GT header,
2660: ZX_EVNT_CLS_MAPPINGS evntmap,
2661: ZX_FC_DOCUMENT_FISCAL_V fc_doc,
2662: FND_TERRITORIES fnd_terr
2663: WHERE

Line 4656: ZX_TRX_HEADERS_GT header,

4652: ELSE NULL
4653: END
4654: END TAX_RATE_CODE_NOT_ACTIVE
4655: FROM
4656: ZX_TRX_HEADERS_GT header,
4657: ZX_EVNT_CLS_MAPPINGS evntmap,
4658: ZX_TRANSACTION_LINES_GT lines_gt,
4659: --ZX_FC_PRODUCT_CATEGORIES_V fc_prodcat,
4660: --ZX_FC_CODES_B fc_user,

Line 5422: FROM ZX_TRX_HEADERS_GT header,

5418: ELSE NULL
5419: END ZX_IMP_TAX_RATE_AMT_MISMATCH
5420:
5421: /* end bug 3676878 */
5422: FROM ZX_TRX_HEADERS_GT header,
5423: ZX_REGIMES_B regime ,
5424: ZX_TAXES_B tax ,
5425: ZX_STATUS_B status ,
5426: -- ZX_RATES_B rate ,

Line 6173: FROM ZX_TRX_HEADERS_GT header,

6169: 'Y'
6170: ELSE
6171: 'N'
6172: END ZX_TAX_MISSING_IN_ADJUSTED_TO
6173: FROM ZX_TRX_HEADERS_GT header,
6174: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
6175: zx_transaction_lines_gt lines_gt
6176: WHERE taxlines_gt.trx_id = header.trx_id
6177: AND taxlines_gt.application_id = Header.application_id

Line 6712: FROM ZX_TRX_HEADERS_GT header,

6708: 'Y'
6709: ELSE
6710: 'N'
6711: END ZX_TAX_MISSING_IN_ADJUSTED_TO
6712: FROM ZX_TRX_HEADERS_GT header,
6713: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
6714: zx_transaction_lines_gt lines_gt
6715: WHERE taxlines_gt.trx_id = header.trx_id
6716: AND taxlines_gt.application_id = Header.application_id

Line 7267: FROM ZX_TRX_HEADERS_GT header,

7263: 'Y'
7264: ELSE
7265: 'N'
7266: END ZX_TAX_MISSING_IN_ADJUSTED_TO
7267: FROM ZX_TRX_HEADERS_GT header,
7268: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
7269: zx_transaction_lines_gt lines_gt
7270: WHERE taxlines_gt.trx_id = header.trx_id
7271: AND taxlines_gt.application_id = Header.application_id

Line 7491: zx_trx_headers_gt header,

7487: END
7488: ELSE 'N'
7489: END STATUS_SUBSCR_NOT_EFFECTIVE
7490: from
7491: zx_trx_headers_gt header,
7492: --zx_transaction_lines_gt lines_gt,
7493: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
7494: ZX_REGIMES_B regime ,
7495: ZX_TAXES_B tax ,

Line 7890: FROM ZX_TRX_HEADERS_GT header,

7886: ELSE 'Y'
7887: END
7888: ELSE NULL
7889: END DEFAULT_RATE_CODE_NOT_EXISTS
7890: FROM ZX_TRX_HEADERS_GT header,
7891: ZX_RATES_B rate ,
7892: zx_rates_b off_rate,
7893: zx_import_tax_lines_gt temp_gt,
7894: ZX_IMPORT_TAX_LINES_GT taxlines_gt,

Line 8167: FROM ZX_TRX_HEADERS_GT header,

8163: CASE WHEN rate.tax_rate_id IS NOT NULL AND rate.active_flag = 'Y'
8164: THEN 'N'
8165: ELSE 'Y'
8166: END TAX_RATE_NOT_ACTIVE
8167: FROM ZX_TRX_HEADERS_GT header,
8168: ZX_RATES_B rate ,
8169: zx_rates_b off_rate,
8170: zx_import_tax_lines_gt temp_gt,
8171: ZX_IMPORT_TAX_LINES_GT taxlines_gt,

Line 8441: UPDATE zx_trx_headers_gt

8437: END IF;
8438:
8439: -- Bug Fix # 4184091
8440: -- As per the email communication from vidya, changed the flag value from Y to N
8441: UPDATE zx_trx_headers_gt
8442: SET validation_check_flag = 'N'
8443: WHERE trx_id IN (SELECT trx_id FROM zx_validation_errors_gt);
8444:
8445: IF ( SQL%ROWCOUNT > 0 ) THEN

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

8445: IF ( SQL%ROWCOUNT > 0 ) THEN
8446: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8447: IF ( g_level_statement >= g_current_runtime_level) THEN
8448: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_VALIDATE_API_PKG.VALIDATE_TAX_ATTR',
8449: 'Updated the validation_check_flag to N in zx_trx_headers_gt for '||to_char(SQL%ROWCOUNT)||' trx_ids ');
8450: END IF;
8451: END IF ;
8452:
8453: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 8506: FROM ZX_TRX_HEADERS_GT header,

8502: header.event_class_code,
8503: header.trx_id,
8504: lines_gt.trx_line_id,
8505: lines_gt.trx_level_type
8506: FROM ZX_TRX_HEADERS_GT header,
8507: ZX_TRANSACTION_LINES_GT lines_gt
8508: WHERE lines_gt.application_id = header.application_id
8509: AND lines_gt.entity_code = header.entity_code
8510: AND lines_gt.event_class_code = header.event_class_code

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

8804:
8805: -- Check for existence of related documents in zx lines det factors table
8806: -- Since the Selection is at the granularity of the transaction lines, also check for existence of
8807: -- error record in validaiton errors gt to avoid inserting header level errors multiple times
8808: -- Also check in zx trx headers gt if this doc is already present
8809: nvl2( header.related_doc_trx_id,
8810: CASE WHEN ((NOT EXISTS
8811: (SELECT 1 FROM ZX_LINES_DET_FACTORS
8812: WHERE application_id = header.related_doc_application_id

Line 8825: (SELECT 1 FROM ZX_TRX_HEADERS_GT

8821: AND trx_id = lines_gt.trx_id
8822: AND trx_line_id < lines_gt.trx_line_id
8823: AND trx_level_type = lines_gt.trx_level_type))
8824: AND ( NOT EXISTS
8825: (SELECT 1 FROM ZX_TRX_HEADERS_GT
8826: WHERE application_id = header.related_doc_application_id
8827: AND entity_code = header.related_doc_entity_code
8828: AND event_class_code = header.related_doc_event_class_code
8829: AND trx_id = header.related_doc_trx_id)))

Line 8997: FROM ZX_TRX_HEADERS_GT header,

8993: THEN 'Y'
8994: ELSE NULL
8995: END,
8996: NULL) ZX_SOURCE_DOC_MISSING
8997: FROM ZX_TRX_HEADERS_GT header,
8998: ZX_TRANSACTION_LINES_GT lines_gt
8999: WHERE lines_gt.application_id = header.application_id
9000: AND lines_gt.entity_code = header.entity_code
9001: AND lines_gt.event_class_code = header.event_class_code

Line 9101: ZX_TRX_HEADERS_GT.ship_third_pty_acct_site_id%TYPE

9097: -- Bug#5066122
9098: -- add structures here to avoid changing spec
9099: --
9100: TYPE ship_thd_pty_acct_ste_id_tbl IS TABLE OF
9101: ZX_TRX_HEADERS_GT.ship_third_pty_acct_site_id%TYPE
9102: INDEX BY BINARY_INTEGER;
9103:
9104: TYPE bill_thd_pty_acct_ste_id_tbl IS TABLE OF
9105: ZX_TRX_HEADERS_GT.bill_third_pty_acct_site_id%TYPE

Line 9105: ZX_TRX_HEADERS_GT.bill_third_pty_acct_site_id%TYPE

9101: ZX_TRX_HEADERS_GT.ship_third_pty_acct_site_id%TYPE
9102: INDEX BY BINARY_INTEGER;
9103:
9104: TYPE bill_thd_pty_acct_ste_id_tbl IS TABLE OF
9105: ZX_TRX_HEADERS_GT.bill_third_pty_acct_site_id%TYPE
9106: INDEX BY BINARY_INTEGER;
9107:
9108: l_ship_thd_pty_acct_ste_id_tbl SHIP_THD_PTY_ACCT_STE_ID_TBL;
9109: l_bill_thd_pty_acct_ste_id_tbl BILL_THD_PTY_ACCT_STE_ID_TBL;

Line 9164: FROM ZX_TRX_HEADERS_GT H,

9160: L.defaulting_attribute9,
9161: L.defaulting_attribute10
9162: -- L.input_tax_classification_code, --Bug 4919842
9163: -- L.output_tax_classification_code --Bug 4919842
9164: FROM ZX_TRX_HEADERS_GT H,
9165: ZX_TRANSACTION_LINES_GT L
9166: WHERE L.application_id = H.application_id
9167: AND L.entity_code = H.entity_code
9168: AND L.event_class_code = H.event_class_code

Line 9263: -- from zx_trx_headers_gt and zx_transaction_lines_gt

9259: l_definforec := l_definforec_null;
9260:
9261: --
9262: -- populate fields in the record with values
9263: -- from zx_trx_headers_gt and zx_transaction_lines_gt
9264: --
9265: -- Bug#4310278- replace line_location_id with
9266: -- ref_doc columns
9267:

Line 9840: ZX_TRX_HEADERS_GT Header

9836: HISTORICAL_TAX_CODE_ID ,
9837: USER_UPD_DET_FACTORS_FLAG -- Bug 4703541
9838: FROM
9839: ZX_TRANSACTION_LINES_GT Lines,
9840: ZX_TRX_HEADERS_GT Header
9841:
9842: WHERE
9843: Lines.application_id = Header.application_id
9844: AND Lines.entity_code = Header.entity_code

Line 9852: l_prev_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;

9848: x_return_status VARCHAR2(20);
9849: l_error_buffer VARCHAR2(240);
9850: l_event_class_rec ZX_API_PUB.event_class_rec_type;
9851:
9852: l_prev_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;
9853: l_prev_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;
9854: l_prev_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;
9855: l_prev_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;
9856:

Line 9853: l_prev_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;

9849: l_error_buffer VARCHAR2(240);
9850: l_event_class_rec ZX_API_PUB.event_class_rec_type;
9851:
9852: l_prev_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;
9853: l_prev_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;
9854: l_prev_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;
9855: l_prev_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;
9856:
9857: l_cur_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;

Line 9854: l_prev_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;

9850: l_event_class_rec ZX_API_PUB.event_class_rec_type;
9851:
9852: l_prev_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;
9853: l_prev_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;
9854: l_prev_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;
9855: l_prev_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;
9856:
9857: l_cur_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;
9858: l_cur_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;

Line 9855: l_prev_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;

9851:
9852: l_prev_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;
9853: l_prev_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;
9854: l_prev_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;
9855: l_prev_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;
9856:
9857: l_cur_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;
9858: l_cur_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;
9859: l_cur_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;

Line 9857: l_cur_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;

9853: l_prev_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;
9854: l_prev_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;
9855: l_prev_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;
9856:
9857: l_cur_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;
9858: l_cur_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;
9859: l_cur_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;
9860: l_cur_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;
9861:

Line 9858: l_cur_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;

9854: l_prev_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;
9855: l_prev_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;
9856:
9857: l_cur_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;
9858: l_cur_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;
9859: l_cur_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;
9860: l_cur_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;
9861:
9862: -- Bug 4703541

Line 9859: l_cur_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;

9855: l_prev_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;
9856:
9857: l_cur_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;
9858: l_cur_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;
9859: l_cur_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;
9860: l_cur_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;
9861:
9862: -- Bug 4703541
9863: -- global_structure_rec ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_rec_type;

Line 9860: l_cur_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;

9856:
9857: l_cur_trx_id ZX_TRX_HEADERS_GT.TRX_ID%TYPE;
9858: l_cur_application_id ZX_TRX_HEADERS_GT.APPLICATION_ID%TYPE;
9859: l_cur_entity_code ZX_TRX_HEADERS_GT.ENTITY_CODE%TYPE;
9860: l_cur_event_class_code ZX_TRX_HEADERS_GT.EVENT_CLASS_CODE%TYPE;
9861:
9862: -- Bug 4703541
9863: -- global_structure_rec ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_rec_type;
9864:

Line 10416: UPDATE ZX_TRX_HEADERS_GT

10412: AND z.trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_ID(i)
10413: AND z.trx_line_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_ID(i);
10414:
10415: FORALL i IN 1..nvl(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID.last,0)
10416: UPDATE ZX_TRX_HEADERS_GT
10417: SET TAX_INVOICE_NUMBER =
10418: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_INVOICE_NUMBER(i),
10419: TAX_INVOICE_DATE =
10420: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_INVOICE_DATE(i),