[Home] [Help]
PACKAGE: APPS.PA_BUDGET_INTEGRATION_PKG
Source
1 PACKAGE PA_BUDGET_INTEGRATION_PKG AS
2 /* $Header: PABDINTS.pls 120.1 2005/08/08 14:49:27 pbandla noship $ */
3
4 ----------------------------------------------------------------------------------------
5 -- Package : PA_BUDGET_INTEGRATION_PKG
6 -- Purpose : Table Handlers APIs to Insert/Update/Delete/Lock a record
7 -- thru SQL Form
8 -- Parameters :
9 -- P_Calling_Mode--> SUBMIT / GENERATE_ACCOUNT
10 ----------------------------------------------------------------------------------------
11
12
13 ----------------------------------------------------------------------------------------
14 -- Procedure : Insert_Row
15 -- Purpose : To insert a record into PA_BUDGETARY_CONTROL_OPTIONS table
16 -- Parameters : ? Ref: P_Calling_Mode--> SUBMIT / GENERATE_ACCOUNT
17 ----------------------------------------------------------------------------------------
18 PROCEDURE Insert_Row (
19 X_Rowid OUT NOCOPY ROWID,
20 p_Project_Type IN VARCHAR2,
21 p_Project_ID IN NUMBER,
22 p_Balance_Type IN VARCHAR2,
23 p_Budget_Type_Code IN VARCHAR2,
24 p_External_Budget_Code IN VARCHAR2,
25 p_GL_Budget_Version_ID IN NUMBER,
26 p_Encumbrance_Type_ID IN NUMBER,
27 p_Bdgt_Cntrl_Flag IN VARCHAR2,
28 P_FC_Level_Project IN VARCHAR2,
29 P_FC_Level_Task IN VARCHAR2,
30 P_FC_Level_RsrcGrp IN VARCHAR2,
31 P_FC_Level_Rsrs IN VARCHAR2,
32 P_Amount_Type IN VARCHAR2,
33 P_Boundary_Code IN VARCHAR2,
34 P_Project_Type_Org_ID IN NUMBER,
35 p_Last_Update_Date IN DATE,
36 p_Last_Updated_By IN NUMBER,
37 p_Creation_Date IN DATE,
38 p_Created_By IN NUMBER,
39 p_Last_Update_Login IN NUMBER
40 );
41
42 ----------------------------------------------------------------------------------------
43 -- Procedure : Update_Row
44 -- Purpose : To Update a record in PA_BUDGETARY_CONTROL_OPTIONS table
45 -- Parameters : ? Ref: P_Calling_Mode--> SUBMIT / GENERATE_ACCOUNT
46 ----------------------------------------------------------------------------------------
47 PROCEDURE Update_Row (
48 p_Rowid IN ROWID,
49 p_Project_Type IN VARCHAR2,
50 p_Project_ID IN NUMBER,
51 p_Balance_Type IN VARCHAR2,
52 p_Budget_Type_Code IN VARCHAR2,
53 p_External_Budget_Code IN VARCHAR2,
54 p_GL_Budget_Version_ID IN NUMBER,
55 p_Encumbrance_Type_ID IN NUMBER,
56 p_Bdgt_Cntrl_Flag IN VARCHAR2,
57 P_FC_Level_Project IN VARCHAR2,
58 P_FC_Level_Task IN VARCHAR2,
59 P_FC_Level_RsrcGrp IN VARCHAR2,
60 P_FC_Level_Rsrs IN VARCHAR2,
61 P_Amount_Type IN VARCHAR2,
62 P_Boundary_Code IN VARCHAR2,
63 p_Last_Update_Date IN DATE,
64 p_Last_Updated_By IN NUMBER,
65 p_Creation_Date IN DATE,
66 p_Created_By IN NUMBER,
67 p_Last_Update_Login IN NUMBER
68 );
69
70 ----------------------------------------------------------------------------------------
71 -- Procedure : Delete_Row
72 -- Purpose : To Delete a record from PA_BUDGETARY_CONTROL_OPTIONS table
73 -- Parameters : ? Ref: P_Calling_Mode--> SUBMIT / GENERATE_ACCOUNT
74 ----------------------------------------------------------------------------------------
75 PROCEDURE Delete_Row (
76 p_Rowid IN ROWID
77 );
78
79 ----------------------------------------------------------------------------------------
80 -- Procedure : Lock_Row
81 -- Purpose : To Lock a record in PA_BUDGETARY_CONTROL_OPTIONS table
82 -- Parameters : ? Ref: P_Calling_Mode--> SUBMIT / GENERATE_ACCOUNT
83 ----------------------------------------------------------------------------------------
84 PROCEDURE Lock_Row (
85 p_Rowid IN ROWID,
86 p_Project_Type IN VARCHAR2,
87 p_Project_ID IN NUMBER,
88 p_Balance_Type IN VARCHAR2,
89 p_Budget_Type_Code IN VARCHAR2,
90 p_External_Budget_Code IN VARCHAR2,
91 p_GL_Budget_Version_ID IN NUMBER,
92 p_Encumbrance_Type_ID IN NUMBER,
93 p_Bdgt_Cntrl_Flag IN VARCHAR2,
94 P_FC_Level_Project IN VARCHAR2,
95 P_FC_Level_Task IN VARCHAR2,
96 P_FC_Level_RsrcGrp IN VARCHAR2,
97 P_FC_Level_Rsrs IN VARCHAR2,
98 P_Amount_Type IN VARCHAR2,
99 P_Boundary_Code IN VARCHAR2
100 );
101
102 END PA_BUDGET_INTEGRATION_PKG ; /* End Package Specifications PA_BUDGET_INTEGRATION_PKG */