APPS.PN_CONTACT_ASSIGNMENTS_PKG dependencies on PN_CONTACT_ASSIGNMENTS_ALL

Line 48: FROM PN_CONTACT_ASSIGNMENTS_ALL

44: )
45: IS
46: CURSOR c IS
47: SELECT ROWID
48: FROM PN_CONTACT_ASSIGNMENTS_ALL
49: WHERE CONTACT_ASSIGNMENT_ID = X_CONTACT_ASSIGNMENT_ID;
50:
51: CURSOR org_cur IS
52: SELECT org_id

Line 76: INSERT INTO PN_CONTACT_ASSIGNMENTS_ALL

72: FROM DUAL;
73: END IF;
74:
75:
76: INSERT INTO PN_CONTACT_ASSIGNMENTS_ALL
77: (
78: CONTACT_ASSIGNMENT_ID
79: ,LAST_UPDATE_DATE
80: ,LAST_UPDATED_BY

Line 188: FROM pn_contact_assignments_all

184: )
185: IS
186: CURSOR c IS
187: SELECT *
188: FROM pn_contact_assignments_all
189: WHERE contact_assignment_id = x_contact_assignment_id
190: FOR UPDATE OF contact_assignment_id NOWAIT;
191:
192: tlinfo c%ROWTYPE;

Line 359: FROM PN_CONTACT_ASSIGNMENTS_ALL

355: l_contactHIStoryId NUMBER := NULL;
356:
357: CURSOR c IS
358: SELECT *
359: FROM PN_CONTACT_ASSIGNMENTS_ALL
360: WHERE CONTACT_ASSIGNMENT_ID = X_CONTACT_ASSIGNMENT_ID;
361:
362: recInfoForHist c%ROWTYPE;
363:

Line 458: UPDATE PN_CONTACT_ASSIGNMENTS_ALL

454: END IF;
455: END IF;
456: END IF;
457:
458: UPDATE PN_CONTACT_ASSIGNMENTS_ALL
459: SET LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
460: ,LAST_UPDATED_BY = X_LAST_UPDATED_BY
461: ,LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
462: ,COMPANY_ID = X_COMPANY_ID

Line 503: FROM PN_CONTACT_ASSIGNMENTS_ALL

499: )
500: IS
501: BEGIN
502: DELETE
503: FROM PN_CONTACT_ASSIGNMENTS_ALL
504: WHERE CONTACT_ASSIGNMENT_ID = X_CONTACT_ASSIGNMENT_ID
505: AND STATUS <> 'F';
506:
507: IF (SQL%NOTFOUND) THEN