1 PACKAGE IGC_CC_REP_YEP_PVT AUTHID CURRENT_USER AS
2 /* $Header: IGCCPRVS.pls 120.3.12000000.4 2007/10/18 12:19:05 bmaddine ship $ */
3
4 FUNCTION LOCK_CC( P_CC_HEADER_ID IN NUMBER)
5 RETURN BOOLEAN;
6
7 FUNCTION LOCK_PO( P_CC_HEADER_ID NUMBER)
8 RETURN BOOLEAN;
9
10
11 FUNCTION VALIDATE_CC( p_CC_HEADER_ID IN NUMBER,
12 p_PROCESS_TYPE IN VARCHAR2,
13 p_PROCESS_PHASE IN VARCHAR2,
14 p_YEAR IN NUMBER,
15 p_SOB_ID IN NUMBER,
16 p_ORG_ID IN NUMBER,
17 p_PROV_ENC_ON IN BOOLEAN,
18 p_REQUEST_ID IN NUMBER)
19 RETURN VARCHAR2;
20
21 FUNCTION invoice_canc_or_paid(p_cc_header_id NUMBER)
22 RETURN BOOLEAN;
23
24 FUNCTION Encumber_CC
25 (
26 p_process_type IN VARCHAR2,
27 p_cc_header_id IN NUMBER,
28 p_sbc_on IN BOOLEAN,
29 p_cbc_on IN BOOLEAN,
30 /*Bug No : 6341012. SLA Uptake. Encumbrance Types are not required*/
31 -- p_cc_prov_enc_type_id IN NUMBER,
32 -- p_cc_conf_enc_type_id IN NUMBER,
33 -- p_req_encumbrance_type_id IN NUMBER,
34 -- p_purch_encumbrance_type_id IN NUMBER,
35 p_currency_code IN VARCHAR2,
36 p_yr_start_date IN DATE,
37 p_yr_end_date IN DATE,
38 p_yr_end_cr_date IN DATE,
39 p_yr_end_dr_date IN DATE,
40 p_rate_date IN DATE,
41 p_rate IN NUMBER,
42 p_revalue_fix_date IN DATE
43 ) RETURN VARCHAR2;
44
45 FUNCTION get_budg_ctrl_params(
46 p_sob_id IN NUMBER,
47 p_org_id IN NUMBER,
48 p_currency_code OUT NOCOPY VARCHAR2,
49 p_sbc_on OUT NOCOPY BOOLEAN,
50 p_cbc_on OUT NOCOPY BOOLEAN,
51 p_prov_enc_on OUT NOCOPY BOOLEAN,
52 p_conf_enc_on OUT NOCOPY BOOLEAN,
53 /*Bug No : 6341012. SLA Uptake. Encumbrance Types are not required*/
54 -- p_req_encumbrance_type_id OUT NOCOPY NUMBER,
55 -- p_purch_encumbrance_type_id OUT NOCOPY NUMBER,
56 -- p_cc_prov_enc_type_id OUT NOCOPY NUMBER,
57 -- p_cc_conf_enc_type_id OUT NOCOPY NUMBER ,
58 p_msg_data OUT NOCOPY VARCHAR2,
59 p_msg_count OUT NOCOPY NUMBER,
60 p_usr_msg OUT NOCOPY VARCHAR2
61 ) RETURN BOOLEAN;
62
63 END IGC_CC_REP_YEP_PVT;