APPS.ZX_VTX_USER_PKG dependencies on ZX_TRX_PRE_PROC_OPTIONS_GT

Line 51: p_tax_regime_code IN ZX_TRX_PRE_PROC_OPTIONS_GT.Tax_Regime_Code%TYPE,

47: p_product_id IN ZX_LINES_DET_FACTORS.product_id%TYPE,
48: p_cert_num IN ZX_LINES_DET_FACTORS.exempt_certificate_number%TYPE,
49: p_exmpt_rsn_code IN ZX_LINES_DET_FACTORS.exempt_reason_code%TYPE,
50: p_exemption_control_flag IN ZX_LINES_DET_FACTORS.Exemption_Control_Flag%TYPE,
51: p_tax_regime_code IN ZX_TRX_PRE_PROC_OPTIONS_GT.Tax_Regime_Code%TYPE,
52: p_position IN NUMBER,
53: p_error_status OUT NOCOPY VARCHAR2
54: );
55:

Line 116: l_tax_provider_id ZX_TRX_PRE_PROC_OPTIONS_GT.Tax_Provider_Id%TYPE;

112: l_event_class_code ZX_LINES_DET_FACTORS.Event_Class_Code%TYPE;
113: l_application_id ZX_LINES_DET_FACTORS.Application_Id%TYPE;
114: l_entity_code ZX_LINES_DET_FACTORS.Entity_Code%TYPE;
115: l_trx_id ZX_LINES_DET_FACTORS.Trx_Id%TYPE;
116: l_tax_provider_id ZX_TRX_PRE_PROC_OPTIONS_GT.Tax_Provider_Id%TYPE;
117: l_tax_regime_code ZX_TRX_PRE_PROC_OPTIONS_GT.Tax_Regime_Code%TYPE;
118: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_HDR_EXT_ATTR';
119: l_exists_in_hdrs_gt NUMBER;
120:

Line 117: l_tax_regime_code ZX_TRX_PRE_PROC_OPTIONS_GT.Tax_Regime_Code%TYPE;

113: l_application_id ZX_LINES_DET_FACTORS.Application_Id%TYPE;
114: l_entity_code ZX_LINES_DET_FACTORS.Entity_Code%TYPE;
115: l_trx_id ZX_LINES_DET_FACTORS.Trx_Id%TYPE;
116: l_tax_provider_id ZX_TRX_PRE_PROC_OPTIONS_GT.Tax_Provider_Id%TYPE;
117: l_tax_regime_code ZX_TRX_PRE_PROC_OPTIONS_GT.Tax_Regime_Code%TYPE;
118: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_HDR_EXT_ATTR';
119: l_exists_in_hdrs_gt NUMBER;
120:
121: BEGIN

Line 351: ZX_TRX_PRE_PROC_OPTIONS_GT ZTPPO

347: ZX_LINE_DET_FACT.BILL_THIRD_PTY_ACCT_SITE_ID
348: FROM
349: ZX_LINES_DET_FACTORS ZX_LINE_DET_FACT ,
350: ZX_USER_PROC_INPUT_V ZUPI ,
351: ZX_TRX_PRE_PROC_OPTIONS_GT ZTPPO
352: WHERE
353: ZX_LINE_DET_FACT.INTERNAL_ORGANIZATION_ID = ZUPI.INTERNAL_ORGANIZATION_ID
354: AND ZX_LINE_DET_FACT.APPLICATION_ID = ZUPI.APPLICATION_ID
355: AND ZX_LINE_DET_FACT.EVENT_CLASS_CODE = ZUPI.EVENT_CLASS_CODE

Line 898: p_tax_regime_code IN ZX_TRX_PRE_PROC_OPTIONS_GT.Tax_Regime_Code%TYPE,

894: p_product_id IN ZX_LINES_DET_FACTORS.product_id%TYPE,
895: p_cert_num IN ZX_LINES_DET_FACTORS.exempt_certificate_number%TYPE,
896: p_exmpt_rsn_code IN ZX_LINES_DET_FACTORS.exempt_reason_code%TYPE,
897: p_exemption_control_flag IN ZX_LINES_DET_FACTORS.Exemption_Control_Flag%TYPE,
898: p_tax_regime_code IN ZX_TRX_PRE_PROC_OPTIONS_GT.Tax_Regime_Code%TYPE,
899: p_position IN NUMBER,
900: p_error_status OUT NOCOPY VARCHAR2
901: ) IS
902:

Line 2451: from ZX_TRX_PRE_PROC_OPTIONS_GT;

2447: cursor error_exception_cursor is
2448: select EVNT_CLS_MAPPING_ID,
2449: TRX_ID,
2450: TAX_REGIME_CODE
2451: from ZX_TRX_PRE_PROC_OPTIONS_GT;
2452:
2453: l_docment_type_id number;
2454: l_trasaction_id number;
2455: l_tax_regime_code varchar2(80);