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_TRL_ALLOCATIONS_PKG dependencies on ZX_LINES

Line 67: 'Insert into zx_lines for allocation of lines. (+)');

63:
64: IF (g_level_procedure >= g_current_runtime_level ) THEN
65: FND_LOG.STRING(g_level_procedure,
66: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',
67: 'Insert into zx_lines for allocation of lines. (+)');
68: END IF;
69:
70: IF (g_level_procedure >= g_current_runtime_level ) THEN
71: FND_LOG.STRING(g_level_procedure,

Line 97: FROM zx_lines_det_factors

93: l_trx_line_exist := NULL;
94: BEGIN
95: SELECT /*+first_rows(1)*/ 'Y'
96: INTO l_trx_line_exist
97: FROM zx_lines_det_factors
98: WHERE application_id = p_application_id
99: AND entity_code = p_entity_code
100: AND event_class_code = p_event_class_code
101: AND trx_id = p_trx_id

Line 130: FROM ZX_LINES

126: -- End : Added a prevetive check to make the trx line exists --
127:
128: SELECT NVL(max(TAX_LINE_NUMBER),0)+1
129: INTO l_tax_line_number
130: FROM ZX_LINES
131: WHERE APPLICATION_ID = p_application_id
132: AND EVENT_CLASS_CODE = p_event_class_code
133: AND ENTITY_CODE = p_entity_code
134: AND TRX_ID = p_trx_id

Line 138: SELECT zx_lines_s.nextval

134: AND TRX_ID = p_trx_id
135: AND TRX_LINE_ID = p_trx_line_id
136: AND TRX_LEVEL_TYPE = p_trx_level_type;
137:
138: SELECT zx_lines_s.nextval
139: INTO l_tax_line_id
140: FROM dual;
141:
142: SELECT DISTINCT precision,minimum_accountable_unit,trx_currency_code

Line 144: FROM zx_lines_det_factors zxd, zx_lines_summary zxs

140: FROM dual;
141:
142: SELECT DISTINCT precision,minimum_accountable_unit,trx_currency_code
143: INTO l_precision, l_minimum_accountable_unit, l_trx_currency_code
144: FROM zx_lines_det_factors zxd, zx_lines_summary zxs
145: WHERE zxd.trx_id = zxs.trx_id
146: AND zxs.summary_tax_line_id = p_summary_tax_line_id;
147:
148: ZX_TRL_DETAIL_OVERRIDE_PKG.Insert_row

Line 457: 'Insert into zx_lines for allocation of lines. (-)');

453:
454: IF (g_level_procedure >= g_current_runtime_level ) THEN
455: FND_LOG.STRING(g_level_procedure,
456: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',
457: 'Insert into zx_lines for allocation of lines. (-)');
458: END IF;
459:
460: IF (g_level_procedure >= g_current_runtime_level ) THEN
461: FND_LOG.STRING(g_level_procedure,

Line 526: FROM ZX_LINES_SUMMARY

522:
523: IF p_tax_amt IS NULL THEN
524: SELECT TAX_AMT
525: INTO l_summary_tax_amt
526: FROM ZX_LINES_SUMMARY
527: WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id;
528: ELSE
529: l_summary_tax_amt := p_tax_amt;
530: END IF;

Line 540: FROM ZX_LINES

536: END IF;
537:
538: SELECT SUM(LINE_AMT)
539: INTO l_total_trx_line_amt
540: FROM ZX_LINES
541: WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id
542: AND APPLICATION_ID = p_application_id
543: AND ENTITY_CODE = p_entity_code
544: AND EVENT_CLASS_CODE = p_event_class_code

Line 555: UPDATE ZX_LINES

551: 'Total_Trx_Line_Amount : '||to_char(l_total_trx_line_amt));
552: END IF;
553:
554: IF l_total_trx_line_amt <> 0 THEN
555: UPDATE ZX_LINES
556: SET unrounded_tax_amt = ((line_amt * l_summary_tax_amt) / l_total_trx_line_amt)
557: WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id
558: AND APPLICATION_ID = p_application_id
559: AND ENTITY_CODE = p_entity_code

Line 567: FROM ZX_LINES

563: END IF;
564:
565: SELECT SUM(unrounded_tax_amt)
566: INTO l_unrounded_tax_amt
567: FROM ZX_LINES
568: WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id
569: AND APPLICATION_ID = p_application_id
570: AND ENTITY_CODE = p_entity_code
571: AND EVENT_CLASS_CODE = p_event_class_code

Line 665: FROM zx_lines

661: -- Start : Added code to find if summary tax line already
662: -- allocated to the trx line for Bug#9664737
663: BEGIN
664: SELECT 'Y' INTO l_alloc_to_summ
665: FROM zx_lines
666: WHERE application_id = p_application_id
667: AND entity_code = p_entity_code
668: AND event_class_code = p_event_class_code
669: AND trx_id = l_trx_record.p_trx_id(i)

Line 684: FROM zx_lines

680:
681: IF NVL(l_alloc_to_summ,'N') = 'N' THEN
682: BEGIN
683: SELECT 'Y' INTO l_alloc_to_r2r
684: FROM zx_lines
685: WHERE application_id = p_application_id
686: AND entity_code = p_entity_code
687: AND event_class_code = p_event_class_code
688: AND trx_id = l_trx_record.p_trx_id(i)

Line 789: v_trx_number zx_lines.trx_number%TYPE;

785: l_tax_line_id NUMBER;
786: l_trx_line_id NUMBER;
787: l_tax_line_number NUMBER;
788: l_tax_id NUMBER;
789: v_trx_number zx_lines.trx_number%TYPE;
790: v_trx_id zx_lines.trx_id%TYPE;
791: v_trx_line_id zx_lines.trx_line_id%TYPE;
792: v_trx_level_type zx_lines.trx_level_type%TYPE;
793: v_trx_line_date zx_lines.trx_line_date%TYPE;

