APPS.FII_BUDGET_INTERFACE_PKG dependencies on FII_BUDGET_INTERFACE

Line 1: PACKAGE BODY FII_BUDGET_INTERFACE_PKG AS

1: PACKAGE BODY FII_BUDGET_INTERFACE_PKG AS
2: /* $Header: FIIBUINB.pls 120.10 2005/06/02 19:25:48 ilavenil noship $ */
3:
4: -- Purpose
5: -- This is the routine called by Web ADI for uploading records

Line 6: -- into FII_BUDGET_INTERFACE

2: /* $Header: FIIBUINB.pls 120.10 2005/06/02 19:25:48 ilavenil noship $ */
3:
4: -- Purpose
5: -- This is the routine called by Web ADI for uploading records
6: -- into FII_BUDGET_INTERFACE
7: -- History
8: -- 07-22-02 S Kung Created
9: -- Arguments
10: -- All columns in the FII_BUDGET_INTERFACE table

Line 10: -- All columns in the FII_BUDGET_INTERFACE table

6: -- into FII_BUDGET_INTERFACE
7: -- History
8: -- 07-22-02 S Kung Created
9: -- Arguments
10: -- All columns in the FII_BUDGET_INTERFACE table
11: -- Example
12: -- FII_BUDGET_INTERFACE.Web_Adi_Upload;
13: -- Notes
14: --

Line 12: -- FII_BUDGET_INTERFACE.Web_Adi_Upload;

8: -- 07-22-02 S Kung Created
9: -- Arguments
10: -- All columns in the FII_BUDGET_INTERFACE table
11: -- Example
12: -- FII_BUDGET_INTERFACE.Web_Adi_Upload;
13: -- Notes
14: --
15: FUNCTION Web_Adi_Upload
16: ( X_RowID IN VARCHAR2 DEFAULT NULL,

Line 166: INSERT INTO FII_BUDGET_INTERFACE

162: RAISE invalid_user_defined;
163: END;
164: END IF;
165:
166: INSERT INTO FII_BUDGET_INTERFACE
167: (plan_type_code, prim_amount_g, report_time_period, report_date, version_date, sec_amount_g, conversion_rate,
168: fin_item, fin_category_id, prod_category_id, company, company_id,
169: cost_center, cost_center_id, user_dim1, user_dim1_id, ledger_id)
170: VALUES

Line 175: UPDATE FII_BUDGET_INTERFACE

171: (X_Plan_Type, X_Prim_Amt, X_Time_Period, X_Date, to_date(X_Version_Date, 'DD-MM-YYYY'), l_sec_amt, X_Rate,
172: X_Fin_Item, l_account, X_Product, X_Company, l_Company,
173: X_Cost_Center, l_Cost_Center, X_User_Defined_Dim, l_User_Defined_Dim, X_Ledger);
174: ELSE
175: UPDATE FII_BUDGET_INTERFACE
176: SET
177: plan_type_code = X_Plan_Type,
178: prim_amount_g = X_Prim_Amt,
179: report_time_period = X_Time_Period,

Line 202: UPDATE FII_BUDGET_INTERFACE

198: --once user fixes the errored record and re-uploads, THEN it is essential that
199: --all other residing VALIDATED records are to be set as status_code = null.
200: --thus upload into base table program will process all of the records existing in
201: --interface table and not just the error-fixed record.
202: UPDATE FII_BUDGET_INTERFACE
203: SET status_code = NULL;
204:
205: END IF;
206: ELSE

Line 237: END FII_BUDGET_INTERFACE_PKG;

233: l_err_msg := fnd_message.get_string('FII', 'FII_EA_VALIDATOR_ERR');
234: return l_err_msg;
235: END Web_Adi_Upload;
236:
237: END FII_BUDGET_INTERFACE_PKG;
238: