APPS.FA_INS_MST_POLS_PKG dependencies on FA_INS_MST_POLS

Line 1: PACKAGE BODY FA_INS_MST_POLS_PKG AS

1: PACKAGE BODY FA_INS_MST_POLS_PKG AS
2: /* $Header: faxinsmb.pls 120.3 2005/08/31 23:21:05 lson noship $ */
3:
4:
5: PROCEDURE Lock_Row( X_Rowid VARCHAR2,

Line 15: FROM fa_ins_mst_pols

11: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
12:
13: CURSOR C IS
14: SELECT *
15: FROM fa_ins_mst_pols
16: WHERE rowid = X_Rowid
17: FOR UPDATE OF policy_number NOWAIT;
18:
19: recinfo C%ROWTYPE;

Line 67: UPDATE fa_ins_mst_pols

63: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
64:
65: BEGIN
66:
67: UPDATE fa_ins_mst_pols
68: SET
69: asset_policy_id = X_Asset_policy_id,
70: policy_number = X_Policy_number,
71: vendor_site_id = X_Vendor_site_id,

Line 107: DELETE FROM fa_ins_mst_pols

103:
104: OPEN C;
105: FETCH C INTO dummy;
106: IF C%NOTFOUND THEN
107: DELETE FROM fa_ins_mst_pols
108: WHERE asset_policy_id = X_asset_policy_id;
109:
110: IF (SQL%NOTFOUND) THEN
111: RAISE NO_DATA_FOUND;

Line 134: END FA_INS_MST_POLS_PKG;

130: commit;
131:
132: END Delete_Row;
133:
134: END FA_INS_MST_POLS_PKG;