Line 790: v_trx_id zx_lines.trx_id%TYPE;

786: l_trx_line_id NUMBER;
787: l_tax_line_number NUMBER;
788: l_tax_id NUMBER;
789: v_trx_number zx_lines.trx_number%TYPE;
790: v_trx_id zx_lines.trx_id%TYPE;
791: v_trx_line_id zx_lines.trx_line_id%TYPE;
792: v_trx_level_type zx_lines.trx_level_type%TYPE;
793: v_trx_line_date zx_lines.trx_line_date%TYPE;
794: v_trx_line_number zx_lines.trx_line_number%TYPE;

Line 791: v_trx_line_id zx_lines.trx_line_id%TYPE;

787: l_tax_line_number NUMBER;
788: l_tax_id NUMBER;
789: v_trx_number zx_lines.trx_number%TYPE;
790: v_trx_id zx_lines.trx_id%TYPE;
791: v_trx_line_id zx_lines.trx_line_id%TYPE;
792: v_trx_level_type zx_lines.trx_level_type%TYPE;
793: v_trx_line_date zx_lines.trx_line_date%TYPE;
794: v_trx_line_number zx_lines.trx_line_number%TYPE;
795: v_trx_line_description zx_transaction_lines.trx_line_description%TYPE;

Line 792: v_trx_level_type zx_lines.trx_level_type%TYPE;

788: l_tax_id NUMBER;
789: v_trx_number zx_lines.trx_number%TYPE;
790: v_trx_id zx_lines.trx_id%TYPE;
791: v_trx_line_id zx_lines.trx_line_id%TYPE;
792: v_trx_level_type zx_lines.trx_level_type%TYPE;
793: v_trx_line_date zx_lines.trx_line_date%TYPE;
794: v_trx_line_number zx_lines.trx_line_number%TYPE;
795: v_trx_line_description zx_transaction_lines.trx_line_description%TYPE;
796: v_line_amt zx_lines.line_amt%TYPE := 0;

Line 793: v_trx_line_date zx_lines.trx_line_date%TYPE;

789: v_trx_number zx_lines.trx_number%TYPE;
790: v_trx_id zx_lines.trx_id%TYPE;
791: v_trx_line_id zx_lines.trx_line_id%TYPE;
792: v_trx_level_type zx_lines.trx_level_type%TYPE;
793: v_trx_line_date zx_lines.trx_line_date%TYPE;
794: v_trx_line_number zx_lines.trx_line_number%TYPE;
795: v_trx_line_description zx_transaction_lines.trx_line_description%TYPE;
796: v_line_amt zx_lines.line_amt%TYPE := 0;
797: l_Place_Of_Supply_Type_Code zx_lines.Place_Of_Supply_Type_Code%TYPE; --Bug 12688194

Line 794: v_trx_line_number zx_lines.trx_line_number%TYPE;

790: v_trx_id zx_lines.trx_id%TYPE;
791: v_trx_line_id zx_lines.trx_line_id%TYPE;
792: v_trx_level_type zx_lines.trx_level_type%TYPE;
793: v_trx_line_date zx_lines.trx_line_date%TYPE;
794: v_trx_line_number zx_lines.trx_line_number%TYPE;
795: v_trx_line_description zx_transaction_lines.trx_line_description%TYPE;
796: v_line_amt zx_lines.line_amt%TYPE := 0;
797: l_Place_Of_Supply_Type_Code zx_lines.Place_Of_Supply_Type_Code%TYPE; --Bug 12688194
798: l_taxable_amt NUMBER;

Line 796: v_line_amt zx_lines.line_amt%TYPE := 0;

792: v_trx_level_type zx_lines.trx_level_type%TYPE;
793: v_trx_line_date zx_lines.trx_line_date%TYPE;
794: v_trx_line_number zx_lines.trx_line_number%TYPE;
795: v_trx_line_description zx_transaction_lines.trx_line_description%TYPE;
796: v_line_amt zx_lines.line_amt%TYPE := 0;
797: l_Place_Of_Supply_Type_Code zx_lines.Place_Of_Supply_Type_Code%TYPE; --Bug 12688194
798: l_taxable_amt NUMBER;
799: l_event_id NUMBER;
800: l_regime_id NUMBER;

Line 797: l_Place_Of_Supply_Type_Code zx_lines.Place_Of_Supply_Type_Code%TYPE; --Bug 12688194

793: v_trx_line_date zx_lines.trx_line_date%TYPE;
794: v_trx_line_number zx_lines.trx_line_number%TYPE;
795: v_trx_line_description zx_transaction_lines.trx_line_description%TYPE;
796: v_line_amt zx_lines.line_amt%TYPE := 0;
797: l_Place_Of_Supply_Type_Code zx_lines.Place_Of_Supply_Type_Code%TYPE; --Bug 12688194
798: l_taxable_amt NUMBER;
799: l_event_id NUMBER;
800: l_regime_id NUMBER;
801: l_status_id NUMBER;

Line 838: l_ledger_id ZX_LINES_SUMMARY.ledger_id%TYPE;

834: AND tax_regime_code = c_tax_regime_code
835: ORDER BY subscription_level_code;
836:
837: -- Added for reallocation feature --
838: l_ledger_id ZX_LINES_SUMMARY.ledger_id%TYPE;
839: l_legal_entity_id ZX_LINES_SUMMARY.legal_entity_id%TYPE;
840: l_establishment_id ZX_LINES_SUMMARY.establishment_id%TYPE;
841: l_currency_conversion_date ZX_LINES_SUMMARY.currency_conversion_date%TYPE;
842: l_currency_conversion_type ZX_LINES_SUMMARY.currency_conversion_type%TYPE;

