DBA Data[Home] [Help]

APPS.ZX_TAXWARE_USER_PKG dependencies on ZX_TRX_PRE_PROC_OPTIONS_GT

Line 56: p_tax_regime_code IN ZX_TRX_PRE_PROC_OPTIONS_GT.Tax_Regime_Code%TYPE,

52: p_product_id IN ZX_LINES_DET_FACTORS.product_id%TYPE,
53: p_cert_num IN ZX_LINES_DET_FACTORS.exempt_certificate_number%TYPE,
54: p_exmpt_rsn_code IN ZX_LINES_DET_FACTORS.exempt_reason_code%TYPE,
55: p_exemption_control_flag IN ZX_LINES_DET_FACTORS.Exemption_Control_Flag%TYPE,
56: p_tax_regime_code IN ZX_TRX_PRE_PROC_OPTIONS_GT.Tax_Regime_Code%TYPE,
57: p_position IN NUMBER,
58: p_error_status OUT NOCOPY VARCHAR2
59: );
60:

Line 127: l_tax_provider_id ZX_TRX_PRE_PROC_OPTIONS_GT.Tax_Provider_Id%TYPE;

123: l_event_class_code ZX_LINES_DET_FACTORS.Event_Class_Code%TYPE;
124: l_application_id ZX_LINES_DET_FACTORS.Application_Id%TYPE;
125: l_entity_code ZX_LINES_DET_FACTORS.Entity_Code%TYPE;
126: l_trx_id ZX_LINES_DET_FACTORS.Trx_Id%TYPE;
127: l_tax_provider_id ZX_TRX_PRE_PROC_OPTIONS_GT.Tax_Provider_Id%TYPE;
128: l_tax_regime_code ZX_TRX_PRE_PROC_OPTIONS_GT.Tax_Regime_Code%TYPE;
129: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_HDR_EXT_ATTR';
130: l_exists_in_hdrs_gt NUMBER;
131:

Line 128: l_tax_regime_code ZX_TRX_PRE_PROC_OPTIONS_GT.Tax_Regime_Code%TYPE;

124: l_application_id ZX_LINES_DET_FACTORS.Application_Id%TYPE;
125: l_entity_code ZX_LINES_DET_FACTORS.Entity_Code%TYPE;
126: l_trx_id ZX_LINES_DET_FACTORS.Trx_Id%TYPE;
127: l_tax_provider_id ZX_TRX_PRE_PROC_OPTIONS_GT.Tax_Provider_Id%TYPE;
128: l_tax_regime_code ZX_TRX_PRE_PROC_OPTIONS_GT.Tax_Regime_Code%TYPE;
129: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_HDR_EXT_ATTR';
130: l_exists_in_hdrs_gt NUMBER;
131:
132:

Line 360: ZX_TRX_PRE_PROC_OPTIONS_GT ZTPPO

356: ZX_LINE_DET_FACT.BILL_THIRD_PTY_ACCT_SITE_ID
357: FROM
358: ZX_LINES_DET_FACTORS ZX_LINE_DET_FACT ,
359: ZX_USER_PROC_INPUT_V ZUPI ,
360: ZX_TRX_PRE_PROC_OPTIONS_GT ZTPPO
361: WHERE
362: ZX_LINE_DET_FACT.INTERNAL_ORGANIZATION_ID = ZUPI.INTERNAL_ORGANIZATION_ID
363: AND ZX_LINE_DET_FACT.APPLICATION_ID = ZUPI.APPLICATION_ID
364: AND ZX_LINE_DET_FACT.EVENT_CLASS_CODE = ZUPI.EVENT_CLASS_CODE

Line 975: p_tax_regime_code IN ZX_TRX_PRE_PROC_OPTIONS_GT.Tax_Regime_Code%TYPE,

971: p_product_id IN ZX_LINES_DET_FACTORS.product_id%TYPE,
972: p_cert_num IN ZX_LINES_DET_FACTORS.exempt_certificate_number%TYPE,
973: p_exmpt_rsn_code IN ZX_LINES_DET_FACTORS.exempt_reason_code%TYPE,
974: p_exemption_control_flag IN ZX_LINES_DET_FACTORS.Exemption_Control_Flag%TYPE,
975: p_tax_regime_code IN ZX_TRX_PRE_PROC_OPTIONS_GT.Tax_Regime_Code%TYPE,
976: p_position IN NUMBER,
977: p_error_status OUT NOCOPY VARCHAR2
978: ) IS
979:

Line 2396: from ZX_TRX_PRE_PROC_OPTIONS_GT;

2392: cursor error_exception_cursor is
2393: select EVNT_CLS_MAPPING_ID,
2394: TRX_ID,
2395: TAX_REGIME_CODE
2396: from ZX_TRX_PRE_PROC_OPTIONS_GT;
2397:
2398: l_docment_type_id number;
2399: l_trasaction_id number;
2400: l_tax_regime_code varchar2(80);