186:
187: CURSOR get_bom_workdays(C_CALENDAR_CODE VARCHAR2,C_SHIFT NUMBER,C_DESCRIPTION VARCHAR2)
188: IS
189: SELECT SEQ_NUM
190: FROM BOM_WORKDAY_PATTERNS
191: WHERE CALENDAR_CODE=C_CALENDAR_CODE
192: AND SHIFT_NUM=C_SHIFT
193: AND DESCRIPTION=C_DESCRIPTION;
194:
447: 'ORGANIZATION_NAME = ' || p_appr_deptshift_rec.ORGANIZATION_NAME ||
448: ', DEPT_DESCRIPTION = ' || p_appr_deptshift_rec.DEPT_DESCRIPTION ||
449: ', CALENDAR_DESCRIPTION = ' || p_appr_deptshift_rec.CALENDAR_DESCRIPTION ||
450: ', SHIFT_NUM = ' || p_appr_deptshift_rec.SHIFT_NUM ||
451: ', WORKDAY_ID = ' || p_appr_deptshift_rec.BOM_WORKDAY_PATTERNS_ID ||
452: ', MAX_SERVICE_CATEGORY = ' || p_appr_deptshift_rec.MAX_SERVICE_CATEGORY);
453: end if;
454: end if;
455: