1 PACKAGE IGC_CBC_FUNDS_CHECKER AS
2 /* $Header: IGCBEFCS.pls 120.6.12000000.3 2007/10/05 13:11:35 mbremkum ship $ */
3
4 /* ------------------------------------------------------------------------- */
5 /* */
6 /* Funds Check API for CC and PSB whenever Funds Check and/or Funds */
7 /* Funds Reservation need to be performed. */
8 /* */
9 /* This routine returns TRUE if successful; otherwise, it returns FALSE */
10 /* */
11 /* In case of failure, this routine will populate the global Message Stack */
12 /* using FND_MESSAGE. The calling routine will retrieve the message from */
13 /* the Stack */
14 /* */
15 /* External Packages which are being invoked include : */
16 /* */
17 /* FND_* */
18 /* */
19 /* GL Tables which are being used include : */
20 /* */
21 /* GL_* */
22 /* */
23 /* AOL Tables which are being used include : */
24 /* */
25 /* FND_* */
26 /* */
27 /* ------------------------------------------------------------------------- */
28
29 -- Parameters :
30
31 -- p_sobid : set of books ID
32 -- p_header_id : CC header ID
33 -- p_mode : funds check mode - 'C' or 'R'
34 -- p_ret_status : return status of funds checking/reservation
35 -- p_actual_flag: 'E' for CC or 'B' for PSB
36
37 FUNCTION IGCFCK(p_sobid IN NUMBER,
38 p_header_id IN NUMBER,
39 p_mode IN VARCHAR2,
40 p_actual_flag IN VARCHAR2,
41 p_doc_type IN VARCHAR2,
42 p_ret_status OUT NOCOPY VARCHAR2,
43 p_batch_result_code OUT NOCOPY VARCHAR2,
44 p_debug IN VARCHAR2:=FND_API.G_FALSE,
45 p_conc_proc IN VARCHAR2:=FND_API.G_FALSE
46 -- p_packet_id IN NUMBER DEFAULT NULL
47 ) RETURN BOOLEAN ;
48 /* Function gives caller the value of Budget info required for temp JE */
49
50
51 /* Procuedure Gets budget information for temporary JE */
52 FUNCTION Get_Rank(
53 p_code IN VARCHAR2)
54 RETURN NUMBER;
55
56 --bug 3199488
57 --PRAGMA RESTRICT_REFERENCES(Get_Rank,WNDS);
58
59
60 FUNCTION Get_Status_By_Result(
61 p_result_code IN VARCHAR2)
62 RETURN VARCHAR2;
63
64 --bug 3199488
65 --PRAGMA RESTRICT_REFERENCES(Get_Status_By_Result,WNDS);
66
67 FUNCTION Get_Result_By_Rank(
68 p_rank IN NUMBER)
69 RETURN VARCHAR2;
70
71 FUNCTION Get_Batch_Result_Code (
72 p_mode VARCHAR2,
73 p_batch_result_code VARCHAR2 )
74 RETURN VARCHAR2;
75
76
77 END IGC_CBC_FUNDS_CHECKER;
78