DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_OPP_PVT dependencies on AS_SALES_LEADS_PUB

Line 38: P_SALES_LEAD_rec IN AS_SALES_LEADS_PUB.SALES_LEAD_rec_type,

34: P_Admin_Group_Id IN NUMBER := FND_API.G_MISS_NUM,
35: P_identity_salesforce_id IN NUMBER := NULL,
36: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
37: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
38: P_SALES_LEAD_rec IN AS_SALES_LEADS_PUB.SALES_LEAD_rec_type,
39: X_Return_Status OUT NOCOPY VARCHAR2,
40: X_Msg_Count OUT NOCOPY NUMBER,
41: X_Msg_Data OUT NOCOPY VARCHAR2,
42: X_OPPORTUNITY_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.HEADER_TBL_TYPE,

Line 253: l_SALES_LEAD_rec AS_SALES_LEADS_PUB.SALES_LEAD_REC_type;

249: l_api_version_number CONSTANT NUMBER := 2.0;
250: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
251: l_header_rec AS_OPPORTUNITY_PUB.HEADER_REC_TYPE;
252: l_line_rec AS_OPPORTUNITY_PUB.LINE_REC_TYPE;
253: l_SALES_LEAD_rec AS_SALES_LEADS_PUB.SALES_LEAD_REC_type;
254: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
255: l_cnt NUMBER := 0;
256: l_cnt_line NUMBER := 0;
257: l_validation_mode VARCHAR2(30) := AS_UTILITY_PVT.G_CREATE;

Line 562: P_SALES_LEAD_LINE_TBL IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_TBL_TYPE

558: P_identity_salesgroup_id IN NUMBER := FND_API.G_MISS_NUM,
559: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
560: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
561: P_SALES_LEAD_ID IN NUMBER,
562: P_SALES_LEAD_LINE_TBL IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_TBL_TYPE
563: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_TBL,
564: P_OPPORTUNITY_ID IN NUMBER,
565: X_Return_Status OUT NOCOPY VARCHAR2,
566: X_Msg_Count OUT NOCOPY NUMBER,

Line 563: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_TBL,

559: P_Sales_Lead_Profile_Tbl IN AS_UTILITY_PUB.Profile_Tbl_Type
560: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
561: P_SALES_LEAD_ID IN NUMBER,
562: P_SALES_LEAD_LINE_TBL IN AS_SALES_LEADS_PUB.SALES_LEAD_LINE_TBL_TYPE
563: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_LINE_TBL,
564: P_OPPORTUNITY_ID IN NUMBER,
565: X_Return_Status OUT NOCOPY VARCHAR2,
566: X_Msg_Count OUT NOCOPY NUMBER,
567: X_Msg_Data OUT NOCOPY VARCHAR2

Line 807: l_Sales_Lead_Rec AS_SALES_LEADS_PUB.Sales_Lead_Rec_Type;

803:
804: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Lead_To_Opportunity';
805: l_api_version_number CONSTANT NUMBER := 2.0;
806: l_Identity_Sales_Member_Rec AS_SALES_MEMBER_PUB.Sales_Member_Rec_Type;
807: l_Sales_Lead_Rec AS_SALES_LEADS_PUB.Sales_Lead_Rec_Type;
808: l_sales_lead_line_tbl AS_SALES_LEADS_PUB.Sales_Lead_Line_Tbl_Type;
809: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;
810: l_line_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;
811: l_line_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_Type;

Line 808: l_sales_lead_line_tbl AS_SALES_LEADS_PUB.Sales_Lead_Line_Tbl_Type;

804: l_api_name CONSTANT VARCHAR2(30) := 'Copy_Lead_To_Opportunity';
805: l_api_version_number CONSTANT NUMBER := 2.0;
806: l_Identity_Sales_Member_Rec AS_SALES_MEMBER_PUB.Sales_Member_Rec_Type;
807: l_Sales_Lead_Rec AS_SALES_LEADS_PUB.Sales_Lead_Rec_Type;
808: l_sales_lead_line_tbl AS_SALES_LEADS_PUB.Sales_Lead_Line_Tbl_Type;
809: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;
810: l_line_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;
811: l_line_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_Type;
812: l_contact_tbl AS_OPPORTUNITY_PUB.Contact_Tbl_Type;

