253: select
254: BCB.OPERATION_SEQ_NUM,
255: BCB.COMPONENT_ITEM_ID,
256: sysdate,
257: fnd_global.user_id,
258: sysdate,
259: fnd_global.user_id,
260: fnd_global.login_id,
261: BCB.ITEM_NUM,
255: BCB.COMPONENT_ITEM_ID,
256: sysdate,
257: fnd_global.user_id,
258: sysdate,
259: fnd_global.user_id,
260: fnd_global.login_id,
261: BCB.ITEM_NUM,
262: BCB.COMPONENT_QUANTITY,
263: BCB.COMPONENT_YIELD_FACTOR,
256: sysdate,
257: fnd_global.user_id,
258: sysdate,
259: fnd_global.user_id,
260: fnd_global.login_id,
261: BCB.ITEM_NUM,
262: BCB.COMPONENT_QUANTITY,
263: BCB.COMPONENT_YIELD_FACTOR,
264: BCB.EFFECTIVITY_DATE,
687: values(
688: 1,
689: v_struct_comp(cntr).component_item_id,
690: sysdate,
691: fnd_global.user_id,
692: sysdate,
693: fnd_global.user_id,
694: fnd_global.login_id,
695: v_struct_comp(cntr).item_num,
689: v_struct_comp(cntr).component_item_id,
690: sysdate,
691: fnd_global.user_id,
692: sysdate,
693: fnd_global.user_id,
694: fnd_global.login_id,
695: v_struct_comp(cntr).item_num,
696: v_struct_comp(cntr).component_quantity,
697: v_struct_comp(cntr).component_yield_factor,
690: sysdate,
691: fnd_global.user_id,
692: sysdate,
693: fnd_global.user_id,
694: fnd_global.login_id,
695: v_struct_comp(cntr).item_num,
696: v_struct_comp(cntr).component_quantity,
697: v_struct_comp(cntr).component_yield_factor,
698: sysdate,
2102: select
2103: BCB.OPERATION_SEQ_NUM,
2104: BCB.COMPONENT_ITEM_ID,
2105: sysdate,
2106: fnd_global.user_id,
2107: sysdate,
2108: fnd_global.user_id,
2109: fnd_global.login_id,
2110: l_item_seq_incr,
2104: BCB.COMPONENT_ITEM_ID,
2105: sysdate,
2106: fnd_global.user_id,
2107: sysdate,
2108: fnd_global.user_id,
2109: fnd_global.login_id,
2110: l_item_seq_incr,
2111: BCB.COMPONENT_QUANTITY,
2112: BCB.COMPONENT_YIELD_FACTOR,
2105: sysdate,
2106: fnd_global.user_id,
2107: sysdate,
2108: fnd_global.user_id,
2109: fnd_global.login_id,
2110: l_item_seq_incr,
2111: BCB.COMPONENT_QUANTITY,
2112: BCB.COMPONENT_YIELD_FACTOR,
2113: BCB.EFFECTIVITY_DATE,
2802: select
2803: BCB.OPERATION_SEQ_NUM,
2804: BCB.COMPONENT_ITEM_ID,
2805: sysdate,
2806: fnd_global.user_id,
2807: sysdate,
2808: fnd_global.user_id,
2809: fnd_global.login_id,
2810: l_item_seq_incr,
2804: BCB.COMPONENT_ITEM_ID,
2805: sysdate,
2806: fnd_global.user_id,
2807: sysdate,
2808: fnd_global.user_id,
2809: fnd_global.login_id,
2810: l_item_seq_incr,
2811: BCB.COMPONENT_QUANTITY,
2812: BCB.COMPONENT_YIELD_FACTOR,
2805: sysdate,
2806: fnd_global.user_id,
2807: sysdate,
2808: fnd_global.user_id,
2809: fnd_global.login_id,
2810: l_item_seq_incr,
2811: BCB.COMPONENT_QUANTITY,
2812: BCB.COMPONENT_YIELD_FACTOR,
2813: BCB.EFFECTIVITY_DATE,
2901: from_end_item_rev_id = v_update_comp_tbl(upd_index).from_revision_id,
2902: to_end_item_rev_id = v_update_comp_tbl(upd_index).to_revision_id,
2903: from_object_revision_id = v_update_comp_tbl(upd_index).from_revision_id,
2904: last_update_date = sysdate,
2905: last_updated_by = fnd_global.user_id,
2906: last_update_login = fnd_global.login_id
2907: where
2908: component_sequence_id = v_update_comp_tbl(upd_index).component_sequence_id; */
2909: l_stmt_no := 470;
2902: to_end_item_rev_id = v_update_comp_tbl(upd_index).to_revision_id,
2903: from_object_revision_id = v_update_comp_tbl(upd_index).from_revision_id,
2904: last_update_date = sysdate,
2905: last_updated_by = fnd_global.user_id,
2906: last_update_login = fnd_global.login_id
2907: where
2908: component_sequence_id = v_update_comp_tbl(upd_index).component_sequence_id; */
2909: l_stmt_no := 470;
2910: if v_update_comp_tbl.exists(v_update_comp_tbl.first) then
2915: from_end_item_rev_id = v_update_comp_tbl(upd_index).from_revision_id,
2916: to_end_item_rev_id = v_update_comp_tbl(upd_index).to_revision_id,
2917: from_object_revision_id = v_update_comp_tbl(upd_index).from_revision_id,
2918: last_update_date = sysdate,
2919: last_updated_by = fnd_global.user_id,
2920: last_update_login = fnd_global.login_id
2921: where
2922: component_sequence_id = v_update_comp_tbl(upd_index).component_sequence_id;
2923: end loop;
2916: to_end_item_rev_id = v_update_comp_tbl(upd_index).to_revision_id,
2917: from_object_revision_id = v_update_comp_tbl(upd_index).from_revision_id,
2918: last_update_date = sysdate,
2919: last_updated_by = fnd_global.user_id,
2920: last_update_login = fnd_global.login_id
2921: where
2922: component_sequence_id = v_update_comp_tbl(upd_index).component_sequence_id;
2923: end loop;
2924: end if;