37: plsqltbl_rec tab_cal_typ;
38:
39: PROCEDURE log_message(pBUFF IN VARCHAR2) IS
40: BEGIN
41: IF fnd_global.conc_request_id > 0 THEN
42: FND_FILE.PUT_LINE( FND_FILE.LOG, pBUFF);
43: ELSE
44: null;
45: END IF;
1785: ((f_date(i) - trunc(f_date(i))) * 86400 ),
1786: ((t_date(i) - trunc(t_date(i))) * 86400 ),
1787: resource_count(i),
1788: sysdate,
1789: FND_GLOBAL.USER_ID,
1790: sysdate,
1791: FND_GLOBAL.USER_ID,
1792: FND_GLOBAL.USER_ID
1793: );
1787: resource_count(i),
1788: sysdate,
1789: FND_GLOBAL.USER_ID,
1790: sysdate,
1791: FND_GLOBAL.USER_ID,
1792: FND_GLOBAL.USER_ID
1793: );
1794:
1795: END IF; /* Usage */
1788: sysdate,
1789: FND_GLOBAL.USER_ID,
1790: sysdate,
1791: FND_GLOBAL.USER_ID,
1792: FND_GLOBAL.USER_ID
1793: );
1794:
1795: END IF; /* Usage */
1796:
2551: ((f_date(i) - trunc(f_date(i))) * 86400 ),
2552: ((t_date(i) - trunc(t_date(i))) * 86400 ),
2553: resource_count(i),
2554: sysdate,
2555: FND_GLOBAL.USER_ID,
2556: sysdate,
2557: FND_GLOBAL.USER_ID,
2558: FND_GLOBAL.USER_ID
2559: ) ;
2553: resource_count(i),
2554: sysdate,
2555: FND_GLOBAL.USER_ID,
2556: sysdate,
2557: FND_GLOBAL.USER_ID,
2558: FND_GLOBAL.USER_ID
2559: ) ;
2560:
2561: first_in := last_in + 1;
2554: sysdate,
2555: FND_GLOBAL.USER_ID,
2556: sysdate,
2557: FND_GLOBAL.USER_ID,
2558: FND_GLOBAL.USER_ID
2559: ) ;
2560:
2561: first_in := last_in + 1;
2562: last_in := last_in + 50000 ;
2779: p_from_time,
2780: p_to_time,
2781: p_assigned_qty,
2782: sysdate,
2783: FND_GLOBAL.USER_ID,
2784: sysdate,
2785: FND_GLOBAL.USER_ID,
2786: FND_GLOBAL.USER_ID ) ;
2787: END IF;
2781: p_assigned_qty,
2782: sysdate,
2783: FND_GLOBAL.USER_ID,
2784: sysdate,
2785: FND_GLOBAL.USER_ID,
2786: FND_GLOBAL.USER_ID ) ;
2787: END IF;
2788: EXCEPTION
2789: WHEN OTHERS THEN
2782: sysdate,
2783: FND_GLOBAL.USER_ID,
2784: sysdate,
2785: FND_GLOBAL.USER_ID,
2786: FND_GLOBAL.USER_ID ) ;
2787: END IF;
2788: EXCEPTION
2789: WHEN OTHERS THEN
2790: log_message('Error in Net Resource Avail Insert ');