APPS.PN_INDEX_EXCLUDE_TERM_PKG dependencies on PN_INDEX_EXCLUDE_TERM_ALL

Line 47: FROM pn_index_exclude_term_all exclude

43: SELECT '1'
44: INTO l_rowExists
45: FROM DUAL
46: WHERE EXISTS ( SELECT 1
47: FROM pn_index_exclude_term_all exclude
48: WHERE exclude.index_lease_id = x_index_lease_id
49: AND exclude.payment_term_id = x_payment_term_id
50: AND exclude.org_id = x_org_id);
51:

Line 74: INSERT INTO PN_INDEX_EXCLUDE_TERM_ALL

70: INTO X_INDEX_EXCLUDE_TERM_ID
71: FROM dual;
72: END IF;
73:
74: INSERT INTO PN_INDEX_EXCLUDE_TERM_ALL
75: (
76: INDEX_EXCLUDE_TERM_ID
77: ,ORG_ID
78: ,INDEX_LEASE_ID

Line 140: UPDATE PN_INDEX_EXCLUDE_TERM_ALL

136: IF (l_return_status IS NOT NULL) THEN
137: APP_EXCEPTION.Raise_Exception;
138: END IF;
139:
140: UPDATE PN_INDEX_EXCLUDE_TERM_ALL
141: SET
142: INDEX_LEASE_ID =X_INDEX_LEASE_ID
143: ,PAYMENT_TERM_ID =X_PAYMENT_TERM_ID
144: ,LAST_UPDATE_DATE =X_LAST_UPDATE_DATE

Line 177: SELECT * FROM PN_INDEX_EXCLUDE_TERM_ALL

173: )
174: IS
175:
176: CURSOR c1 IS
177: SELECT * FROM PN_INDEX_EXCLUDE_TERM_ALL
178: WHERE INDEX_EXCLUDE_TERM_ID = X_INDEX_EXCLUDE_TERM_ID
179: FOR UPDATE OF INDEX_EXCLUDE_TERM_ID NOWAIT;
180:
181: tlinfo c1%ROWTYPE;

Line 243: FROM pn_index_exclude_term_all exclude

239: SELECT '1'
240: INTO l_rowExists
241: FROM DUAL
242: WHERE EXISTS ( SELECT 1
243: FROM pn_index_exclude_term_all exclude
244: WHERE exclude.index_lease_id = x_index_lease_id
245: AND exclude.payment_term_id = x_payment_term_id);
246:
247: EXCEPTION

Line 254: DELETE FROM PN_INDEX_EXCLUDE_TERM_ALL

250: END;
251:
252: IF l_rowExists = '1' THEN
253:
254: DELETE FROM PN_INDEX_EXCLUDE_TERM_ALL
255: WHERE INDEX_LEASE_ID = X_INDEX_LEASE_ID
256: AND PAYMENT_TERM_ID = X_PAYMENT_TERM_ID;
257:
258: IF (sql%notfound) THEN

Line 283: DELETE FROM PN_INDEX_EXCLUDE_TERM_ALL

279: BEGIN
280:
281: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.DELETE_ALL_EXCLUDE_TERMS (+)');
282:
283: DELETE FROM PN_INDEX_EXCLUDE_TERM_ALL
284: WHERE INDEX_LEASE_ID = X_INDEX_LEASE_ID;
285:
286: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.DELETE_ALL_EXCLUDE_TERMS (-)');
287: