PACKAGE: APPS.QP_MASS_MAINTAIN_UTIL

Source

1 PACKAGE QP_MASS_MAINTAIN_UTIL AS
2 /* $Header: QPXMMUTS.pls 120.1.12010000.1 2008/07/28 11:54:43 appldev ship $ */
3 
4 --GLOBAL Constant holding the package name
5 
6   G_PKG_NAME               CONSTANT  VARCHAR2(30) := 'QP_MASS_MAINTAIN_UTIL';
7 
8   -- This Function returns 'N' if pte_code and source_system_code of passed list_header_id matches
9   -- with the corresponding profile values else returns 'Y'
10   -- Its confusing but has been done intentionally
11 
12   FUNCTION Check_SS_PTE_Codes_Match (p_list_header_id   IN NUMBER ) RETURN VARCHAR2;
13 
14   -- This function return the product description
15   FUNCTION get_product_desc(p_product_attr_context  varchar2,
16                             p_product_attr  varchar2,
17                             p_product_attr_val varchar2) RETURN VARCHAR2;
18 
19   Function Get_Product_UOM_Code ( p_list_line_id IN NUMBER,
20                                 p_product_attr_context  IN VARCHAR2,
21                                 p_product_attr  IN VARCHAR2 ) return VARCHAR2;
22 
23   -- This procedure gets the select statement associated with context_code
24   -- and segment_code and return it.
25   PROCEDURE get_valueset_select(p_context_code IN  VARCHAR2,
26                                 p_segment_code IN  VARCHAR2,
27                                 x_select_stmt  OUT NOCOPY VARCHAR2,
28                                 p_segment_map_col IN VARCHAR2 DEFAULT NULL, -- sfiresto fix
29                                 p_pte IN VARCHAR2 DEFAULT NULL,  -- Hierarchical Categories
30                                 p_ss  IN VARCHAR2 DEFAULT NULL); -- Hierarchical Categories
31 END QP_MASS_MAINTAIN_UTIL;