Line 1446: AS_SALES_LEADS_PUB.Update_sales_lead(

1442: */
1443: -- Update Sales Leads for Status Code and Sales lead owner IF needed
1444: -- ffang 030503, bug 2826512, call PUB instead of PVT
1445: -- AS_SALES_LEADS_PVT.Update_sales_lead(
1446: AS_SALES_LEADS_PUB.Update_sales_lead(
1447: P_Api_Version_Number => l_api_version_number,
1448: P_Init_Msg_List => FND_API.G_FALSE,
1449: P_Commit => FND_API.G_FALSE,
1450: P_Validation_Level => P_Validation_Level,

Line 1748: l_Sales_Lead_Rec AS_SALES_LEADS_PUB.Sales_Lead_Rec_Type;

1744:
1745: l_api_name CONSTANT VARCHAR2(30) := 'Link_Lead_To_Opportunity';
1746: l_api_version_number CONSTANT NUMBER := 2.0;
1747: l_Identity_Sales_Member_Rec AS_SALES_MEMBER_PUB.Sales_Member_Rec_Type;
1748: l_Sales_Lead_Rec AS_SALES_LEADS_PUB.Sales_Lead_Rec_Type;
1749: -- l_sales_lead_line_tbl AS_SALES_LEADS_PUB.Sales_Lead_Line_Tbl_Type;
1750: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;
1751: -- l_line_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;
1752: -- l_line_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_Type;

Line 1749: -- l_sales_lead_line_tbl AS_SALES_LEADS_PUB.Sales_Lead_Line_Tbl_Type;

1745: l_api_name CONSTANT VARCHAR2(30) := 'Link_Lead_To_Opportunity';
1746: l_api_version_number CONSTANT NUMBER := 2.0;
1747: l_Identity_Sales_Member_Rec AS_SALES_MEMBER_PUB.Sales_Member_Rec_Type;
1748: l_Sales_Lead_Rec AS_SALES_LEADS_PUB.Sales_Lead_Rec_Type;
1749: -- l_sales_lead_line_tbl AS_SALES_LEADS_PUB.Sales_Lead_Line_Tbl_Type;
1750: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;
1751: -- l_line_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;
1752: -- l_line_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_Type;
1753: -- l_contact_tbl AS_OPPORTUNITY_PUB.Contact_Tbl_Type;

Line 2110: AS_SALES_LEADS_PUB.Update_sales_lead(

2106:
2107: -- Update Sales Leads for Status Code and Sales lead owner IF needed
2108: -- ffang 030503, bug 2826512, call PUB instead of PVT
2109: -- AS_SALES_LEADS_PVT.Update_sales_lead(
2110: AS_SALES_LEADS_PUB.Update_sales_lead(
2111: P_Api_Version_Number => l_api_version_number,
2112: P_Init_Msg_List => FND_API.G_FALSE,
2113: P_Commit => FND_API.G_FALSE,
2114: P_Validation_Level => P_Validation_Level,

Line 2478: l_sales_lead_rec AS_SALES_LEADS_PUB.Sales_Lead_Rec_Type;

2474:
2475: l_api_name CONSTANT VARCHAR2(30) := 'Create_Opp_For_Lead';
2476: l_api_version_number CONSTANT NUMBER := 2.0;
2477: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
2478: l_sales_lead_rec AS_SALES_LEADS_PUB.Sales_Lead_Rec_Type;
2479: -- ffang 020301
2480: l_sl_rec AS_SALES_LEADS_PUB.Sales_Lead_Rec_Type
2481: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC;
2482: l_val VARCHAR2(1) default null;

Line 2480: l_sl_rec AS_SALES_LEADS_PUB.Sales_Lead_Rec_Type

2476: l_api_version_number CONSTANT NUMBER := 2.0;
2477: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
2478: l_sales_lead_rec AS_SALES_LEADS_PUB.Sales_Lead_Rec_Type;
2479: -- ffang 020301
2480: l_sl_rec AS_SALES_LEADS_PUB.Sales_Lead_Rec_Type
2481: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC;
2482: l_val VARCHAR2(1) default null;
2483: -- end ffang 020301
2484: l_sales_lead_line_tbl AS_SALES_LEADS_PUB.Sales_Lead_Line_Tbl_Type;

Line 2481: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC;

2477: l_identity_sales_member_rec AS_SALES_MEMBER_PUB.Sales_member_rec_Type;
2478: l_sales_lead_rec AS_SALES_LEADS_PUB.Sales_Lead_Rec_Type;
2479: -- ffang 020301
2480: l_sl_rec AS_SALES_LEADS_PUB.Sales_Lead_Rec_Type
2481: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC;
2482: l_val VARCHAR2(1) default null;
2483: -- end ffang 020301
2484: l_sales_lead_line_tbl AS_SALES_LEADS_PUB.Sales_Lead_Line_Tbl_Type;
2485: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;

Line 2484: l_sales_lead_line_tbl AS_SALES_LEADS_PUB.Sales_Lead_Line_Tbl_Type;

2480: l_sl_rec AS_SALES_LEADS_PUB.Sales_Lead_Rec_Type
2481: := AS_SALES_LEADS_PUB.G_MISS_SALES_LEAD_REC;
2482: l_val VARCHAR2(1) default null;
2483: -- end ffang 020301
2484: l_sales_lead_line_tbl AS_SALES_LEADS_PUB.Sales_Lead_Line_Tbl_Type;
2485: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;
2486: l_line_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;
2487: l_line_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_Type;
2488: l_contact_tbl AS_OPPORTUNITY_PUB.Contact_Tbl_Type;

Line 2594: AS_SALES_LEADS_PUB.Get_Access_Profiles(

2590: IF l_debug THEN
2591: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling Get_Access_Profiles');
2592: END IF;
2593:
2594: AS_SALES_LEADS_PUB.Get_Access_Profiles(
2595: p_profile_tbl => p_sales_lead_profile_tbl,
2596: x_access_profile_rec => l_access_profile_rec);
2597:
2598: IF l_debug THEN

Line 3202: AS_SALES_LEADS_PUB.Update_sales_lead(

3198: END IF;
3199:
3200: -- ffang 030503, bug 2826512, call PUB instead of PVT
3201: -- AS_SALES_LEADS_PVT.Update_sales_lead(
3202: AS_SALES_LEADS_PUB.Update_sales_lead(
3203: P_Api_Version_Number => l_api_version_number,
3204: P_Init_Msg_List => FND_API.G_FALSE,
3205: P_Commit => FND_API.G_FALSE,
3206: P_Validation_Level => P_Validation_Level,