[Home] [Help]
PACKAGE: APPS.ICX_POR_EXT_ITEM
Source
1 PACKAGE ICX_POR_EXT_ITEM AUTHID CURRENT_USER AS
2 /* $Header: ICXEXTIS.pls 115.13 2004/05/04 14:53:28 srmani ship $*/
3 NULL_NUMBER PLS_INTEGER := -2;
4 -- Price document type
5 TEMPLATE_TYPE PLS_INTEGER := 1;
6 CONTRACT_TYPE PLS_INTEGER := 2;
7 ASL_TYPE PLS_INTEGER := 3;
8 PURCHASING_ITEM_TYPE PLS_INTEGER := 4;
9 INTERNAL_TEMPLATE_TYPE PLS_INTEGER := 5;
10 INTERNAL_ITEM_TYPE PLS_INTEGER := 6;
11 BULKLOAD_TYPE PLS_INTEGER := 7;
12 GLOBAL_AGREEMENT_TYPE PLS_INTEGER := 8;
13
14 -- Bug#3352834 : Dummy request IDs
15 TEMPLATE_TEMP_REQUEST_ID PLS_INTEGER := -10123;
16 CONTRACT_TEMP_REQUEST_ID PLS_INTEGER := -10234;
17 GA_TEMP_REQUEST_ID PLS_INTEGER := -10345;
18 ASL_TEMP_REQUEST_ID PLS_INTEGER := -10456;
19 ITEM_TEMP_REQUEST_ID PLS_INTEGER := -10567;
20 NEW_PRICE_TEMP_REQUEST_ID PLS_INTEGER := -10789;
21 CURRENT_REQUEST_ID PLS_INTEGER := 0;
22
23 -- Bug#3542291 : Dummy Request IDs to be used in setActiveFlags
24 AF_TEMPLATE_TEMP_REQUEST_ID PLS_INTEGER := -20123;
25 AF_CONTRACT_TEMP_REQUEST_ID PLS_INTEGER := -20234;
26 AF_GA_TEMP_REQUEST_ID PLS_INTEGER := -20345;
27 AF_ASL_TEMP_REQUEST_ID PLS_INTEGER := -20456;
28 AF_ITEM_TEMP_REQUEST_ID PLS_INTEGER := -20567;
29 AF_CLEANUP_TEMP_REQUEST_ID PLS_INTEGER := -20678;
30 AF_NEW_PRICE_TEMP_REQUEST_ID PLS_INTEGER := -20789;
31 AF_CURRENT_REQUEST_ID PLS_INTEGER := 0;
32
33 FUNCTION getDocumentType(pPriceType IN VARCHAR2)
34 RETURN VARCHAR2;
35 PROCEDURE cleanupPrices;
36 PROCEDURE extractItemData;
37
38 -- Create functions to get active flag, description, else
39
40 FUNCTION getActiveFlag(p_price_type IN VARCHAR2,
41 p_price_row_id IN ROWID)
42 RETURN VARCHAR2;
43
44 FUNCTION getItemActiveFlag(p_inventory_item_id IN NUMBER,
45 p_org_id IN NUMBER)
46 RETURN VARCHAR2;
47
48 FUNCTION getItemSourceType(p_price_type IN VARCHAR2,
49 p_inventory_item_id IN NUMBER,
50 p_purchasing_enabled_flag IN VARCHAR2,
51 p_outside_operation_flag IN VARCHAR2,
52 p_list_price_per_unit IN NUMBER,
53 p_load_master_item IN VARCHAR2,
54 p_internal_order_enabled_flag IN VARCHAR2,
55 p_load_internal_item IN VARCHAR2)
56 RETURN VARCHAR2;
57
58 FUNCTION getSearchType(p_price_type IN VARCHAR2,
59 p_inventory_item_id IN NUMBER,
60 p_purchasing_enabled_flag IN VARCHAR2,
61 p_outside_operation_flag IN VARCHAR2,
62 p_list_price_per_unit IN NUMBER,
63 p_load_master_item IN VARCHAR2,
64 p_internal_order_enabled_flag IN VARCHAR2,
65 p_load_internal_item IN VARCHAR2)
66 RETURN VARCHAR2;
67
68 FUNCTION getMatchTempalteFlag(p_price_type IN VARCHAR2,
69 p_rt_item_id IN NUMBER,
70 p_template_id IN VARCHAR2)
71 RETURN VARCHAR2;
72
73 -- This function is only used by bulk loader code
74 -- It returns 'Y' -- Active
75 -- 'N' -- Inactive
76 -- 'A' -- ASL price should be reset
77 FUNCTION getBulkLoadActiveFlag(p_action IN VARCHAR2,
78 p_rt_item_id IN NUMBER)
79 RETURN VARCHAR2;
80
81 -- Bug : 3345608
82 --
83 -- Function
84 -- getRate
85 --
86 -- Purpose
87 -- Returns the rate between the from currency and the functional
88 -- currency of the set of books.
89 --
90 -- Arguments
91 -- x_set_of_books_id Set of books id
92 -- x_from_currency From currency
93 -- x_conversion_date Conversion date
94 -- x_conversion_type Conversion type
95 -- x_purchasing_org_id Purchasing Operating Unit ID
96 -- x_owning_org_id Owning org ID
97 -- x_segment1 Blanket Segment1
98 --
99 FUNCTION getRate (
100 x_set_of_books_id NUMBER,
101 x_from_currency VARCHAR2,
102 x_conversion_date DATE,
103 x_conversion_type VARCHAR2 DEFAULT NULL,
104 x_purchasing_org_id NUMBER,
105 x_owning_org_id NUMBER,
106 x_segment1 VARCHAR2) RETURN NUMBER;
107
108 -- Update Request Ids.
109 PROCEDURE updatePriceRequestIds;
110
111 END ICX_POR_EXT_ITEM;