DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_OPP_PVT dependencies on FND_ATTACHED_DOCUMENTS

Line 2442: FROM fnd_attached_documents

2438: --Code added for Enhancement convert lead to opportunity - Attachment
2439: --Enhancement related Bug#3913225 @ @ Callling the procedure Copy_Attachments--changes for ASN.B--Start--
2440: CURSOR C_Attachment_Exists(X_Sales_Lead_Id VARCHAR2) IS
2441: SELECT 'X'
2442: FROM fnd_attached_documents
2443: WHERE pk1_value=X_Sales_Lead_Id;
2444: l_val_exists VARCHAR2(1) default null;
2445: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
2446: --Enhancement related Bug#3913225 @ @ Changes for ASN.B--End

Line 3366: FND_ATTACHED_DOCUMENTS2_PKG.Copy_Attachments(

3362: CLOSE C_Attachment_Exists;
3363:
3364: IF l_val_exists IS NOT NULL THEN
3365: --Copy attachments procedure calling
3366: FND_ATTACHED_DOCUMENTS2_PKG.Copy_Attachments(
3367: x_from_entity_name => 'AS_LEAD_ATTCH',
3368: x_from_pk1_value => to_char(P_SALES_LEAD_ID),
3369: x_to_entity_name => 'AS_OPPORTUNITY_ATTCH',
3370: x_to_pk1_value => to_char(x_opportunity_id),