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

Line 740: | GTT involved : ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT |

736: /* ======================================================================*
737: | PROCEDURE calculate_tax : Calculates and records tax info |
738: | There exists a pl/sql version of same API for performance |
739: | This API also supports processing for multiple event classes |
740: | GTT involved : ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT |
741: * ======================================================================*/
742:
743: PROCEDURE Calculate_tax
744: ( p_api_version IN NUMBER,

Line 773: FROM ZX_TRX_HEADERS_GT

769: -- ENTITY_CODE,
770: -- EVENT_CLASS_CODE,
771: QUOTE_FLAG,
772: ICX_SESSION_ID
773: FROM ZX_TRX_HEADERS_GT
774: WHERE rownum = 1;
775:
776: CURSOR event_classes IS
777: SELECT distinct

Line 784: ZX_TRX_HEADERS_GT header

780: header.entity_code,
781: header.internal_organization_id,
782: evntmap.processing_precedence
783: FROM ZX_EVNT_CLS_MAPPINGS evntmap,
784: ZX_TRX_HEADERS_GT header
785: WHERE header.application_id = evntmap.application_id
786: AND header.entity_code = evntmap.entity_code
787: AND header.event_class_code = evntmap.event_class_code
788: ORDER BY evntmap.processing_precedence;

Line 799: FROM ZX_TRX_HEADERS_GT;

795: ICX_SESSION_ID,
796: EVENT_TYPE_CODE,
797: TAX_EVENT_TYPE_CODE,
798: DOC_EVENT_STATUS
799: FROM ZX_TRX_HEADERS_GT;
800:
801: l_application_id_tbl NUMBER_tbl_type;
802: l_entity_code_tbl VARCHAR2_30_tbl_type;
803: l_event_class_code_tbl VARCHAR2_30_tbl_type;

Line 924: from ZX_TRX_HEADERS_GT

920: into l_evnt_cls.event_class_code(1),
921: l_evnt_cls.application_id(1),
922: l_evnt_cls.entity_code(1),
923: l_evnt_cls.internal_organization_id(1)
924: from ZX_TRX_HEADERS_GT
925: where rownum=1;
926: END IF;
927:
928: -- added for bug fix 5417887

Line 1189: IN (SELECT /+ cardinality (ZX_TRX_HEADERS_GT 1) / APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID

1185: FORALL i IN l_trx_id_tbl.FIRST .. l_trx_id_tbl.LAST
1186: */
1187: DELETE FROM zx_lines_det_factors
1188: WHERE (APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID)
1189: IN (SELECT /*+ cardinality (ZX_TRX_HEADERS_GT 1) */ APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID
1190: FROM ZX_TRX_HEADERS_GT);
1191:
1192:
1193:

Line 1190: FROM ZX_TRX_HEADERS_GT);

1186: */
1187: DELETE FROM zx_lines_det_factors
1188: WHERE (APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID)
1189: IN (SELECT /*+ cardinality (ZX_TRX_HEADERS_GT 1) */ APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID
1190: FROM ZX_TRX_HEADERS_GT);
1191:
1192:
1193:
1194: /*

Line 1249: IN (SELECT /+ unnest cardinality (ZX_TRX_HEADERS_GT 1) /

1245:
1246: */
1247: DELETE /*+ ORDERED USE_NL_WITH_INDEX (Z,ZX_LINES_DET_FACTORS_U1) */ FROM zx_lines_det_factors Z
1248: WHERE (Z.APPLICATION_ID, Z.ENTITY_CODE, Z.EVENT_CLASS_CODE, Z.TRX_ID)
1249: IN (SELECT /*+ unnest cardinality (ZX_TRX_HEADERS_GT 1) */
1250: APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID
1251: FROM ZX_TRX_HEADERS_GT)
1252: AND Z.line_level_action ='DELETE';
1253:

Line 1251: FROM ZX_TRX_HEADERS_GT)

