APPS.BIS_OBJ_REFRESH_HISTORY_PKG dependencies on BIS_OBJ_REFRESH_HISTORY

Line 1: package body BIS_OBJ_REFRESH_HISTORY_PKG AS

1: package body BIS_OBJ_REFRESH_HISTORY_PKG AS
2: /*$Header: BISOBTHB.pls 120.1 2006/05/18 12:29:50 aguwalan noship $*/
3: PROCEDURE Insert_Row ( p_Prog_request_id NUMBER ,
4: p_Object_type VARCHAR2,
5: p_Object_name VARCHAR2,

Line 17: CURSOR C_check IS SELECT 1 from BIS_OBJ_REFRESH_HISTORY

13: p_Last_update_date DATE,
14: p_Last_updated_by NUMBER
15: )
16: is
17: CURSOR C_check IS SELECT 1 from BIS_OBJ_REFRESH_HISTORY
18: where Prog_request_id =p_Prog_request_id and
19: OBJECT_TYPE =p_Object_type and
20: OBJECT_NAME =p_Object_name ;
21:

Line 27: BIS_COLLECTION_UTILITIES.put_line('Following record already exist in BIS_OBJ_REFRESH_HISTORY ');

23:
24: BEGIN
25: --for bug 4174608
26: for c_check_rec in C_check loop
27: BIS_COLLECTION_UTILITIES.put_line('Following record already exist in BIS_OBJ_REFRESH_HISTORY ');
28: BIS_COLLECTION_UTILITIES.put_line('Prog_request_id '||p_Prog_request_id ||' OBJECT_TYPE '|| p_Object_type||' OBJECT_NAME '||p_Object_name);
29: return;
30: end loop;
31: insert into BIS_OBJ_REFRESH_HISTORY

Line 31: insert into BIS_OBJ_REFRESH_HISTORY

27: BIS_COLLECTION_UTILITIES.put_line('Following record already exist in BIS_OBJ_REFRESH_HISTORY ');
28: BIS_COLLECTION_UTILITIES.put_line('Prog_request_id '||p_Prog_request_id ||' OBJECT_TYPE '|| p_Object_type||' OBJECT_NAME '||p_Object_name);
29: return;
30: end loop;
31: insert into BIS_OBJ_REFRESH_HISTORY
32: (Prog_request_id ,
33: Object_type ,
34: Object_name ,
35: Refresh_type ,

Line 66: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_OBJ_REFRESH_HISTORY_PKG.Insert_Row ' || sqlerrm);

62: when others then
63: BIS_COLLECTION_UTILITIES.put_line('Prog_request_id ' || p_Prog_request_id);
64: BIS_COLLECTION_UTILITIES.put_line('Object_type '|| p_Object_type);
65: BIS_COLLECTION_UTILITIES.put_line('Object_name '||p_Object_name);
66: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_OBJ_REFRESH_HISTORY_PKG.Insert_Row ' || sqlerrm);
67: raise;
68: END;
69:
70:

Line 134: stmt := stmt || 'update BIS_OBJ_REFRESH_HISTORY set ' || setClause ;

130:
131: setClause :=setClause || 'Last_update_date = ''' || p_Last_update_date || ''', ' ;
132: setClause :=setClause || 'Last_updated_by= ' || p_Last_updated_by ;
133:
134: stmt := stmt || 'update BIS_OBJ_REFRESH_HISTORY set ' || setClause ;
135: stmt := stmt || ' where Prog_request_id = ' || p_Prog_request_id ;
136: stmt := stmt || ' and Object_type = ''' || p_Object_type ||''' ';
137: stmt := stmt || ' and Object_name = ''' || p_Object_name ||''' ' ;
138:

Line 145: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_OBJ_REFRESH_HISTORY_PKG.Update_Row ' || sqlerrm);

141: RETURN TRUE;
142:
143: EXCEPTION
144: when others then
145: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_OBJ_REFRESH_HISTORY_PKG.Update_Row ' || sqlerrm);
146: raise;
147:
148: END;
149:

Line 153: DELETE FROM BIS_OBJ_REFRESH_HISTORY

149:
150: PROCEDURE Delete_Row (p_prog_req_id number)
151: IS
152: BEGIN
153: DELETE FROM BIS_OBJ_REFRESH_HISTORY
154: WHERE PROG_REQUEST_ID = p_prog_req_id;
155:
156: EXCEPTION
157: when others then

Line 158: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_OBJ_REFRESH_HISTORY_PKG.Delete_Row ' || sqlerrm);

154: WHERE PROG_REQUEST_ID = p_prog_req_id;
155:
156: EXCEPTION
157: when others then
158: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_OBJ_REFRESH_HISTORY_PKG.Delete_Row ' || sqlerrm);
159: raise;
160: END;
161:
162:

Line 163: END BIS_OBJ_REFRESH_HISTORY_PKG;

159: raise;
160: END;
161:
162:
163: END BIS_OBJ_REFRESH_HISTORY_PKG;