1 PACKAGE qa_ss_import_wf AUTHID CURRENT_USER AS
2 /* $Header: qltsswfb.pls 120.0.12010000.1 2008/07/25 09:22:55 appldev ship $ */
3
4 PROCEDURE unblock (item_type IN VARCHAR2, key IN NUMBER);
5
6 PROCEDURE check_completion (itemtype IN VARCHAR2,
7 itemkey IN VARCHAR2,
8 actid IN NUMBER,
9 funcmode IN VARCHAR2,
10 result OUT NOCOPY VARCHAR2);
11
12 PROCEDURE dispatch_notification (itemtype IN VARCHAR2,
13 itemkey IN VARCHAR2,
14 actid IN NUMBER,
15 funcmode IN VARCHAR2,
16 result OUT NOCOPY VARCHAR2);
17
18 PROCEDURE set_message_attr(id IN NUMBER);
19
20 PROCEDURE start_buyer_notification
21 (x_buyer_id IN NUMBER DEFAULT NULL,
22 x_source_id IN NUMBER DEFAULT NULL,
23 x_plan_id IN NUMBER DEFAULT NULL ,
24 x_item_id IN NUMBER DEFAULT NULL,
25 x_po_header_id IN NUMBER DEFAULT NULL);
26
27 PROCEDURE send (itemtype IN VARCHAR2,
28 itemkey IN VARCHAR2,
29 actid IN NUMBER,
30 funcmode IN VARCHAR2,
31 result OUT NOCOPY VARCHAR2);
32
33 FUNCTION create_buyer_process(x_type IN VARCHAR2) RETURN NUMBER;
34
35 FUNCTION get_itemtype_profile RETURN VARCHAR2;
36
37 FUNCTION get_buyer_name(s_id IN NUMBER) RETURN VARCHAR2;
38
39 FUNCTION get_user_name(u_id IN NUMBER) RETURN VARCHAR2;
40
41 FUNCTION get_plan_name(p_id IN NUMBER) RETURN VARCHAR2 ;
42
43 FUNCTION get_org_id(p_id IN NUMBER) RETURN NUMBER;
44
45 FUNCTION get_org_code (org_id IN NUMBER) RETURN VARCHAR2;
46
47 FUNCTION get_org_name (org_id IN NUMBER) RETURN VARCHAR2;
48
49
50 FUNCTION get_item (i_id IN NUMBER) RETURN VARCHAR2 ;
51
52 PROCEDURE set_supplier_info(s_id IN NUMBER, x_itemkey IN NUMBER,
53 x_itemtype IN VARCHAR2);
54
55 FUNCTION get_po_number (p_id IN NUMBER) RETURN VARCHAR2;
56
57
58
59 END qa_ss_import_wf;
60