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_DET_FACTORS

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 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 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 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 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,