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 87: FROM ZX_LINES

83:
84: IF p_enabled_record ='Y' THEN
85: SELECT NVL(max(TAX_LINE_NUMBER),0)+1
86: INTO l_tax_line_number
87: FROM ZX_LINES
88: WHERE APPLICATION_ID = p_application_id
89: AND EVENT_CLASS_CODE = p_event_class_code
90: AND ENTITY_CODE = p_entity_code
91: AND TRX_ID = p_trx_id

Line 95: SELECT zx_lines_s.nextval

91: AND TRX_ID = p_trx_id
92: AND TRX_LINE_ID = p_trx_line_id
93: AND TRX_LEVEL_TYPE = p_trx_level_type;
94:
95: SELECT zx_lines_s.nextval
96: INTO l_tax_line_id
97: FROM dual;
98:
99: SELECT distinct precision,minimum_accountable_unit,trx_currency_code

Line 101: FROM zx_lines_det_factors zxd, zx_lines_summary zxs

97: FROM dual;
98:
99: SELECT distinct precision,minimum_accountable_unit,trx_currency_code
100: INTO l_precision, l_minimum_accountable_unit, l_trx_currency_code
101: FROM zx_lines_det_factors zxd, zx_lines_summary zxs
102: WHERE zxd.trx_id = zxs.trx_id
103: AND zxs.summary_tax_line_id = p_summary_tax_line_id;
104:
105:

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

411:
412: IF (g_level_procedure >= g_current_runtime_level ) THEN
413: FND_LOG.STRING(g_level_procedure,
414: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_Row',
415: 'Insert into zx_lines for allocation of lines. (-)');
416: END IF;
417:
418: IF (g_level_procedure >= g_current_runtime_level ) THEN
419: FND_LOG.STRING(g_level_procedure,

Line 463: 'Update tax_amount in zx_lines for allocation of lines. (+)');

459:
460: IF (g_level_procedure >= g_current_runtime_level ) THEN
461: FND_LOG.STRING(g_level_procedure,
462: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt',
463: 'Update tax_amount in zx_lines for allocation of lines. (+)');
464: END IF;
465:
466: SELECT TAX_AMT
467: INTO l_summary_tax_amt

Line 468: FROM ZX_LINES_SUMMARY

464: END IF;
465:
466: SELECT TAX_AMT
467: INTO l_summary_tax_amt
468: FROM ZX_LINES_SUMMARY
469: WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id;
470:
471: IF (g_level_statement >= g_current_runtime_level ) THEN
472: FND_LOG.STRING(g_level_statement,

Line 478: FROM ZX_LINES

474: 'Summary tax amount '||to_char(l_summary_tax_amt));
475: END IF;
476: SELECT SUM(LINE_AMT)
477: INTO l_total_trx_line_amt
478: FROM ZX_LINES
479: WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id
480: AND APPLICATION_ID = p_application_id
481: AND ENTITY_CODE = p_entity_code
482: AND EVENT_CLASS_CODE = p_event_class_code

Line 493: FROM ZX_LINES

489: END IF;
490:
491: SELECT SUM(unrounded_tax_amt)
492: INTO l_unrounded_tax_amt
493: FROM ZX_LINES
494: WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id
495: AND APPLICATION_ID = p_application_id
496: AND ENTITY_CODE = p_entity_code
497: AND EVENT_CLASS_CODE = p_event_class_code

Line 506: UPDATE ZX_LINES

502: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt',
503: 'total trxline amt'||to_char(l_total_trx_line_amt)||' unrounded amt '||to_char(l_unrounded_tax_amt)||'summary tax amount '||to_char(l_summary_tax_amt));
504: END IF;
505: IF l_total_trx_line_amt <> 0 THEN
506: UPDATE ZX_LINES
507: SET
508: unrounded_tax_amt = ((unrounded_tax_amt * l_summary_tax_amt) / l_total_trx_line_amt)
509: WHERE SUMMARY_TAX_LINE_ID = p_summary_tax_line_id
510: AND APPLICATION_ID = p_application_id

