PACKAGE: APPS.PO_UDA_AUTOCREATE_PKG

Source

1 PACKAGE PO_UDA_AUTOCREATE_PKG AUTHID CURRENT_USER AS
2 /* $Header: PO_UDA_AUTOCREATE_PKG.pls 120.2.12020000.2 2013/02/22 11:29:27 amalick ship $ */
3 
4 
5 -- Global Variables and constants
6 G_OFFER VARCHAR2(3) := 'OFR';
7 G_SOLICITATION VARCHAR2(3) := 'SOL';
8 G_IDV VARCHAR2(3) := 'IDV';
9 G_PO VARCHAR2(3) := 'AWD';
10 G_REQUISITION VARCHAR2(3) := 'REQ';
11 G_SYSTEM VARCHAR2(3) := 'SYS';
12 
13 
14 g_sol_header_pkey_col VARCHAR2(25) := 'AUCTION_HEADER_ID';
15 g_sol_line_number VARCHAR2(15) := 'LINE_NUMBER';
16 g_ofr_header_pkey_col  CONSTANT VARCHAR2(15)  := 'BID_NUMBER';
17 g_ofr_line_number VARCHAR2(15) := 'LINE_NUMBER';
18 
19 g_req_header_pkey_col  CONSTANT VARCHAR2(25)  := 'REQUISITION_HEADER_ID';
20 g_req_line_pkey_col	   CONSTANT VARCHAR2(20)  := 'REQUISITION_LINE_ID';
21 
22 
23 g_pk1_value NUMBER;       --bug12611018
24 g_pk2_value NUMBER;       --bug12611018
25 
26 -- Procedures
27 
28 Procedure AUTOCREATE_UDA_DATA(
29 		P_SOURCE_DOCUMENT IN VARCHAR2, --PR,SOL
30 		P_TARGET_DOCUMENT IN VARCHAR2, --SOL,PO,IDV
31 		P_SRC_PK1_VALUE IN NUMBER,
32 		P_SRC_PK2_VALUE IN NUMBER,
33 		P_TAR_PK1_VALUE IN NUMBER,
34 		P_TAR_PK2_VALUE IN NUMBER,
35 		X_RETURN_STATUS OUT NOCOPY VARCHAR2,
36     X_ERRORCODE OUT NOCOPY NUMBER,
37     X_MSG_COUNT OUT NOCOPY NUMBER,
38     X_MSG_DATA OUT NOCOPY VARCHAR2);
39 
40 FUNCTION get_pk1_value RETURN number;  --bug12611018
41 FUNCTION get_pk2_value RETURN number;  --bug12611018
42 
43 --<Bug 16308668 Start> : Moving procedures to Spec
44 PROCEDURE get_attribute_groups(p_uda_template_id IN NUMBER,
45                                x_attr_group_tbl  IN OUT NOCOPY PO_TBL_VARCHAR30
46                                );
47 FUNCTION get_uda_template_id
48            ( p_functional_area IN VARCHAR2
49             ,p_doc_type IN  VARCHAR2
50             ,p_doc_level IN VARCHAR2
51             ,p_doc_style_id  IN NUMBER DEFAULT NULL
52            ) RETURN number;
53 
54 FUNCTION get_template_id(p_table_name          IN VARCHAR2,
55                          p_pkey1_col_name      IN VARCHAR2,
56                          p_pkey1_val           IN NUMBER,
57                          p_pkey2_col_name      IN VARCHAR2,
58                          p_pkey2_val           IN NUMBER
59                         ) RETURN NUMBER;
60 
61 PROCEDURE get_group_id_tbl(p_level IN VARCHAR2,
62                            x_attr_group_id_tbl OUT NOCOPY po_tbl_number
63                           );
64 --<Bug 16308668 End>
65 
66 END PO_UDA_AUTOCREATE_PKG;