261:
262: /* Get profile */
263: l_single_step_collection := nvl(fnd_profile.value('MSD_ONE_STEP_COLLECTION'), 'N');
264:
265: l_conc_request_id := fnd_global.conc_request_id;
266: debug_line('Conc Reuquest ID : ' || l_conc_request_id);
267:
268: /* Validate definition id */
269: open c_get_cs;
776: to_char(sysdate, 'YYYY/MM/DD'),
777: inv.dcs_level_id,
778: inv.dcs_sr_level_pk,
779: to_char(sysdate),
780: to_char(fnd_global.user_id),
781: to_char(sysdate),
782: to_char(fnd_global.user_id),
783: to_char(fnd_global.login_id)
784: from msd_curr_onhand_inventory_v inv
778: inv.dcs_sr_level_pk,
779: to_char(sysdate),
780: to_char(fnd_global.user_id),
781: to_char(sysdate),
782: to_char(fnd_global.user_id),
783: to_char(fnd_global.login_id)
784: from msd_curr_onhand_inventory_v inv
785: where inv.sr_instance_id = p_instance_id;
786:
779: to_char(sysdate),
780: to_char(fnd_global.user_id),
781: to_char(sysdate),
782: to_char(fnd_global.user_id),
783: to_char(fnd_global.login_id)
784: from msd_curr_onhand_inventory_v inv
785: where inv.sr_instance_id = p_instance_id;
786:
787: end if;
933: crec_data.dcs_level_id, crec_data.dcs_sr_level_value_pk, crec_data.dcs_level_value, crec_data.dcs_level_value_pk,
934: crec_data.attribute_54, crec_data.attribute_55, crec_data.attribute_56, crec_data.attribute_57,
935: crec_data.attribute_58, crec_data.attribute_59, crec_data.attribute_60,
936: p_process_status, p_error_message,
937: fnd_global.user_id, sysdate, sysdate, fnd_global.user_id, fnd_global.login_id);
938:
939: Exception
940: When others then
941: show_line(sqlerrm);
988: crec_data.attribute_46, crec_data.attribute_47, crec_data.attribute_48, crec_data.attribute_49,
989: crec_data.dcs_level_id, crec_data.dcs_sr_level_value_pk, crec_data.dcs_level_value, crec_data.dcs_level_value_pk,
990: crec_data.attribute_54, crec_data.attribute_55, crec_data.attribute_56, crec_data.attribute_57,
991: crec_data.attribute_58, crec_data.attribute_59, crec_data.attribute_60,
992: fnd_global.user_id, sysdate, sysdate, fnd_global.user_id,fnd_global.login_id,
993: p_new_refresh_num, p_new_refresh_num, 'I');
994:
995: Exception
996: When others then
2217: p_instance_id,
2218: p_cs_definition_id,
2219: p_cs_name,
2220: sysdate,
2221: fnd_global.user_id,
2222: sysdate,
2223: fnd_global.user_id,
2224: fnd_global.login_id,
2225: p_refresh_num
2219: p_cs_name,
2220: sysdate,
2221: fnd_global.user_id,
2222: sysdate,
2223: fnd_global.user_id,
2224: fnd_global.login_id,
2225: p_refresh_num
2226: );
2227:
2220: sysdate,
2221: fnd_global.user_id,
2222: sysdate,
2223: fnd_global.user_id,
2224: fnd_global.login_id,
2225: p_refresh_num
2226: );
2227:
2228: