24: x_working_day number; /* Fix for bug 3410450.*/
25:
26: cursor cursor_forward is
27: SELECT BCD1.CALENDAR_DATE
28: FROM BOM_CALENDAR_DATES BCD1,
29: BOM_CALENDAR_DATES BCD2,
30: MTL_PARAMETERS MP
31: WHERE MP.ORGANIZATION_ID = x_org_id
32: AND BCD1.CALENDAR_CODE = MP.CALENDAR_CODE
25:
26: cursor cursor_forward is
27: SELECT BCD1.CALENDAR_DATE
28: FROM BOM_CALENDAR_DATES BCD1,
29: BOM_CALENDAR_DATES BCD2,
30: MTL_PARAMETERS MP
31: WHERE MP.ORGANIZATION_ID = x_org_id
32: AND BCD1.CALENDAR_CODE = MP.CALENDAR_CODE
33: AND BCD2.CALENDAR_CODE = MP.CALENDAR_CODE
37: AND BCD1.SEQ_NUM = NVL(BCD2.SEQ_NUM, BCD2.NEXT_SEQ_NUM) + CEIL(lt);
38:
39: cursor cursor_backward is
40: SELECT BCD1.CALENDAR_DATE
41: FROM BOM_CALENDAR_DATES BCD1,
42: BOM_CALENDAR_DATES BCD2,
43: MTL_PARAMETERS MP
44: WHERE MP.ORGANIZATION_ID = x_org_id
45: AND BCD1.CALENDAR_CODE = MP.CALENDAR_CODE
38:
39: cursor cursor_backward is
40: SELECT BCD1.CALENDAR_DATE
41: FROM BOM_CALENDAR_DATES BCD1,
42: BOM_CALENDAR_DATES BCD2,
43: MTL_PARAMETERS MP
44: WHERE MP.ORGANIZATION_ID = x_org_id
45: AND BCD1.CALENDAR_CODE = MP.CALENDAR_CODE
46: AND BCD2.CALENDAR_CODE = MP.CALENDAR_CODE
55: if the scheduled completion date is a working/non-working day.
56: */
57: cursor cursor_working_day is
58: SELECT nvl(BCD.SEQ_NUM,-1)
59: FROM BOM_CALENDAR_DATES BCD,
60: MTL_PARAMETERS MP
61: WHERE MP.ORGANIZATION_ID = x_org_id
62: AND BCD.CALENDAR_CODE = MP.CALENDAR_CODE
63: AND BCD.EXCEPTION_SET_ID = MP.CALENDAR_EXCEPTION_SET_ID