APPS.FA_INS_POLICIES_PKG dependencies on FA_INS_POLICIES

Line 1: PACKAGE BODY FA_INS_POLICIES_PKG AS

1: PACKAGE BODY FA_INS_POLICIES_PKG AS
2: /* $Header: faxinspb.pls 120.4 2009/03/27 03:23:00 bridgway ship $ */
3:
4:
5: PROCEDURE Get_Calculation_Method (X_Vendor_id NUMBER,

Line 83: CURSOR C IS SELECT rowid FROM fa_ins_policies

79: X_Attribute20 VARCHAR2
80: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
81:
82:
83: CURSOR C IS SELECT rowid FROM fa_ins_policies
84: WHERE asset_policy_id = X_Asset_policy_id
85: AND policy_number = X_Policy_number
86: AND asset_id = X_Asset_id;
87:

Line 130: INSERT INTO fa_ins_policies

126: );
127:
128: END IF;
129:
130: INSERT INTO fa_ins_policies
131: (
132: asset_policy_id,
133: asset_id,
134: book_type_code,

Line 268: FROM fa_ins_policies

264: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
265:
266: CURSOR C IS
267: SELECT *
268: FROM fa_ins_policies
269: WHERE rowid = X_Rowid
270: FOR UPDATE OF policy_number NOWAIT;
271:
272: recinfo C%ROWTYPE;

Line 433: UPDATE fa_ins_policies

429: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
430:
431: BEGIN
432:
433: UPDATE fa_ins_policies
434: SET
435: asset_policy_id = X_Asset_policy_id,
436: asset_id = X_Asset_id,
437: book_type_code = X_Book_type_code,

Line 485: DELETE FROM fa_ins_policies

481: PROCEDURE Delete_Row( X_Rowid VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
482:
483: BEGIN
484:
485: DELETE FROM fa_ins_policies
486: WHERE rowid = X_Rowid;
487:
488: IF (SQL%NOTFOUND) THEN
489: RAISE NO_DATA_FOUND;

Line 494: END FA_INS_POLICIES_PKG;

490: END IF;
491:
492: END Delete_Row;
493:
494: END FA_INS_POLICIES_PKG;