Line 520: 'Update tax_amount in zx_lines for allocation of lines. (-)');

516:
517: IF (g_level_procedure >= g_current_runtime_level ) THEN
518: FND_LOG.STRING(g_level_procedure,
519: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Update_tax_amt',
520: 'Update tax_amount in zx_lines for allocation of lines. (-)');
521: END IF;
522:
523: IF (g_level_procedure >= g_current_runtime_level ) THEN
524: FND_LOG.STRING(g_level_procedure,

Line 617: v_trx_number zx_lines.trx_number%TYPE;

613: l_tax_line_id NUMBER;
614: l_trx_line_id NUMBER;
615: l_tax_line_number NUMBER;
616: l_tax_id NUMBER;
617: v_trx_number zx_lines.trx_number%TYPE;
618: v_trx_id zx_lines.trx_id%TYPE;
619: v_trx_line_id zx_lines.trx_line_id%TYPE;
620: v_trx_level_type zx_lines.trx_level_type%TYPE;
621: v_trx_line_date zx_lines.trx_line_date%TYPE;

Line 618: v_trx_id zx_lines.trx_id%TYPE;

614: l_trx_line_id NUMBER;
615: l_tax_line_number NUMBER;
616: l_tax_id NUMBER;
617: v_trx_number zx_lines.trx_number%TYPE;
618: v_trx_id zx_lines.trx_id%TYPE;
619: v_trx_line_id zx_lines.trx_line_id%TYPE;
620: v_trx_level_type zx_lines.trx_level_type%TYPE;
621: v_trx_line_date zx_lines.trx_line_date%TYPE;
622: v_trx_line_number zx_lines.trx_line_number%TYPE;

Line 619: v_trx_line_id zx_lines.trx_line_id%TYPE;

615: l_tax_line_number NUMBER;
616: l_tax_id NUMBER;
617: v_trx_number zx_lines.trx_number%TYPE;
618: v_trx_id zx_lines.trx_id%TYPE;
619: v_trx_line_id zx_lines.trx_line_id%TYPE;
620: v_trx_level_type zx_lines.trx_level_type%TYPE;
621: v_trx_line_date zx_lines.trx_line_date%TYPE;
622: v_trx_line_number zx_lines.trx_line_number%TYPE;
623: v_trx_line_description zx_transaction_lines.trx_line_description%TYPE;

Line 620: v_trx_level_type zx_lines.trx_level_type%TYPE;

616: l_tax_id NUMBER;
617: v_trx_number zx_lines.trx_number%TYPE;
618: v_trx_id zx_lines.trx_id%TYPE;
619: v_trx_line_id zx_lines.trx_line_id%TYPE;
620: v_trx_level_type zx_lines.trx_level_type%TYPE;
621: v_trx_line_date zx_lines.trx_line_date%TYPE;
622: v_trx_line_number zx_lines.trx_line_number%TYPE;
623: v_trx_line_description zx_transaction_lines.trx_line_description%TYPE;
624: v_line_amt zx_lines.line_amt%TYPE := 0;

Line 621: v_trx_line_date zx_lines.trx_line_date%TYPE;

617: v_trx_number zx_lines.trx_number%TYPE;
618: v_trx_id zx_lines.trx_id%TYPE;
619: v_trx_line_id zx_lines.trx_line_id%TYPE;
620: v_trx_level_type zx_lines.trx_level_type%TYPE;
621: v_trx_line_date zx_lines.trx_line_date%TYPE;
622: v_trx_line_number zx_lines.trx_line_number%TYPE;
623: v_trx_line_description zx_transaction_lines.trx_line_description%TYPE;
624: v_line_amt zx_lines.line_amt%TYPE := 0;
625: l_taxable_amt NUMBER;

Line 622: v_trx_line_number zx_lines.trx_line_number%TYPE;

618: v_trx_id zx_lines.trx_id%TYPE;
619: v_trx_line_id zx_lines.trx_line_id%TYPE;
620: v_trx_level_type zx_lines.trx_level_type%TYPE;
621: v_trx_line_date zx_lines.trx_line_date%TYPE;
622: v_trx_line_number zx_lines.trx_line_number%TYPE;
623: v_trx_line_description zx_transaction_lines.trx_line_description%TYPE;
624: v_line_amt zx_lines.line_amt%TYPE := 0;
625: l_taxable_amt NUMBER;
626: l_event_id NUMBER;

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

620: v_trx_level_type zx_lines.trx_level_type%TYPE;
621: v_trx_line_date zx_lines.trx_line_date%TYPE;
622: v_trx_line_number zx_lines.trx_line_number%TYPE;
623: v_trx_line_description zx_transaction_lines.trx_line_description%TYPE;
624: v_line_amt zx_lines.line_amt%TYPE := 0;
625: l_taxable_amt NUMBER;
626: l_event_id NUMBER;
627: l_regime_id NUMBER;
628: l_status_id NUMBER;

Line 691: FROM ZX_LINES

687: IF l_insert THEN
688:
689: SELECT NVL(MAX(TAX_LINE_NUMBER),0) + 1
690: INTO l_tax_line_number
691: FROM ZX_LINES
692: WHERE APPLICATION_ID = p_application_id
693: AND EVENT_CLASS_CODE = p_event_class_code
694: AND ENTITY_CODE = p_entity_code
695: AND TRX_ID = v_trx_id

Line 732: SELECT zx_lines_s.nextval

728: 'ZX.PLSQL.ZX_TRL_ALLOCATIONS_PKG.Insert_All_Allocation',
729: 'status id : ' || to_char(l_status_id)) ;
730: END IF;
731:
732: SELECT zx_lines_s.nextval
733: INTO l_tax_line_id
734: FROM dual;
735:
736: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 745: FROM zx_lines_det_factors where trx_id = v_trx_id;

