DBA Data[Home] [Help]

APPS.FA_INVENTORY_PKG dependencies on FA_INV_INTERFACE

Line 10: FROM FA_INV_INTERFACE

6: X_Calling_Fn VARCHAR2
7: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
8: cursor c_inv is
9: SELECT *
10: FROM FA_INV_INTERFACE
11: WHERE ROWID = X_ROWID
12: FOR UPDATE OF STATUS NOWAIT;
13: Recinfo c_inv%rowtype;
14:

Line 49: UPDATE fa_inv_interface

45: X_Calling_Fn VARCHAR2
46: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
47: BEGIN
48: if X_Rowid is not null then
49: UPDATE fa_inv_interface
50: SET
51: unit_reconcile_mth = X_unit_rec_mth_lookup_code,
52: loc_reconcile_mth = X_loc_rec_mth_lookup_code,
53: status = X_status_lookup_code,

Line 59: UPDATE fa_inv_interface

55: Last_Updated_By = X_Last_Updated_By,
56: Last_Update_Login = X_Last_Update_Login
57: WHERE rowid = X_Rowid;
58: else
59: UPDATE fa_inv_interface
60: SET
61: unit_reconcile_mth = X_unit_rec_mth_lookup_code,
62: loc_reconcile_mth = X_loc_rec_mth_lookup_code,
63: status = X_status_lookup_code,