247: -- Bug 5279941
248: -- Denormalizing the Asset Group
249: -- ntungare
250: --
251: If x_normalized_id_array.exists(qa_ss_const.asset_group) THEN
252: x_normalized_id_array(qa_ss_const.asset_group).value := QA_FLEX_UTIL.ITEM
253: (x_org_id,
254: x_normalized_id_array(qa_ss_const.asset_group).value);
255: End If;
248: -- Denormalizing the Asset Group
249: -- ntungare
250: --
251: If x_normalized_id_array.exists(qa_ss_const.asset_group) THEN
252: x_normalized_id_array(qa_ss_const.asset_group).value := QA_FLEX_UTIL.ITEM
253: (x_org_id,
254: x_normalized_id_array(qa_ss_const.asset_group).value);
255: End If;
256:
250: --
251: If x_normalized_id_array.exists(qa_ss_const.asset_group) THEN
252: x_normalized_id_array(qa_ss_const.asset_group).value := QA_FLEX_UTIL.ITEM
253: (x_org_id,
254: x_normalized_id_array(qa_ss_const.asset_group).value);
255: End If;
256:
257: --
258: -- Bug 5279941
258: -- Bug 5279941
259: -- Denormalizing the Asset Activity
260: -- ntungare
261: --
262: If x_normalized_id_array.exists(qa_ss_const.asset_activity) THEN
263: x_normalized_id_array(qa_ss_const.asset_activity).value :=
264: QA_FLEX_UTIL.ITEM
265: (x_org_id,
266: x_normalized_id_array(qa_ss_const.asset_activity).value);
259: -- Denormalizing the Asset Activity
260: -- ntungare
261: --
262: If x_normalized_id_array.exists(qa_ss_const.asset_activity) THEN
263: x_normalized_id_array(qa_ss_const.asset_activity).value :=
264: QA_FLEX_UTIL.ITEM
265: (x_org_id,
266: x_normalized_id_array(qa_ss_const.asset_activity).value);
267: End If;
262: If x_normalized_id_array.exists(qa_ss_const.asset_activity) THEN
263: x_normalized_id_array(qa_ss_const.asset_activity).value :=
264: QA_FLEX_UTIL.ITEM
265: (x_org_id,
266: x_normalized_id_array(qa_ss_const.asset_activity).value);
267: End If;
268:
269: --
270: -- Bug 5279941
270: -- Bug 5279941
271: -- Denormalizing the Asset Instance Number
272: -- ntungare
273: --
274: If x_normalized_id_array.exists(qa_ss_const.asset_instance_number) THEN
275: x_normalized_id_array(qa_ss_const.asset_instance_number).value :=
276: QA_FLEX_UTIL.GET_ASSET_INSTANCE_NAME
277: (x_normalized_id_array(qa_ss_const.asset_instance_number).value);
278: End If;
271: -- Denormalizing the Asset Instance Number
272: -- ntungare
273: --
274: If x_normalized_id_array.exists(qa_ss_const.asset_instance_number) THEN
275: x_normalized_id_array(qa_ss_const.asset_instance_number).value :=
276: QA_FLEX_UTIL.GET_ASSET_INSTANCE_NAME
277: (x_normalized_id_array(qa_ss_const.asset_instance_number).value);
278: End If;
279:
273: --
274: If x_normalized_id_array.exists(qa_ss_const.asset_instance_number) THEN
275: x_normalized_id_array(qa_ss_const.asset_instance_number).value :=
276: QA_FLEX_UTIL.GET_ASSET_INSTANCE_NAME
277: (x_normalized_id_array(qa_ss_const.asset_instance_number).value);
278: End If;
279:
280: END eam_denormalize_array;
281:
581: -- So explicitly checking for the sequence elements
582: -- and initializing them to Automatic.
583: -- ntungare Tue Jul 4 06:20:09 PDT 2006
584: --
585: ELSIF c.datatype = qa_ss_const.sequence_datatype THEN
586: l_insert_columns := l_insert_columns || ',' || c.result_column_name;
587: l_insert_values := l_insert_values || ', '''
588: || QA_SEQUENCE_API.get_sequence_default_value
589: || '''';
990: -- in which case set the default val as
991: -- 'Automatic'
992: -- ntungare
993: --
994: elsif pc_rec.datatype = qa_ss_const.sequence_datatype THEN
995: l_ret_string := l_ret_string || '@' || to_char(pc_rec.char_id) || '=' || QA_SEQUENCE_API.get_sequence_default_value;
996:
997: --
998: -- Bug 5365251