[Home] [Help]
187:
188: -- Setting MOAC to pick lines data from other org
189: select org_id into l_tmpl_org_id from aso_quote_headers_all
190: where quote_header_id=p_template_id_tbl(i);
191: mo_global.set_policy_context('S', l_tmpl_org_id);
192: end if;
193: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows_sort(p_template_id_tbl(i));
194: -- ER 9433340
195: if l_tmpl_org_id=l_qte_header_rec.org_id then -- same org id
217: lp_qte_line_tbl(l_template_line_count) := l_qte_line_tbl(j);
218: -- Updating the lines table with new organization id in case operating unit is different
219: if l_prof_temp_filter<>'Q' then
220: if l_qte_header_rec.org_id<>l_tmpl_org_id then
221: mo_global.set_policy_context('S', l_qte_header_rec.org_id);
222: end if;
223: l_qte_organization_id:=oe_sys_parameters.value(param_name => 'MASTER_ORGANIZATION_ID',p_org_id => l_qte_header_rec.org_id);
224: lp_qte_line_tbl(l_template_line_count).organization_id:=l_qte_organization_id;
225: lp_qte_line_tbl(l_template_line_count).org_id:=l_qte_header_rec.org_id;
498: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Update_Quote', 1, 'Y');
499:
500: END IF;
501:
502: --mo_global.set_policy_context('S', l_qte_header_rec.org_id);
503: ASO_QUOTE_PUB.Update_Quote(
504: P_Api_Version_Number => 1.0,
505: P_Init_Msg_List => FND_API.G_FALSE,
506: P_Commit => FND_API.G_FALSE,
530: X_Msg_Count => x_msg_count,
531: X_Msg_Data => x_msg_data
532: );
533:
534: --mo_global.set_policy_context('M', null);
535:
536: IF aso_debug_pub.g_debug_flag = 'Y' THEN
537: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: after Update_Quote', 1, 'Y');
538: END IF;