DBA Data[Home] [Help]

APPS.JAI_TAX_PROCESSING_PKG dependencies on ZX_GLOBAL_STRUCTURES_PKG

Line 934: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.in procedure', ' global_struction_pkg.application_id: '||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.application_id||';'

930: || 'p_event_class_rec.TAX_EVENT_CLASS_CODE :' ||p_event_class_rec.TAX_EVENT_CLASS_CODE||';'
931: || 'p_event_class_rec.trx_id :' ||p_event_class_rec.trx_id||';'
932:
933: );
934: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.in procedure', ' global_struction_pkg.application_id: '||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.application_id||';'
935: || 'global_struction_pkg.entity_code :' ||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.entity_code||';'
936: || 'global_struction_pkg.TAX_EVENT_CLASS_CODE :' ||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.TAX_EVENT_CLASS_CODE||';'
937: || 'global_struction_pkg.trx_id :' ||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.trx_id||';'
938:

Line 935: || 'global_struction_pkg.entity_code :' ||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.entity_code||';'

931: || 'p_event_class_rec.trx_id :' ||p_event_class_rec.trx_id||';'
932:
933: );
934: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.in procedure', ' global_struction_pkg.application_id: '||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.application_id||';'
935: || 'global_struction_pkg.entity_code :' ||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.entity_code||';'
936: || 'global_struction_pkg.TAX_EVENT_CLASS_CODE :' ||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.TAX_EVENT_CLASS_CODE||';'
937: || 'global_struction_pkg.trx_id :' ||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.trx_id||';'
938:
939: );

Line 936: || 'global_struction_pkg.TAX_EVENT_CLASS_CODE :' ||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.TAX_EVENT_CLASS_CODE||';'

932:
933: );
934: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.in procedure', ' global_struction_pkg.application_id: '||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.application_id||';'
935: || 'global_struction_pkg.entity_code :' ||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.entity_code||';'
936: || 'global_struction_pkg.TAX_EVENT_CLASS_CODE :' ||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.TAX_EVENT_CLASS_CODE||';'
937: || 'global_struction_pkg.trx_id :' ||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.trx_id||';'
938:
939: );
940: end if;

Line 937: || 'global_struction_pkg.trx_id :' ||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.trx_id||';'

933: );
934: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.in procedure', ' global_struction_pkg.application_id: '||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.application_id||';'
935: || 'global_struction_pkg.entity_code :' ||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.entity_code||';'
936: || 'global_struction_pkg.TAX_EVENT_CLASS_CODE :' ||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.TAX_EVENT_CLASS_CODE||';'
937: || 'global_struction_pkg.trx_id :' ||ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.trx_id||';'
938:
939: );
940: end if;
941:

Line 945: --IF ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.application_id = 222 --Indicates AR Module

941:
942:
943:
944: IF p_event_class_rec.application_id = 222 --Indicates AR Module
945: --IF ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.application_id = 222 --Indicates AR Module
946: THEN
947: NULL;
948: --IF ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.entity_code = 'TRANSACTIONS'
949: IF p_event_class_rec.entity_code = 'TRANSACTIONS'

Line 948: --IF ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.entity_code = 'TRANSACTIONS'

944: IF p_event_class_rec.application_id = 222 --Indicates AR Module
945: --IF ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.application_id = 222 --Indicates AR Module
946: THEN
947: NULL;
948: --IF ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.entity_code = 'TRANSACTIONS'
949: IF p_event_class_rec.entity_code = 'TRANSACTIONS'
950: --AND ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.TAX_EVENT_CLASS_CODE = 'SALES_TRANSACTION'
951: AND p_event_class_rec.TAX_EVENT_CLASS_CODE = 'SALES_TRANSACTION'
952: THEN

Line 950: --AND ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.TAX_EVENT_CLASS_CODE = 'SALES_TRANSACTION'

