211: l_Instance_Query_Rec.Pa_Project_Task_Id:= P_Proj_Item_Inst_Attr_Rec.Task_Id;
212: l_Instance_Query_Rec.Instance_Usage_Code:= CSE_DATASTRUCTURES_PUB.G_IN_PROCESS;
213:
214: IF (l_debug = 'Y') THEN
215: CSE_DEBUG_PUB.ADD(l_Api_Name||' Before CSI_Item_Instance_Pub.Get_Item_Instance');
216: END IF;
217:
218: CSI_Item_Instance_Pub.Get_Item_Instances(
219: p_api_version =>l_api_version,
214: IF (l_debug = 'Y') THEN
215: CSE_DEBUG_PUB.ADD(l_Api_Name||' Before CSI_Item_Instance_Pub.Get_Item_Instance');
216: END IF;
217:
218: CSI_Item_Instance_Pub.Get_Item_Instances(
219: p_api_version =>l_api_version,
220: p_commit =>l_Commit,
221: p_init_msg_list =>l_Init_Msg_List,
222: p_validation_level =>l_Validation_Level,
335: CSE_DEBUG_PUB.ADD('Before update of serialized item instanace');
336: END IF;
337:
338:
339: CSI_Item_Instance_Pub.Update_Item_Instance(
340: p_api_version=> l_api_version,
341: p_commit => l_Commit,
342: p_validation_level=> l_Validation_Level,
343: p_init_msg_list =>l_Init_Msg_List,
399: IF (l_debug = 'Y') THEN
400: CSE_DEBUG_PUB.ADD('Before querying for the existence of destination record');
401: END IF;
402:
403: CSI_Item_Instance_Pub.Get_Item_Instances(
404: p_api_version => l_api_version,
405: p_commit => l_Commit,
406: p_init_msg_list => l_Init_Msg_List,
407: p_validation_level => l_Validation_Level,
459: IF (l_debug = 'Y') THEN
460: CSE_DEBUG_PUB.ADD('Before update of source instanace qty - step 5.3');
461: END IF;
462:
463: CSI_Item_Instance_Pub.Update_Item_Instance(
464: p_api_version => l_api_version,
465: p_commit => l_Commit,
466: p_validation_level => l_Validation_Level,
467: p_init_msg_list => l_Init_Msg_List,
559: IF (l_debug = 'Y') THEN
560: CSE_DEBUG_PUB.ADD('Before update of destination instanace');
561: END IF;
562:
563: CSI_Item_Instance_Pub.Update_Item_Instance(
564: p_api_version =>l_api_version,
565: p_commit =>l_Commit,
566: p_validation_level =>l_Validation_Level,
567: p_init_msg_list =>l_Init_Msg_List,
661: IF (l_debug = 'Y') THEN
662: CSE_DEBUG_PUB.ADD('Before creation of destination instanace');
663: END IF;
664:
665: CSI_Item_Instance_Pub.Create_Item_Instance(
666: p_api_version =>l_api_version,
667: p_commit =>l_Commit,
668: p_validation_level =>l_Validation_Level,
669: p_init_msg_list =>l_Init_Msg_List,