APPS.MSC_ACTIONS dependencies on MSC_ITEM_EXCEPTIONS

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

447: raise_application_error(-20000,sqlerrm||':'||statement);
448: END;
449:
450: ---------------------------------------------------------------------
451: -- to save the current exception summary into msc_item_exceptions
452: ---------------------------------------------------------------------
453: FUNCTION save_as(plan NUMBER) RETURN NUMBER IS
454: version_id NUMBER;
455: BEGIN

Line 459: FROM msc_item_exceptions

455: BEGIN
456:
457: SELECT MAX(NVL(version,0))+1
458: INTO version_id
459: FROM msc_item_exceptions
460: WHERE plan_id= plan;
461:
462: INSERT INTO msc_item_exceptions
463: (exception_type, inventory_item_id, plan_id, sr_instance_id,

Line 462: INSERT INTO msc_item_exceptions

458: INTO version_id
459: FROM msc_item_exceptions
460: WHERE plan_id= plan;
461:
462: INSERT INTO msc_item_exceptions
463: (exception_type, inventory_item_id, plan_id, sr_instance_id,
464: organization_id, last_update_date, last_updated_by,
465: creation_date, created_by, last_update_login, display, request_id,
466: program_application_id, program_id,

Line 477: FROM msc_item_exceptions

473: program_application_id, program_id,
474: program_update_date, exception_count, project_Id,
475: task_id, version_id, planning_group,
476: department_id, resource_id, exception_group
477: FROM msc_item_exceptions
478: WHERE version is null
479: AND plan_id= plan;
480: commit;
481: Return version_id;

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

493: statement varchar2(2000);
494: rows_processed integer;
495: BEGIN
496:
497: -- update msc_item_exceptions by the their rowid (stored as char8 in
498: -- msc_form_query) by applying the criteria on the second insert
499: -- of msc_form_query
500:
501: statement :=

Line 502: 'update msc_item_exceptions

498: -- msc_form_query) by applying the criteria on the second insert
499: -- of msc_form_query
500:
501: statement :=
502: 'update msc_item_exceptions
503: set display = 2,
504: last_update_login = :last_update_login,
505: last_updated_by = :last_updated_by,
506: last_update_date = sysdate

Line 527: -- to lock the row in msc_item_exceptions

523: raise no_data_found;
524:
525: END update_row;
526: ---------------------------------------------------------------------
527: -- to lock the row in msc_item_exceptions
528: -- if the row is deleted, return 1. if the data is changed, return 2.
529: -- if the row is locked successfully, return 3.
530: ---------------------------------------------------------------------
531: FUNCTION lock_row(p_exception_id number, p_omit_list VARCHAR2)

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

536: display_flag NUMBER;
537: counter NUMBER;
538: BEGIN
539:
540: -- lock the row in msc_item_exceptions by the their rowid (stored as char8 in
541: -- msc_form_query) by applying the criteria on the second insert
542: -- of msc_form_query
543:
544: statement :=

Line 546: from msc_item_exceptions

542: -- of msc_form_query
543:
544: statement :=
545: 'select display
546: from msc_item_exceptions
547: where rowid in (
548: select chartorowid(char8)
549: from msc_form_query
550: where ' ||p_omit_list||