1 PACKAGE po_control_action_validations AUTHID CURRENT_USER AS
2 /* $Header: PO_CONTROL_ACTION_VALIDATIONS.pls 120.1.12020000.1 2013/02/10 16:26:52 vegajula noship $*/
3
4
5 c_cancel_api CONSTANT VARCHAR2(30) :='CANCEL API';
6
7 --------------------------------------------------------------------------------
8 --Start of Comments
9 --Name: validate_cancel_action
10 --
11 --Effects: Validates the document for Cancel Action and insert the error in
12 -- online_eport_text table.
13 --Notes:
14 -- See the package body for more comments.
15 --End of Comments
16 -------------------------------------------------------------------------------
17 PROCEDURE validate_cancel_action(
18 p_da_call_rec IN OUT NOCOPY po_document_action_pvt.DOC_ACTION_CALL_TBL_REC_TYPE,
19 p_key IN po_session_gt.key%TYPE,
20 p_user_id IN po_lines.last_updated_by%TYPE,
21 p_login_id IN po_lines.last_update_login%TYPE,
22 p_po_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE,
23 p_req_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.req_encumbrance_flag%TYPE,
24 x_return_status OUT NOCOPY VARCHAR2,
25 x_msg_data OUT NOCOPY VARCHAR2,
26 x_return_code OUT NOCOPY VARCHAR2
27
28 );
29
30 -------------------------------------------------------------------------------
31 --Start of Comments
32 --Name: is_complex_work_po
33 --
34 -- Function:
35 -- This is wrapper function on PO_COMPLEX_WORK_PVT.is_complex_work_po.
36 -- PO_COMPLEX_WORK_PVT.is_complex_work_po returns boolean,so cannot be used
37 -- in sql statmemt
38 -- So creating a wrapper on it, that will return 'Y'/'N'.
39 --Notes:
40 -- See the package body for more comments.
41 --End of Comments
42 -------------------------------------------------------------------------------
43
44 FUNCTION is_complex_work_po (p_doc_id IN NUMBER)
45 RETURN VARCHAR2;
46
47 -------------------------------------------------------------------------------
48 --Start of Comments
49 --Name: val_doc_security
50 --
51 -- Function:
52 -- This is wrapper function on PO_REQS_CONTROL_SV.val_doc_security.
53 -- PO_REQS_CONTROL_SV.val_doc_security returns boolean , so cannot be used
54 -- in sql statmemt
55 -- So creating a wrapper on it, that will return 'Y'/'N'.
56 --Notes:
57 -- See the package body for more comments.
58 --End of Comments
59 -------------------------------------------------------------------------------
60
61 FUNCTION val_doc_security (p_doc_agent_id IN NUMBER,
62 p_agent_id IN NUMBER,
63 p_doc_type IN VARCHAR2,
64 p_doc_subtype IN VARCHAR2) RETURN VARCHAR2;
65
66 END po_control_action_validations;