APPS.GHR_HISTORY_API dependencies on GHR_PA_HISTORY

Line 24: (table_name ghr_pa_history.table_name%type,

20: g_cancel constant ghr_pa_requests.first_noa_cancel_or_Correct%type:='CANCEL';
21: g_correct constant ghr_pa_requests.first_noa_cancel_or_Correct%type:='CORRECT';
22:
23: Type operation_info_type is record
24: (table_name ghr_pa_history.table_name%type,
25: table_pk_id ghr_pa_history.information1%type,
26: operation varchar2(10),
27: row_id rowid
28: );

Line 25: table_pk_id ghr_pa_history.information1%type,

21: g_correct constant ghr_pa_requests.first_noa_cancel_or_Correct%type:='CORRECT';
22:
23: Type operation_info_type is record
24: (table_name ghr_pa_history.table_name%type,
25: table_pk_id ghr_pa_history.information1%type,
26: operation varchar2(10),
27: row_id rowid
28: );
29:

Line 46: Type pa_history_type is table of ghr_pa_history%rowtype

42: assignment_id per_assignments_f.assignment_id%type,
43: dml_operation varchar2(1)
44: );
45:
46: Type pa_history_type is table of ghr_pa_history%rowtype
47: index by binary_integer;
48:
49: Type g_session_var_type is record
50: (pa_request_id number,

Line 92: p_table_name in ghr_pa_history.table_name%type ,

88:
89: Procedure set_operation_info(
90: p_program_name in varchar2 ,
91: p_date_effective in date ,
92: p_table_name in ghr_pa_history.table_name%type ,
93: p_table_pk_id in ghr_pa_history.information1%type ,
94: p_operation in varchar2,
95: p_old_record_data in ghr_pa_history%rowtype,
96: p_row_id in rowid

Line 93: p_table_pk_id in ghr_pa_history.information1%type ,

89: Procedure set_operation_info(
90: p_program_name in varchar2 ,
91: p_date_effective in date ,
92: p_table_name in ghr_pa_history.table_name%type ,
93: p_table_pk_id in ghr_pa_history.information1%type ,
94: p_operation in varchar2,
95: p_old_record_data in ghr_pa_history%rowtype,
96: p_row_id in rowid
97: );

Line 95: p_old_record_data in ghr_pa_history%rowtype,

91: p_date_effective in date ,
92: p_table_name in ghr_pa_history.table_name%type ,
93: p_table_pk_id in ghr_pa_history.information1%type ,
94: p_operation in varchar2,
95: p_old_record_data in ghr_pa_history%rowtype,
96: p_row_id in rowid
97: );
98:
99:

Line 103: p_table_name in ghr_pa_history.table_name%type,

99:
100: Function row_already_touched(p_row_id in rowid) return boolean;
101:
102: Function add_row_operation_info_rg (
103: p_table_name in ghr_pa_history.table_name%type,
104: p_table_pk_id in ghr_pa_history.information1%type,
105: p_operation in varchar2,
106: p_row_id in rowid)
107: return binary_integer;

Line 104: p_table_pk_id in ghr_pa_history.information1%type,

100: Function row_already_touched(p_row_id in rowid) return boolean;
101:
102: Function add_row_operation_info_rg (
103: p_table_name in ghr_pa_history.table_name%type,
104: p_table_pk_id in ghr_pa_history.information1%type,
105: p_operation in varchar2,
106: p_row_id in rowid)
107: return binary_integer;
108:

Line 111: p_pre_update_rg in ghr_pa_history%rowtype,

107: return binary_integer;
108:
109: -- Following procedure will hold the :old values
110: Procedure add_row_pre_update_record_rg (
111: p_pre_update_rg in ghr_pa_history%rowtype,
112: p_ind in binary_integer);
113:
114: Procedure post_update_process;
115:

Line 127: p_hist_data in out nocopy ghr_pa_history%rowtype,

123: p_date_effective in date default null,
124: p_altered_pa_request_id in number default null,
125: p_noa_id_corrected in number default null,
126: p_pa_history_id in number default null,
127: p_hist_data in out nocopy ghr_pa_history%rowtype,
128: p_result_code out nocopy varchar2);
129:
130: Procedure Post_forms_commit_process( p_eff_date in date);
131: Procedure New_form_instance_process;