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 default null) 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 48: UPDATE fa_inv_interface

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

Line 58: UPDATE fa_inv_interface

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