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;