741:
742: BEGIN
743: SELECT distinct nvl(related_doc_date,nvl(provnl_tax_determination_date
744: ,nvl(adjusted_doc_date,trx_date))) , trx_date, related_doc_date ,adjusted_doc_date into l_tax_determine_date, l_trx_date ,l_related_doc_date, l_adjusted_doc_date
745: FROM zx_lines_det_factors where trx_id = v_trx_id;
746: EXCEPTION
747: WHEN others THEN NULL;
748: END ;
749:

Line 1133: v_trx_line_id zx_lines.trx_line_id%TYPE;

1129: l_tax_id NUMBER;
1130: l_regime_id NUMBER;
1131: l_status_id NUMBER;
1132:
1133: v_trx_line_id zx_lines.trx_line_id%TYPE;
1134: v_trx_line_number zx_lines.trx_line_number%TYPE;
1135:
1136: l_tax_event_class_code zx_evnt_cls_mappings.tax_event_class_code%type;
1137: l_trx_number zx_lines_det_factors.trx_number%type;

Line 1134: v_trx_line_number zx_lines.trx_line_number%TYPE;

1130: l_regime_id NUMBER;
1131: l_status_id NUMBER;
1132:
1133: v_trx_line_id zx_lines.trx_line_id%TYPE;
1134: v_trx_line_number zx_lines.trx_line_number%TYPE;
1135:
1136: l_tax_event_class_code zx_evnt_cls_mappings.tax_event_class_code%type;
1137: l_trx_number zx_lines_det_factors.trx_number%type;
1138: l_legal_reporting_status zx_taxes_b.legal_reporting_status_def_val%type;

Line 1137: l_trx_number zx_lines_det_factors.trx_number%type;

