APPS.AS_IMPORT_SL_PVT dependencies on HZ_CONTACT_POINTS

Line 272: from hz_contact_points

268: c_phone_number varchar2,
269: c_phone_line_type varchar2,
270: c_url varchar2) IS
271: select contact_point_id
272: from hz_contact_points
273: where owner_table_id = c_owner_table_id
274: and owner_table_name = 'HZ_PARTIES'
275: and nvl(email_address,'1') = nvl(c_email_address,'1')
276: and nvl(phone_area_code,'1') = nvl(c_phone_area_code,'1')

Line 489: FROM HZ_CONTACT_POINTS

485:
486: begin
487: SELECT COUNT(*) NO_PRIMARY_CPS
488: INTO l_no_of_primary_cps
489: FROM HZ_CONTACT_POINTS
490: WHERE CONTACT_POINT_TYPE = 'PHONE' AND PRIMARY_FLAG = 'Y'
491: AND OWNER_TABLE_NAME = 'HZ_PARTIES' AND OWNER_TABLE_ID = pI.rel_party_id;
492:
493: write_log(3, 'AC : No. of primary contact points found ' || l_no_of_primary_cps || ' for part rel id : ' || pI.rel_party_id);

Line 497: UPDATE HZ_CONTACT_POINTS

493: write_log(3, 'AC : No. of primary contact points found ' || l_no_of_primary_cps || ' for part rel id : ' || pI.rel_party_id);
494:
495: -- Validation
496: If l_no_of_primary_cps < 1 then
497: UPDATE HZ_CONTACT_POINTS
498: SET PRIMARY_FLAG = 'Y'
499: WHERE owner_table_name = 'HZ_PARTIES'
500: AND contact_point_type = 'PHONE'
501: AND owner_table_id = pI.rel_party_id

Line 516: -- 3. HZ_CONTACT_POINTS

512: -- assign the Recs with flex values
513: -- note: currently, the following entities are only supported
514: -- 1. HZ_PARTIES
515: -- 2. HZ_LOCATIONS
516: -- 3. HZ_CONTACT_POINTS
517: -- 4. HZ_PARTY_SITES
518: -- 5. HZ_ORG_CONTACTS
519: -- 6. AS_SALES_LEADS
520: -- 7. AS_SALES_LEAD_LINES

Line 649: if (pEntity = 'HZ_CONTACT_POINTS') then

645: -- pHzlRec.global_attribute18 := I.gattr_val_18;
646: -- pHzlRec.global_attribute19 := I.gattr_val_19;
647: -- pHzlRec.global_attribute20 := I.gattr_val_20;
648: end if;
649: if (pEntity = 'HZ_CONTACT_POINTS') then
650: pHzcpRec.attribute_category := I.attr_val_category;
651: pHzcpRec.attribute1 := I.attr_val_1;
652: pHzcpRec.attribute2 := I.attr_val_2;
653: pHzcpRec.attribute3 := I.attr_val_3;

Line 1159: and contact_level_table = 'HZ_CONTACT_POINTS';

1155: into l_res_id
1156: from hz_contact_preferences
1157: where contact_level_table_id = pI.phone_id
1158: and contact_type = 'CALL'
1159: and contact_level_table = 'HZ_CONTACT_POINTS';
1160:
1161: Exception
1162: when NO_DATA_FOUND then
1163: l_res_rec.contact_type := 'CALL';

Line 1165: l_res_rec.contact_level_table := 'HZ_CONTACT_POINTS';

1161: Exception
1162: when NO_DATA_FOUND then
1163: l_res_rec.contact_type := 'CALL';
1164: l_res_rec.preference_start_date := sysdate;
1165: l_res_rec.contact_level_table := 'HZ_CONTACT_POINTS';
1166: -- l_res_rec.subject_id:= pI.contact_party_id;
1167: l_res_rec.contact_level_table_id:= pI.phone_id;
1168:
1169: write_log (3, 'Creating CntPreference: PHONE');

Line 1338: 'HZ_CONTACT_POINTS',

1334: -- l_dummy_rec6 ,
1335: l_dummy_rec7 ,
1336: l_dummy_tbl8 ,
1337: l_dummy_tbl9 ,
1338: 'HZ_CONTACT_POINTS',
1339: pI.import_interface_id,
1340: G_return_status
1341: );
1342:

Line 1576: 'HZ_CONTACT_POINTS',

1572: -- l_dummy_rec6 ,
1573: l_dummy_rec7 ,
1574: l_dummy_tbl8 ,
1575: l_dummy_tbl9 ,
1576: 'HZ_CONTACT_POINTS',
1577: pI.import_interface_id,
1578: G_return_status
1579: );
1580: */

Line 2394: FROM HZ_CONTACT_POINTS

2390:
2391: -- ajchatto, for retrieving primary contact point of primary contact
2392: CURSOR c_get_primary_cp (c_rel_party_id number) IS
2393: SELECT CONTACT_POINT_ID
2394: FROM HZ_CONTACT_POINTS
2395: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES' AND CONTACT_POINT_TYPE = 'PHONE'
2396: AND PRIMARY_FLAG = 'Y' AND OWNER_TABLE_ID = c_rel_party_id
2397: AND ROWNUM = 1; --TO SELECT ONE ROW
2398:

Line 2776: FROM HZ_CONTACT_POINTS

2772:
2773: -- Get the primary contact point id of the primary contact and use it in phone_id
2774: SELECT CONTACT_POINT_ID
2775: INTO l_contact_point_id
2776: FROM HZ_CONTACT_POINTS
2777: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES' AND CONTACT_POINT_TYPE = 'PHONE'
2778: AND PRIMARY_FLAG = 'Y' AND OWNER_TABLE_ID = pI.REL_PARTY_ID
2779: AND ROWNUM = 1; --TO SELECT ONE ROW
2780:

Line 3477: FROM hz_matched_cpts_gt hzmcp, hz_contact_points hzcp

3473: -- Cursor for getting matched contact_point from hz_matched_cpts_gt
3474: CURSOR C_matched_contact_points(cp_type VARCHAR2, p_plt VARCHAR2)
3475: IS
3476: SELECT hzmcp.party_id, hzmcp.contact_point_id, score , hzcp.creation_date
3477: FROM hz_matched_cpts_gt hzmcp, hz_contact_points hzcp
3478: WHERE search_context_id = l_search_context_id
3479: AND hzmcp.contact_point_id = hzcp.contact_point_id
3480: AND hzcp.contact_point_type = cp_type
3481: AND nvl(hzcp.phone_line_type,'xx') = nvl(p_plt,'xx')