Line 839: l_legal_entity_id ZX_LINES_SUMMARY.legal_entity_id%TYPE;

835: ORDER BY subscription_level_code;
836:
837: -- Added for reallocation feature --
838: l_ledger_id ZX_LINES_SUMMARY.ledger_id%TYPE;
839: l_legal_entity_id ZX_LINES_SUMMARY.legal_entity_id%TYPE;
840: l_establishment_id ZX_LINES_SUMMARY.establishment_id%TYPE;
841: l_currency_conversion_date ZX_LINES_SUMMARY.currency_conversion_date%TYPE;
842: l_currency_conversion_type ZX_LINES_SUMMARY.currency_conversion_type%TYPE;
843: l_currency_conversion_rate ZX_LINES_SUMMARY.currency_conversion_rate%TYPE;

Line 840: l_establishment_id ZX_LINES_SUMMARY.establishment_id%TYPE;

836:
837: -- Added for reallocation feature --
838: l_ledger_id ZX_LINES_SUMMARY.ledger_id%TYPE;
839: l_legal_entity_id ZX_LINES_SUMMARY.legal_entity_id%TYPE;
840: l_establishment_id ZX_LINES_SUMMARY.establishment_id%TYPE;
841: l_currency_conversion_date ZX_LINES_SUMMARY.currency_conversion_date%TYPE;
842: l_currency_conversion_type ZX_LINES_SUMMARY.currency_conversion_type%TYPE;
843: l_currency_conversion_rate ZX_LINES_SUMMARY.currency_conversion_rate%TYPE;
844: l_taxable_basis_formula ZX_LINES_SUMMARY.taxable_basis_formula%TYPE;

Line 841: l_currency_conversion_date ZX_LINES_SUMMARY.currency_conversion_date%TYPE;

837: -- Added for reallocation feature --
838: l_ledger_id ZX_LINES_SUMMARY.ledger_id%TYPE;
839: l_legal_entity_id ZX_LINES_SUMMARY.legal_entity_id%TYPE;
840: l_establishment_id ZX_LINES_SUMMARY.establishment_id%TYPE;
841: l_currency_conversion_date ZX_LINES_SUMMARY.currency_conversion_date%TYPE;
842: l_currency_conversion_type ZX_LINES_SUMMARY.currency_conversion_type%TYPE;
843: l_currency_conversion_rate ZX_LINES_SUMMARY.currency_conversion_rate%TYPE;
844: l_taxable_basis_formula ZX_LINES_SUMMARY.taxable_basis_formula%TYPE;
845: l_tax_calculation_formula ZX_LINES_SUMMARY.tax_calculation_formula%TYPE;

Line 842: l_currency_conversion_type ZX_LINES_SUMMARY.currency_conversion_type%TYPE;

838: l_ledger_id ZX_LINES_SUMMARY.ledger_id%TYPE;
839: l_legal_entity_id ZX_LINES_SUMMARY.legal_entity_id%TYPE;
840: l_establishment_id ZX_LINES_SUMMARY.establishment_id%TYPE;
841: l_currency_conversion_date ZX_LINES_SUMMARY.currency_conversion_date%TYPE;
842: l_currency_conversion_type ZX_LINES_SUMMARY.currency_conversion_type%TYPE;
843: l_currency_conversion_rate ZX_LINES_SUMMARY.currency_conversion_rate%TYPE;
844: l_taxable_basis_formula ZX_LINES_SUMMARY.taxable_basis_formula%TYPE;
845: l_tax_calculation_formula ZX_LINES_SUMMARY.tax_calculation_formula%TYPE;
846: l_tax_exemption_id ZX_LINES_SUMMARY.tax_exemption_id%TYPE;

Line 843: l_currency_conversion_rate ZX_LINES_SUMMARY.currency_conversion_rate%TYPE;

839: l_legal_entity_id ZX_LINES_SUMMARY.legal_entity_id%TYPE;
840: l_establishment_id ZX_LINES_SUMMARY.establishment_id%TYPE;
841: l_currency_conversion_date ZX_LINES_SUMMARY.currency_conversion_date%TYPE;
842: l_currency_conversion_type ZX_LINES_SUMMARY.currency_conversion_type%TYPE;
843: l_currency_conversion_rate ZX_LINES_SUMMARY.currency_conversion_rate%TYPE;
844: l_taxable_basis_formula ZX_LINES_SUMMARY.taxable_basis_formula%TYPE;
845: l_tax_calculation_formula ZX_LINES_SUMMARY.tax_calculation_formula%TYPE;
846: l_tax_exemption_id ZX_LINES_SUMMARY.tax_exemption_id%TYPE;
847: l_exempt_certificate_number ZX_LINES_SUMMARY.exempt_certificate_number%TYPE;

Line 844: l_taxable_basis_formula ZX_LINES_SUMMARY.taxable_basis_formula%TYPE;

840: l_establishment_id ZX_LINES_SUMMARY.establishment_id%TYPE;
841: l_currency_conversion_date ZX_LINES_SUMMARY.currency_conversion_date%TYPE;
842: l_currency_conversion_type ZX_LINES_SUMMARY.currency_conversion_type%TYPE;
843: l_currency_conversion_rate ZX_LINES_SUMMARY.currency_conversion_rate%TYPE;
844: l_taxable_basis_formula ZX_LINES_SUMMARY.taxable_basis_formula%TYPE;
845: l_tax_calculation_formula ZX_LINES_SUMMARY.tax_calculation_formula%TYPE;
846: l_tax_exemption_id ZX_LINES_SUMMARY.tax_exemption_id%TYPE;
847: l_exempt_certificate_number ZX_LINES_SUMMARY.exempt_certificate_number%TYPE;
848: l_exempt_reason_code ZX_LINES_SUMMARY.exempt_reason_code%TYPE;

