[Home] [Help]
PACKAGE: APPS.PO_ASL_API_PUB
Source
1 PACKAGE PO_ASL_API_PUB AUTHID CURRENT_USER AS
2 /* $Header: PO_ASL_API_PUB.pls 120.2.12020000.2 2013/02/11 13:46:25 vegajula noship $*/
3
4 -- ASL PROCESS_ACTION Constants
5 g_ACTION_CREATE CONSTANT VARCHAR2(10) := 'CREATE';
6 g_ACTION_UPDATE CONSTANT VARCHAR2(10) := 'UPDATE';
7 g_ACTION_SYNC CONSTANT VARCHAR2(10) := 'SYNC';
8
9 -- CHILD PROCESS_ACTION Constants
10 g_ACTION_ADD CONSTANT VARCHAR2(10) := 'ADD';
11 g_ACTION_DELETE CONSTANT VARCHAR2(10) := 'DELETE';
12 --------------------------------------------------------------------------------
13 --Start of Comments
14
15 --Name: create_update_asl
16
17 --Function:
18 -- This will dump the data from the plsql tables into global temporary tables
19 -- with a session key generated by this procedure
20
21 --Parameters:
22
23 --IN:
24 -- p_asl_rec PO_APPROVED_SUPPLIER_LIST_REC
25 -- p_asl_attr_rec PO_ASL_ATTRIBUTES_REC
26 -- p_asl_doc_rec PO_ASL_DOCUMENTS_REC
27 -- p_chv_auth_rec CHV_AUTHORIZATIONS_REC
28 -- p_capacity_rec PO_SUPPLIER_ITEM_CAPACITY_REC
29 -- p_tolerance_rec PO_SUPPLIER_ITEM_TOLERANCE_REC
30 -- p_commit VARCHAR2
31
32 --OUT:
33 -- x_session_key NUMBER
34 -- x_return_status VARCHAR2(1)
35 -- x_return_msg VARCHAR2(2000)
36
37 --End of Comments
38 --------------------------------------------------------------------------------
39 PROCEDURE create_update_asl(
40 p_asl_rec IN PO_APPROVED_SUPPLIER_LIST_REC
41 , p_asl_attr_rec IN PO_ASL_ATTRIBUTES_REC
42 , p_asl_doc_rec IN PO_ASL_DOCUMENTS_REC
43 , p_chv_auth_rec IN CHV_AUTHORIZATIONS_REC
44 , p_capacity_rec IN PO_SUPPLIER_ITEM_CAPACITY_REC
45 , p_tolerance_rec IN PO_SUPPLIER_ITEM_TOLERANCE_REC
46 , p_commit IN VARCHAR2
47 , x_session_key OUT NOCOPY NUMBER
48 , x_return_status OUT NOCOPY VARCHAR2
49 , x_return_msg OUT NOCOPY VARCHAR2
50 );
51
52
53 --------------------------------------------------------------------------------
54 --Start of Comments
55
56 --Name: process
57
58 --Function:
59 -- This will first derive the id fields based on the display values provided.
60 -- Next it will try to default any null fields which are defaultable.
61 -- Call PO_ASL_API_PVT.reject_asl_record for which the id values remain null
62 -- and dsp values are not null after processing
63
64 --Parameters:
65
66 --OUT:
67 -- x_return_status VARCHAR2(1)
68 -- x_return_msg VARCHAR2(2000)
69
70 --End of Comments
71 ---------------------------------------------------------------------------------
72
73 PROCEDURE process(
74 x_return_status OUT NOCOPY VARCHAR2
75 , x_return_msg OUT NOCOPY VARCHAR2
76 );
77
78
79 --------------------------------------------------------------------------------
80 --START of comments
81
82 --NAME: get_doc_header
83
84 --FUNCTION:
85 -- Retrieves the document header id based on item and category
86
87 --PARAMETERS:
88 --IN:
89 -- p_user_key_tbl po_tbl_number
90 -- p_entity_name po_tbl_varchar30
91 -- p_rejection_reason po_tbl_varchar2000
92
93 --OUT:
94 -- x_return_status VARCHAR2
95 -- x_return_msg VARCHAR2
96
97 --END of comments
98 --------------------------------------------------------------------------------
99
100 FUNCTION get_doc_header(
101 p_user_key IN NUMBER
102 , p_doc_type IN VARCHAR2
103 , p_using_org_id IN NUMBER
104 , p_segment IN VARCHAR2
105 )
106 RETURN NUMBER;
107
108 --------------------------------------------------------------------------------
109 --START of comments
110
111 --NAME: get_doc_line_id
112
113 --FUNCTION:
114 -- Retrieves the document line id based on headerId, item and category
115
116 --PARAMETERS:
117 --IN:
118 -- p_user_key_tbl po_tbl_number
119 -- p_entity_name po_tbl_varchar30
120 -- p_rejection_reason po_tbl_varchar2000
121
122 --OUT:
123 -- x_return_status VARCHAR2
124 -- x_return_msg VARCHAR2
125
126 --END of comments
127 --------------------------------------------------------------------------------
128
129 FUNCTION get_doc_line_id(
130 p_user_key IN NUMBER
131 , p_header_id IN VARCHAR2
132 , p_using_org_id IN NUMBER
133 , p_line_num IN NUMBER
134 )
135 RETURN NUMBER;
136
137 END PO_ASL_API_PUB;