APPS.BIS_RS_RUN_HISTORY_PKG dependencies on BIS_RS_RUN_HISTORY

Line 1: package body BIS_RS_RUN_HISTORY_PKG AS

1: package body BIS_RS_RUN_HISTORY_PKG AS
2: /*$Header: BISRSTHB.pls 120.0 2005/06/01 14:53 appldev noship $*/
3:
4: PROCEDURE Insert_Row(p_Request_set_id NUMBER
5: , p_Set_app_id NUMBER

Line 19: CURSOR C_check IS SELECT ROWID from BIS_RS_RUN_HISTORY

15: , p_Last_update_date DATE
16: , p_Last_updated_by NUMBER
17: , p_completion_text VARCHAR2)
18: IS
19: CURSOR C_check IS SELECT ROWID from BIS_RS_RUN_HISTORY
20: where Request_set_id =p_Request_set_id;
21: X_Rowid varchar2(200);
22: BEGIN
23: insert into BIS_RS_RUN_HISTORY

Line 23: insert into BIS_RS_RUN_HISTORY

19: CURSOR C_check IS SELECT ROWID from BIS_RS_RUN_HISTORY
20: where Request_set_id =p_Request_set_id;
21: X_Rowid varchar2(200);
22: BEGIN
23: insert into BIS_RS_RUN_HISTORY
24: (Request_set_id
25: ,Set_app_id
26: ,Request_id
27: ,request_set_type

Line 64: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_RS_RUN_HISTORY_PKG.Insert_Row ' || sqlerrm);

60: end if;
61: CLOSE C_check;
62: commit;
63: EXCEPTION WHEN OTHERS THEN
64: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_RS_RUN_HISTORY_PKG.Insert_Row ' || sqlerrm);
65: raise;
66: END;
67:
68: FUNCTION Update_Row ( p_Request_id NUMBER

Line 112: stmt := 'update BIS_RS_RUN_HISTORY set ' || setClause ;

108: setClause :=setClause || 'Last_update_date = ''' || p_Last_update_date || ''', ' ;
109: setClause :=setClause || 'Last_updated_by= ' || p_Last_updated_by ;
110:
111:
112: stmt := 'update BIS_RS_RUN_HISTORY set ' || setClause ;
113: stmt := stmt || ' where Request_id = ' || p_Request_id ;
114:
115:
116: execute immediate stmt;

Line 119: update BIS_RS_RUN_HISTORY

115:
116: execute immediate stmt;
117:
118: if(p_completion_text is not null) then
119: update BIS_RS_RUN_HISTORY
120: set Completion_text = p_completion_text
121: where Request_id = p_Request_id;
122: end if;
123:

Line 129: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_RS_RUN_HISTORY_PKG.Update_Row ' || sqlerrm);

125:
126: RETURN TRUE;
127:
128: EXCEPTION WHEN OTHERS THEN
129: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_RS_RUN_HISTORY_PKG.Update_Row ' || sqlerrm);
130: raise;
131:
132: END;
133:

Line 139: DELETE FROM BIS_RS_RUN_HISTORY

135: PROCEDURE Delete_Row(p_last_update_date date)
136: IS
137: BEGIN
138:
139: DELETE FROM BIS_RS_RUN_HISTORY
140: WHERE Last_update_date <= p_last_update_date;
141:
142: commit;
143:

Line 145: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_RS_RUN_HISTORY_PKG.Delete_Row ' || sqlerrm);

141:
142: commit;
143:
144: EXCEPTION WHEN OTHERS THEN
145: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_RS_RUN_HISTORY_PKG.Delete_Row ' || sqlerrm);
146: raise;
147:
148: END;
149:

Line 150: END BIS_RS_RUN_HISTORY_PKG;

146: raise;
147:
148: END;
149:
150: END BIS_RS_RUN_HISTORY_PKG;