1 PACKAGE PO_ASL_API_GRP AUTHID CURRENT_USER AS
2 /* $Header: PO_ASL_API_GRP.pls 120.2.12020000.2 2013/02/11 13:35:01 vegajula noship $*/
3
4 --------------------------------------------------------------------------------
5 --Start of Comments
6
7 --Name: process
8
9 --Function:
10 -- This will determine whether to do insert or update.
11 -- Create will throw error if you are passing diuplicate asl.
12 -- Update will throw error if asl does not exists.
13 -- Call Validation interface to perform field validations
14 -- Call PO_ASL_API_PVT.reject_asl_record for the records in case any
15 -- validation error.
16
17 --Parameters:
18
19 --IN:
20 -- p_session_key NUMBER
21
22 --OUT:
23 -- x_return_status VARCHAR2
24 -- x_return_msg VARCHAR2
25
26 --End of Comments
27 --------------------------------------------------------------------------------
28
29 PROCEDURE process(
30 p_session_key IN NUMBER
31 , x_return_status OUT NOCOPY VARCHAR2
32 , x_return_msg OUT NOCOPY VARCHAR2
33 );
34
35 FUNCTION determine_action(
36 p_item_id IN NUMBER
37 , p_category_id IN NUMBER
38 , p_using_organization_id IN NUMBER
39 , p_vendor_id IN NUMBER
40 , p_vendor_site_id IN NUMBER
41 )
42 RETURN VARCHAR2;
43
44 FUNCTION validate_vmi(
45 p_item_id IN NUMBER
46 , p_using_organization_id IN NUMBER
47 , p_vendor_site_id IN NUMBER
48 )
49 RETURN VARCHAR2;
50
51
52 END PO_ASL_API_GRP;