1 PACKAGE PSA_BC_XLA_PVT AUTHID CURRENT_USER AS
2 --$Header: psavbcxs.pls 120.6.12020000.1 2012/06/26 13:10:18 appldev ship $
3 ---------------------------------------------------------------------------
4
5
6 G_BC_MODE VARCHAR(1);
7 G_OVERRIDE_FLAG VARCHAR2(1);
8 G_USER_ID NUMBER;
9 G_USER_RESP_ID NUMBER;
10 G_APPLICATION_ID NUMBER;
11 G_PACKET_ID NUMBER;
12
13
14 -- /*============================================================================
15 -- API name : Budgetary_Control
16 -- Type : private
17 -- Pre-reqs : Create events in psa_bc_xla_events_gt
18 -- Description : Invokes the SLA accounting engine for BCPSA
19 --
20 --
21 --
22 -- Parameters :
23 -- IN :
24 -- p_init_msg_list IN VARCHAR2 optional Default FND_API.G_FALSE
25 -- p_commit IN VARCHAR2 optional Default FND_API.G_FALSE
26 -- p_application_id IN NUMBER Required
27 -- p_bc_mode IN NUMBER optional Possible values:Check(C )
28 -- /Reserve(R)/partial(P)/Force pass(F)
29 -- p_bc_override_flag VARCHAR2 optional Possible values: Y/N
30 -- p_user_id IN NUMBER optional
31 -- p_user_resp_id IN NUMBER optional
32 --
33 -- OUT : x_return_status OUT VARCHAR2(1)
34 -- x_msg_count OUT NUMBER
35 -- x_msg_data OUT VARCHAR2(2000)
36 -- x_status_code OUT
37 -- x_packet_id OUT NUMBER
38 -- /*============================================================================
39
40 PROCEDURE Budgetary_Control
41 ( p_init_msg_list IN VARCHAR2 DEFAULT NULL
42 ,x_return_status OUT NOCOPY VARCHAR2
43 ,x_msg_count OUT NOCOPY NUMBER
44 ,x_msg_data OUT NOCOPY VARCHAR2
45 ,p_application_id IN INTEGER
46 ,p_bc_mode IN VARCHAR2 DEFAULT NULL
47 ,p_override_flag IN VARCHAR2 DEFAULT NULL
48 ,P_user_id IN NUMBER DEFAULT NULL
49 ,P_user_resp_id IN NUMBER DEFAULT NULL
50 ,x_status_code OUT NOCOPY VARCHAR2
51 ,x_Packet_ID OUT NOCOPY NUMBER
52 );
53
54
55 -- /*============================================================================
56 -- API name : get_sla_notupgraded_flag
57 -- Type : private
58 -- Pre-reqs : None
59 -- Description : Returns Y/N depending on whether the distribution passed is notupgraded
60 --
61 -- Parameters :
62 -- IN :
63 -- p_application_id IN NUMBER Applied to Application ID
64 -- p_entity_code IN VARCHAR2 Applied to Entity code
65 -- p_source_id_int_1 IN NUMBER Applied to Header ID
66 -- p_dist_link_type IN VARCHAR2 Applied to Dist Link Type
67 -- p_distribution_id IN NUMBER Applied to Distribution ID
68 --
69 -- Returns : VARCHAR2 i.e., Y/N
70 -- /*============================================================================
71
72
73
74 FUNCTION get_sla_notupgraded_flag ( p_application_id IN NUMBER,
75 p_entity_code IN VARCHAR2,
76 p_source_id_int_1 IN NUMBER,
77 p_dist_link_type IN VARCHAR2,
78 p_distribution_id IN NUMBER) RETURN VARCHAR2;
79 PROCEDURE psa_xla_error
80 (
81 p_message_code IN VARCHAR2,
82 p_event_id IN NUMBER DEFAULT NULL
83 );
84
85 END PSA_BC_XLA_PVT; -- Package spec