APPS.PNT_PHONE_PKG dependencies on PN_PHONES_ALL

Line 28: FROM pn_phones_all ph

24: BEGIN
25:
26: SELECT count(1)
27: INTO primary_count
28: FROM pn_phones_all ph
29: WHERE ph.contact_id = p_contact_id
30: AND ph.primary_flag = 'Y'
31: AND ((p_phone_id is null) or ph.phone_id <> p_phone_id )
32: AND org_id = p_org_id;

Line 86: FROM pn_phones_all

82: )
83: IS
84: CURSOR C IS
85: SELECT rowid
86: FROM pn_phones_all
87: WHERE phone_id = X_Phone_Id;
88:
89: l_id number;
90:

Line 114: INSERT INTO pn_phones_all

110: SELECT pn_phones_s.nextval
111: INTO x_phone_id
112: FROM dual;
113:
114: INSERT INTO pn_phones_all
115: (
116: phone_id,
117: last_update_date,
118: last_updated_by,

Line 225: FROM pn_phones_all

221: X_Attribute15 VARCHAR2
222: ) IS
223: CURSOR C IS
224: SELECT *
225: FROM pn_phones_all
226: WHERE rowid = X_Rowid
227: FOR UPDATE of Phone_Id NOWAIT;
228: Recinfo C%ROWTYPE;
229:

Line 371: UPDATE pn_phones_all

367:
368: BEGIN
369: --
370: --
371: UPDATE pn_phones_all
372: SET
373: last_update_date = X_Last_Update_Date,
374: last_updated_by = X_Last_Updated_By,
375: phone_number = X_Phone_Number,

Line 416: DELETE FROM pn_phones_all

412: PROCEDURE delete_row ( x_rowid VARCHAR2)
413: IS
414: BEGIN
415:
416: DELETE FROM pn_phones_all
417: WHERE rowid = x_rowid;
418:
419: IF (SQL%NOTFOUND) THEN
420: RAISE NO_DATA_FOUND;

Line 437: DELETE FROM pn_phones_all

433: PROCEDURE delete_row (x_phone_id IN NUMBER)
434: IS
435: BEGIN
436:
437: DELETE FROM pn_phones_all
438: WHERE phone_id = x_phone_id;
439:
440: IF (SQL%NOTFOUND)
441: THEN