1133: v_trx_line_id zx_lines.trx_line_id%TYPE;
1134: v_trx_line_number zx_lines.trx_line_number%TYPE;
1135:
1136: l_tax_event_class_code zx_evnt_cls_mappings.tax_event_class_code%type;
1137: l_trx_number zx_lines_det_factors.trx_number%type;
1138: l_legal_reporting_status zx_taxes_b.legal_reporting_status_def_val%type;
1139: l_tax_reporting_flag zx_lines_det_factors.tax_reporting_flag%type;
1140:
1141: l_hq_estb_pty_tax_prof_id ZX_LINES_DET_FACTORS.HQ_ESTB_PARTY_TAX_PROF_ID%TYPE;

Line 1139: l_tax_reporting_flag zx_lines_det_factors.tax_reporting_flag%type;

1135:
1136: l_tax_event_class_code zx_evnt_cls_mappings.tax_event_class_code%type;
1137: l_trx_number zx_lines_det_factors.trx_number%type;
1138: l_legal_reporting_status zx_taxes_b.legal_reporting_status_def_val%type;
1139: l_tax_reporting_flag zx_lines_det_factors.tax_reporting_flag%type;
1140:
1141: l_hq_estb_pty_tax_prof_id ZX_LINES_DET_FACTORS.HQ_ESTB_PARTY_TAX_PROF_ID%TYPE;
1142: l_internal_org_loc_id ZX_LINES_DET_FACTORS.INTERNAL_ORG_LOCATION_ID%TYPE;
1143: l_event_class_mapping_id ZX_EVNT_CLS_MAPPINGS.EVENT_CLASS_MAPPING_ID%TYPE;

Line 1141: l_hq_estb_pty_tax_prof_id ZX_LINES_DET_FACTORS.HQ_ESTB_PARTY_TAX_PROF_ID%TYPE;

1137: l_trx_number zx_lines_det_factors.trx_number%type;
1138: l_legal_reporting_status zx_taxes_b.legal_reporting_status_def_val%type;
1139: l_tax_reporting_flag zx_lines_det_factors.tax_reporting_flag%type;
1140:
1141: l_hq_estb_pty_tax_prof_id ZX_LINES_DET_FACTORS.HQ_ESTB_PARTY_TAX_PROF_ID%TYPE;
1142: l_internal_org_loc_id ZX_LINES_DET_FACTORS.INTERNAL_ORG_LOCATION_ID%TYPE;
1143: l_event_class_mapping_id ZX_EVNT_CLS_MAPPINGS.EVENT_CLASS_MAPPING_ID%TYPE;
1144: l_tax_type_code ZX_TAXES_B.TAX_TYPE_CODE%TYPE;
1145: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;

Line 1142: l_internal_org_loc_id ZX_LINES_DET_FACTORS.INTERNAL_ORG_LOCATION_ID%TYPE;

1138: l_legal_reporting_status zx_taxes_b.legal_reporting_status_def_val%type;
1139: l_tax_reporting_flag zx_lines_det_factors.tax_reporting_flag%type;
1140:
1141: l_hq_estb_pty_tax_prof_id ZX_LINES_DET_FACTORS.HQ_ESTB_PARTY_TAX_PROF_ID%TYPE;
1142: l_internal_org_loc_id ZX_LINES_DET_FACTORS.INTERNAL_ORG_LOCATION_ID%TYPE;
1143: l_event_class_mapping_id ZX_EVNT_CLS_MAPPINGS.EVENT_CLASS_MAPPING_ID%TYPE;
1144: l_tax_type_code ZX_TAXES_B.TAX_TYPE_CODE%TYPE;
1145: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;
1146: l_default_taxation_country ZX_LINES_DET_FACTORS.DEFAULT_TAXATION_COUNTRY%TYPE;

Line 1146: l_default_taxation_country ZX_LINES_DET_FACTORS.DEFAULT_TAXATION_COUNTRY%TYPE;

