APPS.MSC_ACTIONS dependencies on MSC_ITEM_EXCEPTIONS

Line 461: -- to save the current exception summary into msc_item_exceptions

457: raise_application_error(-20000,sqlerrm||':'||statement);
458: END;
459:
460: ---------------------------------------------------------------------
461: -- to save the current exception summary into msc_item_exceptions
462: ---------------------------------------------------------------------
463: FUNCTION save_as(plan NUMBER) RETURN NUMBER IS
464: version_id NUMBER;
465: BEGIN

Line 469: FROM msc_item_exceptions

465: BEGIN
466:
467: SELECT MAX(NVL(version,0))+1
468: INTO version_id
469: FROM msc_item_exceptions
470: WHERE plan_id= plan;
471:
472: INSERT INTO msc_item_exceptions
473: (exception_type, inventory_item_id, plan_id, sr_instance_id,

Line 472: INSERT INTO msc_item_exceptions

468: INTO version_id
469: FROM msc_item_exceptions
470: WHERE plan_id= plan;
471:
472: INSERT INTO msc_item_exceptions
473: (exception_type, inventory_item_id, plan_id, sr_instance_id,
474: organization_id, last_update_date, last_updated_by,
475: creation_date, created_by, last_update_login, display, request_id,
476: program_application_id, program_id,

Line 487: FROM msc_item_exceptions

483: program_application_id, program_id,
484: program_update_date, exception_count, project_Id,
485: task_id, version_id, planning_group,
486: department_id, resource_id, exception_group
487: FROM msc_item_exceptions
488: WHERE version is null
489: AND plan_id= plan;
490: commit;
491: Return version_id;

Line 507: -- update msc_item_exceptions by the their rowid (stored as char8 in

503: statement varchar2(2000);
504: rows_processed integer;
505: BEGIN
506:
507: -- update msc_item_exceptions by the their rowid (stored as char8 in
508: -- msc_form_query) by applying the criteria on the second insert
509: -- of msc_form_query
510:
511: statement :=

Line 512: 'update msc_item_exceptions

508: -- msc_form_query) by applying the criteria on the second insert
509: -- of msc_form_query
510:
511: statement :=
512: 'update msc_item_exceptions
513: set display = 2,
514: last_update_login = :last_update_login,
515: last_updated_by = :last_updated_by,
516: last_update_date = sysdate

Line 537: -- to lock the row in msc_item_exceptions

533: raise no_data_found;
534:
535: END update_row;
536: ---------------------------------------------------------------------
537: -- to lock the row in msc_item_exceptions
538: -- if the row is deleted, return 1. if the data is changed, return 2.
539: -- if the row is locked successfully, return 3.
540: ---------------------------------------------------------------------
541: FUNCTION lock_row(p_exception_id number, p_omit_list VARCHAR2)

Line 550: -- lock the row in msc_item_exceptions by the their rowid (stored as char8 in

546: display_flag NUMBER;
547: counter NUMBER;
548: BEGIN
549:
550: -- lock the row in msc_item_exceptions by the their rowid (stored as char8 in
551: -- msc_form_query) by applying the criteria on the second insert
552: -- of msc_form_query
553:
554: statement :=

Line 556: from msc_item_exceptions

552: -- of msc_form_query
553:
554: statement :=
555: 'select display
556: from msc_item_exceptions
557: where rowid in (
558: select chartorowid(char8)
559: from msc_form_query
560: where ' ||p_omit_list||