Line 845: l_tax_calculation_formula ZX_LINES_SUMMARY.tax_calculation_formula%TYPE;

841: l_currency_conversion_date ZX_LINES_SUMMARY.currency_conversion_date%TYPE;
842: l_currency_conversion_type ZX_LINES_SUMMARY.currency_conversion_type%TYPE;
843: l_currency_conversion_rate ZX_LINES_SUMMARY.currency_conversion_rate%TYPE;
844: l_taxable_basis_formula ZX_LINES_SUMMARY.taxable_basis_formula%TYPE;
845: l_tax_calculation_formula ZX_LINES_SUMMARY.tax_calculation_formula%TYPE;
846: l_tax_exemption_id ZX_LINES_SUMMARY.tax_exemption_id%TYPE;
847: l_exempt_certificate_number ZX_LINES_SUMMARY.exempt_certificate_number%TYPE;
848: l_exempt_reason_code ZX_LINES_SUMMARY.exempt_reason_code%TYPE;
849: l_tax_exception_id ZX_LINES_SUMMARY.tax_exception_id%TYPE;

Line 846: l_tax_exemption_id ZX_LINES_SUMMARY.tax_exemption_id%TYPE;

842: l_currency_conversion_type ZX_LINES_SUMMARY.currency_conversion_type%TYPE;
843: l_currency_conversion_rate ZX_LINES_SUMMARY.currency_conversion_rate%TYPE;
844: l_taxable_basis_formula ZX_LINES_SUMMARY.taxable_basis_formula%TYPE;
845: l_tax_calculation_formula ZX_LINES_SUMMARY.tax_calculation_formula%TYPE;
846: l_tax_exemption_id ZX_LINES_SUMMARY.tax_exemption_id%TYPE;
847: l_exempt_certificate_number ZX_LINES_SUMMARY.exempt_certificate_number%TYPE;
848: l_exempt_reason_code ZX_LINES_SUMMARY.exempt_reason_code%TYPE;
849: l_tax_exception_id ZX_LINES_SUMMARY.tax_exception_id%TYPE;
850: l_tax_provider_id ZX_LINES_SUMMARY.tax_provider_id%TYPE;

Line 847: l_exempt_certificate_number ZX_LINES_SUMMARY.exempt_certificate_number%TYPE;

843: l_currency_conversion_rate ZX_LINES_SUMMARY.currency_conversion_rate%TYPE;
844: l_taxable_basis_formula ZX_LINES_SUMMARY.taxable_basis_formula%TYPE;
845: l_tax_calculation_formula ZX_LINES_SUMMARY.tax_calculation_formula%TYPE;
846: l_tax_exemption_id ZX_LINES_SUMMARY.tax_exemption_id%TYPE;
847: l_exempt_certificate_number ZX_LINES_SUMMARY.exempt_certificate_number%TYPE;
848: l_exempt_reason_code ZX_LINES_SUMMARY.exempt_reason_code%TYPE;
849: l_tax_exception_id ZX_LINES_SUMMARY.tax_exception_id%TYPE;
850: l_tax_provider_id ZX_LINES_SUMMARY.tax_provider_id%TYPE;
851:

Line 848: l_exempt_reason_code ZX_LINES_SUMMARY.exempt_reason_code%TYPE;

844: l_taxable_basis_formula ZX_LINES_SUMMARY.taxable_basis_formula%TYPE;
845: l_tax_calculation_formula ZX_LINES_SUMMARY.tax_calculation_formula%TYPE;
846: l_tax_exemption_id ZX_LINES_SUMMARY.tax_exemption_id%TYPE;
847: l_exempt_certificate_number ZX_LINES_SUMMARY.exempt_certificate_number%TYPE;
848: l_exempt_reason_code ZX_LINES_SUMMARY.exempt_reason_code%TYPE;
849: l_tax_exception_id ZX_LINES_SUMMARY.tax_exception_id%TYPE;
850: l_tax_provider_id ZX_LINES_SUMMARY.tax_provider_id%TYPE;
851:
852: -- Added this cursor for reallocation feature

Line 849: l_tax_exception_id ZX_LINES_SUMMARY.tax_exception_id%TYPE;

845: l_tax_calculation_formula ZX_LINES_SUMMARY.tax_calculation_formula%TYPE;
846: l_tax_exemption_id ZX_LINES_SUMMARY.tax_exemption_id%TYPE;
847: l_exempt_certificate_number ZX_LINES_SUMMARY.exempt_certificate_number%TYPE;
848: l_exempt_reason_code ZX_LINES_SUMMARY.exempt_reason_code%TYPE;
849: l_tax_exception_id ZX_LINES_SUMMARY.tax_exception_id%TYPE;
850: l_tax_provider_id ZX_LINES_SUMMARY.tax_provider_id%TYPE;
851:
852: -- Added this cursor for reallocation feature
853: -- to fetch the values of some summarization columns

Line 850: l_tax_provider_id ZX_LINES_SUMMARY.tax_provider_id%TYPE;

846: l_tax_exemption_id ZX_LINES_SUMMARY.tax_exemption_id%TYPE;
847: l_exempt_certificate_number ZX_LINES_SUMMARY.exempt_certificate_number%TYPE;
848: l_exempt_reason_code ZX_LINES_SUMMARY.exempt_reason_code%TYPE;
849: l_tax_exception_id ZX_LINES_SUMMARY.tax_exception_id%TYPE;
850: l_tax_provider_id ZX_LINES_SUMMARY.tax_provider_id%TYPE;
851:
852: -- Added this cursor for reallocation feature
853: -- to fetch the values of some summarization columns
854: CURSOR get_summary_columns (c_summary_tax_line_id NUMBER)

