APPS.PN_INSURANCE_REQUIREMENTS_PKG dependencies on PN_INSURANCE_REQUIREMENTS_ALL

Line 52: FROM pn_insurance_requirements_all

48: )
49: IS
50: CURSOR C IS
51: SELECT ROWID
52: FROM pn_insurance_requirements_all
53: WHERE insurance_requirement_id = x_insurance_requirement_id;
54:
55: CURSOR org_cur IS
56: SELECT org_id

Line 80: INSERT INTO PN_INSURANCE_REQUIREMENTS_ALL

76: ELSE
77: l_org_id := x_org_id;
78: END IF;
79:
80: INSERT INTO PN_INSURANCE_REQUIREMENTS_ALL
81: (
82: CREATION_DATE,
83: CREATED_BY,
84: LAST_UPDATE_LOGIN,

Line 207: FROM PN_INSURANCE_REQUIREMENTS_ALL

203: )
204: IS
205: CURSOR c1 IS
206: SELECT *
207: FROM PN_INSURANCE_REQUIREMENTS_ALL
208: WHERE INSURANCE_REQUIREMENT_ID = X_INSURANCE_REQUIREMENT_ID
209: FOR UPDATE OF INSURANCE_REQUIREMENT_ID NOWAIT;
210:
211: tlinfo c1%ROWTYPE;

Line 406: FROM pn_insurance_requirements_all

402: )
403: IS
404: CURSOR c2 IS
405: SELECT *
406: FROM pn_insurance_requirements_all
407: WHERE insurance_requirement_id = x_insurance_requirement_id;
408:
409: recInfoForHist c2%ROWTYPE;
410:

Line 518: UPDATE pn_insurance_requirements_all

514: );
515: END IF;
516: END IF;
517:
518: UPDATE pn_insurance_requirements_all
519: SET INSURANCE_TYPE_LOOKUP_CODE = X_INSURANCE_TYPE_LOOKUP_CODE,
520: LEASE_CHANGE_ID = X_LEASE_CHANGE_ID,
521: POLICY_START_DATE = X_POLICY_START_DATE,
522: POLICY_EXPIRATION_DATE = X_POLICY_EXPIRATION_DATE,

Line 571: DELETE FROM pn_insurance_requirements_all

567: X_INSURANCE_REQUIREMENT_ID IN NUMBER
568: )
569: IS
570: BEGIN
571: DELETE FROM pn_insurance_requirements_all
572: WHERE insurance_requirement_id = x_insurance_requirement_id;
573:
574: IF (SQL%NOTFOUND) THEN
575: RAISE NO_DATA_FOUND;