[Home] [Help]
174: disj_id number;
175:
176: BEGIN
177: SELECT Disjunction_id
178: INTO disj_id FROM fnd_conc_release_Disjs
179: WHERE application_id = disj_application_id
180: AND disj_name = Disjunction_name;
181:
182: RETURN disj_id;
909: end if;
910: end if;
911:
912: /* Get new ID */
913: select fnd_conc_release_disjs_s.nextval
914: into obj_id
915: from sys.dual;
916:
917: appl_id := application_id_f(application);
916:
917: appl_id := application_id_f(application);
918:
919: /* Do the insert */
920: insert into fnd_conc_release_disjs
921: (application_id, disjunction_id, disjunction_name,
922: enabled_flag,
923: last_update_date, last_updated_by, last_update_login,
924: creation_date, created_by, updated_flag)
930:
931:
932: -- insert rows for each installed language into the tl table
933: for lang_rec in lang_cur loop
934: insert into fnd_conc_release_disjs_tl
935: (application_id, disjunction_id, language,
936: creation_date, created_by,
937: last_update_date, last_updated_by, last_update_login,
938: description, user_disjunction_name, source_lang)
965: appl_id := application_id_f(Application);
966:
967: select 'Y'
968: into dummy
969: from fnd_conc_release_Disjs
970: where application_id = appl_id
971: and Disjunction_name = Disj_Name
972: and rownum = 1;
973:
1052: (d_app_id, d_id, s_app_id, s_id, v_id, Negation_Flag,
1053: 'S', created_by,
1054: last_update_login, last_update_date, last_updated_by, creation_date);
1055:
1056: update FND_CONC_RELEASE_DISJS
1057: set updated_flag = 'Y'
1058: where APPLICATION_ID = d_app_id
1059: and DISJUNCTION_ID = d_id;
1060:
1118: Values
1119: (d_app_id, d_id, p_app_id, p_id, 'P', Negation_Flag, created_by,
1120: last_update_login, last_update_date, last_updated_by, creation_date);
1121:
1122: update FND_CONC_RELEASE_DISJS
1123: set updated_flag = 'Y'
1124: where APPLICATION_ID = d_app_id
1125: and DISJUNCTION_ID = d_id;
1126: