eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BUDGET_INTEGRATION_PKG dependencies on PA_BUDGETARY_CONTROL_OPTIONS

Line 15: -- Purpose : To insert a record into PA_BUDGETARY_CONTROL_OPTIONS table

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,

Line 45: INSERT INTO PA_BUDGETARY_CONTROL_OPTIONS (

41: AS
42: BEGIN
43:
44: BEGIN
45: INSERT INTO PA_BUDGETARY_CONTROL_OPTIONS (
46: Project_Type,
47: Project_ID,
48: Balance_Type,
49: Budget_Type_Code,

Line 97: FROM PA_BUDGETARY_CONTROL_OPTIONS

93: -- session (in SQL*Forms) ==> For details refer to the appln. Dev. Stds.
94: BEGIN
95: SELECT RowID
96: INTO X_RowID
97: FROM PA_BUDGETARY_CONTROL_OPTIONS
98: WHERE Budget_Type_Code = P_Budget_Type_Code
99: AND ( Project_ID = P_Project_ID OR Project_Type = P_Project_Type)
100: AND nvl(Project_Type_Org_ID,-99) = nvl(P_Project_Type_Org_ID,-99) ; -- Added for bug #4772022
101: EXCEPTION

Line 114: -- Purpose : To Update a record in PA_BUDGETARY_CONTROL_OPTIONS table

110: END Insert_Row;
111:
112: ----------------------------------------------------------------------------------------
113: -- Procedure : Update_Row
114: -- Purpose : To Update a record in PA_BUDGETARY_CONTROL_OPTIONS table
115: -- Parameters : ? Ref: P_Calling_Mode--> SUBMIT / GENERATE_ACCOUNT
116: ----------------------------------------------------------------------------------------
117: PROCEDURE Update_Row (
118: p_Rowid IN ROWID,

Line 142: UPDATE PA_BUDGETARY_CONTROL_OPTIONS

138: )
139: AS
140: BEGIN
141:
142: UPDATE PA_BUDGETARY_CONTROL_OPTIONS
143: SET
144: Project_Type = p_Project_Type,
145: Project_ID = p_Project_ID,
146: Balance_Type = p_Balance_Type,

Line 175: -- Purpose : To Delete a record from PA_BUDGETARY_CONTROL_OPTIONS table

171: END Update_Row;
172:
173: ----------------------------------------------------------------------------------------
174: -- Procedure : Delete_Row
175: -- Purpose : To Delete a record from PA_BUDGETARY_CONTROL_OPTIONS table
176: -- Parameters : ? Ref: P_Calling_Mode--> SUBMIT / GENERATE_ACCOUNT
177: ----------------------------------------------------------------------------------------
178: PROCEDURE Delete_Row (
179: p_Rowid IN ROWID

Line 184: DELETE FROM PA_BUDGETARY_CONTROL_OPTIONS

180: )
181: AS
182: BEGIN
183:
184: DELETE FROM PA_BUDGETARY_CONTROL_OPTIONS
185: WHERE RowID = p_Rowid;
186:
187: IF (SQL%NOTFOUND) THEN
188: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_ERROR');

Line 197: -- Purpose : To Lock a record in PA_BUDGETARY_CONTROL_OPTIONS table

193:
194:
195: ----------------------------------------------------------------------------------------
196: -- Procedure : Lock_Row
197: -- Purpose : To Lock a record in PA_BUDGETARY_CONTROL_OPTIONS table
198: -- Parameters : ? Ref: P_Calling_Mode--> SUBMIT / GENERATE_ACCOUNT
199: ----------------------------------------------------------------------------------------
200: PROCEDURE Lock_Row (
201: p_Rowid IN ROWID,

Line 232: PA_BUDGETARY_CONTROL_OPTIONS

228: Bdgt_Cntrl_Flag,
229: Amount_Type,
230: Boundary_Code
231: FROM
232: PA_BUDGETARY_CONTROL_OPTIONS
233: WHERE
234: RowID = p_RowID
235: FOR UPDATE OF Budget_Type_Code NOWAIT;
236: