APPS.OKC_QUERY dependencies on WF_NOTIFICATION

Line 222: -- from wf_notification_attributes for a notification_id

218:
219: ---------------------------------------------------------------------
220: -- FUNCTION: GetKid
221: -- DESCRIPTION : Gets the contract number from the attribute value
222: -- from wf_notification_attributes for a notification_id
223: -- used in launchpad_inbox_view.
224: ----------------------------------------------------------------------
225:
226: FUNCTION GetKid(p_notification_id IN NUMBER,

Line 236: v_id := wf_notification.getattrnumber(p_notification_id,

232: v_id okc_k_headers_all_b.id%TYPE;
233: -- end bug # 4666846
234: BEGIN
235:
236: v_id := wf_notification.getattrnumber(p_notification_id,
237: p_att_name);
238: IF v_id IS NOT NULL THEN
239: RETURN(v_id);
240: ELSE

Line 253: -- from wf_notification_attributes for a notification_id

249:
250: ---------------------------------------------------------------------
251: -- FUNCTION: GetKnumber
252: -- DESCRIPTION : Gets the contract number from the attribute value
253: -- from wf_notification_attributes for a notification_id
254: -- used in launchpad_inbox_view.
255: ----------------------------------------------------------------------
256: FUNCTION GetKnumber(p_notification_id IN NUMBER,
257: p_att_name IN VARCHAR2)

Line 277: v_id := wf_notification.getattrnumber(p_notification_id,

273: x_knumber okc_k_headers_all_b.contract_number%TYPE;
274: --end bug # 4666846
275: BEGIN
276:
277: v_id := wf_notification.getattrnumber(p_notification_id,
278: p_att_name);
279: IF v_id IS NOT NULL THEN
280: OPEN k_cur(v_id);
281: FETCH k_cur INTO k_rec;

Line 302: -- from wf_notification_attributes for a notification_id

298: --mmadhavi added GetKmodifier
299: ---------------------------------------------------------------------------
300: -- FUNCTION: GetKnumber
301: -- DESCRIPTION : Gets the contract number modifier from the attribute value
302: -- from wf_notification_attributes for a notification_id
303: -- used in launchpad_inbox_view.
304: ---------------------------------------------------------------------------
305: FUNCTION GetKmodifier(p_notification_id IN NUMBER,
306: p_att_name IN VARCHAR2)

Line 326: v_id := wf_notification.getattrnumber(p_notification_id,

322: x_knumber okc_k_headers_all_b.contract_number_modifier%TYPE;
323: -- end bug # 4666846
324: BEGIN
325:
326: v_id := wf_notification.getattrnumber(p_notification_id,
327: p_att_name);
328: IF v_id IS NOT NULL THEN
329: OPEN k_cur(v_id);
330: FETCH k_cur INTO k_rec;