301: *******/
302: PROCEDURE Init_Globals IS
303:
304: BEGIN
305: G_request_id := FND_GLOBAL.CONC_REQUEST_ID();
306: G_appl_id := FND_GLOBAL.PROG_APPL_ID();
307: G_program_id := FND_GLOBAL.CONC_PROGRAM_ID();
308: G_user_id := FND_GLOBAL.USER_ID();
309: G_login_id := FND_GLOBAL.CONC_LOGIN_ID();
302: PROCEDURE Init_Globals IS
303:
304: BEGIN
305: G_request_id := FND_GLOBAL.CONC_REQUEST_ID();
306: G_appl_id := FND_GLOBAL.PROG_APPL_ID();
307: G_program_id := FND_GLOBAL.CONC_PROGRAM_ID();
308: G_user_id := FND_GLOBAL.USER_ID();
309: G_login_id := FND_GLOBAL.CONC_LOGIN_ID();
310: END Init_Globals;
303:
304: BEGIN
305: G_request_id := FND_GLOBAL.CONC_REQUEST_ID();
306: G_appl_id := FND_GLOBAL.PROG_APPL_ID();
307: G_program_id := FND_GLOBAL.CONC_PROGRAM_ID();
308: G_user_id := FND_GLOBAL.USER_ID();
309: G_login_id := FND_GLOBAL.CONC_LOGIN_ID();
310: END Init_Globals;
311:
304: BEGIN
305: G_request_id := FND_GLOBAL.CONC_REQUEST_ID();
306: G_appl_id := FND_GLOBAL.PROG_APPL_ID();
307: G_program_id := FND_GLOBAL.CONC_PROGRAM_ID();
308: G_user_id := FND_GLOBAL.USER_ID();
309: G_login_id := FND_GLOBAL.CONC_LOGIN_ID();
310: END Init_Globals;
311:
312:
305: G_request_id := FND_GLOBAL.CONC_REQUEST_ID();
306: G_appl_id := FND_GLOBAL.PROG_APPL_ID();
307: G_program_id := FND_GLOBAL.CONC_PROGRAM_ID();
308: G_user_id := FND_GLOBAL.USER_ID();
309: G_login_id := FND_GLOBAL.CONC_LOGIN_ID();
310: END Init_Globals;
311:
312:
313: /******* Insert data for the specified day
327: l_stime DATE := SYSDATE; -- time when insert started, to be used by Write_log
328: l_insert_stmnt VARCHAR2(20000);
329: l_select_stmnt1 VARCHAR2(20000);
330: l_select_stmnt2 VARCHAR2(20000);
331: l_quote VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(39); -- single quote
332: l_row_count NUMBER;
333:
334:
335: BEGIN