DBA Data[Home] [Help]

APPS.FA_INS_POLICIES_PKG dependencies on FA_API_TYPES

Line 11: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

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) IS
12:
13: CURSOR C (X_vendor_id NUMBER, X_Policy_number VARCHAR2) IS
14: SELECT pol.calculation_method,
15: pol.Vendor_Site_code,

Line 80: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

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) IS
81:
82:
83: CURSOR C IS SELECT rowid FROM fa_ins_policies
84: WHERE asset_policy_id = X_Asset_policy_id

Line 264: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

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) IS
265:
266: CURSOR C IS
267: SELECT *
268: FROM fa_ins_policies

Line 429: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

425: X_Attribute18 VARCHAR2,
426: X_Attribute19 VARCHAR2,
427: X_Attribute20 VARCHAR2
428:
429: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
430:
431: BEGIN
432:
433: UPDATE fa_ins_policies

Line 481: PROCEDURE Delete_Row( X_Rowid VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

477:
478: END Update_Row;
479:
480:
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