Line 869: FROM zx_lines_summary

865: exempt_certificate_number,
866: exempt_reason_code,
867: tax_exception_id,
868: tax_provider_id
869: FROM zx_lines_summary
870: WHERE summary_tax_line_id = c_summary_tax_line_id;
871:
872: BEGIN
873:

Line 956: FROM zx_lines_det_factors

952: l_trx_line_exist := NULL;
953: BEGIN
954: SELECT /*+first_rows(1)*/ 'Y'
955: INTO l_trx_line_exist
956: FROM zx_lines_det_factors
957: WHERE application_id = p_application_id
958: AND entity_code = p_entity_code
959: AND event_class_code = p_event_class_code
960: AND trx_id = v_trx_id

Line 989: FROM ZX_LINES

985: -- End : Added a prevetive check to make the trx line exists --
986:
987: SELECT NVL(MAX(TAX_LINE_NUMBER),0) + 1
988: INTO l_tax_line_number
989: FROM ZX_LINES
990: WHERE APPLICATION_ID = p_application_id
991: AND EVENT_CLASS_CODE = p_event_class_code
992: AND ENTITY_CODE = p_entity_code
993: AND TRX_ID = v_trx_id

Line 1046: SELECT zx_lines_s.nextval

1042: IF l_status_id IS NULL THEN
1043: RAISE NO_DATA_FOUND;
1044: END IF;
1045:
1046: SELECT zx_lines_s.nextval
1047: INTO l_tax_line_id
1048: FROM dual;
1049:
1050: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1063: FROM zx_lines_det_factors

1059: trx_date,
1060: related_doc_date ,
1061: adjusted_doc_date
1062: INTO l_tax_determine_date, l_trx_date ,l_related_doc_date, l_adjusted_doc_date
1063: FROM zx_lines_det_factors
1064: WHERE trx_id = v_trx_id
1065: AND application_id = p_application_id
1066: AND entity_code = p_entity_code
1067: AND event_class_code = p_event_class_code

Line 1078: -- Fetch summarization columns from ZX_LINES_SUMMARY for re-allocation

1074: 'exception : ' || sqlerrm);
1075: END IF;
1076: END ;
1077:
1078: -- Fetch summarization columns from ZX_LINES_SUMMARY for re-allocation
1079: OPEN get_summary_columns(p_summary_tax_line_id);
1080: FETCH get_summary_columns INTO
1081: l_ledger_id,
1082: l_legal_entity_id,

Line 1503: v_trx_line_id zx_lines.trx_line_id%TYPE;

1499: l_tax_id NUMBER;
1500: l_regime_id NUMBER;
1501: l_status_id NUMBER;
1502:
1503: v_trx_line_id zx_lines.trx_line_id%TYPE;
1504: v_trx_line_number zx_lines.trx_line_number%TYPE;
1505:
1506: l_tax_event_class_code zx_evnt_cls_mappings.tax_event_class_code%type;
1507: l_trx_number zx_lines_det_factors.trx_number%type;

Line 1504: v_trx_line_number zx_lines.trx_line_number%TYPE;

1500: l_regime_id NUMBER;
1501: l_status_id NUMBER;
1502:
1503: v_trx_line_id zx_lines.trx_line_id%TYPE;
1504: v_trx_line_number zx_lines.trx_line_number%TYPE;
1505:
1506: l_tax_event_class_code zx_evnt_cls_mappings.tax_event_class_code%type;
1507: l_trx_number zx_lines_det_factors.trx_number%type;
1508: l_legal_reporting_status zx_taxes_b.legal_reporting_status_def_val%type;

Line 1507: l_trx_number zx_lines_det_factors.trx_number%type;

1503: v_trx_line_id zx_lines.trx_line_id%TYPE;
1504: v_trx_line_number zx_lines.trx_line_number%TYPE;
1505:
1506: l_tax_event_class_code zx_evnt_cls_mappings.tax_event_class_code%type;
1507: l_trx_number zx_lines_det_factors.trx_number%type;
1508: l_legal_reporting_status zx_taxes_b.legal_reporting_status_def_val%type;
1509: l_tax_reporting_flag zx_lines_det_factors.tax_reporting_flag%type;
1510:
1511: l_hq_estb_pty_tax_prof_id ZX_LINES_DET_FACTORS.HQ_ESTB_PARTY_TAX_PROF_ID%TYPE;

Line 1509: l_tax_reporting_flag zx_lines_det_factors.tax_reporting_flag%type;

1505:
1506: l_tax_event_class_code zx_evnt_cls_mappings.tax_event_class_code%type;
1507: l_trx_number zx_lines_det_factors.trx_number%type;
1508: l_legal_reporting_status zx_taxes_b.legal_reporting_status_def_val%type;
1509: l_tax_reporting_flag zx_lines_det_factors.tax_reporting_flag%type;
1510:
1511: l_hq_estb_pty_tax_prof_id ZX_LINES_DET_FACTORS.HQ_ESTB_PARTY_TAX_PROF_ID%TYPE;
1512: l_internal_org_loc_id ZX_LINES_DET_FACTORS.INTERNAL_ORG_LOCATION_ID%TYPE;
1513: l_event_class_mapping_id ZX_EVNT_CLS_MAPPINGS.EVENT_CLASS_MAPPING_ID%TYPE;

Line 1511: l_hq_estb_pty_tax_prof_id ZX_LINES_DET_FACTORS.HQ_ESTB_PARTY_TAX_PROF_ID%TYPE;

