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_OPPORTUNITY_PUB

Line 42: X_OPPORTUNITY_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.HEADER_TBL_TYPE,

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,
43: X_OPP_LINES_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.LINE_TBL_TYPE
44: )
45: IS
46: -- Bug 1558460

Line 43: X_OPP_LINES_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.LINE_TBL_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,
43: X_OPP_LINES_tbl OUT NOCOPY AS_OPPORTUNITY_PUB.LINE_TBL_TYPE
44: )
45: IS
46: -- Bug 1558460
47: -- solin, use customer_id to find opportunity. source_promotion_id is not

Line 251: l_header_rec AS_OPPORTUNITY_PUB.HEADER_REC_TYPE;

247:
248: l_api_name CONSTANT VARCHAR2(30) := 'Get_Potential_Opportunity';
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;

Line 252: l_line_rec AS_OPPORTUNITY_PUB.LINE_REC_TYPE;

248: l_api_name CONSTANT VARCHAR2(30) := 'Get_Potential_Opportunity';
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;

Line 809: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;

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;
813: l_contact_out_tbl AS_OPPORTUNITY_PUB.Contact_Out_Tbl_Type;

Line 810: l_line_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;

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;
813: l_contact_out_tbl AS_OPPORTUNITY_PUB.Contact_Out_Tbl_Type;
814: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;

Line 811: l_line_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_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;
813: l_contact_out_tbl AS_OPPORTUNITY_PUB.Contact_Out_Tbl_Type;
814: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
815: l_val VARCHAR2(1) default null;

Line 812: l_contact_tbl AS_OPPORTUNITY_PUB.Contact_Tbl_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;
813: l_contact_out_tbl AS_OPPORTUNITY_PUB.Contact_Out_Tbl_Type;
814: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
815: l_val VARCHAR2(1) default null;
816: --axavier l_val_id NUMBER;

Line 813: l_contact_out_tbl AS_OPPORTUNITY_PUB.Contact_Out_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;
813: l_contact_out_tbl AS_OPPORTUNITY_PUB.Contact_Out_Tbl_Type;
814: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
815: l_val VARCHAR2(1) default null;
816: --axavier l_val_id NUMBER;
817: l_lead_line_id NUMBER;

