APPS.GL_BUDGET_RANGE_INTERIM_PKG dependencies on GL_BUDGET_RANGE_INTERIM

Line 1: PACKAGE BODY GL_BUDGET_RANGE_INTERIM_PKG as

1: PACKAGE BODY GL_BUDGET_RANGE_INTERIM_PKG as
2: /* $Header: glibdrib.pls 120.4 2005/05/05 01:02:03 kvora ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Ledger_Id NUMBER,

Line 106: CURSOR C IS SELECT rowid FROM gl_budget_range_interim

102: X_Stat_Amount11 NUMBER,
103: X_Stat_Amount12 NUMBER,
104: X_Stat_Amount13 NUMBER
105: ) IS
106: CURSOR C IS SELECT rowid FROM gl_budget_range_interim
107: WHERE ledger_id = X_Ledger_Id
108: AND code_combination_id = X_Code_Combination_Id
109: AND currency_code = X_Currency_Code
110: AND budget_version_id = X_Budget_Version_Id

Line 118: INSERT INTO gl_budget_range_interim(

114: AND status_number = X_Status_Number;
115:
116: BEGIN
117:
118: INSERT INTO gl_budget_range_interim(
119: ledger_id,
120: code_combination_id,
121: currency_code,
122: budget_version_id,

Line 429: FROM gl_budget_range_interim

425: X_Stat_Amount13 NUMBER
426: ) IS
427: CURSOR C IS
428: SELECT *
429: FROM gl_budget_range_interim
430: WHERE rowid = X_Rowid
431: FOR UPDATE of Ledger_Id NOWAIT;
432: Recinfo C%ROWTYPE;
433: BEGIN

Line 825: UPDATE gl_budget_range_interim

821: X_Stat_Amount12 NUMBER,
822: X_Stat_Amount13 NUMBER
823: ) IS
824: BEGIN
825: UPDATE gl_budget_range_interim
826: SET
827: ledger_id = X_Ledger_Id,
828: code_combination_id = X_Code_Combination_Id,
829: currency_code = X_Currency_Code,

Line 935: DELETE FROM gl_budget_range_interim

931: END Update_Row;
932:
933: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
934: BEGIN
935: DELETE FROM gl_budget_range_interim
936: WHERE rowid = X_Rowid;
937:
938: if (SQL%NOTFOUND) then
939: RAISE NO_DATA_FOUND;

Line 943: END GL_BUDGET_RANGE_INTERIM_PKG;

939: RAISE NO_DATA_FOUND;
940: end if;
941: END Delete_Row;
942:
943: END GL_BUDGET_RANGE_INTERIM_PKG;