APPS.WF_MAILER_PARAMETER dependencies on WF_MAILER_TAGS

Line 355: -- wf_mailer_tags_c type

351: -- get_mailer_tags_c - Return the REF Cursor for the list of tags
352: -- IN
353: -- Service name
354: -- RETURN
355: -- wf_mailer_tags_c type
356: FUNCTION get_mailer_tags_c(pServiceName IN VARCHAR2)
357: RETURN wf_mailer_tags_c
358: AS
359: v_cursor wf_mailer_tags_c;

Line 357: RETURN wf_mailer_tags_c

353: -- Service name
354: -- RETURN
355: -- wf_mailer_tags_c type
356: FUNCTION get_mailer_tags_c(pServiceName IN VARCHAR2)
357: RETURN wf_mailer_tags_c
358: AS
359: v_cursor wf_mailer_tags_c;
360:
361: BEGIN

Line 359: v_cursor wf_mailer_tags_c;

355: -- wf_mailer_tags_c type
356: FUNCTION get_mailer_tags_c(pServiceName IN VARCHAR2)
357: RETURN wf_mailer_tags_c
358: AS
359: v_cursor wf_mailer_tags_c;
360:
361: BEGIN
362: OPEN v_cursor FOR
363: SELECT name, tag_id, action, pattern

Line 364: FROM wf_mailer_tags

360:
361: BEGIN
362: OPEN v_cursor FOR
363: SELECT name, tag_id, action, pattern
364: FROM wf_mailer_tags
365: WHERE name = pServiceName
366: UNION
367: SELECT name, tag_id, action, pattern
368: FROM wf_mailer_tags

Line 368: FROM wf_mailer_tags

364: FROM wf_mailer_tags
365: WHERE name = pServiceName
366: UNION
367: SELECT name, tag_id, action, pattern
368: FROM wf_mailer_tags
369: WHERE name = '-WF_DEFAULT-';
370:
371: RETURN v_cursor;
372: END get_mailer_tags_c;

Line 379: -- The list of tags in a PL/SQL Table of wf_mailer_tags_rec_type

375: -- GetTAGs - Return a list of tags and their actions
376: -- IN
377: -- The name for the instance
378: -- OUT
379: -- The list of tags in a PL/SQL Table of wf_mailer_tags_rec_type
380: PROCEDURE GetTAGS(pName IN VARCHAR2, pTags in out NOCOPY wf_mailer_tags_tbl_type)
381: IS
382: lName VARCHAR2(12);
383: CURSOR c is

Line 380: PROCEDURE GetTAGS(pName IN VARCHAR2, pTags in out NOCOPY wf_mailer_tags_tbl_type)

376: -- IN
377: -- The name for the instance
378: -- OUT
379: -- The list of tags in a PL/SQL Table of wf_mailer_tags_rec_type
380: PROCEDURE GetTAGS(pName IN VARCHAR2, pTags in out NOCOPY wf_mailer_tags_tbl_type)
381: IS
382: lName VARCHAR2(12);
383: CURSOR c is
384: SELECT name, tag_id, pattern, action

Line 385: FROM wf_mailer_tags

381: IS
382: lName VARCHAR2(12);
383: CURSOR c is
384: SELECT name, tag_id, pattern, action
385: FROM wf_mailer_tags
386: WHERE name = lName;
387:
388: i integer;
389:

Line 434: from wf_mailer_tags

430: IF (ptag_id > 0 ) then
431:
432: select count(1)
433: into tagExists
434: from wf_mailer_tags
435: WHERE tag_id = pTag_id;
436:
437: if tagExists > 0 then
438: if paction is null and ppattern is null then

Line 439: DELETE wf_mailer_tags

435: WHERE tag_id = pTag_id;
436:
437: if tagExists > 0 then
438: if paction is null and ppattern is null then
439: DELETE wf_mailer_tags
440: WHERE name = pName
441: AND tag_id = ptag_id;
442: else
443: UPDATE wf_mailer_tags

Line 443: UPDATE wf_mailer_tags

439: DELETE wf_mailer_tags
440: WHERE name = pName
441: AND tag_id = ptag_id;
442: else
443: UPDATE wf_mailer_tags
444: SET action = paction,
445: pattern = ppattern
446: WHERE name = pName
447: AND tag_id = ptag_id;

Line 452: INSERT INTO wf_mailer_tags

448: end if;
449: else
450: -- Tag does not exist, insert it,
451: -- This will only be executed for Loader
452: INSERT INTO wf_mailer_tags
453: (name,
454: tag_id,
455: action,
456: pattern)

Line 468: from wf_mailer_tags

464: -- Check if tag exist based on NODENAME, Action, Pattern
465: -- So that we don't have duplicate (same action, pattern) Tags
466: select count(1)
467: into tagExists
468: from wf_mailer_tags
469: where action = paction
470: and pattern = ppattern
471: and name = pName ;
472:

Line 475: INSERT INTO wf_mailer_tags

471: and name = pName ;
472:
473: -- Insert unique tags
474: if(nvl(tagExists, 0) = 0) then
475: INSERT INTO wf_mailer_tags
476: (name,
477: tag_id,
478: action,
479: pattern)

Line 481: wf_mailer_tags_s.nextval,

477: tag_id,
478: action,
479: pattern)
480: VALUES (pName,
481: wf_mailer_tags_s.nextval,
482: paction,
483: ppattern);
484: end if;
485: end if;