APPS.PV_OPPORTUNITY_VHUK dependencies on AS_LEADS_ALL

Line 876: FROM as_leads_all ld, hz_parties pt

872:
873: CURSOR lc_opportunity (pc_lead_id number) is
874: SELECT ld.customer_id, ld.address_id
875: , pt.party_name, ld.currency_code
876: FROM as_leads_all ld, hz_parties pt
877: WHERE ld.customer_id = pt.party_id
878: AND ld.lead_id = pc_lead_id;
879:
880: CURSOR lc_get_opp_amt (pc_lead_id NUMBER) is

Line 1287: -- Update AS_LEADS_ALL set AUTO_ASSIGNMENT_TYPE in AS_LEADS_ALL to PRM for the lead_id.

1283: fnd_message.Set_Token('TEXT', 'After 2nd Create Sales team');
1284: fnd_msg_pub.Add;
1285: END IF;
1286:
1287: -- Update AS_LEADS_ALL set AUTO_ASSIGNMENT_TYPE in AS_LEADS_ALL to PRM for the lead_id.
1288:
1289: IF p_relationship_type = 'PARTNER_OF' THEN
1290:
1291: IF p_partner_type = 'PARTNER' THEN

Line 1293: Update AS_LEADS_ALL

1289: IF p_relationship_type = 'PARTNER_OF' THEN
1290:
1291: IF p_partner_type = 'PARTNER' THEN
1292:
1293: Update AS_LEADS_ALL
1294: SET PRM_ASSIGNMENT_TYPE = 'SINGLE',
1295: AUTO_ASSIGNMENT_TYPE = 'PRM'
1296: WHERE lead_id = l_lead_id;
1297:

Line 1300: Update AS_LEADS_ALL

1296: WHERE lead_id = l_lead_id;
1297:
1298: ELSIF p_partner_type = 'VAD' THEN -- 'VAD_OF'
1299:
1300: Update AS_LEADS_ALL
1301: SET AUTO_ASSIGNMENT_TYPE = 'PRM'
1302: WHERE lead_id = l_lead_id;
1303:
1304: END IF;

Line 1417: FROM as_leads_all

1413:
1414: CURSOR lc_opp_amt(pc_lead_id NUMBER)
1415: IS
1416: SELECT nvl(total_amount,0), currency_code
1417: FROM as_leads_all
1418: WHERE lead_id = pc_lead_id;
1419:
1420: BEGIN
1421:

Line 1625: l_customer_id as_leads_all.customer_id%TYPE;

1621: l_category jtf_rs_resource_extns.category%type;
1622: l_party_id jtf_rs_resource_extns.source_id%type;
1623: l_party_name jtf_rs_resource_extns.source_business_grp_name%type;
1624: l_vendor_org_name jtf_rs_resource_extns.source_business_grp_name%type;
1625: l_customer_id as_leads_all.customer_id%TYPE;
1626: l_address_id as_leads_all.address_id%TYPE;
1627: l_wf_item_type VARCHAR2(20);
1628: l_wf_item_key VARCHAR2(20);
1629: l_partner_id NUMBER;

Line 1626: l_address_id as_leads_all.address_id%TYPE;

1622: l_party_id jtf_rs_resource_extns.source_id%type;
1623: l_party_name jtf_rs_resource_extns.source_business_grp_name%type;
1624: l_vendor_org_name jtf_rs_resource_extns.source_business_grp_name%type;
1625: l_customer_id as_leads_all.customer_id%TYPE;
1626: l_address_id as_leads_all.address_id%TYPE;
1627: l_wf_item_type VARCHAR2(20);
1628: l_wf_item_key VARCHAR2(20);
1629: l_partner_id NUMBER;
1630: l_partner_name VARCHAR2(360);

Line 1735: FROM as_leads_all ld, hz_parties pt

1731:
1732: CURSOR lc_opportunity (pc_lead_id number) is
1733: SELECT ld.customer_id, ld.address_id, pt.party_name,
1734: nvl(ld.total_amount,0),ld.currency_code, ld.description
1735: FROM as_leads_all ld, hz_parties pt
1736: WHERE ld.customer_id = pt.party_id
1737: AND ld.lead_id = pc_lead_id;
1738:
1739: CURSOR lc_get_pt_emp_cat(pc_salesforce_id NUMBER) IS

Line 1781: (select status from as_leads_all

1777: select decode(a.status_code, t.status, a.meaning, a.status_code),
1778: decode(a.status_code, pc_status_code, a.meaning, a.status_code),
1779: a.status_code, a.win_loss_indicator
1780: from as_statuses_vl a,
1781: (select status from as_leads_all
1782: where lead_id = pc_lead_id) t
1783: where a.enabled_flag = 'Y'
1784: and a.opp_flag = 'Y'
1785: and a.status_code in (t.status, pc_status_code);