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_LEAD_ROUTING_WF dependencies on AS_SALES_LEADS

Line 443: FROM AS_SALES_LEADS_LOG LOG

439: WHERE ACC.SALES_LEAD_ID = c_sales_lead_id
440: AND ACC.CREATED_BY_TAP_FLAG = 'Y'
441: AND NOT EXISTS (
442: SELECT 1
443: FROM AS_SALES_LEADS_LOG LOG
444: WHERE LOG.SALES_LEAD_ID = c_sales_lead_id
445: AND LOG.ASSIGN_TO_SALESFORCE_ID = ACC.SALESFORCE_ID
446: AND (LOG.ASSIGN_SALES_GROUP_ID = ACC.SALES_GROUP_ID
447: OR LOG.ASSIGN_SALES_GROUP_ID IS NULL AND ACC.SALES_GROUP_ID IS NULL))

Line 591: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type;

587: l_rs_id NUMBER := null;
588:
589: l_sales_lead_id NUMBER;
590: l_call_user_hook BOOLEAN;
591: l_sales_lead_rec AS_SALES_LEADS_PUB.SALES_LEAD_Rec_Type;
592: l_org_owner_id_tbl NUMBER_TABLE;
593: l_i NUMBER;
594: l_return_status VARCHAR2(15);
595: l_msg_count NUMBER;

Line 628: FROM AS_SALES_LEADS

624: REF_COMM_LTR_STATUS, REF_ORDER_NUMBER, REF_ORDER_AMT,
625: REF_COMM_AMT, LEAD_DATE, SOURCE_SYSTEM, COUNTRY,
626: TOTAL_AMOUNT, EXPIRATION_DATE, LEAD_ENGINE_RUN_DATE, LEAD_RANK_IND,
627: CURRENT_REROUTES
628: FROM AS_SALES_LEADS
629: WHERE SALES_LEAD_ID = c_sales_lead_id;
630:
631: CURSOR c_get_resource_avail(c_sales_lead_id NUMBER) IS
632: SELECT 'Y'

Line 909: FROM as_sales_leads

905:
906: CURSOR c_sales_lead(c_sales_lead_id NUMBER) IS
907: SELECT customer_id, address_id, reject_reason_code,
908: lead_rank_id, qualified_flag, NVL(accept_flag, 'N'), status_code
909: FROM as_sales_leads
910: WHERE Sales_lead_id = c_sales_lead_id;
911:
912: -- Get whether status is open or not for the lead
913: -- Get lead_rank_score and lead creation_date

Line 917: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk

913: -- Get lead_rank_score and lead creation_date
914: CURSOR c_get_open_status_flag(c_sales_lead_id NUMBER) IS
915: SELECT DECODE(sta.opp_open_status_flag, 'Y', 'Y', 'N', NULL),
916: rk.min_score, sl.creation_date
917: FROM as_statuses_b sta, as_sales_leads sl, as_sales_lead_ranks_b rk
918: WHERE sl.sales_lead_id = c_sales_lead_id
919: AND sl.status_code = sta.status_code
920: AND sl.lead_rank_id = rk.rank_id(+);
921: BEGIN

Line 962: AS_SALES_LEADS_LOG_PKG.Insert_Row(

958: l_qualified_flag, l_freeze_flag, l_status_code;
959: CLOSE c_sales_lead;
960:
961: -- Call API to create log entry
962: AS_SALES_LEADS_LOG_PKG.Insert_Row(
963: px_log_id => l_sales_lead_log_id ,
964: p_sales_lead_id => l_sales_lead_id,
965: p_created_by => fnd_global.user_id,
966: p_creation_date => SYSDATE,

Line 985: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(

981: p_category => NULL);
982:
983: -- Call table handler directly, not calling Update_Sales_Lead,
984: -- in case current user doesn't have update privilege.
985: AS_SALES_LEADS_PKG.Sales_Lead_Update_Row(
986: p_SALES_LEAD_ID => l_SALES_LEAD_ID,
987: p_LAST_UPDATE_DATE => SYSDATE,
988: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
989: p_CREATION_DATE => FND_API.G_MISS_DATE,

Line 1175: l_Assign_Id_tbl AS_SALES_LEADS_PUB.Assign_Id_Tbl_Type;

1171: l_sales_lead_id NUMBER;
1172: l_return_status VARCHAR2(15);
1173: l_msg_count NUMBER;
1174: l_msg_data VARCHAR2(2000);
1175: l_Assign_Id_tbl AS_SALES_LEADS_PUB.Assign_Id_Tbl_Type;
1176:
1177: BEGIN
1178:
1179: IF funcmode = 'RUN' THEN

Line 1186: -- AS_SALES_LEADS_PVT.Assign_Sales_Lead (

1182: itemtype => itemtype,
1183: itemkey => itemkey,
1184: aname => 'SALES_LEAD_ID' );
1185:
1186: -- AS_SALES_LEADS_PVT.Assign_Sales_Lead (
1187: AS_SALES_LEAD_ASSIGN_PVT.Assign_Sales_Lead (
1188: P_Api_Version_Number => 2.0,
1189: P_Init_Msg_List => FND_API.G_FALSE,
1190: p_commit => FND_API.G_FALSE,

Line 1254: FROM as_sales_leads

1250: result OUT NOCOPY VARCHAR2 )
1251: IS
1252: CURSOR c_workload (resource_id_in number) IS
1253: SELECT count(sales_lead_id)
1254: FROM as_sales_leads
1255: WHERE assign_to_salesforce_id = resource_id_in;
1256:
1257: l_resource_cnt NUMBER := 0;
1258: l_avail_resources available_resource_table;

Line 1311: FROM as_sales_leads_log

1307: l_sales_lead_id NUMBER;
1308:
1309: CURSOR c_checklog (resource_id_in number, sl_id_in number) IS
1310: SELECT count(log_id)
1311: FROM as_sales_leads_log
1312: WHERE assign_to_salesforce_id = resource_id_in
1313: and sales_lead_id = sl_id_in;
1314:
1315: BEGIN

Line 1402: l_sales_lead_rec AS_SALES_LEADS_PUB.sales_lead_rec_type;

1398: SELECT manager_id
1399: FROM jtf_rs_group_dtls_vl
1400: WHERE group_id = group_id_in;
1401:
1402: l_sales_lead_rec AS_SALES_LEADS_PUB.sales_lead_rec_type;
1403: l_sales_lead_profile_tbl AS_UTILITY_PUB.Profile_Tbl_Type
1404: := AS_UTILITY_PUB.G_MISS_PROFILE_TBL;
1405:
1406: l_api_version_number NUMBER := 2.0;

Line 1426: FROM as_sales_leads

1422: customer_id,
1423: address_id,
1424: assign_sales_group_id,
1425: sales_lead_id
1426: FROM as_sales_leads
1427: WHERE sales_lead_id = x_sales_lead_id;
1428:
1429: BEGIN
1430:

Line 1484: AS_SALES_LEADS_PUB.update_sales_lead(

1480:
1481: -- Now reassign escalated lead to the manager
1482: l_sales_lead_rec.assign_to_salesforce_id := l_manager_id;
1483:
1484: AS_SALES_LEADS_PUB.update_sales_lead(
1485: p_api_version_number => l_api_version_number
1486: ,p_init_msg_list => fnd_api.g_FALSE
1487: ,p_commit => fnd_api.g_false
1488: ,p_validation_level => 0 -- fnd_api.g_valid_level_full