APPS.ASO_SALES_TEAM_PVT dependencies on ASO_QUOTE_HEADERS_ALL

Line 101: FROM ASO_QUOTE_HEADERS_ALL

97:
98:
99: CURSOR C_Get_Header_Info (l_qte_hdr NUMBER) IS
100: SELECT Quote_Header_Id, Quote_Number, Party_Id, Sold_To_Party_Site_Id, Cust_Party_Id
101: FROM ASO_QUOTE_HEADERS_ALL
102: WHERE Quote_Header_Id = l_qte_hdr;
103:
104: CURSOR C_Get_Out_Hdr_Info (l_qte_hdr NUMBER) IS
105: SELECT Quote_Header_Id, Last_Update_Date

Line 106: FROM ASO_QUOTE_HEADERS_ALL

102: WHERE Quote_Header_Id = l_qte_hdr;
103:
104: CURSOR C_Get_Out_Hdr_Info (l_qte_hdr NUMBER) IS
105: SELECT Quote_Header_Id, Last_Update_Date
106: FROM ASO_QUOTE_HEADERS_ALL
107: WHERE Quote_header_Id = l_qte_hdr;
108:
109: CURSOR C_Quote_Exists (l_qte_hdr NUMBER) IS
110: SELECT 'Y'

Line 111: FROM ASO_QUOTE_HEADERS_ALL

107: WHERE Quote_header_Id = l_qte_hdr;
108:
109: CURSOR C_Quote_Exists (l_qte_hdr NUMBER) IS
110: SELECT 'Y'
111: FROM ASO_QUOTE_HEADERS_ALL
112: WHERE Quote_Header_Id = l_qte_hdr;
113:
114: CURSOR C_Get_Update_Date(qte_hdr_id NUMBER) IS
115: SELECT Last_Update_Date

Line 116: FROM ASO_QUOTE_HEADERS_ALL

112: WHERE Quote_Header_Id = l_qte_hdr;
113:
114: CURSOR C_Get_Update_Date(qte_hdr_id NUMBER) IS
115: SELECT Last_Update_Date
116: FROM ASO_QUOTE_HEADERS_ALL
117: WHERE Quote_Header_Id = qte_hdr_id;
118:
119: CURSOR C_Team_Exists (l_qte_number NUMBER) IS
120: SELECT 'Y'

Line 736: UPDATE ASO_QUOTE_HEADERS_ALL

732: IF aso_debug_pub.g_debug_flag = 'Y' THEN
733: aso_debug_pub.add('nores:create:Assign_Sales_Team: Before primary salesagent insert in qte_hdr ',1,'N');
734: END IF;
735:
736: UPDATE ASO_QUOTE_HEADERS_ALL
737: SET Resource_Id = l_primary_salesagent,
738: Resource_Grp_Id = l_primary_res_grp,
739: last_update_date = sysdate,
740: last_updated_by = fnd_global.user_id,

Line 1568: FROM ASO_QUOTE_HEADERS_ALL

1564: IS
1565:
1566: CURSOR C_Get_Primary_Resource (l_qte_number NUMBER) IS
1567: SELECT Resource_Id, Resource_Grp_Id
1568: FROM ASO_QUOTE_HEADERS_ALL
1569: WHERE Quote_Number = l_qte_number
1570: AND Max_Version_Flag = 'Y';
1571:
1572: CURSOR C_Primary_Res_Kept (l_res NUMBER, l_qte_num NUMBER) IS

Line 1879: UPDATE ASO_QUOTE_HEADERS_ALL

1875: END IF;
1876: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1877: aso_debug_pub.add('Assign_Sales_Team: Update primary salesagent in Hdr ',1,'N');
1878: END IF;
1879: UPDATE ASO_QUOTE_HEADERS_ALL
1880: SET Resource_Id = l_primary_salesagent,
1881: Resource_Grp_Id = l_primary_res_grp,
1882: last_update_date = sysdate,
1883: last_updated_by = fnd_global.user_id,

Line 2457: UPDATE ASO_QUOTE_HEADERS_ALL

2453:
2454: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2455: aso_debug_pub.add('Opp_Qte_PS: Update primary salesagent in Hdr ',1,'N');
2456: END IF;
2457: UPDATE ASO_QUOTE_HEADERS_ALL
2458: SET Resource_Id = l_primary_salesagent,
2459: Resource_Grp_Id = l_primary_res_grp,
2460: last_update_date = sysdate,
2461: last_updated_by = fnd_global.user_id,