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_TAXWARE_USER_PKG dependencies on ZX_LINES

Line 44: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,

40:
41: /***********Declaration of private procedures*************/
42: PROCEDURE POPULATE_EXEMPTION_DETAILS
43: (
44: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,
45: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
46: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
47: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
48: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,

Line 45: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,

41: /***********Declaration of private procedures*************/
42: PROCEDURE POPULATE_EXEMPTION_DETAILS
43: (
44: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,
45: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
46: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
47: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
48: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
49: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,

Line 46: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,

42: PROCEDURE POPULATE_EXEMPTION_DETAILS
43: (
44: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,
45: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
46: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
47: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
48: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
49: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
50: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,

Line 47: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,

43: (
44: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,
45: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
46: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
47: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
48: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
49: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
50: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
51: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%TYPE,

Line 48: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,

44: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,
45: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
46: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
47: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
48: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
49: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
50: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
51: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%TYPE,
52: p_product_id IN ZX_LINES_DET_FACTORS.product_id%TYPE,

Line 49: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,

45: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
46: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
47: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
48: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
49: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
50: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
51: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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,

Line 50: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,

46: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
47: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
48: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
49: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
50: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
51: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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,

Line 51: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%TYPE,

47: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
48: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
49: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
50: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
51: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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,

Line 52: p_product_id IN ZX_LINES_DET_FACTORS.product_id%TYPE,

48: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
49: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
50: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
51: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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,

Line 53: p_cert_num IN ZX_LINES_DET_FACTORS.exempt_certificate_number%TYPE,

49: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
50: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
51: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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,

Line 54: p_exmpt_rsn_code IN ZX_LINES_DET_FACTORS.exempt_reason_code%TYPE,

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

Line 55: p_exemption_control_flag IN ZX_LINES_DET_FACTORS.Exemption_Control_Flag%TYPE,

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

Line 63: p_application_id IN ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,

59: );
60:
61: PROCEDURE derive_view_name
62: (
63: p_application_id IN ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,
64: p_event_class_code IN ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,
65: p_api_name IN VARCHAR2,
66: p_adjusted_doc_trx_id IN ZX_LINES_DET_FACTORS.ADJUSTED_DOC_TRX_ID%TYPE,
67: p_line_level_action IN ZX_LINES_DET_FACTORS.LINE_LEVEL_ACTION%TYPE,

Line 64: p_event_class_code IN ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,

60:
61: PROCEDURE derive_view_name
62: (
63: p_application_id IN ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,
64: p_event_class_code IN ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,
65: p_api_name IN VARCHAR2,
66: p_adjusted_doc_trx_id IN ZX_LINES_DET_FACTORS.ADJUSTED_DOC_TRX_ID%TYPE,
67: p_line_level_action IN ZX_LINES_DET_FACTORS.LINE_LEVEL_ACTION%TYPE,
68: x_view_name OUT NOCOPY VARCHAR2

Line 66: p_adjusted_doc_trx_id IN ZX_LINES_DET_FACTORS.ADJUSTED_DOC_TRX_ID%TYPE,

62: (
63: p_application_id IN ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,
64: p_event_class_code IN ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,
65: p_api_name IN VARCHAR2,
66: p_adjusted_doc_trx_id IN ZX_LINES_DET_FACTORS.ADJUSTED_DOC_TRX_ID%TYPE,
67: p_line_level_action IN ZX_LINES_DET_FACTORS.LINE_LEVEL_ACTION%TYPE,
68: x_view_name OUT NOCOPY VARCHAR2
69: );
70: PROCEDURE Initialize_Nested_Tables ;

Line 67: p_line_level_action IN ZX_LINES_DET_FACTORS.LINE_LEVEL_ACTION%TYPE,

63: p_application_id IN ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,
64: p_event_class_code IN ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,
65: p_api_name IN VARCHAR2,
66: p_adjusted_doc_trx_id IN ZX_LINES_DET_FACTORS.ADJUSTED_DOC_TRX_ID%TYPE,
67: p_line_level_action IN ZX_LINES_DET_FACTORS.LINE_LEVEL_ACTION%TYPE,
68: x_view_name OUT NOCOPY VARCHAR2
69: );
70: PROCEDURE Initialize_Nested_Tables ;
71: PROCEDURE Initialize_Exemption_Tables;

Line 123: l_event_class_code ZX_LINES_DET_FACTORS.Event_Class_Code%TYPE;

119: PROCEDURE Derive_Hdr_Ext_Attr( x_error_status OUT NOCOPY VARCHAR2
120: , x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type) IS
121:
122: l_header_ext_attr1 ZX_PRVDR_HDR_EXTNS_GT.HEADER_EXT_VARCHAR_ATTRIBUTE1%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;

Line 124: l_application_id ZX_LINES_DET_FACTORS.Application_Id%TYPE;

120: , x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type) IS
121:
122: l_header_ext_attr1 ZX_PRVDR_HDR_EXTNS_GT.HEADER_EXT_VARCHAR_ATTRIBUTE1%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;

Line 125: l_entity_code ZX_LINES_DET_FACTORS.Entity_Code%TYPE;

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

Line 126: l_trx_id ZX_LINES_DET_FACTORS.Trx_Id%TYPE;

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

Line 162: ZX_LINES_DET_FACTORS ZX_DET_FACT ,

158: l_tax_regime_code,
159: g_trx_date,
160: g_trx_type_id
161: FROM
162: ZX_LINES_DET_FACTORS ZX_DET_FACT ,
163: ZX_USER_PROC_INPUT_V ZX_PRE_REC_OPT
164: WHERE
165: ZX_DET_FACT.INTERNAL_ORGANIZATION_ID = ZX_PRE_REC_OPT.INTERNAL_ORGANIZATION_ID
166: AND ZX_DET_FACT.APPLICATION_ID = ZX_PRE_REC_OPT.APPLICATION_ID

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

310: PROCEDURE Derive_Line_Ext_Attr( x_error_status OUT NOCOPY VARCHAR2
311: , x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type) IS
312:
313:
314: --This is the main driver cursor for fetching all records from the ZX_LINES_DET_FACTORS
315: --to populate into the ZX_PRVDR_LINE_EXTNS_GT table
316:
317:
318: CURSOR PROC_LINE_CSR IS

Line 358: ZX_LINES_DET_FACTORS ZX_LINE_DET_FACT ,

354: ZX_LINE_DET_FACT.ADJUSTED_DOC_TRX_LEVEL_TYPE ,
355: ZX_LINE_DET_FACT.SHIP_THIRD_PTY_ACCT_SITE_ID ,
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

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

373: OR (ZX_LINE_DET_FACT.LINE_LEVEL_ACTION = 'DELETE'));
374:
375:
376: --This is the cursor for fetching all records from the ZX_USR_PROC_NEG_LINE_V.
377: --The specific purpose of this view is to retain old data from zx_lines_det_factors
378: --to populate into the ZX_PRVDR_LINE_EXTNS_GT table
379:
380: CURSOR PROC_NEG_LINE_CSR IS
381: SELECT

Line 432: l_product_id ZX_LINES_DET_FACTORS.product_id%TYPE;

428:
429: x_exemption_record ZX_TCM_GET_EXEMPT_PKG.exemption_rec_type;
430: x_ret_status VARCHAR2(30);
431: l_errors PLS_INTEGER;
432: l_product_id ZX_LINES_DET_FACTORS.product_id%TYPE;
433: l_memo_line_id NUMBER;
434: l_is_view_name_derived VARCHAR2(1);
435: --l_view_name VARCHAR2(200); --Commented for the bug#6723111
436: l_srv_name VARCHAR2(100);

Line 846: p_application_id IN ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,

842: | 08/13/2004 Arnab Sengupta Created.
843: |
844: +==========================================================================*/
845: PROCEDURE DERIVE_VIEW_NAME(
846: p_application_id IN ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,
847: p_event_class_code IN ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,
848: p_api_name IN VARCHAR2,
849: p_adjusted_doc_trx_id IN ZX_LINES_DET_FACTORS.ADJUSTED_DOC_TRX_ID%TYPE,
850: p_line_level_action IN ZX_LINES_DET_FACTORS.LINE_LEVEL_ACTION%TYPE,

Line 847: p_event_class_code IN ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,

843: |
844: +==========================================================================*/
845: PROCEDURE DERIVE_VIEW_NAME(
846: p_application_id IN ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,
847: p_event_class_code IN ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,
848: p_api_name IN VARCHAR2,
849: p_adjusted_doc_trx_id IN ZX_LINES_DET_FACTORS.ADJUSTED_DOC_TRX_ID%TYPE,
850: p_line_level_action IN ZX_LINES_DET_FACTORS.LINE_LEVEL_ACTION%TYPE,
851: x_view_name OUT NOCOPY VARCHAR2

Line 849: p_adjusted_doc_trx_id IN ZX_LINES_DET_FACTORS.ADJUSTED_DOC_TRX_ID%TYPE,

845: PROCEDURE DERIVE_VIEW_NAME(
846: p_application_id IN ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,
847: p_event_class_code IN ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,
848: p_api_name IN VARCHAR2,
849: p_adjusted_doc_trx_id IN ZX_LINES_DET_FACTORS.ADJUSTED_DOC_TRX_ID%TYPE,
850: p_line_level_action IN ZX_LINES_DET_FACTORS.LINE_LEVEL_ACTION%TYPE,
851: x_view_name OUT NOCOPY VARCHAR2
852: )
853: IS

Line 850: p_line_level_action IN ZX_LINES_DET_FACTORS.LINE_LEVEL_ACTION%TYPE,

846: p_application_id IN ZX_LINES_DET_FACTORS.APPLICATION_ID%TYPE,
847: p_event_class_code IN ZX_LINES_DET_FACTORS.EVENT_CLASS_CODE%TYPE,
848: p_api_name IN VARCHAR2,
849: p_adjusted_doc_trx_id IN ZX_LINES_DET_FACTORS.ADJUSTED_DOC_TRX_ID%TYPE,
850: p_line_level_action IN ZX_LINES_DET_FACTORS.LINE_LEVEL_ACTION%TYPE,
851: x_view_name OUT NOCOPY VARCHAR2
852: )
853: IS
854: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_VIEW_NAME';

Line 963: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,

959: +==========================================================================*/
960:
961: PROCEDURE POPULATE_EXEMPTION_DETAILS
962: (
963: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,
964: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
965: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
966: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
967: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,

Line 964: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,

960:
961: PROCEDURE POPULATE_EXEMPTION_DETAILS
962: (
963: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,
964: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
965: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
966: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
967: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
968: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,

Line 965: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,

961: PROCEDURE POPULATE_EXEMPTION_DETAILS
962: (
963: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,
964: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
965: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
966: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
967: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
968: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
969: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,

Line 966: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,

962: (
963: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,
964: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
965: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
966: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
967: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
968: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
969: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
970: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%TYPE,

Line 967: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,

963: p_bill_to_site_use IN ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE,
964: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
965: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
966: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
967: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
968: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
969: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
970: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%TYPE,
971: p_product_id IN ZX_LINES_DET_FACTORS.product_id%TYPE,

Line 968: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,

964: p_bill_to_location_id IN ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE,
965: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
966: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
967: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
968: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
969: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
970: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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,

Line 969: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,

965: p_bill_to_party_tax_id IN ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE,
966: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
967: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
968: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
969: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
970: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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,

Line 970: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%TYPE,

966: p_bill_to_site_tax_prof IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
967: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
968: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
969: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
970: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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,

Line 971: p_product_id IN ZX_LINES_DET_FACTORS.product_id%TYPE,

967: p_hq_site_tax_prof_id IN ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE,
968: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
969: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
970: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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,

Line 972: p_cert_num IN ZX_LINES_DET_FACTORS.exempt_certificate_number%TYPE,

968: p_hq_party_tax_prof_id_tab IN ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE,
969: p_bill_third_pty_acct_id IN ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE,
970: p_product_org_id IN ZX_LINES_DET_FACTORS.PRODUCT_ORG_ID%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,

Line 973: p_exmpt_rsn_code IN ZX_LINES_DET_FACTORS.exempt_reason_code%TYPE,

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

Line 974: p_exemption_control_flag IN ZX_LINES_DET_FACTORS.Exemption_Control_Flag%TYPE,

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

Line 1097: FROM ZX_LINES

1093:
1094: BEGIN
1095: SELECT TAX_EXEMPTION_ID
1096: INTO x_exempt_record.exemption_id
1097: FROM ZX_LINES
1098: WHERE application_id = adj_doc_appl_id_tab(p_position)
1099: AND entity_code = adj_doc_entity_code_tab(p_position)
1100: AND event_class_code = adj_evnt_cls_code_tab(p_position)
1101: AND trx_id = adjusted_doc_trx_id_tab(p_position)

Line 1648: l_product_id ZX_LINES_DET_FACTORS.product_id%TYPE;

1644:
1645: PROCEDURE DERIVE_PRODUCT_CODE
1646: IS
1647:
1648: l_product_id ZX_LINES_DET_FACTORS.product_id%TYPE;
1649: l_memo_line_id NUMBER;
1650: l_master_org_id oe_system_parameters_all.master_organization_id%type;
1651:
1652: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_PRODUCT_CODE';

Line 2211: FROM zx_lines_det_factors

2207: IF arp_transaction_date_tab(i) IS NULL THEN
2208: BEGIN
2209: SELECT trx_line_gl_date
2210: INTO arp_transaction_date_tab(i)
2211: FROM zx_lines_det_factors
2212: WHERE internal_organization_id = internal_org_id_tab(i)
2213: AND application_id = application_id_tab(i)
2214: AND Entity_Code = entity_code_tab(i)
2215: AND Event_Class_Code = event_class_code_tab(i)