APPS.FNDCP_SCH dependencies on FND_CONC_RELEASE_CLASSES

Line 155: FROM fnd_conc_release_classes

151:
152: BEGIN
153: SELECT Release_Class_id
154: INTO class_id
155: FROM fnd_conc_release_classes
156: WHERE application_id = class_application_id
157: AND class_name = release_class_name;
158:
159: RETURN class_id;

Line 411: update fnd_conc_release_classes c

407:
408: appl_id := application_id_f(application);
409:
410: /* Do the update */
411: update fnd_conc_release_classes c
412: set c.enabled_flag = 'Y',
413: c.last_update_date = l_last_update_date,
414: c.last_updated_by = l_last_updated_by,
415: c.last_update_login = l_last_update_login

Line 462: update fnd_conc_release_classes c

458:
459: appl_id := application_id_f(application);
460:
461: /* Do the update */
462: update fnd_conc_release_classes c
463: set c.enabled_flag = 'N',
464: c.last_update_date = l_last_update_date,
465: c.last_updated_by = l_last_updated_by,
466: c.last_update_login = l_last_update_login

Line 550: update fnd_conc_release_classes c

546:
547: appl_id := application_id_f(application);
548:
549: /* Do the update */
550: update fnd_conc_release_classes c
551: set RESUBMIT_INTERVAL= Resub_Interval,
552: RESUBMIT_INTERVAL_UNIT_CODE = Resub_Int_Unit_Code,
553: RESUBMIT_INTERVAL_TYPE_CODE = Resub_Int_Type_Code,
554: c.last_update_date = l_last_update_date,

Line 618: select fnd_conc_release_classes_s.nextval

614: end if;
615: end if;
616:
617: /* Get new ID */
618: select fnd_conc_release_classes_s.nextval
619: into obj_id
620: from sys.dual;
621:
622: appl_id := application_id_f(application);

Line 625: insert into fnd_conc_release_classes

621:
622: appl_id := application_id_f(application);
623:
624: /* Do the insert */
625: insert into fnd_conc_release_classes
626: (application_id, release_class_id, release_class_name,
627: enabled_flag, class_type,
628: last_update_date, last_updated_by, last_update_login,
629: creation_date, created_by, updated_flag)

Line 638: insert into fnd_conc_release_classes_tl

634: creation_date, created_by, 'Y');
635:
636: -- insert rows for each installed language into the tl table
637: for lang_rec in lang_cur loop
638: insert into fnd_conc_release_classes_tl
639: (application_id, release_class_id, language,
640: creation_date, created_by,
641: last_update_date, last_updated_by, last_update_login,
642: description, user_release_class_name, source_lang)

Line 674: from fnd_conc_release_classes

670: appl_id := application_id_f(Application);
671:
672: select 'Y'
673: into dummy
674: from fnd_conc_release_classes
675: where application_id = appl_id
676: and release_class_name = Class_Name
677: and rownum = 1;
678:

Line 739: update FND_CONC_RELEASE_CLASSES

735: Values
736: (c_app_id, c_id, d_app_id, d_id, created_by, last_update_login,
737: last_update_date, last_updated_by, creation_date);
738:
739: update FND_CONC_RELEASE_CLASSES
740: set updated_flag = 'Y'
741: where APPLICATION_ID = c_app_id
742: and RELEASE_CLASS_ID = c_id;
743: