DBA Data[Home] [Help]

APPS.AST_UWQ_WRAPPER_PKG dependencies on AS_SALES_LEADS_PUB

Line 1072: l_sales_lead_line_tbl AS_SALES_LEADS_PUB.sales_lead_line_tbl_type;

1068: l_source_promotion_id NUMBER;
1069: -- End Mod.
1070:
1071: l_sales_lead_profile_tbl AS_UTILITY_PUB.profile_tbl_type;
1072: l_sales_lead_line_tbl AS_SALES_LEADS_PUB.sales_lead_line_tbl_type;
1073: l_sales_lead_rec AS_SALES_LEADS_PUB.sales_lead_rec_type;
1074: l_sales_lead_contact_tbl AS_SALES_LEADS_PUB.sales_lead_contact_tbl_type;
1075: l_sales_lead_contact_rec AS_SALES_LEADS_PUB.sales_lead_contact_rec_type;
1076: l_sales_lead_line_out_tbl AS_SALES_LEADS_PUB.sales_lead_line_out_tbl_type;

Line 1073: l_sales_lead_rec AS_SALES_LEADS_PUB.sales_lead_rec_type;

1069: -- End Mod.
1070:
1071: l_sales_lead_profile_tbl AS_UTILITY_PUB.profile_tbl_type;
1072: l_sales_lead_line_tbl AS_SALES_LEADS_PUB.sales_lead_line_tbl_type;
1073: l_sales_lead_rec AS_SALES_LEADS_PUB.sales_lead_rec_type;
1074: l_sales_lead_contact_tbl AS_SALES_LEADS_PUB.sales_lead_contact_tbl_type;
1075: l_sales_lead_contact_rec AS_SALES_LEADS_PUB.sales_lead_contact_rec_type;
1076: l_sales_lead_line_out_tbl AS_SALES_LEADS_PUB.sales_lead_line_out_tbl_type;
1077: l_sales_lead_contact_out_tbl AS_SALES_LEADS_PUB.sales_lead_cnt_out_tbl_type;

Line 1074: l_sales_lead_contact_tbl AS_SALES_LEADS_PUB.sales_lead_contact_tbl_type;

1070:
1071: l_sales_lead_profile_tbl AS_UTILITY_PUB.profile_tbl_type;
1072: l_sales_lead_line_tbl AS_SALES_LEADS_PUB.sales_lead_line_tbl_type;
1073: l_sales_lead_rec AS_SALES_LEADS_PUB.sales_lead_rec_type;
1074: l_sales_lead_contact_tbl AS_SALES_LEADS_PUB.sales_lead_contact_tbl_type;
1075: l_sales_lead_contact_rec AS_SALES_LEADS_PUB.sales_lead_contact_rec_type;
1076: l_sales_lead_line_out_tbl AS_SALES_LEADS_PUB.sales_lead_line_out_tbl_type;
1077: l_sales_lead_contact_out_tbl AS_SALES_LEADS_PUB.sales_lead_cnt_out_tbl_type;
1078: G_Access_Rec_Type AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;

Line 1075: l_sales_lead_contact_rec AS_SALES_LEADS_PUB.sales_lead_contact_rec_type;

1071: l_sales_lead_profile_tbl AS_UTILITY_PUB.profile_tbl_type;
1072: l_sales_lead_line_tbl AS_SALES_LEADS_PUB.sales_lead_line_tbl_type;
1073: l_sales_lead_rec AS_SALES_LEADS_PUB.sales_lead_rec_type;
1074: l_sales_lead_contact_tbl AS_SALES_LEADS_PUB.sales_lead_contact_tbl_type;
1075: l_sales_lead_contact_rec AS_SALES_LEADS_PUB.sales_lead_contact_rec_type;
1076: l_sales_lead_line_out_tbl AS_SALES_LEADS_PUB.sales_lead_line_out_tbl_type;
1077: l_sales_lead_contact_out_tbl AS_SALES_LEADS_PUB.sales_lead_cnt_out_tbl_type;
1078: G_Access_Rec_Type AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
1079: l_salesteam_rec as_access_pub.sales_team_rec_type:=as_api_records_pkg.get_p_sales_team_rec;

Line 1076: l_sales_lead_line_out_tbl AS_SALES_LEADS_PUB.sales_lead_line_out_tbl_type;

1072: l_sales_lead_line_tbl AS_SALES_LEADS_PUB.sales_lead_line_tbl_type;
1073: l_sales_lead_rec AS_SALES_LEADS_PUB.sales_lead_rec_type;
1074: l_sales_lead_contact_tbl AS_SALES_LEADS_PUB.sales_lead_contact_tbl_type;
1075: l_sales_lead_contact_rec AS_SALES_LEADS_PUB.sales_lead_contact_rec_type;
1076: l_sales_lead_line_out_tbl AS_SALES_LEADS_PUB.sales_lead_line_out_tbl_type;
1077: l_sales_lead_contact_out_tbl AS_SALES_LEADS_PUB.sales_lead_cnt_out_tbl_type;
1078: G_Access_Rec_Type AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
1079: l_salesteam_rec as_access_pub.sales_team_rec_type:=as_api_records_pkg.get_p_sales_team_rec;
1080:

Line 1077: l_sales_lead_contact_out_tbl AS_SALES_LEADS_PUB.sales_lead_cnt_out_tbl_type;

1073: l_sales_lead_rec AS_SALES_LEADS_PUB.sales_lead_rec_type;
1074: l_sales_lead_contact_tbl AS_SALES_LEADS_PUB.sales_lead_contact_tbl_type;
1075: l_sales_lead_contact_rec AS_SALES_LEADS_PUB.sales_lead_contact_rec_type;
1076: l_sales_lead_line_out_tbl AS_SALES_LEADS_PUB.sales_lead_line_out_tbl_type;
1077: l_sales_lead_contact_out_tbl AS_SALES_LEADS_PUB.sales_lead_cnt_out_tbl_type;
1078: G_Access_Rec_Type AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
1079: l_salesteam_rec as_access_pub.sales_team_rec_type:=as_api_records_pkg.get_p_sales_team_rec;
1080:
1081: -- Added by Sumita on 10.14.2004 for bug # 3812865

Line 1269: AS_SALES_LEADS_PUB.create_sales_lead(

1265: l_sales_lead_profile_tbl(4).profile_value := G_access_rec_type.mgr_update_profile_value;
1266: l_sales_lead_profile_tbl(5).profile_name := 'AS_ADMIN_UPDATE';
1267: l_sales_lead_profile_tbl(5).profile_value := G_access_rec_type.admin_update_profile_value;
1268:
1269: AS_SALES_LEADS_PUB.create_sales_lead(
1270: P_API_VERSION_NUMBER => l_api_version
1271: ,P_INIT_MSG_LIST => l_init_msg_list
1272: ,P_COMMIT => l_commit
1273: ,P_VALIDATION_LEVEL => l_validation_level

Line 1345: AS_SALES_LEADS_PUB.Lead_Process_After_Create(

1341: **/
1342: /** Adding this to fix bug 2918647. We should call Lead_Process_After_Create
1343: after create_sales_lead.
1344: **/
1345: AS_SALES_LEADS_PUB.Lead_Process_After_Create(
1346: P_Api_Version_Number => l_api_version
1347: ,P_Init_Msg_List => l_init_msg_list
1348: ,P_Commit => l_commit
1349: ,P_Validation_Level => l_validation_level

Line 1409: l_sales_lead_line_tbl AS_SALES_LEADS_PUB.sales_lead_line_tbl_type;

1405: l_commit VARCHAR2(5) := 'T';
1406: l_channel_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_CHANNEL');
1407: l_vehicle_response_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_VEHICLE_RESPONSE_CODE');
1408: l_sales_lead_profile_tbl AS_UTILITY_PUB.profile_tbl_type;
1409: l_sales_lead_line_tbl AS_SALES_LEADS_PUB.sales_lead_line_tbl_type;
1410: l_sales_lead_rec AS_SALES_LEADS_PUB.sales_lead_rec_type := AS_API_RECORDS_PKG.get_p_sales_lead_rec;
1411: l_sales_lead_contact_tbl AS_SALES_LEADS_PUB.sales_lead_contact_tbl_type;
1412: l_sales_lead_line_out_tbl AS_SALES_LEADS_PUB.sales_lead_line_out_tbl_type;
1413:

Line 1410: l_sales_lead_rec AS_SALES_LEADS_PUB.sales_lead_rec_type := AS_API_RECORDS_PKG.get_p_sales_lead_rec;

1406: l_channel_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_CHANNEL');
1407: l_vehicle_response_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_VEHICLE_RESPONSE_CODE');
1408: l_sales_lead_profile_tbl AS_UTILITY_PUB.profile_tbl_type;
1409: l_sales_lead_line_tbl AS_SALES_LEADS_PUB.sales_lead_line_tbl_type;
1410: l_sales_lead_rec AS_SALES_LEADS_PUB.sales_lead_rec_type := AS_API_RECORDS_PKG.get_p_sales_lead_rec;
1411: l_sales_lead_contact_tbl AS_SALES_LEADS_PUB.sales_lead_contact_tbl_type;
1412: l_sales_lead_line_out_tbl AS_SALES_LEADS_PUB.sales_lead_line_out_tbl_type;
1413:
1414: G_Access_Rec_Type AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;

Line 1411: l_sales_lead_contact_tbl AS_SALES_LEADS_PUB.sales_lead_contact_tbl_type;

1407: l_vehicle_response_code VARCHAR2(30) := FND_PROFILE.VALUE('AS_DEFAULT_LEAD_VEHICLE_RESPONSE_CODE');
1408: l_sales_lead_profile_tbl AS_UTILITY_PUB.profile_tbl_type;
1409: l_sales_lead_line_tbl AS_SALES_LEADS_PUB.sales_lead_line_tbl_type;
1410: l_sales_lead_rec AS_SALES_LEADS_PUB.sales_lead_rec_type := AS_API_RECORDS_PKG.get_p_sales_lead_rec;
1411: l_sales_lead_contact_tbl AS_SALES_LEADS_PUB.sales_lead_contact_tbl_type;
1412: l_sales_lead_line_out_tbl AS_SALES_LEADS_PUB.sales_lead_line_out_tbl_type;
1413:
1414: G_Access_Rec_Type AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
1415:

Line 1412: l_sales_lead_line_out_tbl AS_SALES_LEADS_PUB.sales_lead_line_out_tbl_type;

1408: l_sales_lead_profile_tbl AS_UTILITY_PUB.profile_tbl_type;
1409: l_sales_lead_line_tbl AS_SALES_LEADS_PUB.sales_lead_line_tbl_type;
1410: l_sales_lead_rec AS_SALES_LEADS_PUB.sales_lead_rec_type := AS_API_RECORDS_PKG.get_p_sales_lead_rec;
1411: l_sales_lead_contact_tbl AS_SALES_LEADS_PUB.sales_lead_contact_tbl_type;
1412: l_sales_lead_line_out_tbl AS_SALES_LEADS_PUB.sales_lead_line_out_tbl_type;
1413:
1414: G_Access_Rec_Type AS_ACCESS_PUB.ACCESS_PROFILE_REC_TYPE;
1415:
1416: l_count NUMBER;

Line 1481: AS_SALES_LEADS_PUB.update_sales_lead(

1477: l_sales_lead_profile_tbl(4).profile_value := G_access_rec_type.mgr_update_profile_value;
1478: l_sales_lead_profile_tbl(5).profile_name := 'AS_ADMIN_UPDATE';
1479: l_sales_lead_profile_tbl(5).profile_value := G_access_rec_type.admin_update_profile_value;
1480:
1481: AS_SALES_LEADS_PUB.update_sales_lead(
1482: P_API_VERSION_NUMBER => l_api_version
1483: ,P_INIT_MSG_LIST => l_init_msg_list
1484: ,P_COMMIT => l_commit
1485: ,P_VALIDATION_LEVEL => l_validation_level

Line 1505: AS_SALES_LEADS_PUB.Lead_Process_After_Update(

1501:
1502: /** Adding this to fix bug 2918647. We should call Lead_Process_After_Update
1503: after update_sales_lead.
1504: **/
1505: AS_SALES_LEADS_PUB.Lead_Process_After_Update(
1506: P_Api_Version_Number => l_api_version
1507: ,P_Init_Msg_List => l_init_msg_list
1508: ,P_Commit => l_commit
1509: ,P_Validation_Level => l_validation_level

Line 1593: AS_SALES_LEADS_PUB.Create_Opportunity_For_Lead(

1589: l_sales_lead_profile_tbl(4).profile_value := G_access_rec_type.mgr_update_profile_value;
1590: l_sales_lead_profile_tbl(5).profile_name := 'AS_ADMIN_UPDATE';
1591: l_sales_lead_profile_tbl(5).profile_value := G_access_rec_type.admin_update_profile_value;
1592:
1593: AS_SALES_LEADS_PUB.Create_Opportunity_For_Lead(
1594: p_api_version_NUMBER => l_api_version
1595: ,p_init_msg_list => l_init_msg_list
1596: ,p_commit => l_commit
1597: ,p_validation_level => l_validation_level

Line 1745: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_rec_type := AS_API_RECORDS_PKG.Get_P_Sales_Lead_Rec;

1741: l_commit VARCHAR2(10) := 'F';
1742: l_return_status VARCHAR2(10);
1743: l_msg_data VARCHAR2(2000);
1744: l_Sales_Lead_Profile_Tbl AS_UTILITY_PUB.Profile_Tbl_Type;
1745: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_rec_type := AS_API_RECORDS_PKG.Get_P_Sales_Lead_Rec;
1746: l_header_tbl AS_OPPORTUNITY_PUB.HEADER_TBL_TYPE := AS_API_RECORDS_PKG.Get_P_Header_Tbl;
1747: l_purchase_tbl AS_OPPORTUNITY_PUB.LINE_TBL_TYPE := AS_API_RECORDS_PKG.Get_P_Line_Tbl;
1748:
1749: l_validation_level CONSTANT NUMBER := NVL(FND_PROFILE.VALUE('AST_SL_DEBUG_VALID_LEVEL'),0);

Line 1781: /** 11.5.7 should use AS_SALES_LEADS_PUB.Get_Potential_Opportunity **/

1777: l_sales_lead_profile_tbl(4).profile_value := G_Access_Rec_Type.mgr_update_profile_value;
1778: l_sales_lead_profile_tbl(5).profile_name := 'AS_ADMIN_UPDATE';
1779: l_sales_lead_profile_tbl(5).profile_value := G_Access_Rec_Type.admin_update_profile_value;
1780:
1781: /** 11.5.7 should use AS_SALES_LEADS_PUB.Get_Potential_Opportunity **/
1782:
1783: AS_LINK_LEAD_OPP_PUB.Get_Potential_Opportunity(
1784: p_api_version_NUMBER => l_api_version
1785: ,p_init_msg_list => l_init_msg_list