DBA Data[Home] [Help]

APPS.PQH_FR_GLOBAL_PAYSCALE_API dependencies on PQH_FR_GLOBAL_INDICES_F

Line 32: l_global_index_id pqh_fr_global_indices_f.global_index_id%type;

28: l_in_out_parameter number;
29: l_effective_date date;
30: l_proc varchar2(72) := g_package||'create_indemnity_rate';
31: l_object_version_number number(9);
32: l_global_index_id pqh_fr_global_indices_f.global_index_id%type;
33: l_effective_start_date date;
34: l_effective_end_date date;
35:
36: begin

Line 196: l_global_index_id pqh_fr_global_indices_f.global_index_id%type;

192: l_in_out_parameter number;
193: l_effective_date date;
194: l_proc varchar2(72) := g_package||'create_global_index';
195: l_object_version_number number(9);
196: l_global_index_id pqh_fr_global_indices_f.global_index_id%type;
197: l_effective_start_date date;
198: l_effective_end_date date;
199:
200: begin

Line 365: l_global_index_id pqh_fr_global_indices_f.global_index_id%type;

361: l_in_out_parameter number;
362: l_effective_date date;
363: l_proc varchar2(72) := g_package||'update_indemnity_rate';
364: l_object_version_number number(9);
365: l_global_index_id pqh_fr_global_indices_f.global_index_id%type;
366: l_effective_start_date date;
367: l_effective_end_date date;
368:
369: begin

Line 536: l_global_index_id pqh_fr_global_indices_f.global_index_id%type;

532: l_in_out_parameter number;
533: l_effective_date date;
534: l_proc varchar2(72) := g_package||'update_global_index';
535: l_object_version_number number(9);
536: l_global_index_id pqh_fr_global_indices_f.global_index_id%type;
537: l_effective_start_date date;
538: l_effective_end_date date;
539:
540: begin