DBA Data[Home] [Help]

APPS.GL_DAILY_RATES_PKG dependencies on GL_DAILY_RATES_PKG

Line 1: PACKAGE BODY GL_DAILY_RATES_PKG as

1: PACKAGE BODY GL_DAILY_RATES_PKG as
2: /* $Header: glirtdyb.pls 120.10.12020000.2 2012/08/28 21:01:06 phmullap ship $ */
3: --
4: -- Package
5: -- gl_daily_rates_pkg

Line 5: -- gl_daily_rates_pkg

1: PACKAGE BODY GL_DAILY_RATES_PKG as
2: /* $Header: glirtdyb.pls 120.10.12020000.2 2012/08/28 21:01:06 phmullap ship $ */
3: --
4: -- Package
5: -- gl_daily_rates_pkg
6: -- Purpose
7: -- To contain validation and insertion routines for gl_daily_rates
8: -- History
9: -- 07-29-97 W Wong Created

Line 85: IF ( GL_DAILY_RATES_PKG.Used_In_Ledger( X_From_Currency,

81: -- Set the status code to 'O' if the X_To_Currency and X_Conversion_Type is
82: -- used in ledgers.
83: -- Set status code to 'C' otherwise.
84: --
85: IF ( GL_DAILY_RATES_PKG.Used_In_Ledger( X_From_Currency,
86: X_To_Currency,
87: X_Conversion_Type,
88: X_Euro_Currency,
89: X_Conversion_Date )) THEN

Line 552: IF ( GL_DAILY_RATES_PKG.Used_In_Ledger( X_From_Currency,

548: BEGIN
549: -- Set the status code to 'O' if the X_To_Currency and X_Conversion_Type is
550: -- used in ledgers.
551: IF ( X_Status_Code <> 'O' ) THEN
552: IF ( GL_DAILY_RATES_PKG.Used_In_Ledger( X_From_Currency,
553: X_To_Currency,
554: X_Conversion_Type,
555: X_Euro_Currency,
556: X_Conversion_Date )) THEN

Line 706: IF ( GL_DAILY_RATES_PKG.Used_In_Ledger( X_From_Currency,

702: BEGIN
703: -- Set the status code to 'D' if the X_To_Currency and X_Conversion_Type is
704: -- used in ledgers.
705: IF ( X_Status_Code <> 'O' ) THEN
706: IF ( GL_DAILY_RATES_PKG.Used_In_Ledger( X_From_Currency,
707: X_To_Currency,
708: X_Conversion_Type,
709: X_Euro_Currency,
710: X_Conversion_Date )) THEN

Line 937: -- gl_daily_rates_pkg.Insert_DateRage(....);

933: -- Arguments
934: -- All the columns of the table GL_DAILY_RATES_INTERFACE
935: --
936: -- Example
937: -- gl_daily_rates_pkg.Insert_DateRage(....);
938: --
939: -- Notes
940: --
941: PROCEDURE Insert_DateRange(X_From_Currency VARCHAR2,

Line 1062: -- gl_daily_rates_pkg.Validate_DailyRates(....);

1058: -- X_From_Conversion_Date From Conversion Date
1059: -- X_To_Conversion_Date To Conversion Date
1060: --
1061: -- Example
1062: -- gl_daily_rates_pkg.Validate_DailyRates(....);
1063: --
1064: -- Notes
1065: --
1066: PROCEDURE Validate_DailyRates(X_From_Currency VARCHAR2,

Line 1170: -- gl_daily_rates_pkg.Submit_Conc_Request(....);

1166: -- Arguments
1167: --
1168: --
1169: -- Example
1170: -- gl_daily_rates_pkg.Submit_Conc_Request(....);
1171: --
1172: -- Notes
1173: --
1174: FUNCTION submit_conc_request RETURN NUMBER

Line 1282: GL_DAILY_RATES_PKG.update_row(

1278: and conversion_type = X_Conversion_Type;
1279:
1280: -- Update only if the record exists in the database
1281: --IF ( lrowid IS NOT NULL and invrowid IS NOT NULL) THEN
1282: GL_DAILY_RATES_PKG.update_row(
1283: X_Rowid =>lrowid,
1284: X_Inverse_Rowid =>invrowid,
1285: X_From_Currency =>X_From_Currency,
1286: X_To_Currency =>X_To_Currency,

Line 1319: GL_DAILY_RATES_PKG.insert_row(

1315: );
1316: --END IF;
1317:
1318: EXCEPTION WHEN NO_DATA_FOUND THEN
1319: GL_DAILY_RATES_PKG.insert_row(
1320: X_Rowid =>lrowid,
1321: X_Inverse_Rowid =>invrowid,
1322: X_From_Currency =>X_From_Currency,
1323: X_To_Currency =>X_To_Currency,

Line 1357: END GL_DAILY_RATES_PKG;

1353:
1354:
1355: END Upload_Row;
1356:
1357: END GL_DAILY_RATES_PKG;