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_VTX_USER_PKG dependencies on ZX_LINES_DET_FACTORS

Line 39: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,

35:
36: /***********Declaration of private procedures*************/
37: PROCEDURE POPULATE_EXEMPTION_DETAILS
38: (
39: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,
40: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
41: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
42: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
43: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,

Line 40: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,

36: /***********Declaration of private procedures*************/
37: PROCEDURE POPULATE_EXEMPTION_DETAILS
38: (
39: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,
40: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
41: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
42: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
43: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
44: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,

Line 41: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,

37: PROCEDURE POPULATE_EXEMPTION_DETAILS
38: (
39: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,
40: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
41: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
42: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
43: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
44: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
45: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,

Line 42: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,

38: (
39: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,
40: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
41: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
42: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
43: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
44: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
45: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
46: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%TYPE,

Line 43: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,

39: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,
40: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
41: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
42: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
43: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
44: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
45: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
46: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%TYPE,
47: p_product_id IN ZX_LINES_DET_FACTORS.product_id%TYPE,

Line 44: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,

40: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
41: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
42: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
43: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
44: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
45: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
46: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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,

Line 45: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,

41: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
42: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
43: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
44: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
45: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
46: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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,

Line 46: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%TYPE,

42: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
43: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
44: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
45: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
46: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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,

Line 47: p_product_id IN ZX_LINES_DET_FACTORS.product_id%TYPE,

43: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
44: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
45: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
46: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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,

Line 48: p_cert_num IN ZX_LINES_DET_FACTORS.exempt_certificate_number%TYPE,

44: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
45: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
46: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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,

Line 49: p_exmpt_rsn_code IN ZX_LINES_DET_FACTORS.exempt_reason_code%TYPE,

45: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
46: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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

Line 50: p_exemption_control_flag IN ZX_LINES_DET_FACTORS.Exemption_Control_Flag%TYPE,

46: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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: );

Line 58: p_application_id IN ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,

54: );
55:
56: PROCEDURE derive_view_name
57: (
58: p_application_id IN ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,
59: p_event_class_code IN ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,
60: p_api_name IN VARCHAR2,
61: p_adjusted_doc_trx_id IN ZX_LINES_DET_FACTORS.ADJUSTED_DOC_TRX_ID%TYPE,
62: p_line_level_action IN ZX_LINES_DET_FACTORS.LINE_LEVEL_ACTION%TYPE,

Line 59: p_event_class_code IN ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,

55:
56: PROCEDURE derive_view_name
57: (
58: p_application_id IN ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,
59: p_event_class_code IN ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,
60: p_api_name IN VARCHAR2,
61: p_adjusted_doc_trx_id IN ZX_LINES_DET_FACTORS.ADJUSTED_DOC_TRX_ID%TYPE,
62: p_line_level_action IN ZX_LINES_DET_FACTORS.LINE_LEVEL_ACTION%TYPE,
63: x_view_name OUT NOCOPY VARCHAR2

Line 61: p_adjusted_doc_trx_id IN ZX_LINES_DET_FACTORS.ADJUSTED_DOC_TRX_ID%TYPE,

57: (
58: p_application_id IN ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,
59: p_event_class_code IN ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,
60: p_api_name IN VARCHAR2,
61: p_adjusted_doc_trx_id IN ZX_LINES_DET_FACTORS.ADJUSTED_DOC_TRX_ID%TYPE,
62: p_line_level_action IN ZX_LINES_DET_FACTORS.LINE_LEVEL_ACTION%TYPE,
63: x_view_name OUT NOCOPY VARCHAR2
64: );
65: PROCEDURE Initialize_Nested_Tables ;

Line 62: p_line_level_action IN ZX_LINES_DET_FACTORS.LINE_LEVEL_ACTION%TYPE,

58: p_application_id IN ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,
59: p_event_class_code IN ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,
60: p_api_name IN VARCHAR2,
61: p_adjusted_doc_trx_id IN ZX_LINES_DET_FACTORS.ADJUSTED_DOC_TRX_ID%TYPE,
62: p_line_level_action IN ZX_LINES_DET_FACTORS.LINE_LEVEL_ACTION%TYPE,
63: x_view_name OUT NOCOPY VARCHAR2
64: );
65: PROCEDURE Initialize_Nested_Tables ;
66: PROCEDURE Initialize_Exemption_Tables;

Line 112: l_event_class_code ZX_LINES_DET_FACTORS.Event_Class_Code%TYPE;

108: PROCEDURE Derive_Hdr_Ext_Attr( x_error_status OUT NOCOPY VARCHAR2
109: , x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type) IS
110:
111: l_header_ext_attr1 ZX_PRVDR_HDR_EXTNS_GT.HEADER_EXT_VARCHAR_ATTRIBUTE1%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;

Line 113: l_application_id ZX_LINES_DET_FACTORS.Application_Id%TYPE;

109: , x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type) IS
110:
111: l_header_ext_attr1 ZX_PRVDR_HDR_EXTNS_GT.HEADER_EXT_VARCHAR_ATTRIBUTE1%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;

Line 114: l_entity_code ZX_LINES_DET_FACTORS.Entity_Code%TYPE;

110:
111: l_header_ext_attr1 ZX_PRVDR_HDR_EXTNS_GT.HEADER_EXT_VARCHAR_ATTRIBUTE1%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';

Line 115: l_trx_id ZX_LINES_DET_FACTORS.Trx_Id%TYPE;

111: l_header_ext_attr1 ZX_PRVDR_HDR_EXTNS_GT.HEADER_EXT_VARCHAR_ATTRIBUTE1%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;

Line 151: ZX_LINES_DET_FACTORS ZX_DET_FACT ,

147: l_tax_regime_code,
148: g_trx_date,
149: g_trx_type_id
150: FROM
151: ZX_LINES_DET_FACTORS ZX_DET_FACT ,
152: ZX_USER_PROC_INPUT_V ZX_PRE_REC_OPT
153: WHERE
154: ZX_DET_FACT.INTERNAL_ORGANIZATION_ID = ZX_PRE_REC_OPT.INTERNAL_ORGANIZATION_ID
155: AND ZX_DET_FACT.APPLICATION_ID = ZX_PRE_REC_OPT.APPLICATION_ID

Line 306: --This is the main driver cursor for fetching all records from the ZX_LINES_DET_FACTORS

302: PROCEDURE Derive_Line_Ext_Attr( x_error_status OUT NOCOPY VARCHAR2
303: , x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type) IS
304:
305:
306: --This is the main driver cursor for fetching all records from the ZX_LINES_DET_FACTORS
307: --to populate into the ZX_PRVDR_LINE_EXTNS_GT table
308:
309:
310: CURSOR PROC_LINE_CSR IS

Line 349: ZX_LINES_DET_FACTORS ZX_LINE_DET_FACT ,

345: ZX_LINE_DET_FACT.ADJUSTED_DOC_TRX_LEVEL_TYPE ,
346: ZX_LINE_DET_FACT.SHIP_THIRD_PTY_ACCT_SITE_ID ,
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

Line 368: --The specific purpose of this view is to retain old data from zx_lines_det_factors

364: OR (ZX_LINE_DET_FACT.LINE_LEVEL_ACTION = 'DELETE'));
365:
366:
367: --This is the cursor for fetching all records from the ZX_USR_PROC_NEG_LINE_V.
368: --The specific purpose of this view is to retain old data from zx_lines_det_factors
369: --to populate into the ZX_PRVDR_LINE_EXTNS_GT table
370:
371: CURSOR PROC_NEG_LINE_CSR IS
372: SELECT

Line 778: p_application_id IN ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,

774: | 08/13/2004 Arnab Sengupta Created.
775: |
776: +==========================================================================*/
777: PROCEDURE DERIVE_VIEW_NAME(
778: p_application_id IN ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,
779: p_event_class_code IN ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,
780: p_api_name IN VARCHAR2,
781: p_adjusted_doc_trx_id IN ZX_LINES_DET_FACTORS.ADJUSTED_DOC_TRX_ID%TYPE,
782: p_line_level_action IN ZX_LINES_DET_FACTORS.LINE_LEVEL_ACTION%TYPE,

Line 779: p_event_class_code IN ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,

775: |
776: +==========================================================================*/
777: PROCEDURE DERIVE_VIEW_NAME(
778: p_application_id IN ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,
779: p_event_class_code IN ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,
780: p_api_name IN VARCHAR2,
781: p_adjusted_doc_trx_id IN ZX_LINES_DET_FACTORS.ADJUSTED_DOC_TRX_ID%TYPE,
782: p_line_level_action IN ZX_LINES_DET_FACTORS.LINE_LEVEL_ACTION%TYPE,
783: x_view_name OUT NOCOPY VARCHAR2

Line 781: p_adjusted_doc_trx_id IN ZX_LINES_DET_FACTORS.ADJUSTED_DOC_TRX_ID%TYPE,

777: PROCEDURE DERIVE_VIEW_NAME(
778: p_application_id IN ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,
779: p_event_class_code IN ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,
780: p_api_name IN VARCHAR2,
781: p_adjusted_doc_trx_id IN ZX_LINES_DET_FACTORS.ADJUSTED_DOC_TRX_ID%TYPE,
782: p_line_level_action IN ZX_LINES_DET_FACTORS.LINE_LEVEL_ACTION%TYPE,
783: x_view_name OUT NOCOPY VARCHAR2
784: ) IS
785:

Line 782: p_line_level_action IN ZX_LINES_DET_FACTORS.LINE_LEVEL_ACTION%TYPE,

778: p_application_id IN ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,
779: p_event_class_code IN ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,
780: p_api_name IN VARCHAR2,
781: p_adjusted_doc_trx_id IN ZX_LINES_DET_FACTORS.ADJUSTED_DOC_TRX_ID%TYPE,
782: p_line_level_action IN ZX_LINES_DET_FACTORS.LINE_LEVEL_ACTION%TYPE,
783: x_view_name OUT NOCOPY VARCHAR2
784: ) IS
785:
786: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_VIEW_NAME';

Line 886: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,

882: |
883: +==========================================================================*/
884: PROCEDURE POPULATE_EXEMPTION_DETAILS
885: (
886: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,
887: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
888: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
889: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
890: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,

Line 887: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,

883: +==========================================================================*/
884: PROCEDURE POPULATE_EXEMPTION_DETAILS
885: (
886: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,
887: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
888: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
889: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
890: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
891: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,

Line 888: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,

884: PROCEDURE POPULATE_EXEMPTION_DETAILS
885: (
886: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,
887: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
888: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
889: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
890: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
891: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
892: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,

Line 889: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,

885: (
886: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,
887: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
888: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
889: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
890: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
891: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
892: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
893: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%TYPE,

Line 890: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,

886: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,
887: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
888: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
889: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
890: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
891: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
892: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
893: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%TYPE,
894: p_product_id IN ZX_LINES_DET_FACTORS.product_id%TYPE,

Line 891: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,

887: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
888: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
889: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
890: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
891: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
892: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
893: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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,

Line 892: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,

888: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
889: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
890: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
891: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
892: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
893: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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,

Line 893: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%TYPE,

889: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
890: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
891: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
892: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
893: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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,

Line 894: p_product_id IN ZX_LINES_DET_FACTORS.product_id%TYPE,

890: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
891: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
892: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
893: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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,

Line 895: p_cert_num IN ZX_LINES_DET_FACTORS.exempt_certificate_number%TYPE,

891: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
892: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
893: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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,

Line 896: p_exmpt_rsn_code IN ZX_LINES_DET_FACTORS.exempt_reason_code%TYPE,

892: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
893: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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

Line 897: p_exemption_control_flag IN ZX_LINES_DET_FACTORS.Exemption_Control_Flag%TYPE,

893: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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

Line 1725: l_product_id ZX_LINES_DET_FACTORS.product_id%TYPE;

1721:
1722: PROCEDURE DERIVE_PRODUCT_CODE
1723: IS
1724:
1725: l_product_id ZX_LINES_DET_FACTORS.product_id%TYPE;
1726: l_memo_line_id NUMBER;
1727: l_org_id RA_CUSTOMER_TRX_LINES_ALL.ORG_ID%TYPE;
1728: l_master_org_id oe_system_parameters_all.master_organization_id%type;
1729:

Line 1971: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;

1967: l_inventory_item_id NUMBER;
1968: l_master_org_id oe_system_parameters_all.master_organization_id%type;
1969: l_org_id RA_CUSTOMER_TRX_LINES_ALL.ORG_ID%TYPE;
1970: l_ship_from_party_id ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE;
1971: l_ship_from_location_id ZX_LINES_DET_FACTORS.SHIP_FROM_LOCATION_ID%TYPE;
1972:
1973: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_SHIP_FROM_ADDRESS_CODE';
1974:
1975: BEGIN

Line 1983: FROM ZX_LINES_DET_FACTORS

1979:
1980: BEGIN
1981: SELECT SHIP_FROM_LOCATION_ID
1982: INTO l_ship_from_location_id
1983: FROM ZX_LINES_DET_FACTORS
1984: WHERE APPLICATION_ID = application_id_tab(i)
1985: AND ENTITY_CODE = entity_code_tab(i)
1986: AND EVENT_CLASS_CODE = event_class_code_tab(i)
1987: AND TRX_ID = trx_id_tab(i)

Line 2400: FROM zx_lines_det_factors

2396: IF arp_transaction_date_tab(i) IS NULL THEN
2397: BEGIN
2398: SELECT trx_line_gl_date
2399: INTO arp_transaction_date_tab(i)
2400: FROM zx_lines_det_factors
2401: WHERE internal_organization_id = internal_org_id_tab(i)
2402: AND application_id = application_id_tab(i)
2403: AND Entity_Code = entity_code_tab(i)
2404: AND Event_Class_Code = event_class_code_tab(i)