357: x_horizon_start_date and
358: x_horizon_end_date ;
359: BEGIN
360:
361: X_login_id := fnd_global.login_id;
362: X_last_updated_by := fnd_global.user_id;
363:
364: X_progress := '030';
365:
358: x_horizon_end_date ;
359: BEGIN
360:
361: X_login_id := fnd_global.login_id;
362: X_last_updated_by := fnd_global.user_id;
363:
364: X_progress := '030';
365:
366: OPEN C1;
497: --dbms_output.put_line('Get Approved Reqs: Item'||x_item_id);
498: --dbms_output.put_line('Get Approved Reqs: Start date'||x_horizon_start_date);
499: --dbms_output.put_line('Get Approved Reqs: End date'||x_horizon_end_date);
500:
501: X_login_id := fnd_global.login_id;
502: X_last_updated_by := fnd_global.user_id;
503:
504: X_progress := '030';
505:
498: --dbms_output.put_line('Get Approved Reqs: Start date'||x_horizon_start_date);
499: --dbms_output.put_line('Get Approved Reqs: End date'||x_horizon_end_date);
500:
501: X_login_id := fnd_global.login_id;
502: X_last_updated_by := fnd_global.user_id;
503:
504: X_progress := '030';
505:
506: OPEN C1;
681: performance */
682:
683: BEGIN
684:
685: X_login_id := fnd_global.login_id;
686: X_last_updated_by := fnd_global.user_id;
687:
688: X_progress := '020';
689:
682:
683: BEGIN
684:
685: X_login_id := fnd_global.login_id;
686: X_last_updated_by := fnd_global.user_id;
687:
688: X_progress := '020';
689:
690: OPEN C1;