1507: l_trx_number zx_lines_det_factors.trx_number%type;
1508: l_legal_reporting_status zx_taxes_b.legal_reporting_status_def_val%type;
1509: l_tax_reporting_flag zx_lines_det_factors.tax_reporting_flag%type;
1510:
1511: l_hq_estb_pty_tax_prof_id ZX_LINES_DET_FACTORS.HQ_ESTB_PARTY_TAX_PROF_ID%TYPE;
1512: l_internal_org_loc_id ZX_LINES_DET_FACTORS.INTERNAL_ORG_LOCATION_ID%TYPE;
1513: l_event_class_mapping_id ZX_EVNT_CLS_MAPPINGS.EVENT_CLASS_MAPPING_ID%TYPE;
1514: l_tax_type_code ZX_TAXES_B.TAX_TYPE_CODE%TYPE;
1515: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;

Line 1512: l_internal_org_loc_id ZX_LINES_DET_FACTORS.INTERNAL_ORG_LOCATION_ID%TYPE;

1508: l_legal_reporting_status zx_taxes_b.legal_reporting_status_def_val%type;
1509: l_tax_reporting_flag zx_lines_det_factors.tax_reporting_flag%type;
1510:
1511: l_hq_estb_pty_tax_prof_id ZX_LINES_DET_FACTORS.HQ_ESTB_PARTY_TAX_PROF_ID%TYPE;
1512: l_internal_org_loc_id ZX_LINES_DET_FACTORS.INTERNAL_ORG_LOCATION_ID%TYPE;
1513: l_event_class_mapping_id ZX_EVNT_CLS_MAPPINGS.EVENT_CLASS_MAPPING_ID%TYPE;
1514: l_tax_type_code ZX_TAXES_B.TAX_TYPE_CODE%TYPE;
1515: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;
1516: l_default_taxation_country ZX_LINES_DET_FACTORS.DEFAULT_TAXATION_COUNTRY%TYPE;

Line 1516: l_default_taxation_country ZX_LINES_DET_FACTORS.DEFAULT_TAXATION_COUNTRY%TYPE;

1512: l_internal_org_loc_id ZX_LINES_DET_FACTORS.INTERNAL_ORG_LOCATION_ID%TYPE;
1513: l_event_class_mapping_id ZX_EVNT_CLS_MAPPINGS.EVENT_CLASS_MAPPING_ID%TYPE;
1514: l_tax_type_code ZX_TAXES_B.TAX_TYPE_CODE%TYPE;
1515: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;
1516: l_default_taxation_country ZX_LINES_DET_FACTORS.DEFAULT_TAXATION_COUNTRY%TYPE;
1517: l_rndg_ship_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_PROF_ID%TYPE;
1518: l_rndg_bill_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_PROF_ID%TYPE;
1519: l_rndg_ship_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID%TYPE;
1520: l_rndg_bill_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID%TYPE;

Line 1517: l_rndg_ship_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_PROF_ID%TYPE;

1513: l_event_class_mapping_id ZX_EVNT_CLS_MAPPINGS.EVENT_CLASS_MAPPING_ID%TYPE;
1514: l_tax_type_code ZX_TAXES_B.TAX_TYPE_CODE%TYPE;
1515: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;
1516: l_default_taxation_country ZX_LINES_DET_FACTORS.DEFAULT_TAXATION_COUNTRY%TYPE;
1517: l_rndg_ship_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_PROF_ID%TYPE;
1518: l_rndg_bill_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_PROF_ID%TYPE;
1519: l_rndg_ship_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID%TYPE;
1520: l_rndg_bill_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID%TYPE;
1521: l_ship_to_location_id ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID%TYPE;

Line 1518: l_rndg_bill_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_PROF_ID%TYPE;

1514: l_tax_type_code ZX_TAXES_B.TAX_TYPE_CODE%TYPE;
1515: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;
1516: l_default_taxation_country ZX_LINES_DET_FACTORS.DEFAULT_TAXATION_COUNTRY%TYPE;
1517: l_rndg_ship_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_PROF_ID%TYPE;
1518: l_rndg_bill_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_PROF_ID%TYPE;
1519: l_rndg_ship_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID%TYPE;
1520: l_rndg_bill_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID%TYPE;
1521: l_ship_to_location_id ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID%TYPE;
1522: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;

Line 1519: l_rndg_ship_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID%TYPE;

1515: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;
1516: l_default_taxation_country ZX_LINES_DET_FACTORS.DEFAULT_TAXATION_COUNTRY%TYPE;
1517: l_rndg_ship_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_PROF_ID%TYPE;
1518: l_rndg_bill_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_PROF_ID%TYPE;
1519: l_rndg_ship_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID%TYPE;
1520: l_rndg_bill_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID%TYPE;
1521: l_ship_to_location_id ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID%TYPE;
1522: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
1523: l_bill_to_location_id ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE;

Line 1520: l_rndg_bill_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID%TYPE;

1516: l_default_taxation_country ZX_LINES_DET_FACTORS.DEFAULT_TAXATION_COUNTRY%TYPE;
1517: l_rndg_ship_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_PROF_ID%TYPE;
1518: l_rndg_bill_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_PROF_ID%TYPE;
1519: l_rndg_ship_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID%TYPE;
1520: l_rndg_bill_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID%TYPE;
1521: l_ship_to_location_id ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID%TYPE;
1522: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
1523: l_bill_to_location_id ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE;
1524: l_bill_from_location_id ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID%TYPE;

Line 1521: l_ship_to_location_id ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID%TYPE;

1517: l_rndg_ship_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_PROF_ID%TYPE;
1518: l_rndg_bill_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_PROF_ID%TYPE;
1519: l_rndg_ship_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID%TYPE;
1520: l_rndg_bill_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID%TYPE;
1521: l_ship_to_location_id ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID%TYPE;
1522: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
1523: l_bill_to_location_id ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE;
1524: l_bill_from_location_id ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID%TYPE;
1525: l_ship_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;