1247: DELETE /*+ ORDERED USE_NL_WITH_INDEX (Z,ZX_LINES_DET_FACTORS_U1) */ FROM zx_lines_det_factors Z
1248: WHERE (Z.APPLICATION_ID, Z.ENTITY_CODE, Z.EVENT_CLASS_CODE, Z.TRX_ID)
1249: IN (SELECT /*+ unnest cardinality (ZX_TRX_HEADERS_GT 1) */
1250: APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID
1251: FROM ZX_TRX_HEADERS_GT)
1252: AND Z.line_level_action ='DELETE';
1253:
1254:
1255: /*

Line 1315: UPDATE ZX_TRX_HEADERS_GT headers

1311: /*---------------------------------------------------------+
1312: | Set the out parameter |
1313: +--------------------------------------------------------*/
1314: BEGIN
1315: UPDATE ZX_TRX_HEADERS_GT headers
1316: SET doc_level_recalc_flag = (SELECT distinct(lines.threshold_indicator_flag)
1317: FROM ZX_LINES_DET_FACTORS lines
1318: WHERE lines.application_id = headers.application_id
1319: AND lines.event_class_code = headers.event_class_code

Line 2123: | GTT involved : ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT , |

2119:
2120: /* ======================================================================*
2121: | PROCEDURE import_document_with_tax : Imports document with tax |
2122: | This API also supports processing for multiple event classes |
2123: | GTT involved : ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT , |
2124: | ZX_IMPORT_TAX_LINES_GT and ZX_TRX_TAX_LINK_GT |
2125: * ======================================================================*/
2126: PROCEDURE Import_document_with_tax
2127: ( p_api_version IN NUMBER,

Line 2155: ZX_TRX_HEADERS_GT header

2151: header.entity_code,
2152: header.internal_organization_id,
2153: evntmap.processing_precedence
2154: FROM ZX_EVNT_CLS_MAPPINGS evntmap,
2155: ZX_TRX_HEADERS_GT header
2156: WHERE header.application_id = evntmap.application_id
2157: AND header.entity_code = evntmap.entity_code
2158: AND header.event_class_code = evntmap.event_class_code
2159: ORDER BY evntmap.processing_precedence;

Line 2261: from ZX_TRX_HEADERS_GT

2257: into l_evnt_cls.event_class_code(1),
2258: l_evnt_cls.application_id(1),
2259: l_evnt_cls.entity_code(1),
2260: l_evnt_cls.internal_organization_id(1)
2261: from ZX_TRX_HEADERS_GT
2262: where rownum=1;
2263: END IF;
2264:
2265:

Line 4396: | GTT involved : ZX_TRX_HEADERS_GT, ZX_ITM_DISTRIBUTIONS_GT |

4392: /* =======================================================================*
4393: | PROCEDURE determine_recovery : Calculate the distribution of tax amounts
4394: | into recoverable and/or non-recoverable tax amounts. |
4395: | This API also supports processing for multiple event classes |
4396: | GTT involved : ZX_TRX_HEADERS_GT, ZX_ITM_DISTRIBUTIONS_GT |
4397: * =======================================================================*/
4398:
4399: PROCEDURE Determine_recovery
4400: ( p_api_version IN NUMBER,

Line 4435: ZX_TRX_HEADERS_GT header

4431: header.entity_code,
4432: header.internal_organization_id,
4433: evntmap.processing_precedence
4434: FROM ZX_EVNT_CLS_MAPPINGS evntmap,
4435: ZX_TRX_HEADERS_GT header
4436: WHERE header.application_id = evntmap.application_id
4437: AND header.entity_code = evntmap.entity_code
4438: AND header.event_class_code = evntmap.event_class_code
4439: ORDER BY evntmap.processing_precedence;

Line 4453: FROM ZX_TRX_HEADERS_GT

4449: EVENT_CLASS_CODE,
4450: TRX_ID,
4451: QUOTE_FLAG,
4452: ICX_SESSION_ID
4453: FROM ZX_TRX_HEADERS_GT
4454: WHERE event_class_code = p_event_class_code
4455: AND application_id = p_application_id
4456: AND entity_code = p_entity_code
4457: AND (validation_check_flag is null OR

Line 4464: FROM ZX_TRX_HEADERS_GT;

4460: -- added for bug fix 5417887
4461: CURSOR c_headers is
4462: SELECT APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, ICX_SESSION_ID,
4463: EVENT_TYPE_CODE, TAX_EVENT_TYPE_CODE, DOC_EVENT_STATUS
4464: FROM ZX_TRX_HEADERS_GT;
4465:
4466: l_application_id_tbl NUMBER_tbl_type;
4467: l_entity_code_tbl VARCHAR2_30_tbl_type;
4468: l_event_class_code_tbl VARCHAR2_30_tbl_type;

Line 4525: ZX_TRX_HEADERS_GT h,

4521: h.event_class_code event_class_code,
4522: H.trx_id trx_id,
4523: H.quote_flag quote_flag -- Bug 5646787
4524: from
4525: ZX_TRX_HEADERS_GT h,
4526: ZX_EVNT_TYP_MAPPINGS zxevntmap,
4527: ZX_EVNT_CLS_TYPS zxevnttyp
4528: where
4529: zxevntmap.event_class_code = h.event_class_code

Line 4649: FROM ZX_TRX_HEADERS_GT

4645: INTO l_evnt_cls.event_class_code(1),
4646: l_evnt_cls.application_id(1),
4647: l_evnt_cls.internal_organization_id(1),
4648: l_evnt_cls.entity_code(1)
4649: FROM ZX_TRX_HEADERS_GT
4650: WHERE rownum=1;
4651: END IF;
4652:
4653: /*-----------------------------------------+

Line 4687: FROM ZX_TRX_HEADERS_GT

4683: END IF;
4684:
4685: select ICX_SESSION_ID
4686: INTO l_event_class_rec.ICX_SESSION_ID
4687: FROM ZX_TRX_HEADERS_GT
4688: where rownum = 1;
4689:
4690: IF l_event_class_rec.QUOTE_FLAG = 'Y' and
4691: l_event_class_rec.ICX_SESSION_ID is not null THEN

Line 6676: FROM ZX_TRX_HEADERS_GT zthg

6672: , zthg.trx_id
6673: , zetm.event_type_code -- Bug 5598384
6674: , zect.tax_event_type_code
6675: , zect.status_code
6676: FROM ZX_TRX_HEADERS_GT zthg
6677: , ZX_EVNT_TYP_MAPPINGS zetm
6678: , ZX_EVNT_CLS_TYPS zect
6679: WHERE zthg.event_class_code = zetm.event_class_code
6680: AND zthg.entity_code = zetm.entity_code

Line 8148: FROM ZX_TRX_HEADERS_GT headers

8144: SELECT internal_organization_id,
8145: application_id
8146: INTO l_internal_organization_id,
8147: l_app_id
8148: FROM ZX_TRX_HEADERS_GT headers
8149: WHERE rownum =1;
8150:
8151: EXCEPTION
8152: WHEN NO_DATA_FOUND THEN

Line 12145: -- Fetch from zx_trx_headers_gt and zx_trx_transaction_lines_gt into

12141: -- This overloaded procedure acts as a wrapper on TDS default_tax_attribs
12142: -- procedure to default the tax determining attributes. It follows the
12143: -- following logic defaulting the determining attributes.
12144: --
12145: -- Fetch from zx_trx_headers_gt and zx_trx_transaction_lines_gt into
12146: -- global structure zx_global_structures_pkg.trx_line_dist_tbl
12147: -- For records in trx_line_dist_tbl
12148: -- Loop
12149: -- If line_level_action is UPDATE

Line 12221: FROM ZX_TRX_HEADERS_GT;

12217: RNDG_BILL_TO_PARTY_SITE_ID,
12218: RNDG_BILL_FROM_PARTY_SITE_ID,
12219: QUOTE_FLAG,
12220: ESTABLISHMENT_ID
12221: FROM ZX_TRX_HEADERS_GT;
12222:
12223: BEGIN
12224: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
12225: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_API_PUB: '||l_api_name||'()+');