Line 1273: AS_OPPORTUNITY_PUB.Create_Opp_Lines (

1269: IF l_line_tbl.count > 0
1270: THEN
1271: -- ffang 030503, bug 2826512, call PUB instead of PVT
1272: -- AS_OPP_line_PVT.Create_opp_lines (
1273: AS_OPPORTUNITY_PUB.Create_Opp_Lines (
1274: p_api_version_number => 2.0,
1275: p_init_msg_list => FND_API.G_FALSE,
1276: p_commit => FND_API.G_FALSE, -- ffang020100
1277: -- p_commit => FND_API.G_TRUE,

Line 1416: AS_OPPORTUNITY_PUB.Create_Contacts (

1412: END IF;
1413:
1414: -- ffang 030503, bug 2826512, call PUB instead of PVT
1415: -- AS_OPP_CONTACT_PVT.Create_opp_contacts (
1416: AS_OPPORTUNITY_PUB.Create_Contacts (
1417: p_api_version_number => 2.0,
1418: p_init_msg_list => FND_API.G_FALSE,
1419: p_commit => FND_API.G_FALSE,
1420: p_validation_level => p_validation_level,

Line 1750: l_header_rec AS_OPPORTUNITY_PUB.Header_Rec_Type;

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;
1754: -- l_contact_out_tbl AS_OPPORTUNITY_PUB.Contact_Out_Tbl_Type;

Line 1751: -- l_line_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;

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;
1754: -- l_contact_out_tbl AS_OPPORTUNITY_PUB.Contact_Out_Tbl_Type;
1755: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;

Line 1752: -- l_line_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_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;
1754: -- l_contact_out_tbl AS_OPPORTUNITY_PUB.Contact_Out_Tbl_Type;
1755: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
1756: l_val VARCHAR2(1) default null;

Line 1753: -- l_contact_tbl AS_OPPORTUNITY_PUB.Contact_Tbl_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;
1754: -- l_contact_out_tbl AS_OPPORTUNITY_PUB.Contact_Out_Tbl_Type;
1755: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
1756: l_val VARCHAR2(1) default null;
1757: --axavier l_val_id NUMBER;

Line 1754: -- l_contact_out_tbl AS_OPPORTUNITY_PUB.Contact_Out_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;
1754: -- l_contact_out_tbl AS_OPPORTUNITY_PUB.Contact_Out_Tbl_Type;
1755: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
1756: l_val VARCHAR2(1) default null;
1757: --axavier l_val_id NUMBER;
1758: -- l_lead_line_id NUMBER;

Line 2485: l_header_rec AS_OPPORTUNITY_PUB.Header_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;
2489: l_contact_out_tbl AS_OPPORTUNITY_PUB.Contact_Out_Tbl_Type;

Line 2486: l_line_tbl AS_OPPORTUNITY_PUB.Line_Tbl_Type;

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;
2489: l_contact_out_tbl AS_OPPORTUNITY_PUB.Contact_Out_Tbl_Type;
2490: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;

Line 2487: l_line_out_tbl AS_OPPORTUNITY_PUB.Line_Out_Tbl_Type;

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;
2489: l_contact_out_tbl AS_OPPORTUNITY_PUB.Contact_Out_Tbl_Type;
2490: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
2491: l_lead_line_id NUMBER;

Line 2488: l_contact_tbl AS_OPPORTUNITY_PUB.Contact_Tbl_Type;

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;
2489: l_contact_out_tbl AS_OPPORTUNITY_PUB.Contact_Out_Tbl_Type;
2490: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
2491: l_lead_line_id NUMBER;
2492: l_lead_id NUMBER;

Line 2489: l_contact_out_tbl AS_OPPORTUNITY_PUB.Contact_Out_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;
2489: l_contact_out_tbl AS_OPPORTUNITY_PUB.Contact_Out_Tbl_Type;
2490: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
2491: l_lead_line_id NUMBER;
2492: l_lead_id NUMBER;
2493: l_last_update_date DATE;

Line 2887: AS_OPPORTUNITY_PUB.Create_Opp_Header (

2883: AS_UTILITY_PVT.Debug_Message(l_module, NULL, 'P_Ident_SF_Id : ' || P_Identity_Salesforce_Id);
2884: END IF;
2885: -- ffang 030503, bug 2826512, call PUB instead of PVT
2886: -- AS_OPP_HEADER_PVT.Create_opp_header (
2887: AS_OPPORTUNITY_PUB.Create_Opp_Header (
2888: p_api_version_number => 2.0,
2889: p_init_msg_list => FND_API.G_FALSE,
2890: p_commit => FND_API.G_FALSE,
2891: p_validation_level => p_validation_level,

Line 3015: AS_OPPORTUNITY_PUB.Create_Opp_Lines (

3011: END IF;
3012:
3013: -- ffang 030503, bug 2826512, call PUB instead of PVT
3014: -- AS_OPP_line_PVT.Create_opp_lines (
3015: AS_OPPORTUNITY_PUB.Create_Opp_Lines (
3016: p_api_version_number => 2.0,
3017: p_init_msg_list => FND_API.G_FALSE,
3018: p_commit => FND_API.G_FALSE,
3019: p_validation_level => p_validation_level,

Line 3143: AS_OPPORTUNITY_PUB.Create_Contacts (

3139: END IF;
3140:
3141: -- ffang 030503, bug 2826512, call PUB instead of PVT
3142: -- AS_OPP_CONTACT_PVT.Create_opp_contacts (
3143: AS_OPPORTUNITY_PUB.Create_Contacts (
3144: p_api_version_number => 2.0,
3145: p_init_msg_list => FND_API.G_FALSE,
3146: p_commit => FND_API.G_FALSE,
3147: p_validation_level => p_validation_level,