Line 1522: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;

1518: l_rndg_bill_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_PROF_ID%TYPE;
1519: l_rndg_ship_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID%TYPE;
1520: l_rndg_bill_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID%TYPE;
1521: l_ship_to_location_id ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID%TYPE;
1522: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
1523: l_bill_to_location_id ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE;
1524: l_bill_from_location_id ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID%TYPE;
1525: l_ship_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
1526: l_bill_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;

Line 1523: l_bill_to_location_id ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE;

1519: l_rndg_ship_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID%TYPE;
1520: l_rndg_bill_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID%TYPE;
1521: l_ship_to_location_id ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID%TYPE;
1522: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
1523: l_bill_to_location_id ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE;
1524: l_bill_from_location_id ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID%TYPE;
1525: l_ship_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
1526: l_bill_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
1527: l_ship_from_site_tx_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;

Line 1524: l_bill_from_location_id ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID%TYPE;

1520: l_rndg_bill_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID%TYPE;
1521: l_ship_to_location_id ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID%TYPE;
1522: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
1523: l_bill_to_location_id ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE;
1524: l_bill_from_location_id ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID%TYPE;
1525: l_ship_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
1526: l_bill_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
1527: l_ship_from_site_tx_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
1528: l_bill_from_site_tx_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID%TYPE;

Line 1525: l_ship_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;

1521: l_ship_to_location_id ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID%TYPE;
1522: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
1523: l_bill_to_location_id ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE;
1524: l_bill_from_location_id ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID%TYPE;
1525: l_ship_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
1526: l_bill_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
1527: l_ship_from_site_tx_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
1528: l_bill_from_site_tx_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
1529: l_ctrl_hdr_tx_appl_flag ZX_LINES_DET_FACTORS.CTRL_HDR_TX_APPL_FLAG%TYPE;

Line 1526: l_bill_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;

1522: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
1523: l_bill_to_location_id ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE;
1524: l_bill_from_location_id ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID%TYPE;
1525: l_ship_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
1526: l_bill_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
1527: l_ship_from_site_tx_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
1528: l_bill_from_site_tx_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
1529: l_ctrl_hdr_tx_appl_flag ZX_LINES_DET_FACTORS.CTRL_HDR_TX_APPL_FLAG%TYPE;
1530: l_ship_third_pty_acct_site_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID%TYPE;

Line 1527: l_ship_from_site_tx_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;

1523: l_bill_to_location_id ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE;
1524: l_bill_from_location_id ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID%TYPE;
1525: l_ship_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
1526: l_bill_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
1527: l_ship_from_site_tx_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
1528: l_bill_from_site_tx_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
1529: l_ctrl_hdr_tx_appl_flag ZX_LINES_DET_FACTORS.CTRL_HDR_TX_APPL_FLAG%TYPE;
1530: l_ship_third_pty_acct_site_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID%TYPE;
1531: l_bill_third_pty_acct_site_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID%TYPE;

Line 1528: l_bill_from_site_tx_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID%TYPE;

1524: l_bill_from_location_id ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID%TYPE;
1525: l_ship_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
1526: l_bill_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
1527: l_ship_from_site_tx_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
1528: l_bill_from_site_tx_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
1529: l_ctrl_hdr_tx_appl_flag ZX_LINES_DET_FACTORS.CTRL_HDR_TX_APPL_FLAG%TYPE;
1530: l_ship_third_pty_acct_site_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID%TYPE;
1531: l_bill_third_pty_acct_site_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID%TYPE;
1532: l_ship_third_pty_acct_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID%TYPE;

Line 1529: l_ctrl_hdr_tx_appl_flag ZX_LINES_DET_FACTORS.CTRL_HDR_TX_APPL_FLAG%TYPE;

1525: l_ship_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
1526: l_bill_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
1527: l_ship_from_site_tx_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
1528: l_bill_from_site_tx_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
1529: l_ctrl_hdr_tx_appl_flag ZX_LINES_DET_FACTORS.CTRL_HDR_TX_APPL_FLAG%TYPE;
1530: l_ship_third_pty_acct_site_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID%TYPE;
1531: l_bill_third_pty_acct_site_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID%TYPE;
1532: l_ship_third_pty_acct_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID%TYPE;
1533: l_bill_third_pty_acct_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE;

Line 1530: l_ship_third_pty_acct_site_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID%TYPE;

1526: l_bill_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
1527: l_ship_from_site_tx_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
1528: l_bill_from_site_tx_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
1529: l_ctrl_hdr_tx_appl_flag ZX_LINES_DET_FACTORS.CTRL_HDR_TX_APPL_FLAG%TYPE;
1530: l_ship_third_pty_acct_site_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID%TYPE;
1531: l_bill_third_pty_acct_site_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID%TYPE;
1532: l_ship_third_pty_acct_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID%TYPE;
1533: l_bill_third_pty_acct_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE;
1534: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;

Line 1531: l_bill_third_pty_acct_site_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID%TYPE;

1527: l_ship_from_site_tx_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
1528: l_bill_from_site_tx_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
1529: l_ctrl_hdr_tx_appl_flag ZX_LINES_DET_FACTORS.CTRL_HDR_TX_APPL_FLAG%TYPE;
1530: l_ship_third_pty_acct_site_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID%TYPE;
1531: l_bill_third_pty_acct_site_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID%TYPE;
1532: l_ship_third_pty_acct_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID%TYPE;
1533: l_bill_third_pty_acct_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE;
1534: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
1535: l_currency_conversion_date ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_DATE%TYPE;

