DBA Data[Home] [Help]

APPS.PQH_FR_STAT_SIT_RULES_API dependencies on PQH_FR_STAT_SITUATION_RULES

Line 36: l_stat_situation_rule_id pqh_fr_stat_situation_rules.stat_situation_rule_id%type;

32: l_in_out_parameter number;
33: l_effective_date date;
34: l_proc varchar2(72) := g_package||'create_stat_situation_rule';
35: l_object_version_number number(9);
36: l_stat_situation_rule_id pqh_fr_stat_situation_rules.stat_situation_rule_id%type;
37:
38: begin
39:
40: if g_debug then

Line 213: l_stat_situation_rule_id pqh_fr_stat_situation_rules.stat_situation_rule_id%type;

209: l_in_out_parameter number;
210: l_effective_date date;
211: l_proc varchar2(72) := g_package||'update_stat_situation_rule';
212: l_object_version_number number(9);
213: l_stat_situation_rule_id pqh_fr_stat_situation_rules.stat_situation_rule_id%type;
214:
215: begin
216:
217: if g_debug then

Line 376: l_stat_situation_rule_id pqh_fr_stat_situation_rules.stat_situation_rule_id%type;

372: --
373: -- Declare cursors and local variables
374: --
375: l_proc varchar2(72) := g_package||'delete_statutory_situation';
376: l_stat_situation_rule_id pqh_fr_stat_situation_rules.stat_situation_rule_id%type;
377:
378: begin
379: if g_debug then
380: --