1 PACKAGE por_uda_pkg AUTHID CURRENT_USER AS
2 /* $Header: POR_UDA_PKG.pls 120.3.12020000.2 2013/04/12 17:34:36 mzhussai ship $ */
3
4 PROCEDURE get_pr_line_attr_group_ids(
5 p_template_id IN VARCHAR2,
6 p_req_line_id IN NUMBER,
7 p_is_amd_mode VARCHAR2,
8 x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,
9 x_return_status OUT NOCOPY VARCHAR2
10 );
11
12 PROCEDURE get_pr_header_attr_group_ids(
13 p_template_id IN VARCHAR2,
14 p_req_header_id IN NUMBER,
15 p_is_amd_mode VARCHAR2,
16 x_attr_grp_ids OUT NOCOPY PO_TBL_NUMBER,
17 x_return_status OUT NOCOPY VARCHAR2
18 );
19
20 PROCEDURE merge_amendment_uda_header(p_confirmed_id IN NUMBER,
21 p_revision_num IN NUMBER );
22
23 PROCEDURE merge_amendment_uda_line(p_confirmed_id IN NUMBER,
24 p_revision_num IN NUMBER );
25
26 PROCEDURE copy_uda_line(p_from_req_header_id IN NUMBER,
27 p_to_req_header_id IN number,
28 x_return_status OUT NOCOPY VARCHAR2,
29 x_return_msg OUT NOCOPY varchar2);
30
31 PROCEDURE copy_uda_header(p_from_req_header_id IN number,
32 p_to_req_header_id IN number,
33 x_return_status OUT NOCOPY VARCHAR2,
34 x_return_msg OUT NOCOPY varchar2);
35
36 PROCEDURE DEFAULT_NON_RENDER_UDA( p_req_header_id IN NUMBER,
37 p_is_amend_flow IN VARCHAR,
38 x_return_status OUT NOCOPY VARCHAR2);
39 PROCEDURE SUBMIT_NON_RENDER_UDA( p_req_header_id IN NUMBER
40 ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
41 ,x_return_status OUT NOCOPY VARCHAR2);
42
43 PROCEDURE UDA_SUBMISSION_CHECK
44 (
45 p_pk1_value IN NUMBER
46 ,p_pk2_value IN NUMBER DEFAULT NULL
47 ,p_pk3_value IN NUMBER DEFAULT NULL
48 ,p_pk4_value IN NUMBER DEFAULT NULL
49 ,p_pk5_value IN NUMBER DEFAULT NULL
50 ,p_template_id IN NUMBER
51 ,p_address_lookup_type IN VARCHAR2 DEFAULT NULL
52 ,x_external_attr_value_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_TABLE
53 ,x_return_status OUT NOCOPY VARCHAR2
54 ,x_errorcode OUT NOCOPY NUMBER
55 ,x_msg_count OUT NOCOPY NUMBER
56 ,x_msg_data OUT NOCOPY VARCHAR2
57 ,uda_return_status OUT NOCOPY VARCHAR2
58 ,uda_msg_data OUT NOCOPY VARCHAR2
59 );
60
61 procedure COPY_DOC_NUMBER_UDA(p_old_header_id IN NUMBER
62 ,p_new_header_id IN NUMBER
63 , p_template_id IN NUMBER
64 , x_return_status OUT NOCOPY VARCHAR2);
65
66 END POR_UDA_PKG;
[Home] [Help]