DBA Data[Home] [Help]

APPS.FA_DEPRN_BASIS_RULES_PKG dependencies on FA_API_TYPES

Line 17: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

13: X_calculation_basis VARCHAR2,
14: X_enabled_flag VARCHAR2,
15: X_program_name VARCHAR2,
16: X_description VARCHAR2
17: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
18: CURSOR C is SELECT FA_DEPRN_BASIS_RULES_S.nextval from sys.dual;
19:
20: CURSOR C_MAX_SEQ
21: is

Line 90: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

86: X_calculation_basis VARCHAR2,
87: X_enabled_flag VARCHAR2,
88: X_program_name VARCHAR2,
89: X_description VARCHAR2
90: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
91: CURSOR C IS
92: Select deprn_basis_rule_id,
93: rule_name,
94: user_rule_name,

Line 151: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

147: X_calculation_basis VARCHAR2,
148: X_enabled_flag VARCHAR2,
149: X_program_name VARCHAR2,
150: X_description VARCHAR2
151: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
152:
153: BEGIN
154:
155: UPDATE FA_DEPRN_BASIS_RULES

Line 181: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

177:
178: END Update_Row;
179:
180: PROCEDURE Delete_Row(X_deprn_basis_rule_id NUMBER
181: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
182:
183: h_count number;
184:
185: BEGIN

Line 220: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

216: X_calculation_basis VARCHAR2,
217: X_enabled_flag VARCHAR2,
218: X_program_name VARCHAR2,
219: X_description VARCHAR2
220: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
221:
222: h_record_exists number(15);
223: h_deprn_basis_rule_id number(15);
224: user_id number(15);

Line 300: p_log_level_rec IN FA_API_TYPES.log_level_rec_type

296: X_calculation_basis IN VARCHAR2 DEFAULT NULL,
297: X_enabled_flag IN VARCHAR2,
298: X_program_name IN VARCHAR2,
299: X_description IN VARCHAR2 DEFAULT NULL,
300: p_log_level_rec IN FA_API_TYPES.log_level_rec_type
301: DEFAULT NULL) IS
302:
303:
304: h_record_exists number(15);

Line 388: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is

384: X_OWNER in VARCHAR2,
385: X_USER_RULE_NAME in VARCHAR2,
386: X_RULE_NAME in VARCHAR2,
387: X_DESCRIPTION in VARCHAR2
388: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
389:
390: user_id number;
391:
392: begin

Line 432: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

428: X_LAST_UPDATE_DATE in DATE,
429: X_USER_RULE_NAME in VARCHAR2 DEFAULT NULL,
430: X_RULE_NAME in VARCHAR2 DEFAULT NULL,
431: X_DESCRIPTION in VARCHAR2 DEFAULT NULL,
432: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
433:
434: user_id number;
435:
436: db_last_updated_by number;