DBA Data[Home] [Help]

APPS.ASO_OPP_QTE_PUB dependencies on ASO_QUOTE_ACCESSES

Line 241: FROM AS_ACCESSES_ALL a, ASO_QUOTE_HEADERS_ALL B,aso_quote_accesses c

237: -- bug 5534788, fixed cursor so that freeze flag
238: -- is carried over from opp to qte correctly
239: Cursor C_opp_owner(p_lead_id NUMBER,p_qte_number Number) IS
240: SELECT a.freeze_flag,c.access_id
241: FROM AS_ACCESSES_ALL a, ASO_QUOTE_HEADERS_ALL B,aso_quote_accesses c
242: WHERE a.lead_id = p_lead_id
243: AND b.quote_number = p_qte_number
244: AND a.salesforce_id = c.resource_id
245: AND b.quote_number =c.quote_number;

Line 1361: ASO_QUOTE_ACCESSES_PKG.UPDATE_ROW(

1357: || lx_qte_header_rec.resource_id, 1, 'Y');
1358: END IF;
1359:
1360: FOR l_opp_rec IN C_opp_owner(P_OPP_QTE_IN_REC.OPPORTUNITY_ID,lx_qte_header_rec.quote_number) LOOP
1361: ASO_QUOTE_ACCESSES_PKG.UPDATE_ROW(
1362: P_ACCESS_ID => l_opp_rec.access_id,
1363: P_QUOTE_NUMBER => FND_API.G_MISS_NUM,
1364: P_RESOURCE_ID => FND_API.G_MISS_NUM,
1365: P_RESOURCE_GRP_ID => FND_API.G_MISS_NUM,