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 2005/05/05 01:21:06 kvora 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 2005/05/05 01:21:06 kvora 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 923: -- gl_daily_rates_pkg.Insert_DateRage(....);

919: -- Arguments
920: -- All the columns of the table GL_DAILY_RATES_INTERFACE
921: --
922: -- Example
923: -- gl_daily_rates_pkg.Insert_DateRage(....);
924: --
925: -- Notes
926: --
927: PROCEDURE Insert_DateRange(X_From_Currency VARCHAR2,

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

1044: -- X_From_Conversion_Date From Conversion Date
1045: -- X_To_Conversion_Date To Conversion Date
1046: --
1047: -- Example
1048: -- gl_daily_rates_pkg.Validate_DailyRates(....);
1049: --
1050: -- Notes
1051: --
1052: PROCEDURE Validate_DailyRates(X_From_Currency VARCHAR2,

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

1152: -- Arguments
1153: --
1154: --
1155: -- Example
1156: -- gl_daily_rates_pkg.Submit_Conc_Request(....);
1157: --
1158: -- Notes
1159: --
1160: FUNCTION submit_conc_request RETURN NUMBER

Line 1268: GL_DAILY_RATES_PKG.update_row(

1264: and conversion_type = X_Conversion_Type;
1265:
1266: -- Update only if the record exists in the database
1267: --IF ( lrowid IS NOT NULL and invrowid IS NOT NULL) THEN
1268: GL_DAILY_RATES_PKG.update_row(
1269: X_Rowid =>lrowid,
1270: X_Inverse_Rowid =>invrowid,
1271: X_From_Currency =>X_From_Currency,
1272: X_To_Currency =>X_To_Currency,

Line 1305: GL_DAILY_RATES_PKG.insert_row(

1301: );
1302: --END IF;
1303:
1304: EXCEPTION WHEN NO_DATA_FOUND THEN
1305: GL_DAILY_RATES_PKG.insert_row(
1306: X_Rowid =>lrowid,
1307: X_Inverse_Rowid =>invrowid,
1308: X_From_Currency =>X_From_Currency,
1309: X_To_Currency =>X_To_Currency,

Line 1343: END GL_DAILY_RATES_PKG;

1339:
1340:
1341: END Upload_Row;
1342:
1343: END GL_DAILY_RATES_PKG;