946: THEN
947: NULL;
948: --IF ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.entity_code = 'TRANSACTIONS'
949: IF p_event_class_rec.entity_code = 'TRANSACTIONS'
950: --AND ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.TAX_EVENT_CLASS_CODE = 'SALES_TRANSACTION'
951: AND p_event_class_rec.TAX_EVENT_CLASS_CODE = 'SALES_TRANSACTION'
952: THEN
953: lv_action := JAI_CONSTANTS.inserting;
954:

Line 957: --OPEN c_ra_customer_trx(ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.trx_id);

953: lv_action := JAI_CONSTANTS.inserting;
954:
955:
956:
957: --OPEN c_ra_customer_trx(ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.trx_id);
958: OPEN c_ra_customer_trx(p_event_class_rec.trx_id);
959: FETCH c_ra_customer_trx INTO t_ra_customer_trx_rec;
960: CLOSE c_ra_customer_trx;
961:

Line 964: --FOR rec_trx_lines in c_ra_cust_trx_lines(ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.trx_id)

960: CLOSE c_ra_customer_trx;
961:
962: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX for transaction ' || t_ra_customer_trx_rec.customer_trx_id);
963:
964: --FOR rec_trx_lines in c_ra_cust_trx_lines(ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.trx_id)
965: FOR rec_trx_lines in c_ra_cust_trx_lines(p_event_class_rec.trx_id)
966: LOOP
967:
968: /*FOR i IN 1 .. ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.application_id.count

Line 968: /*FOR i IN 1 .. ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.application_id.count

964: --FOR rec_trx_lines in c_ra_cust_trx_lines(ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.trx_id)
965: FOR rec_trx_lines in c_ra_cust_trx_lines(p_event_class_rec.trx_id)
966: LOOP
967:
968: /*FOR i IN 1 .. ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.application_id.count
969: LOOP*/
970:
971: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX into loop for transaction ' || t_ra_customer_trx_rec.customer_trx_id);
972:

Line 976: /*SELECT ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.trx_line_id(i)

972:
973:
974: ln_trx_line_id := rec_trx_lines.customer_trx_line_id;
975:
976: /*SELECT ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.trx_line_id(i)
977: INTO ln_trx_line_id
978: FROM DUAL
979: WHERE ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.trx_id(i) = ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.trx_id
980: AND ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.entity_code(i) = 'TRANSACTIONS'

Line 979: WHERE ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.trx_id(i) = ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.trx_id

975:
976: /*SELECT ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.trx_line_id(i)
977: INTO ln_trx_line_id
978: FROM DUAL
979: WHERE ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.trx_id(i) = ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.trx_id
980: AND ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.entity_code(i) = 'TRANSACTIONS'
981: --AND ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.event_class_code(i) = 'INVOICE'
982: --AND ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.event_type_code(i) = 'INV_CREATE'
983: ;*/

Line 980: AND ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.entity_code(i) = 'TRANSACTIONS'

976: /*SELECT ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.trx_line_id(i)
977: INTO ln_trx_line_id
978: FROM DUAL
979: WHERE ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.trx_id(i) = ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.trx_id
980: AND ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.entity_code(i) = 'TRANSACTIONS'
981: --AND ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.event_class_code(i) = 'INVOICE'
982: --AND ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.event_type_code(i) = 'INV_CREATE'
983: ;*/
984:

Line 981: --AND ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.event_class_code(i) = 'INVOICE'

977: INTO ln_trx_line_id
978: FROM DUAL
979: WHERE ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.trx_id(i) = ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.trx_id
980: AND ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.entity_code(i) = 'TRANSACTIONS'
981: --AND ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.event_class_code(i) = 'INVOICE'
982: --AND ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.event_type_code(i) = 'INV_CREATE'
983: ;*/
984:
985: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX get trx line id ' || ln_trx_line_id);

Line 982: --AND ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.event_type_code(i) = 'INV_CREATE'

