APPS.ASO_SALES_TEAM_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 378: FROM ASO_QUOTE_HEADERS_ALL

374:
375: CURSOR C_Get_Header_Info (l_qte_hdr NUMBER) IS
376: SELECT Quote_Header_Id, Quote_Number, Party_Id, Sold_To_Party_Site_Id, Cust_Party_Id,
377: cust_account_id -- Code change done for Bug 11076978
378: FROM ASO_QUOTE_HEADERS_ALL
379: WHERE Quote_Header_Id = l_qte_hdr;
380:
381: CURSOR C_Get_Out_Hdr_Info (l_qte_hdr NUMBER) IS
382: SELECT Quote_Header_Id, Last_Update_Date

Line 383: FROM ASO_QUOTE_HEADERS_ALL

379: WHERE Quote_Header_Id = l_qte_hdr;
380:
381: CURSOR C_Get_Out_Hdr_Info (l_qte_hdr NUMBER) IS
382: SELECT Quote_Header_Id, Last_Update_Date
383: FROM ASO_QUOTE_HEADERS_ALL
384: WHERE Quote_header_Id = l_qte_hdr;
385:
386: CURSOR C_Quote_Exists (l_qte_hdr NUMBER) IS
387: SELECT 'Y'

Line 388: FROM ASO_QUOTE_HEADERS_ALL

384: WHERE Quote_header_Id = l_qte_hdr;
385:
386: CURSOR C_Quote_Exists (l_qte_hdr NUMBER) IS
387: SELECT 'Y'
388: FROM ASO_QUOTE_HEADERS_ALL
389: WHERE Quote_Header_Id = l_qte_hdr;
390:
391: CURSOR C_Get_Update_Date(qte_hdr_id NUMBER) IS
392: SELECT Last_Update_Date

Line 393: FROM ASO_QUOTE_HEADERS_ALL

389: WHERE Quote_Header_Id = l_qte_hdr;
390:
391: CURSOR C_Get_Update_Date(qte_hdr_id NUMBER) IS
392: SELECT Last_Update_Date
393: FROM ASO_QUOTE_HEADERS_ALL
394: WHERE Quote_Header_Id = qte_hdr_id;
395:
396: CURSOR C_Team_Exists (l_qte_number NUMBER) IS
397: SELECT 'Y'

Line 1027: UPDATE ASO_QUOTE_HEADERS_ALL

1023: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1024: aso_debug_pub.add('nores:create:Assign_Sales_Team: Before primary salesagent insert in qte_hdr ',1,'N');
1025: END IF;
1026:
1027: UPDATE ASO_QUOTE_HEADERS_ALL
1028: SET Resource_Id = l_primary_salesagent,
1029: Resource_Grp_Id = l_primary_res_grp,
1030: last_update_date = sysdate,
1031: last_updated_by = fnd_global.user_id,

Line 2007: FROM ASO_QUOTE_HEADERS_ALL

2003: IS
2004:
2005: CURSOR C_Get_Primary_Resource (l_qte_number NUMBER) IS
2006: SELECT Resource_Id, Resource_Grp_Id
2007: FROM ASO_QUOTE_HEADERS_ALL
2008: WHERE Quote_Number = l_qte_number
2009: AND Max_Version_Flag = 'Y';
2010:
2011: CURSOR C_Primary_Res_Kept (l_res NUMBER, l_qte_num NUMBER) IS

Line 2318: UPDATE ASO_QUOTE_HEADERS_ALL

2314: END IF;
2315: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2316: aso_debug_pub.add('Assign_Sales_Team: Update primary salesagent in Hdr ',1,'N');
2317: END IF;
2318: UPDATE ASO_QUOTE_HEADERS_ALL
2319: SET Resource_Id = l_primary_salesagent,
2320: Resource_Grp_Id = l_primary_res_grp,
2321: last_update_date = sysdate,
2322: last_updated_by = fnd_global.user_id,

Line 2896: UPDATE ASO_QUOTE_HEADERS_ALL

2892:
2893: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2894: aso_debug_pub.add('Opp_Qte_PS: Update primary salesagent in Hdr ',1,'N');
2895: END IF;
2896: UPDATE ASO_QUOTE_HEADERS_ALL
2897: SET Resource_Id = l_primary_salesagent,
2898: Resource_Grp_Id = l_primary_res_grp,
2899: last_update_date = sysdate,
2900: last_updated_by = fnd_global.user_id,