PACKAGE: APPS.PQH_SIT_ENGINE

Source

1 PACKAGE PQH_SIT_ENGINE AUTHID CURRENT_USER  as
2 /* $Header: pqsiteng.pkh 120.0 2005/05/29 02:42 appldev noship $ */
3 g_package varchar2(30) := 'pqh_sit_engine';
4 Function GET_TRANSACTION_VALUE (p_person_id      IN  number,
5                                 p_effective_date in date,
6                                 p_attribute_id   IN  number) RETURN  varchar2 ;
7 
8 function check_attribute_result(p_rule_from in varchar2,
9                                 p_txn_value in varchar2,
10                                 p_rule_to   in varchar2,
11                                 p_value_style_cd in varchar2,
12                                 p_exclude_flag in varchar2) return BOOLEAN ;
13 
14 PROCEDURE apply_defined_rules(p_stat_sit_id    IN number,
15                               p_person_id      IN number,
16                               p_effective_date IN DATE,
17                               p_rule_type      IN VARCHAR2 DEFAULT 'REQUIRED',
18                               p_status_flag    OUT NOCOPY varchar2) ;
19 
20 Function is_situation_valid(p_person_id NUMBER,
21                                p_effective_date IN DATE,
22                                p_statutory_situation_id NUMBER) RETURN VARCHAR2;
23 end pqh_sit_engine;