1 package OKE_K_ORGANIZER_PKG AUTHID CURRENT_USER as
2 /* $Header: OKEKORGS.pls 115.8 2002/11/20 17:19:21 syho ship $ */
3
4 RECORD_COUNT NUMBER := to_number(FND_PROFILE.VALUE('OKE_K_FIFO_LOG'));
5
6 --
7 -- Procedure: populate_query_node
8 --
9 -- Purpose: return the tree node data based on the passed in where clause
10 --
11 -- Parameters:
12 -- (IN) x_user_valuse varchar2 passed in where clause
13 -- x_icon varchar2 tree node icon
14 -- x_tree_object varchar2 tree name
15 -- x_node_state number tree node state
16 -- x_low_value number low range associated w/current node
17 -- x_high_value number high range associated w/current node
18 --
19 -- (OUT) x_tree_data_table fnd_apptree.node_tbl_type store return tree node data
20 -- x_return_status varchar2 status
21 --
22
23
24 PROCEDURE populate_query_node(x_user_value IN varchar2,
25 x_icon IN varchar2,
26 x_tree_object IN varchar2,
27 x_node_state IN number,
28 x_low_value IN number,
29 x_high_value IN number,
30 x_tree_data_table OUT NOCOPY fnd_apptree.node_tbl_type,
31 x_return_status OUT NOCOPY varchar2);
32
33
34 --
35 -- Procedure: fifo_log
36 --
37 -- Purpose: update the contract documents log for user
38 --
39 -- Parameters:
40 -- (IN) x_user_id number user id
41 -- x_k_header_id number contract document id
42 -- x_object_name varchar2 tree object name
43 --
44
45
46 PROCEDURE fifo_log(x_user_id number,
47 x_k_header_id number,
48 x_object_name varchar2);
49
50 --
51 -- Procedure: get_party_name
52 --
53 -- Purpose: get the customer/contractor name for the contract document
54 --
55 -- Parameters:
56 -- (IN) x_role varchar2 party role
57 -- x_k_header_id number contract document id
58 --
59 -- (OUT) x_party_name varchar2 party name
60 --
61
62
63 PROCEDURE get_party_name(x_role IN varchar2 ,
64 x_k_header_id IN number ,
65 x_party_name OUT NOCOPY varchar2 );
66
67
68 end OKE_K_ORGANIZER_PKG;