1142: l_internal_org_loc_id ZX_LINES_DET_FACTORS.INTERNAL_ORG_LOCATION_ID%TYPE;
1143: l_event_class_mapping_id ZX_EVNT_CLS_MAPPINGS.EVENT_CLASS_MAPPING_ID%TYPE;
1144: l_tax_type_code ZX_TAXES_B.TAX_TYPE_CODE%TYPE;
1145: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;
1146: l_default_taxation_country ZX_LINES_DET_FACTORS.DEFAULT_TAXATION_COUNTRY%TYPE;
1147: l_rndg_ship_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_PROF_ID%TYPE;
1148: l_rndg_bill_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_PROF_ID%TYPE;
1149: l_rndg_ship_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID%TYPE;
1150: l_rndg_bill_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID%TYPE;

Line 1147: l_rndg_ship_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_PROF_ID%TYPE;

1143: l_event_class_mapping_id ZX_EVNT_CLS_MAPPINGS.EVENT_CLASS_MAPPING_ID%TYPE;
1144: l_tax_type_code ZX_TAXES_B.TAX_TYPE_CODE%TYPE;
1145: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;
1146: l_default_taxation_country ZX_LINES_DET_FACTORS.DEFAULT_TAXATION_COUNTRY%TYPE;
1147: l_rndg_ship_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_PROF_ID%TYPE;
1148: l_rndg_bill_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_PROF_ID%TYPE;
1149: l_rndg_ship_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID%TYPE;
1150: l_rndg_bill_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID%TYPE;
1151: l_ship_to_location_id ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID%TYPE;

Line 1148: l_rndg_bill_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_PROF_ID%TYPE;

1144: l_tax_type_code ZX_TAXES_B.TAX_TYPE_CODE%TYPE;
1145: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;
1146: l_default_taxation_country ZX_LINES_DET_FACTORS.DEFAULT_TAXATION_COUNTRY%TYPE;
1147: l_rndg_ship_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_PROF_ID%TYPE;
1148: l_rndg_bill_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_PROF_ID%TYPE;
1149: l_rndg_ship_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID%TYPE;
1150: l_rndg_bill_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID%TYPE;
1151: l_ship_to_location_id ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID%TYPE;
1152: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;

Line 1149: l_rndg_ship_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID%TYPE;

1145: l_rate_type_code ZX_RATES_B.RATE_TYPE_CODE%TYPE;
1146: l_default_taxation_country ZX_LINES_DET_FACTORS.DEFAULT_TAXATION_COUNTRY%TYPE;
1147: l_rndg_ship_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_PROF_ID%TYPE;
1148: l_rndg_bill_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_PROF_ID%TYPE;
1149: l_rndg_ship_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID%TYPE;
1150: l_rndg_bill_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID%TYPE;
1151: l_ship_to_location_id ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID%TYPE;
1152: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
1153: l_bill_to_location_id ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE;

Line 1150: l_rndg_bill_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID%TYPE;

1146: l_default_taxation_country ZX_LINES_DET_FACTORS.DEFAULT_TAXATION_COUNTRY%TYPE;
1147: l_rndg_ship_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_PROF_ID%TYPE;
1148: l_rndg_bill_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_PROF_ID%TYPE;
1149: l_rndg_ship_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID%TYPE;
1150: l_rndg_bill_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID%TYPE;
1151: l_ship_to_location_id ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID%TYPE;
1152: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
1153: l_bill_to_location_id ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE;
1154: l_bill_from_location_id ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID%TYPE;

Line 1151: l_ship_to_location_id ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID%TYPE;

1147: l_rndg_ship_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_PROF_ID%TYPE;
1148: l_rndg_bill_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_PROF_ID%TYPE;
1149: l_rndg_ship_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID%TYPE;
1150: l_rndg_bill_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID%TYPE;
1151: l_ship_to_location_id ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID%TYPE;
1152: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
1153: l_bill_to_location_id ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE;
1154: l_bill_from_location_id ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID%TYPE;
1155: l_ship_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;

Line 1152: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;

1148: l_rndg_bill_fr_pty_tx_prof_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_PROF_ID%TYPE;
1149: l_rndg_ship_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID%TYPE;
1150: l_rndg_bill_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID%TYPE;
1151: l_ship_to_location_id ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID%TYPE;
1152: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
1153: l_bill_to_location_id ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE;
1154: l_bill_from_location_id ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID%TYPE;
1155: l_ship_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
1156: l_bill_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;

