APPS.BIS_RS_STAGE_RUN_HISTORY_PKG dependencies on BIS_RS_STAGE_RUN_HISTORY

Line 1: package body BIS_RS_STAGE_RUN_HISTORY_PKG AS

1: package body BIS_RS_STAGE_RUN_HISTORY_PKG AS
2: /*$Header: BISSTTHB.pls 120.3 2006/01/24 08:24 aguwalan noship $*/
3: PROCEDURE Insert_Row ( p_Request_set_id NUMBER
4: , p_Set_app_id NUMBER
5: , p_Stage_id NUMBER

Line 19: CURSOR C_check IS SELECT ROWID from BIS_RS_STAGE_RUN_HISTORY

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

Line 23: insert into BIS_RS_STAGE_RUN_HISTORY

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

Line 63: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_RS_STAGE_RUN_HISTORY_PKG.Insert_Row ' || sqlerrm);

59: end if;
60: CLOSE C_check;
61: Commit;
62: EXCEPTION WHEN OTHERS THEN
63: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_RS_STAGE_RUN_HISTORY_PKG.Insert_Row ' || sqlerrm);
64: raise;
65: END;
66: -- modified aguwalan
67: function Update_Row (p_Request_id NUMBER

Line 106: stmt := 'update BIS_RS_STAGE_RUN_HISTORY set '|| setClause ;

102:
103: if setClause is not null then
104: setClause :=setClause || 'Last_update_date = ''' || p_Last_update_date || ''', ' ;
105: setClause :=setClause || 'Last_updated_by= ' || p_Last_updated_by ;
106: stmt := 'update BIS_RS_STAGE_RUN_HISTORY set '|| setClause ;
107: stmt := stmt || ' where Set_request_id = :1 and Request_id = :2';
108: execute immediate stmt USING p_Set_request_id, p_Request_id;
109: end if;
110:

Line 114: update BIS_RS_STAGE_RUN_HISTORY

110:
111: -- this is kept outside to handle pseudo languege issues
112:
113: if(p_completion_text is not null) then
114: update BIS_RS_STAGE_RUN_HISTORY
115: set Completion_text = p_completion_text ,
116: Last_update_date = p_Last_update_date ,
117: Last_updated_by = p_Last_updated_by
118: where Set_request_id = p_Set_request_id

Line 126: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_RS_STAGE_RUN_HISTORY_PKG.Update_Row ' || sqlerrm);

122:
123: RETURN TRUE;
124:
125: EXCEPTION WHEN OTHERS THEN
126: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_RS_STAGE_RUN_HISTORY_PKG.Update_Row ' || sqlerrm);
127: raise;
128: END;
129:
130:

Line 135: DELETE FROM BIS_RS_STAGE_RUN_HISTORY

131: PROCEDURE Delete_Row (p_set_req_id number)
132: IS
133: BEGIN
134:
135: DELETE FROM BIS_RS_STAGE_RUN_HISTORY
136: WHERE SET_REQUEST_ID = p_set_req_id;
137:
138: EXCEPTION WHEN OTHERS THEN
139: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_RS_STAGE_RUN_HISTORY_PKG.Delete_Row ' || sqlerrm);

Line 139: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_RS_STAGE_RUN_HISTORY_PKG.Delete_Row ' || sqlerrm);

135: DELETE FROM BIS_RS_STAGE_RUN_HISTORY
136: WHERE SET_REQUEST_ID = p_set_req_id;
137:
138: EXCEPTION WHEN OTHERS THEN
139: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_RS_STAGE_RUN_HISTORY_PKG.Delete_Row ' || sqlerrm);
140: raise;
141:
142: END;
143:

Line 144: END BIS_RS_STAGE_RUN_HISTORY_PKG;

140: raise;
141:
142: END;
143:
144: END BIS_RS_STAGE_RUN_HISTORY_PKG;