DBA Data[Home] [Help]

PACKAGE: APPS.POR_ITEM_ATTRIBUTES_PKG

Source


1 PACKAGE POR_ITEM_ATTRIBUTES_PKG AUTHID CURRENT_USER AS
2 /* $Header: PORATTRS.pls 115.2 2003/11/14 02:44:57 kaholee ship $ */
3 
4 
5 procedure Create_Attach_Item_Attr(itemtype in varchar2,
6                                 itemkey         in varchar2,
7                                 actid           in number,
8                                 funcmode        in varchar2,
9                                 resultout       out NOCOPY varchar2);
10 
11 /******************************************************************
12  * Gets Requisition Lines that have associated adhoc data         *
13  ******************************************************************/
14 PROCEDURE add_attribute_attachment(p_req_header_id IN NUMBER,
15                                    p_item_type IN VARCHAR2,
16                                    p_category_id IN NUMBER DEFAULT 33,
17                                    p_wf_item_type IN VARCHAR2,
18                                    p_wf_item_key IN VARCHAR2);
19 
20 /******************************************************************
21  * Concatenate all attribute codes and values into a text value   *
22  * for an associated Requisition Line.                            *
23  ******************************************************************/
24 PROCEDURE get_attach_text(p_requisition_line_id   IN NUMBER,
25                           p_requisition_header_id IN NUMBER,
26                           p_item_type             IN VARCHAR2,
27                           p_text 		  OUT NOCOPY LONG);
28 
29 /* 2977976
30    Appends the parameter m_a1 to m_a15 to the existing text
31    if  the value of the parameters m_a1 to m_a15 is not null
32 */
33 function append_if_not_null(existing_text IN long,
34                             m_a1 IN varchar2,
35                             m_a2 IN varchar2,
36                             m_a3 IN varchar2,
37                             m_a4 IN varchar2,
38                             m_a5 IN varchar2,
39                             m_a6 IN varchar2,
40                             m_a7 IN varchar2,
41                             m_a8 IN varchar2,
42                             m_a9 IN varchar2,
43                             m_a10 IN varchar2,
44                             m_a11 IN varchar2,
45                             m_a12 IN varchar2,
46                             m_a13 IN varchar2,
47                             m_a14 IN varchar2,
48                             m_a15 IN varchar2)
49 return long;
50 
51 END POR_ITEM_ATTRIBUTES_PKG;