APPS.BIS_RS_PROG_RUN_HISTORY_PKG dependencies on BIS_RS_PROG_RUN_HISTORY

Line 1: package body BIS_RS_PROG_RUN_HISTORY_PKG AS

1: package body BIS_RS_PROG_RUN_HISTORY_PKG AS
2: /*$Header: BISPRTHB.pls 120.0 2005/06/01 14:27 appldev noship $*/
3: PROCEDURE Insert_Row( p_Set_request_id Number,
4: p_Stage_request_id Number,
5: p_Request_id Number,

Line 22: insert into BIS_RS_PROG_RUN_HISTORY

18: is
19:
20: BEGIN
21:
22: insert into BIS_RS_PROG_RUN_HISTORY
23: (Set_request_id,
24: Stage_request_id,
25: Request_id,
26: Program_id,

Line 56: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_RS_PROG_RUN_HISTORY_PKG.Insert_Row ' || sqlerrm);

52:
53: commit;
54: EXCEPTION
55: when others then
56: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_RS_PROG_RUN_HISTORY_PKG.Insert_Row ' || sqlerrm);
57: raise;
58:
59: END;
60:

Line 115: stmt := stmt || 'update BIS_RS_PROG_RUN_HISTORY set '|| setClause;

111:
112: setClause :=setClause || 'Last_update_date = '''|| p_Last_update_date || ''', ' ;
113: setClause :=setClause || 'Last_updated_by= ' || p_Last_updated_by ;
114:
115: stmt := stmt || 'update BIS_RS_PROG_RUN_HISTORY set '|| setClause;
116: stmt := stmt || ' where Set_request_id = :1 and Request_id = :2 ';
117:
118: execute immediate stmt using p_Set_request_id ,p_Request_id;
119:

Line 121: update BIS_RS_PROG_RUN_HISTORY

117:
118: execute immediate stmt using p_Set_request_id ,p_Request_id;
119:
120: if(p_completion_text is not null) then
121: update BIS_RS_PROG_RUN_HISTORY
122: set Completion_text = p_completion_text
123: where Set_request_id = p_Set_request_id and Request_id = p_Request_id;
124: end if;
125:

Line 131: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_RS_PROG_RUN_HISTORY_PKG.Update_Row ' || sqlerrm);

127: RETURN TRUE;
128:
129: EXCEPTION
130: when others then
131: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_RS_PROG_RUN_HISTORY_PKG.Update_Row ' || sqlerrm);
132: raise;
133:
134: END;
135:

Line 141: DELETE FROM BIS_RS_PROG_RUN_HISTORY

137: PROCEDURE Delete_Row (p_set_rq_id number)
138: IS
139: BEGIN
140:
141: DELETE FROM BIS_RS_PROG_RUN_HISTORY
142: WHERE SET_REQUEST_ID =p_set_rq_id;
143:
144: EXCEPTION
145: when others then

Line 146: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_RS_PROG_RUN_HISTORY_PKG.Delete_Row ' || sqlerrm);

142: WHERE SET_REQUEST_ID =p_set_rq_id;
143:
144: EXCEPTION
145: when others then
146: BIS_COLLECTION_UTILITIES.put_line('Exception happens in BIS_RS_PROG_RUN_HISTORY_PKG.Delete_Row ' || sqlerrm);
147: raise;
148: END;
149:
150:

Line 151: END BIS_RS_PROG_RUN_HISTORY_PKG;

147: raise;
148: END;
149:
150:
151: END BIS_RS_PROG_RUN_HISTORY_PKG;