321:
322: /********************************************************/
323: /* Select calendar Code and Exception Set Id for future */
324: /* use so that the SQL statements do not have to join */
325: /* with MTL_PARAMETERS table. */
326: /********************************************************/
327:
328: SELECT CALENDAR_CODE, CALENDAR_EXCEPTION_SET_ID
329: INTO cal_code, except_id
326: /********************************************************/
327:
328: SELECT CALENDAR_CODE, CALENDAR_EXCEPTION_SET_ID
329: INTO cal_code, except_id
330: FROM MTL_PARAMETERS
331: WHERE ORGANIZATION_ID = org_id;
332:
333: END Init;
334:
569:
570: /********************************************************/
571: /* Select calendar Code and Exception Set Id for future */
572: /* use so that the SQL statements do not have to join */
573: /* with MTL_PARAMETERS table. */
574: /********************************************************/
575:
576: SELECT TO_NUMBER(TO_CHAR(effect_date, 'J'))
577: INTO j_effect_date