eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_SALES_LEAD_OPP_PVT dependencies on AS_SALES_LEADS

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 595: FROM as_sales_leads

591:
592: /*
593: CURSOR C_Get_Last_Update_Date (X_Sales_Lead_Id NUMBER) IS
594: SELECT last_update_date,channel_code
595: FROM as_sales_leads
596: WHERE sales_lead_id = X_Sales_Lead_Id;
597: */
598:
599: CURSOR C_Get_Sales_Lead (X_Sales_Lead_Id NUMBER) IS

Line 661: FROM as_sales_leads

657: ,offer_id
658: -- ,security_group_id
659: ,incumbent_partner_party_id
660: ,incumbent_partner_resource_id
661: FROM as_sales_leads
662: WHERE sales_lead_id = X_Sales_Lead_Id;
663:
664: CURSOR C_Get_Opportunity (x_Opportunity_Id NUMBER) IS
665: SELECT last_update_date

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 1071: AS_SALES_LEADS_PVT.Validate_Sales_Lead_Id (

1067: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling Validate_sales_lead_id');
1068: END IF;
1069:
1070: -- Validate sales lead id whther it is a valid ID.
1071: AS_SALES_LEADS_PVT.Validate_Sales_Lead_Id (
1072: P_Init_Msg_List => FND_API.G_FALSE
1073: ,P_Validation_mode => FND_API.G_MISS_CHAR
1074: ,P_Sales_Lead_Id => P_Sales_Lead_Id
1075: ,X_Return_Status => X_Return_Status

Line 1129: -- axavier commented this. This check is not required, as the as_sales_leads salesforce_id is not updated

1125: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Validate sales lead owner');
1126: END IF;
1127:
1128: /*
1129: -- axavier commented this. This check is not required, as the as_sales_leads salesforce_id is not updated
1130: OPEN C_Sales_Owner_Check (l_Sales_Lead_Rec.assign_to_salesforce_id,
1131: P_Opportunity_Id,'Y');
1132: FETCH C_Sales_Owner_Check INTO l_val_id;
1133:

Line 1445: -- AS_SALES_LEADS_PVT.Update_sales_lead(

1441: END IF;
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,

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 1689: FROM as_sales_leads

1685: ,offer_id
1686: -- ,security_group_id
1687: ,incumbent_partner_party_id
1688: ,incumbent_partner_resource_id
1689: FROM as_sales_leads
1690: WHERE sales_lead_id = X_Sales_Lead_Id;
1691:
1692: CURSOR C_Get_Opportunity (x_Opportunity_Id NUMBER) IS
1693: SELECT last_update_date

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 2009: AS_SALES_LEADS_PVT.Validate_Sales_Lead_Id (

2005: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling Validate_sales_lead_id');
2006: END IF;
2007:
2008: -- Validate sales lead id whther it is a valid ID.
2009: AS_SALES_LEADS_PVT.Validate_Sales_Lead_Id (
2010: P_Init_Msg_List => FND_API.G_FALSE
2011: ,P_Validation_mode => FND_API.G_MISS_CHAR
2012: ,P_Sales_Lead_Id => P_Sales_Lead_Id
2013: ,X_Return_Status => X_Return_Status

Line 2064: -- axavier commented this. This check is not required, as the as_sales_leads salesforce_id is not updated

2060: IF l_debug THEN
2061: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Validate sales lead owner');
2062: END IF;
2063: /*
2064: -- axavier commented this. This check is not required, as the as_sales_leads salesforce_id is not updated
2065:
2066: OPEN C_Sales_Owner_Check (l_Sales_Lead_Rec.assign_to_salesforce_id,
2067: P_Opportunity_Id,'Y');
2068: FETCH C_Sales_Owner_Check INTO l_val_id;

Line 2109: -- AS_SALES_LEADS_PVT.Update_sales_lead(

2105: l_header_rec.member_role := FND_API.G_MISS_CHAR;
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,

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 2327: FROM as_sales_leads

2323: ,prm_ind_classification_code
2324: -- the following 2 fields added for bug#3613374
2325: ,sales_methodology_id
2326: ,sales_stage_id
2327: FROM as_sales_leads
2328: WHERE sales_lead_id = X_Sales_Lead_Id;
2329:
2330: CURSOR C_Get_Sales_lead_lines (X_Sales_Lead_Id NUMBER) IS
2331: SELECT sales_lead_line_id

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 3201: -- AS_SALES_LEADS_PVT.Update_sales_lead(

3197: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'Calling 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,

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,