Line 1532: l_ship_third_pty_acct_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID%TYPE;

1528: l_bill_from_site_tx_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
1529: l_ctrl_hdr_tx_appl_flag ZX_LINES_DET_FACTORS.CTRL_HDR_TX_APPL_FLAG%TYPE;
1530: l_ship_third_pty_acct_site_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID%TYPE;
1531: l_bill_third_pty_acct_site_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID%TYPE;
1532: l_ship_third_pty_acct_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID%TYPE;
1533: l_bill_third_pty_acct_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE;
1534: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
1535: l_currency_conversion_date ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_DATE%TYPE;
1536: l_currency_conversion_rate ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_RATE%TYPE;

Line 1533: l_bill_third_pty_acct_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE;

1529: l_ctrl_hdr_tx_appl_flag ZX_LINES_DET_FACTORS.CTRL_HDR_TX_APPL_FLAG%TYPE;
1530: l_ship_third_pty_acct_site_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID%TYPE;
1531: l_bill_third_pty_acct_site_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID%TYPE;
1532: l_ship_third_pty_acct_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID%TYPE;
1533: l_bill_third_pty_acct_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE;
1534: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
1535: l_currency_conversion_date ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_DATE%TYPE;
1536: l_currency_conversion_rate ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_RATE%TYPE;
1537: l_currency_conversion_type ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_TYPE%TYPE;

Line 1534: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;

1530: l_ship_third_pty_acct_site_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID%TYPE;
1531: l_bill_third_pty_acct_site_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID%TYPE;
1532: l_ship_third_pty_acct_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID%TYPE;
1533: l_bill_third_pty_acct_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE;
1534: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
1535: l_currency_conversion_date ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_DATE%TYPE;
1536: l_currency_conversion_rate ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_RATE%TYPE;
1537: l_currency_conversion_type ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_TYPE%TYPE;
1538:

Line 1535: l_currency_conversion_date ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_DATE%TYPE;

1531: l_bill_third_pty_acct_site_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID%TYPE;
1532: l_ship_third_pty_acct_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID%TYPE;
1533: l_bill_third_pty_acct_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE;
1534: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
1535: l_currency_conversion_date ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_DATE%TYPE;
1536: l_currency_conversion_rate ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_RATE%TYPE;
1537: l_currency_conversion_type ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_TYPE%TYPE;
1538:
1539:

Line 1536: l_currency_conversion_rate ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_RATE%TYPE;

1532: l_ship_third_pty_acct_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID%TYPE;
1533: l_bill_third_pty_acct_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE;
1534: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
1535: l_currency_conversion_date ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_DATE%TYPE;
1536: l_currency_conversion_rate ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_RATE%TYPE;
1537: l_currency_conversion_type ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_TYPE%TYPE;
1538:
1539:
1540: BEGIN

Line 1537: l_currency_conversion_type ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_TYPE%TYPE;

1533: l_bill_third_pty_acct_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE;
1534: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
1535: l_currency_conversion_date ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_DATE%TYPE;
1536: l_currency_conversion_rate ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_RATE%TYPE;
1537: l_currency_conversion_type ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_TYPE%TYPE;
1538:
1539:
1540: BEGIN
1541:

Line 1558: FROM ZX_LINES

1554: SELECT nvl(min(trx_line_id),0),
1555: nvl(min(trx_line_number),0)
1556: INTO v_trx_line_number,
1557: v_trx_line_id
1558: FROM ZX_LINES
1559: WHERE TRX_ID = p_trx_id
1560: AND APPLICATION_ID = p_application_id
1561: AND EVENT_CLASS_CODE = p_event_class_code
1562: AND ENTITY_CODE = p_entity_code;

Line 1715: SELECT zx_lines_s.nextval

1711: RETURN;
1712:
1713: END;
1714:
1715: SELECT zx_lines_s.nextval
1716: INTO l_tax_line_id
1717: FROM dual;
1718:
1719: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1759: FROM ZX_LINES_DET_FACTORS

1755: l_bill_from_pty_tax_prof_id, l_ship_from_site_tx_prof_id,
1756: l_bill_from_site_tx_prof_id, l_ctrl_hdr_tx_appl_flag,
1757: l_ship_third_pty_acct_site_id, l_bill_third_pty_acct_site_id,
1758: l_ship_third_pty_acct_id, l_bill_third_pty_acct_id
1759: FROM ZX_LINES_DET_FACTORS
1760: WHERE APPLICATION_ID = P_APPLICATION_ID
1761: AND ENTITY_CODE = P_ENTITY_CODE
1762: AND EVENT_CLASS_CODE = P_EVENT_CLASS_CODE
1763: AND TRX_ID = P_TRX_ID

Line 1777: INSERT INTO ZX_LINES (SUMMARY_TAX_LINE_ID,

1773: --End Bug 8266185
1774: END;
1775:
1776:
1777: INSERT INTO ZX_LINES (SUMMARY_TAX_LINE_ID,
1778: INTERNAL_ORGANIZATION_ID,
1779: APPLICATION_ID,
1780: ENTITY_CODE,
1781: EVENT_CLASS_CODE,

Line 1972: INSERT INTO ZX_LINES_DET_FACTORS( INTERNAL_ORGANIZATION_ID,

1968: fnd_global.user_id,
1969: sysdate,
1970: fnd_global.login_id);
1971:
1972: INSERT INTO ZX_LINES_DET_FACTORS( INTERNAL_ORGANIZATION_ID,
1973: APPLICATION_ID,
1974: ENTITY_CODE,
1975: EVENT_CLASS_CODE,
1976: EVENT_TYPE_CODE,