APPS.GL_HISTORICAL_RATES_PKG dependencies on GL_HISTORICAL_RATES

Line 1: PACKAGE BODY GL_HISTORICAL_RATES_PKG as

1: PACKAGE BODY GL_HISTORICAL_RATES_PKG as
2: /* $Header: glirthtb.pls 120.5.12000000.2 2007/08/28 15:59:35 dthakker ship $ */
3:
4: PROCEDURE check_unique( x_rowid VARCHAR2,
5: x_ledger_id NUMBER,

Line 12: FROM gl_historical_rates hist

8: x_target_currency VARCHAR2,
9: x_usage_code VARCHAR2) IS
10: CURSOR c_dup IS
11: SELECT 'Duplicate'
12: FROM gl_historical_rates hist
13: WHERE hist.ledger_id = x_ledger_id
14: AND hist.code_combination_id = x_code_combination_id
15: AND hist.period_name = x_period_name
16: AND hist.target_currency = x_target_currency

Line 41: 'GL_HISTORICAL_RATES_PKG.check_unique');

37: RAISE;
38: WHEN OTHERS THEN
39: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
40: fnd_message.set_token('PROCEDURE',
41: 'GL_HISTORICAL_RATES_PKG.check_unique');
42: RAISE;
43:
44: END check_unique;
45:

Line 74: CURSOR C IS SELECT rowid FROM gl_historical_rates

70: X_Context VARCHAR2,
71: X_Usage_Code VARCHAR2,
72: X_Chart_of_Accounts_Id NUMBER
73: ) IS
74: CURSOR C IS SELECT rowid FROM gl_historical_rates
75: WHERE ledger_id = X_Ledger_Id
76: AND code_combination_id = X_Code_Combination_Id
77: AND period_name = X_Period_Name
78: AND target_currency = X_Target_Currency

Line 81: INSERT INTO gl_historical_rates(

77: AND period_name = X_Period_Name
78: AND target_currency = X_Target_Currency
79: AND usage_code = X_Usage_Code;
80: BEGIN
81: INSERT INTO gl_historical_rates(
82: ledger_id,
83: period_name,
84: period_num,
85: period_year,

Line 191: FROM gl_historical_rates

187: X_Usage_Code VARCHAR2
188: ) IS
189: CURSOR C IS
190: SELECT *
191: FROM gl_historical_rates
192: WHERE rowid = X_Rowid
193: FOR UPDATE of Ledger_Id NOWAIT;
194: Recinfo C%ROWTYPE;
195: BEGIN

Line 292: UPDATE gl_historical_rates

288: X_Usage_Code VARCHAR2,
289: X_Chart_of_Accounts_Id NUMBER
290: ) IS
291: BEGIN
292: UPDATE gl_historical_rates
293: SET
294:
295: ledger_id = X_Ledger_Id,
296: period_name = X_Period_Name,

Line 353: DELETE FROM gl_historical_rates

349:
350:
351: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
352: BEGIN
353: DELETE FROM gl_historical_rates
354: WHERE rowid = X_Rowid;
355:
356: if (SQL%NOTFOUND) then
357: RAISE NO_DATA_FOUND;

Line 441: 'GL_HISTORICAL_RATES_PKG.get_bal_seg');

437: RAISE;
438: WHEN OTHERS THEN
439: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
440: fnd_message.set_token('PROCEDURE',
441: 'GL_HISTORICAL_RATES_PKG.get_bal_seg');
442: RAISE;
443: END get_bal_seg;
444:
445: -- **********************************************************************

Line 755: DELETE FROM gl_historical_rates

751: V_sysdate_str, v_conc_segmetns);
752: GL_CODE_COMBINATIONS_PKG.select_columns(X_Code_Combination_Id,
753: X_Account_Type, dummy);
754:
755: DELETE FROM gl_historical_rates
756: WHERE ledger_id = l_ledger_id
757: AND code_combination_id = X_Code_Combination_Id
758: AND period_name = X_PERIOD_NAME
759: AND target_currency = X_Target_Currency

Line 762: GL_HISTORICAL_RATES_PKG.Insert_Row(X_Rowid, l_ledger_id,

758: AND period_name = X_PERIOD_NAME
759: AND target_currency = X_Target_Currency
760: AND usage_code = V_Usage_Code;
761:
762: GL_HISTORICAL_RATES_PKG.Insert_Row(X_Rowid, l_ledger_id,
763: X_PERIOD_NAME, X_Period_Num,
764: X_Period_Year, X_Code_Combination_Id,
765: X_Target_Currency, X_Update_Flag,
766: X_Last_Update_Date,

Line 778: END GL_HISTORICAL_RATES_PKG;

774: V_Usage_Code, X_Chart_of_Accounts_Id);
775: END Insert_Row_WebADI_Wrapper;
776:
777:
778: END GL_HISTORICAL_RATES_PKG;