Line 1153: l_bill_to_location_id ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE;

1149: l_rndg_ship_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_SHIP_FROM_PTY_TX_P_ST_ID%TYPE;
1150: l_rndg_bill_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID%TYPE;
1151: l_ship_to_location_id ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID%TYPE;
1152: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
1153: l_bill_to_location_id ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE;
1154: l_bill_from_location_id ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID%TYPE;
1155: l_ship_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
1156: l_bill_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
1157: l_ship_from_site_tx_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;

Line 1154: l_bill_from_location_id ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID%TYPE;

1150: l_rndg_bill_fr_pty_tx_p_st_id ZX_LINES_DET_FACTORS.RDNG_BILL_FROM_PTY_TX_P_ST_ID%TYPE;
1151: l_ship_to_location_id ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID%TYPE;
1152: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
1153: l_bill_to_location_id ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE;
1154: l_bill_from_location_id ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID%TYPE;
1155: l_ship_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
1156: l_bill_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
1157: l_ship_from_site_tx_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
1158: l_bill_from_site_tx_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID%TYPE;

Line 1155: l_ship_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;

1151: l_ship_to_location_id ZX_LINES_DET_FACTORS.SHIP_TO_LOCATION_ID%TYPE;
1152: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
1153: l_bill_to_location_id ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE;
1154: l_bill_from_location_id ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID%TYPE;
1155: l_ship_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
1156: l_bill_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
1157: l_ship_from_site_tx_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
1158: l_bill_from_site_tx_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
1159: l_ctrl_hdr_tx_appl_flag ZX_LINES_DET_FACTORS.CTRL_HDR_TX_APPL_FLAG%TYPE;

Line 1156: l_bill_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;

1152: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
1153: l_bill_to_location_id ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE;
1154: l_bill_from_location_id ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID%TYPE;
1155: l_ship_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
1156: l_bill_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
1157: l_ship_from_site_tx_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
1158: l_bill_from_site_tx_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
1159: l_ctrl_hdr_tx_appl_flag ZX_LINES_DET_FACTORS.CTRL_HDR_TX_APPL_FLAG%TYPE;
1160: l_ship_third_pty_acct_site_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID%TYPE;

Line 1157: l_ship_from_site_tx_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;

1153: l_bill_to_location_id ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE;
1154: l_bill_from_location_id ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID%TYPE;
1155: l_ship_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
1156: l_bill_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
1157: l_ship_from_site_tx_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
1158: l_bill_from_site_tx_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
1159: l_ctrl_hdr_tx_appl_flag ZX_LINES_DET_FACTORS.CTRL_HDR_TX_APPL_FLAG%TYPE;
1160: l_ship_third_pty_acct_site_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID%TYPE;
1161: l_bill_third_pty_acct_site_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID%TYPE;

Line 1158: l_bill_from_site_tx_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID%TYPE;

1154: l_bill_from_location_id ZX_LINES_DET_FACTORS.BILL_FROM_LOCATION_ID%TYPE;
1155: l_ship_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
1156: l_bill_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
1157: l_ship_from_site_tx_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
1158: l_bill_from_site_tx_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
1159: l_ctrl_hdr_tx_appl_flag ZX_LINES_DET_FACTORS.CTRL_HDR_TX_APPL_FLAG%TYPE;
1160: l_ship_third_pty_acct_site_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID%TYPE;
1161: l_bill_third_pty_acct_site_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID%TYPE;
1162: l_ship_third_pty_acct_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID%TYPE;

Line 1159: l_ctrl_hdr_tx_appl_flag ZX_LINES_DET_FACTORS.CTRL_HDR_TX_APPL_FLAG%TYPE;