978: FROM DUAL
979: WHERE ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.trx_id(i) = ZX_GLOBAL_STRUCTURES_PKG.G_EVENT_CLASS_REC.trx_id
980: AND ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.entity_code(i) = 'TRANSACTIONS'
981: --AND ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.event_class_code(i) = 'INVOICE'
982: --AND ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.event_type_code(i) = 'INV_CREATE'
983: ;*/
984:
985: fnd_file.put_line(FND_FILE.LOG,'Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX get trx line id ' || ln_trx_line_id);
986:

Line 1434: IF (zx_global_structures_pkg.g_event_class_rec.application_id = 200) THEN --Indicates AP Module

1430: lv_return_message VARCHAR2(2000);
1431:
1432:
1433: BEGIN
1434: IF (zx_global_structures_pkg.g_event_class_rec.application_id = 200) THEN --Indicates AP Module
1435:
1436: IF zx_global_structures_pkg.g_event_class_rec.event_class_code IN ('STANDARD INVOICES' ) AND
1437: zx_global_structures_pkg.g_event_class_rec.tax_event_type_code IN ('VALIDATE' ) AND
1438: zx_global_structures_pkg.g_event_class_rec.event_type_code IN ('STANDARD VALIDATED TAX')

Line 1436: IF zx_global_structures_pkg.g_event_class_rec.event_class_code IN ('STANDARD INVOICES' ) AND

1432:
1433: BEGIN
1434: IF (zx_global_structures_pkg.g_event_class_rec.application_id = 200) THEN --Indicates AP Module
1435:
1436: IF zx_global_structures_pkg.g_event_class_rec.event_class_code IN ('STANDARD INVOICES' ) AND
1437: zx_global_structures_pkg.g_event_class_rec.tax_event_type_code IN ('VALIDATE' ) AND
1438: zx_global_structures_pkg.g_event_class_rec.event_type_code IN ('STANDARD VALIDATED TAX')
1439: THEN
1440:

Line 1437: zx_global_structures_pkg.g_event_class_rec.tax_event_type_code IN ('VALIDATE' ) AND

1433: BEGIN
1434: IF (zx_global_structures_pkg.g_event_class_rec.application_id = 200) THEN --Indicates AP Module
1435:
1436: IF zx_global_structures_pkg.g_event_class_rec.event_class_code IN ('STANDARD INVOICES' ) AND
1437: zx_global_structures_pkg.g_event_class_rec.tax_event_type_code IN ('VALIDATE' ) AND
1438: zx_global_structures_pkg.g_event_class_rec.event_type_code IN ('STANDARD VALIDATED TAX')
1439: THEN
1440:
1441: lv_action := JAI_CONSTANTS.updating;

Line 1438: zx_global_structures_pkg.g_event_class_rec.event_type_code IN ('STANDARD VALIDATED TAX')

1434: IF (zx_global_structures_pkg.g_event_class_rec.application_id = 200) THEN --Indicates AP Module
1435:
1436: IF zx_global_structures_pkg.g_event_class_rec.event_class_code IN ('STANDARD INVOICES' ) AND
1437: zx_global_structures_pkg.g_event_class_rec.tax_event_type_code IN ('VALIDATE' ) AND
1438: zx_global_structures_pkg.g_event_class_rec.event_type_code IN ('STANDARD VALIDATED TAX')
1439: THEN
1440:
1441: lv_action := JAI_CONSTANTS.updating;
1442:

Line 1443: FOR ap_inv_dist_rec in c_get_inv_dists(zx_global_structures_pkg.g_event_class_rec.trx_id)LOOP

1439: THEN
1440:
1441: lv_action := JAI_CONSTANTS.updating;
1442:
1443: FOR ap_inv_dist_rec in c_get_inv_dists(zx_global_structures_pkg.g_event_class_rec.trx_id)LOOP
1444: JAI_TAX_PROCESSING_PKG.create_accounting(
1445: pr_rec => ap_inv_dist_rec ,
1446: pv_action => lv_action ,
1447: pv_return_code => lv_return_code ,