7: X_Asset_policy_id IN OUT NOCOPY NUMBER,
8: X_Calculation_method IN OUT NOCOPY VARCHAR2,
9: X_Vendor_site_code IN OUT NOCOPY VARCHAR2,
10: X_Vendor_Site_id IN OUT NOCOPY NUMBER,
11: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
12:
13: CURSOR C (X_vendor_id NUMBER, X_Policy_number VARCHAR2) IS
14: SELECT pol.calculation_method,
15: pol.Vendor_Site_code,
76: X_Attribute17 VARCHAR2,
77: X_Attribute18 VARCHAR2,
78: X_Attribute19 VARCHAR2,
79: X_Attribute20 VARCHAR2,
80: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
81:
82:
83: CURSOR C IS SELECT rowid FROM fa_ins_policies
84: WHERE asset_policy_id = X_Asset_policy_id
260: X_Attribute17 VARCHAR2,
261: X_Attribute18 VARCHAR2,
262: X_Attribute19 VARCHAR2,
263: X_Attribute20 VARCHAR2,
264: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
265:
266: CURSOR C IS
267: SELECT *
268: FROM fa_ins_policies
423: X_Attribute17 VARCHAR2,
424: X_Attribute18 VARCHAR2,
425: X_Attribute19 VARCHAR2,
426: X_Attribute20 VARCHAR2,
427: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
428:
429: BEGIN
430:
431: UPDATE fa_ins_policies
476: END Update_Row;
477:
478:
479: PROCEDURE Delete_Row( X_Rowid VARCHAR2,
480: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
481:
482: BEGIN
483:
484: DELETE FROM fa_ins_policies