DBA Data[Home] [Help]

APPS.ZX_DEFAULT_AUTOMATION_PKG dependencies on ZX_LINES_DET_FACTORS

Line 27: (DEFAULT_TAXATION_COUNTRY zx_lines_det_factors.DEFAULT_TAXATION_COUNTRY%type,

23: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
24: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
25:
26: TYPE DET_TAX_ATTR_REC IS RECORD
27: (DEFAULT_TAXATION_COUNTRY zx_lines_det_factors.DEFAULT_TAXATION_COUNTRY%type,
28: DOCUMENT_SUB_TYPE zx_lines_det_factors.DOCUMENT_SUB_TYPE%type,
29: TRX_BUSINESS_CATEGORY zx_lines_det_factors.TRX_BUSINESS_CATEGORY%type,
30: LINE_INTENDED_USE zx_lines_det_factors.LINE_INTENDED_USE%type,
31: PRODUCT_FISC_CLASSIFICATION zx_lines_det_factors.PRODUCT_FISC_CLASSIFICATION%type,

Line 28: DOCUMENT_SUB_TYPE zx_lines_det_factors.DOCUMENT_SUB_TYPE%type,

24: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
25:
26: TYPE DET_TAX_ATTR_REC IS RECORD
27: (DEFAULT_TAXATION_COUNTRY zx_lines_det_factors.DEFAULT_TAXATION_COUNTRY%type,
28: DOCUMENT_SUB_TYPE zx_lines_det_factors.DOCUMENT_SUB_TYPE%type,
29: TRX_BUSINESS_CATEGORY zx_lines_det_factors.TRX_BUSINESS_CATEGORY%type,
30: LINE_INTENDED_USE zx_lines_det_factors.LINE_INTENDED_USE%type,
31: PRODUCT_FISC_CLASSIFICATION zx_lines_det_factors.PRODUCT_FISC_CLASSIFICATION%type,
32: PRODUCT_CATEGORY zx_lines_det_factors.PRODUCT_CATEGORY%type,

Line 29: TRX_BUSINESS_CATEGORY zx_lines_det_factors.TRX_BUSINESS_CATEGORY%type,

25:
26: TYPE DET_TAX_ATTR_REC IS RECORD
27: (DEFAULT_TAXATION_COUNTRY zx_lines_det_factors.DEFAULT_TAXATION_COUNTRY%type,
28: DOCUMENT_SUB_TYPE zx_lines_det_factors.DOCUMENT_SUB_TYPE%type,
29: TRX_BUSINESS_CATEGORY zx_lines_det_factors.TRX_BUSINESS_CATEGORY%type,
30: LINE_INTENDED_USE zx_lines_det_factors.LINE_INTENDED_USE%type,
31: PRODUCT_FISC_CLASSIFICATION zx_lines_det_factors.PRODUCT_FISC_CLASSIFICATION%type,
32: PRODUCT_CATEGORY zx_lines_det_factors.PRODUCT_CATEGORY%type,
33: PRODUCT_TYPE zx_lines_det_factors.PRODUCT_TYPE%type,

Line 30: LINE_INTENDED_USE zx_lines_det_factors.LINE_INTENDED_USE%type,

26: TYPE DET_TAX_ATTR_REC IS RECORD
27: (DEFAULT_TAXATION_COUNTRY zx_lines_det_factors.DEFAULT_TAXATION_COUNTRY%type,
28: DOCUMENT_SUB_TYPE zx_lines_det_factors.DOCUMENT_SUB_TYPE%type,
29: TRX_BUSINESS_CATEGORY zx_lines_det_factors.TRX_BUSINESS_CATEGORY%type,
30: LINE_INTENDED_USE zx_lines_det_factors.LINE_INTENDED_USE%type,
31: PRODUCT_FISC_CLASSIFICATION zx_lines_det_factors.PRODUCT_FISC_CLASSIFICATION%type,
32: PRODUCT_CATEGORY zx_lines_det_factors.PRODUCT_CATEGORY%type,
33: PRODUCT_TYPE zx_lines_det_factors.PRODUCT_TYPE%type,
34: USER_DEFINED_FISC_CLASS zx_lines_det_factors.USER_DEFINED_FISC_CLASS%type,

Line 31: PRODUCT_FISC_CLASSIFICATION zx_lines_det_factors.PRODUCT_FISC_CLASSIFICATION%type,

27: (DEFAULT_TAXATION_COUNTRY zx_lines_det_factors.DEFAULT_TAXATION_COUNTRY%type,
28: DOCUMENT_SUB_TYPE zx_lines_det_factors.DOCUMENT_SUB_TYPE%type,
29: TRX_BUSINESS_CATEGORY zx_lines_det_factors.TRX_BUSINESS_CATEGORY%type,
30: LINE_INTENDED_USE zx_lines_det_factors.LINE_INTENDED_USE%type,
31: PRODUCT_FISC_CLASSIFICATION zx_lines_det_factors.PRODUCT_FISC_CLASSIFICATION%type,
32: PRODUCT_CATEGORY zx_lines_det_factors.PRODUCT_CATEGORY%type,
33: PRODUCT_TYPE zx_lines_det_factors.PRODUCT_TYPE%type,
34: USER_DEFINED_FISC_CLASS zx_lines_det_factors.USER_DEFINED_FISC_CLASS%type,
35: ASSESSABLE_VALUE zx_lines_det_factors.ASSESSABLE_VALUE%type,

Line 32: PRODUCT_CATEGORY zx_lines_det_factors.PRODUCT_CATEGORY%type,

28: DOCUMENT_SUB_TYPE zx_lines_det_factors.DOCUMENT_SUB_TYPE%type,
29: TRX_BUSINESS_CATEGORY zx_lines_det_factors.TRX_BUSINESS_CATEGORY%type,
30: LINE_INTENDED_USE zx_lines_det_factors.LINE_INTENDED_USE%type,
31: PRODUCT_FISC_CLASSIFICATION zx_lines_det_factors.PRODUCT_FISC_CLASSIFICATION%type,
32: PRODUCT_CATEGORY zx_lines_det_factors.PRODUCT_CATEGORY%type,
33: PRODUCT_TYPE zx_lines_det_factors.PRODUCT_TYPE%type,
34: USER_DEFINED_FISC_CLASS zx_lines_det_factors.USER_DEFINED_FISC_CLASS%type,
35: ASSESSABLE_VALUE zx_lines_det_factors.ASSESSABLE_VALUE%type,
36: PRODUCT_ID zx_lines_det_factors.PRODUCT_ID%type,

Line 33: PRODUCT_TYPE zx_lines_det_factors.PRODUCT_TYPE%type,

29: TRX_BUSINESS_CATEGORY zx_lines_det_factors.TRX_BUSINESS_CATEGORY%type,
30: LINE_INTENDED_USE zx_lines_det_factors.LINE_INTENDED_USE%type,
31: PRODUCT_FISC_CLASSIFICATION zx_lines_det_factors.PRODUCT_FISC_CLASSIFICATION%type,
32: PRODUCT_CATEGORY zx_lines_det_factors.PRODUCT_CATEGORY%type,
33: PRODUCT_TYPE zx_lines_det_factors.PRODUCT_TYPE%type,
34: USER_DEFINED_FISC_CLASS zx_lines_det_factors.USER_DEFINED_FISC_CLASS%type,
35: ASSESSABLE_VALUE zx_lines_det_factors.ASSESSABLE_VALUE%type,
36: PRODUCT_ID zx_lines_det_factors.PRODUCT_ID%type,
37: PRODUCT_ORG_ID zx_lines_det_factors.PRODUCT_ORG_ID%type,

Line 34: USER_DEFINED_FISC_CLASS zx_lines_det_factors.USER_DEFINED_FISC_CLASS%type,

30: LINE_INTENDED_USE zx_lines_det_factors.LINE_INTENDED_USE%type,
31: PRODUCT_FISC_CLASSIFICATION zx_lines_det_factors.PRODUCT_FISC_CLASSIFICATION%type,
32: PRODUCT_CATEGORY zx_lines_det_factors.PRODUCT_CATEGORY%type,
33: PRODUCT_TYPE zx_lines_det_factors.PRODUCT_TYPE%type,
34: USER_DEFINED_FISC_CLASS zx_lines_det_factors.USER_DEFINED_FISC_CLASS%type,
35: ASSESSABLE_VALUE zx_lines_det_factors.ASSESSABLE_VALUE%type,
36: PRODUCT_ID zx_lines_det_factors.PRODUCT_ID%type,
37: PRODUCT_ORG_ID zx_lines_det_factors.PRODUCT_ORG_ID%type,
38: TAX_CLASSIFICATION_CODE zx_lines_det_factors.INPUT_TAX_CLASSIFICATION_CODE%type,

Line 35: ASSESSABLE_VALUE zx_lines_det_factors.ASSESSABLE_VALUE%type,

31: PRODUCT_FISC_CLASSIFICATION zx_lines_det_factors.PRODUCT_FISC_CLASSIFICATION%type,
32: PRODUCT_CATEGORY zx_lines_det_factors.PRODUCT_CATEGORY%type,
33: PRODUCT_TYPE zx_lines_det_factors.PRODUCT_TYPE%type,
34: USER_DEFINED_FISC_CLASS zx_lines_det_factors.USER_DEFINED_FISC_CLASS%type,
35: ASSESSABLE_VALUE zx_lines_det_factors.ASSESSABLE_VALUE%type,
36: PRODUCT_ID zx_lines_det_factors.PRODUCT_ID%type,
37: PRODUCT_ORG_ID zx_lines_det_factors.PRODUCT_ORG_ID%type,
38: TAX_CLASSIFICATION_CODE zx_lines_det_factors.INPUT_TAX_CLASSIFICATION_CODE%type,
39: USER_OVERRIDE_TAX_FLAG zx_lines_det_factors.USER_UPD_DET_FACTORS_FLAG%type,

Line 36: PRODUCT_ID zx_lines_det_factors.PRODUCT_ID%type,

32: PRODUCT_CATEGORY zx_lines_det_factors.PRODUCT_CATEGORY%type,
33: PRODUCT_TYPE zx_lines_det_factors.PRODUCT_TYPE%type,
34: USER_DEFINED_FISC_CLASS zx_lines_det_factors.USER_DEFINED_FISC_CLASS%type,
35: ASSESSABLE_VALUE zx_lines_det_factors.ASSESSABLE_VALUE%type,
36: PRODUCT_ID zx_lines_det_factors.PRODUCT_ID%type,
37: PRODUCT_ORG_ID zx_lines_det_factors.PRODUCT_ORG_ID%type,
38: TAX_CLASSIFICATION_CODE zx_lines_det_factors.INPUT_TAX_CLASSIFICATION_CODE%type,
39: USER_OVERRIDE_TAX_FLAG zx_lines_det_factors.USER_UPD_DET_FACTORS_FLAG%type,
40: --Bug 9454044

Line 37: PRODUCT_ORG_ID zx_lines_det_factors.PRODUCT_ORG_ID%type,

33: PRODUCT_TYPE zx_lines_det_factors.PRODUCT_TYPE%type,
34: USER_DEFINED_FISC_CLASS zx_lines_det_factors.USER_DEFINED_FISC_CLASS%type,
35: ASSESSABLE_VALUE zx_lines_det_factors.ASSESSABLE_VALUE%type,
36: PRODUCT_ID zx_lines_det_factors.PRODUCT_ID%type,
37: PRODUCT_ORG_ID zx_lines_det_factors.PRODUCT_ORG_ID%type,
38: TAX_CLASSIFICATION_CODE zx_lines_det_factors.INPUT_TAX_CLASSIFICATION_CODE%type,
39: USER_OVERRIDE_TAX_FLAG zx_lines_det_factors.USER_UPD_DET_FACTORS_FLAG%type,
40: --Bug 9454044
41: TAX_INVOICE_DATE zx_lines_det_factors.TAX_INVOICE_DATE%TYPE);

Line 38: TAX_CLASSIFICATION_CODE zx_lines_det_factors.INPUT_TAX_CLASSIFICATION_CODE%type,

34: USER_DEFINED_FISC_CLASS zx_lines_det_factors.USER_DEFINED_FISC_CLASS%type,
35: ASSESSABLE_VALUE zx_lines_det_factors.ASSESSABLE_VALUE%type,
36: PRODUCT_ID zx_lines_det_factors.PRODUCT_ID%type,
37: PRODUCT_ORG_ID zx_lines_det_factors.PRODUCT_ORG_ID%type,
38: TAX_CLASSIFICATION_CODE zx_lines_det_factors.INPUT_TAX_CLASSIFICATION_CODE%type,
39: USER_OVERRIDE_TAX_FLAG zx_lines_det_factors.USER_UPD_DET_FACTORS_FLAG%type,
40: --Bug 9454044
41: TAX_INVOICE_DATE zx_lines_det_factors.TAX_INVOICE_DATE%TYPE);
42:

Line 39: USER_OVERRIDE_TAX_FLAG zx_lines_det_factors.USER_UPD_DET_FACTORS_FLAG%type,

35: ASSESSABLE_VALUE zx_lines_det_factors.ASSESSABLE_VALUE%type,
36: PRODUCT_ID zx_lines_det_factors.PRODUCT_ID%type,
37: PRODUCT_ORG_ID zx_lines_det_factors.PRODUCT_ORG_ID%type,
38: TAX_CLASSIFICATION_CODE zx_lines_det_factors.INPUT_TAX_CLASSIFICATION_CODE%type,
39: USER_OVERRIDE_TAX_FLAG zx_lines_det_factors.USER_UPD_DET_FACTORS_FLAG%type,
40: --Bug 9454044
41: TAX_INVOICE_DATE zx_lines_det_factors.TAX_INVOICE_DATE%TYPE);
42:
43: TYPE DET_TAX_ATTR_TBL IS TABLE OF DET_TAX_ATTR_REC INDEX BY VARCHAR2(150);

Line 41: TAX_INVOICE_DATE zx_lines_det_factors.TAX_INVOICE_DATE%TYPE);

37: PRODUCT_ORG_ID zx_lines_det_factors.PRODUCT_ORG_ID%type,
38: TAX_CLASSIFICATION_CODE zx_lines_det_factors.INPUT_TAX_CLASSIFICATION_CODE%type,
39: USER_OVERRIDE_TAX_FLAG zx_lines_det_factors.USER_UPD_DET_FACTORS_FLAG%type,
40: --Bug 9454044
41: TAX_INVOICE_DATE zx_lines_det_factors.TAX_INVOICE_DATE%TYPE);
42:
43: TYPE DET_TAX_ATTR_TBL IS TABLE OF DET_TAX_ATTR_REC INDEX BY VARCHAR2(150);
44: l_det_tax_attr_tbl DET_TAX_ATTR_TBL;
45:

Line 194: FROM zx_lines_det_factors

190: , l_det_tax_attr_tbl(l_source_line_key).TAX_CLASSIFICATION_CODE
191: , l_det_tax_attr_tbl(l_source_line_key).USER_OVERRIDE_TAX_FLAG
192: --Bug 9454044
193: , l_det_tax_attr_tbl(l_source_line_key).tax_invoice_date
194: FROM zx_lines_det_factors
195: WHERE application_id = NVL(l_intrcmp_src_appln_id,ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_application_id(p_trx_line_index))
196: AND entity_code = NVL(l_intrcmp_src_entity_code,ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_entity_code(p_trx_line_index))
197: AND event_class_code = NVL(l_intrcmp_src_event_class_code,ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(p_trx_line_index))
198: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(p_trx_line_index)

Line 269: FROM zx_lines_det_factors

265: , l_det_tax_attr_tbl(l_source_line_key).PRODUCT_ID
266: , l_det_tax_attr_tbl(l_source_line_key).PRODUCT_ORG_ID
267: , l_det_tax_attr_tbl(l_source_line_key).TAX_CLASSIFICATION_CODE
268: , l_det_tax_attr_tbl(l_source_line_key).USER_OVERRIDE_TAX_FLAG
269: FROM zx_lines_det_factors
270: WHERE application_id = NVL(l_intrcmp_src_appln_id,ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_application_id(p_trx_line_index))
271: AND entity_code = NVL(l_intrcmp_src_entity_code,ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_entity_code(p_trx_line_index))
272: AND event_class_code = NVL(l_intrcmp_src_event_class_code,ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(p_trx_line_index))
273: AND trx_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_trx_id(p_trx_line_index)

Line 763: l_tax_invoice_number ZX_LINES_DET_FACTORS.TAX_INVOICE_NUMBER%TYPE;

759: IS
760:
761: l_api_name CONSTANT VARCHAR2(30) := 'DEFAULT_TAX_REPORTING_ATTRIBS';
762:
763: l_tax_invoice_number ZX_LINES_DET_FACTORS.TAX_INVOICE_NUMBER%TYPE;
764: l_tax_invoice_date ZX_LINES_DET_FACTORS.TAX_INVOICE_DATE%TYPE;
765:
766: l_context_info_rec ZX_API_PUB.context_info_rec_type;
767:

Line 764: l_tax_invoice_date ZX_LINES_DET_FACTORS.TAX_INVOICE_DATE%TYPE;

760:
761: l_api_name CONSTANT VARCHAR2(30) := 'DEFAULT_TAX_REPORTING_ATTRIBS';
762:
763: l_tax_invoice_number ZX_LINES_DET_FACTORS.TAX_INVOICE_NUMBER%TYPE;
764: l_tax_invoice_date ZX_LINES_DET_FACTORS.TAX_INVOICE_DATE%TYPE;
765:
766: l_context_info_rec ZX_API_PUB.context_info_rec_type;
767:
768: BEGIN