DBA Data[Home] [Help]

APPS.PAY_PST_UTILS dependencies on HR_GENERAL

Line 14: g_date_started DATE := hr_general.start_of_time;

10: g_percent_complete NUMBER := -1;
11: g_process_status VARCHAR2(30) := 'PROCESS_STATUS_UNKNOWN';
12: g_total_lines NUMBER := -1;
13: g_can_update VARCHAR2(30) := 'CAN_UPDATE_UNKNOWN';
14: g_date_started DATE := hr_general.start_of_time;
15: g_parameter_group VARCHAR2(240) := 'PARAMETER_GROUP_UNKNOWN';
16: g_validate_only VARCHAR2(30) := 'VALIDATE_ONLY_UNKNOWN';
17: g_date_completed DATE := hr_general.end_of_time;
18: g_completion_text VARCHAR2(2000) := 'COMPLETION_TEXT_UNKNOWN';

Line 17: g_date_completed DATE := hr_general.end_of_time;

13: g_can_update VARCHAR2(30) := 'CAN_UPDATE_UNKNOWN';
14: g_date_started DATE := hr_general.start_of_time;
15: g_parameter_group VARCHAR2(240) := 'PARAMETER_GROUP_UNKNOWN';
16: g_validate_only VARCHAR2(30) := 'VALIDATE_ONLY_UNKNOWN';
17: g_date_completed DATE := hr_general.end_of_time;
18: g_completion_text VARCHAR2(2000) := 'COMPLETION_TEXT_UNKNOWN';
19: g_process_phase VARCHAR2(240) := 'PROCESS_PHASE_UNKNOWN';
20: g_last_batch_exception VARCHAR2(2000) := 'LAST_BATCH_EXCEPTION_UNKNOWN';
21: g_display_view_errors NUMBER := 0;

Line 22: g_last_process_date DATE := hr_general.start_of_time;

18: g_completion_text VARCHAR2(2000) := 'COMPLETION_TEXT_UNKNOWN';
19: g_process_phase VARCHAR2(240) := 'PROCESS_PHASE_UNKNOWN';
20: g_last_batch_exception VARCHAR2(2000) := 'LAST_BATCH_EXCEPTION_UNKNOWN';
21: g_display_view_errors NUMBER := 0;
22: g_last_process_date DATE := hr_general.start_of_time;
23: --
24: g_module_name VARCHAR2(240) := 'MODULE_NAME_UNKNOWN';
25: g_module_status VARCHAR2(30) := 'MODULE_STATUS_UNKNOWN';
26: g_api_unprocessed NUMBER := -1;

Line 55: nvl(pg.action_parameter_group_name,hr_general.decode_lookup('NAME_TRANSLATIONS','DEFAULT')),

51: );
52: --
53: CURSOR csr_process(cp_batch_id IN NUMBER) IS
54: SELECT cr.actual_start_date,
55: nvl(pg.action_parameter_group_name,hr_general.decode_lookup('NAME_TRANSLATIONS','DEFAULT')),
56: yn.meaning,
57: cr.actual_completion_date,
58: cr.completion_text,
59: fl.meaning,