1155: l_ship_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_PARTY_TAX_PROF_ID%TYPE;
1156: l_bill_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
1157: l_ship_from_site_tx_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
1158: l_bill_from_site_tx_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
1159: l_ctrl_hdr_tx_appl_flag ZX_LINES_DET_FACTORS.CTRL_HDR_TX_APPL_FLAG%TYPE;
1160: l_ship_third_pty_acct_site_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID%TYPE;
1161: l_bill_third_pty_acct_site_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID%TYPE;
1162: l_ship_third_pty_acct_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID%TYPE;
1163: l_bill_third_pty_acct_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE;

Line 1160: l_ship_third_pty_acct_site_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID%TYPE;

1156: l_bill_from_pty_tax_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_PARTY_TAX_PROF_ID%TYPE;
1157: l_ship_from_site_tx_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
1158: l_bill_from_site_tx_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
1159: l_ctrl_hdr_tx_appl_flag ZX_LINES_DET_FACTORS.CTRL_HDR_TX_APPL_FLAG%TYPE;
1160: l_ship_third_pty_acct_site_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID%TYPE;
1161: l_bill_third_pty_acct_site_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID%TYPE;
1162: l_ship_third_pty_acct_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID%TYPE;
1163: l_bill_third_pty_acct_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE;
1164: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;

Line 1161: l_bill_third_pty_acct_site_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID%TYPE;

1157: l_ship_from_site_tx_prof_id ZX_LINES_DET_FACTORS.SHIP_FROM_SITE_TAX_PROF_ID%TYPE;
1158: l_bill_from_site_tx_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
1159: l_ctrl_hdr_tx_appl_flag ZX_LINES_DET_FACTORS.CTRL_HDR_TX_APPL_FLAG%TYPE;
1160: l_ship_third_pty_acct_site_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID%TYPE;
1161: l_bill_third_pty_acct_site_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID%TYPE;
1162: l_ship_third_pty_acct_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID%TYPE;
1163: l_bill_third_pty_acct_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE;
1164: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
1165: l_currency_conversion_date ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_DATE%TYPE;

Line 1162: l_ship_third_pty_acct_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID%TYPE;

1158: l_bill_from_site_tx_prof_id ZX_LINES_DET_FACTORS.BILL_FROM_SITE_TAX_PROF_ID%TYPE;
1159: l_ctrl_hdr_tx_appl_flag ZX_LINES_DET_FACTORS.CTRL_HDR_TX_APPL_FLAG%TYPE;
1160: l_ship_third_pty_acct_site_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID%TYPE;
1161: l_bill_third_pty_acct_site_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID%TYPE;
1162: l_ship_third_pty_acct_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID%TYPE;
1163: l_bill_third_pty_acct_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE;
1164: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
1165: l_currency_conversion_date ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_DATE%TYPE;
1166: l_currency_conversion_rate ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_RATE%TYPE;

Line 1163: l_bill_third_pty_acct_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE;

1159: l_ctrl_hdr_tx_appl_flag ZX_LINES_DET_FACTORS.CTRL_HDR_TX_APPL_FLAG%TYPE;
1160: l_ship_third_pty_acct_site_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID%TYPE;
1161: l_bill_third_pty_acct_site_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID%TYPE;
1162: l_ship_third_pty_acct_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID%TYPE;
1163: l_bill_third_pty_acct_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE;
1164: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
1165: l_currency_conversion_date ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_DATE%TYPE;
1166: l_currency_conversion_rate ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_RATE%TYPE;
1167: l_currency_conversion_type ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_TYPE%TYPE;

Line 1164: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;

1160: l_ship_third_pty_acct_site_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID%TYPE;
1161: l_bill_third_pty_acct_site_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID%TYPE;
1162: l_ship_third_pty_acct_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID%TYPE;
1163: l_bill_third_pty_acct_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE;
1164: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
1165: l_currency_conversion_date ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_DATE%TYPE;
1166: l_currency_conversion_rate ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_RATE%TYPE;
1167: l_currency_conversion_type ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_TYPE%TYPE;
1168:

Line 1165: l_currency_conversion_date ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_DATE%TYPE;

1161: l_bill_third_pty_acct_site_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID%TYPE;
1162: l_ship_third_pty_acct_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID%TYPE;
1163: l_bill_third_pty_acct_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE;
1164: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
1165: l_currency_conversion_date ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_DATE%TYPE;
1166: l_currency_conversion_rate ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_RATE%TYPE;
1167: l_currency_conversion_type ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_TYPE%TYPE;
1168:
1169:

Line 1166: l_currency_conversion_rate ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_RATE%TYPE;

1162: l_ship_third_pty_acct_id ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_ID%TYPE;
1163: l_bill_third_pty_acct_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE;
1164: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
1165: l_currency_conversion_date ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_DATE%TYPE;
1166: l_currency_conversion_rate ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_RATE%TYPE;
1167: l_currency_conversion_type ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_TYPE%TYPE;
1168:
1169:
1170: BEGIN

Line 1167: l_currency_conversion_type ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_TYPE%TYPE;

1163: l_bill_third_pty_acct_id ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE;
1164: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
1165: l_currency_conversion_date ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_DATE%TYPE;
1166: l_currency_conversion_rate ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_RATE%TYPE;
1167: l_currency_conversion_type ZX_LINES_DET_FACTORS.CURRENCY_CONVERSION_TYPE%TYPE;
1168:
1169:
1170: BEGIN
1171:

Line 1188: FROM ZX_LINES

1184: SELECT nvl(min(trx_line_id),0),
1185: nvl(min(trx_line_number),0)
1186: INTO v_trx_line_number,
1187: v_trx_line_id
1188: FROM ZX_LINES
1189: WHERE TRX_ID = p_trx_id
1190: AND APPLICATION_ID = p_application_id
1191: AND EVENT_CLASS_CODE = p_event_class_code
1192: AND ENTITY_CODE = p_entity_code;

Line 1345: SELECT zx_lines_s.nextval

1341: RETURN;
1342:
1343: END;
1344:
1345: SELECT zx_lines_s.nextval
1346: INTO l_tax_line_id
1347: FROM dual;
1348:
1349: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1389: FROM ZX_LINES_DET_FACTORS

1385: l_bill_from_pty_tax_prof_id, l_ship_from_site_tx_prof_id,
1386: l_bill_from_site_tx_prof_id, l_ctrl_hdr_tx_appl_flag,
1387: l_ship_third_pty_acct_site_id, l_bill_third_pty_acct_site_id,
1388: l_ship_third_pty_acct_id, l_bill_third_pty_acct_id
1389: FROM ZX_LINES_DET_FACTORS
1390: WHERE APPLICATION_ID = P_APPLICATION_ID
1391: AND ENTITY_CODE = P_ENTITY_CODE
1392: AND EVENT_CLASS_CODE = P_EVENT_CLASS_CODE
1393: AND TRX_ID = P_TRX_ID

Line 1401: INSERT INTO ZX_LINES (SUMMARY_TAX_LINE_ID,

1397: l_trx_number := NULL;
1398: END;
1399:
1400:
1401: INSERT INTO ZX_LINES (SUMMARY_TAX_LINE_ID,
1402: INTERNAL_ORGANIZATION_ID,
1403: APPLICATION_ID,
1404: ENTITY_CODE,
1405: EVENT_CLASS_CODE,

Line 1596: INSERT INTO ZX_LINES_DET_FACTORS( INTERNAL_ORGANIZATION_ID,

1592: fnd_global.user_id,
1593: sysdate,
1594: fnd_global.login_id);
1595:
1596: INSERT INTO ZX_LINES_DET_FACTORS( INTERNAL_ORGANIZATION_ID,
1597: APPLICATION_ID,
1598: ENTITY_CODE,
1599: EVENT_CLASS_CODE,
1600: EVENT_TYPE_CODE,