18: x_progress VARCHAR2(3) := NULL;
19: x_message VARCHAR2(240);
20: x_item_confirm BOOLEAN DEFAULT FALSE;
21:
22: x_user_id NUMBER := NVL(fnd_global.user_id, 0);
23: x_login_id NUMBER := NVL(fnd_global.login_id, 0);
24:
25: BEGIN
26:
19: x_message VARCHAR2(240);
20: x_item_confirm BOOLEAN DEFAULT FALSE;
21:
22: x_user_id NUMBER := NVL(fnd_global.user_id, 0);
23: x_login_id NUMBER := NVL(fnd_global.login_id, 0);
24:
25: BEGIN
26:
27: x_progress := '010';
136: -- not to confirm schedule header.
137:
138: x_header_confirm VARCHAR2(1) := 'Y';
139:
140: x_user_id NUMBER := NVL(fnd_global.user_id, 0);
141: x_login_id NUMBER := NVL(fnd_global.login_id, 0);
142:
143:
144: CURSOR c_all_schedule_items IS
137:
138: x_header_confirm VARCHAR2(1) := 'Y';
139:
140: x_user_id NUMBER := NVL(fnd_global.user_id, 0);
141: x_login_id NUMBER := NVL(fnd_global.login_id, 0);
142:
143:
144: CURSOR c_all_schedule_items IS
145: SELECT csh.schedule_horizon_start,