[Home] [Help]
594: X_Msg_Count OUT NOCOPY NUMBER,
595: X_Msg_Data OUT NOCOPY VARCHAR2
596: )
597: IS
598: -- solin, 02/01/2001, replace view AS_PARTY_CUSTOMERS_V with table HZ_PARTIES
599: CURSOR C_Customer_Id_Exists (c_Customer_Id NUMBER) IS
600: SELECT 'X'
601: FROM HZ_PARTIES
602: WHERE PARTY_TYPE IN ('PERSON', 'ORGANIZATION')
597: IS
598: -- solin, 02/01/2001, replace view AS_PARTY_CUSTOMERS_V with table HZ_PARTIES
599: CURSOR C_Customer_Id_Exists (c_Customer_Id NUMBER) IS
600: SELECT 'X'
601: FROM HZ_PARTIES
602: WHERE PARTY_TYPE IN ('PERSON', 'ORGANIZATION')
603: AND PARTY_ID = c_Customer_Id;
604:
605: CURSOR C_Customer_is_active(c_Customer_Id NUMBER) IS
603: AND PARTY_ID = c_Customer_Id;
604:
605: CURSOR C_Customer_is_active(c_Customer_Id NUMBER) IS
606: SELECT status
607: FROM hz_parties
608: WHERE PARTY_TYPE IN ('PERSON', 'ORGANIZATION')
609: AND PARTY_ID = c_Customer_Id;
610:
611: l_val VARCHAR2(1);
3313: -- 11.5.10 ckapoor Lead Name changes for Rivendell
3314:
3315: CURSOR C_get_primary_contact_name(X_sales_lead_id NUMBER) IS
3316: SELECT hzp.party_name
3317: FROM hz_parties hzp, as_sales_leads sl
3318: WHERE hzp.party_id = sl.primary_cnt_person_party_id
3319: and sl.sales_lead_id = X_sales_lead_id;
3320: -- this works since contacts API would have already updated the
3321: -- primary contacts party id information in as_sales_leads.
3322:
3323:
3324: CURSOR C_get_customer_name (X_party_id NUMBER) IS
3325: SELECT party_name
3326: FROM hz_parties
3327: WHERE party_id = X_party_id;
3328:
3329: ---- bug 2533638 - TST1158.7:MSTR:ORG. ADDRESS IS NOT PICKED WHEN CREATING LEAD FROM PARTNER DETAIL
3330:
4395: --CURSOR C_PHONE_ID_Exists(c_sales_lead_id NUMBER) IS
4396: -- SELECT hz.contact_point_id
4397: -- FROM AS_SALES_LEADS SL, HZ_CONTACT_POINTS HZ
4398: -- WHERE hz.owner_table_id = sl.customer_id
4399: -- AND hz.owner_table_name = 'HZ_PARTIES'
4400: -- AND hz.contact_point_type = 'PHONE'
4401: -- AND hz.primary_flag = 'Y'
4402: -- AND sl.sales_lead_id = c_sales_lead_id;
4403: