APPS.ZX_TDS_RULE_BASE_DETM_PVT dependencies on MTL_SYSTEM_ITEMS

Line 104: p_product_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,

100: - get_product_tax_info
101: - get get_party_tax_info
102:
103: PROCEDURE get_tax_info_from_item(
104: p_product_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
105: p_item_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE,
106: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
107: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
108: p_return_status OUT NOCOPY VARCHAR2,

Line 105: p_item_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE,

101: - get get_party_tax_info
102:
103: PROCEDURE get_tax_info_from_item(
104: p_product_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
105: p_item_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE,
106: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
107: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
108: p_return_status OUT NOCOPY VARCHAR2,
109: p_error_buffer OUT NOCOPY VARCHAR2);

Line 4943: FROM MTL_SYSTEM_ITEMS

4939: 8192);
4940: BEGIN
4941: SELECT item_type
4942: INTO l_trx_alphanumeric_value
4943: FROM MTL_SYSTEM_ITEMS
4944: WHERE inventory_item_id = ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PRODUCT_ID(p_structure_index)
4945: AND organization_id = nvl(ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.PRODUCT_ORG_ID(p_structure_index),
4946: p_event_class_rec.internal_organization_id);
4947: EXCEPTION

Line 6691: -- get taxable_flag or tax_code from mtl_system_items

6687: RETURN;
6688: END IF;
6689:
6690: --
6691: -- get taxable_flag or tax_code from mtl_system_items
6692: --
6693: get_tax_info_from_item(l_product_id,
6694: l_item_org_id,
6695: p_determining_factor_code,

Line 6729: -- mtl_system_items table depending on the determining factor code passed in

6725: -- get_tax_info_from_item
6726: --
6727: -- DESCRIPTION
6728: -- This procedure returns taxable_flag or tax_code obtained from
6729: -- mtl_system_items table depending on the determining factor code passed in
6730: --
6731:
6732: PROCEDURE get_tax_info_from_item(
6733: p_product_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,

Line 6733: p_product_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,

6729: -- mtl_system_items table depending on the determining factor code passed in
6730: --
6731:
6732: PROCEDURE get_tax_info_from_item(
6733: p_product_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
6734: p_item_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE,
6735: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
6736: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6737: p_return_status OUT NOCOPY VARCHAR2,

Line 6734: p_item_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE,

6730: --
6731:
6732: PROCEDURE get_tax_info_from_item(
6733: p_product_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
6734: p_item_org_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE,
6735: p_determining_factor_code IN ZX_CONDITIONS.DETERMINING_FACTOR_CODE%TYPE,
6736: p_trx_alphanumeric_value OUT NOCOPY ZX_CONDITIONS.ALPHANUMERIC_VALUE%TYPE,
6737: p_return_status OUT NOCOPY VARCHAR2,
6738: p_error_buffer OUT NOCOPY VARCHAR2)

Line 6742: (c_product_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,

6738: p_error_buffer OUT NOCOPY VARCHAR2)
6739:
6740: IS
6741: CURSOR get_tax_code_csr
6742: (c_product_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
6743: c_item_org_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE)
6744: IS
6745: SELECT TAX_CODE
6746: FROM MTL_SYSTEM_ITEMS

Line 6743: c_item_org_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE)

6739:
6740: IS
6741: CURSOR get_tax_code_csr
6742: (c_product_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
6743: c_item_org_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE)
6744: IS
6745: SELECT TAX_CODE
6746: FROM MTL_SYSTEM_ITEMS
6747: WHERE INVENTORY_ITEM_ID = c_product_id AND

Line 6746: FROM MTL_SYSTEM_ITEMS

6742: (c_product_id MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE,
6743: c_item_org_id MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE)
6744: IS
6745: SELECT TAX_CODE
6746: FROM MTL_SYSTEM_ITEMS
6747: WHERE INVENTORY_ITEM_ID = c_product_id AND
6748: ORGANIZATION_ID = c_item_org_id;
6749:
6750: BEGIN