DBA Data[Home] [Help]

APPS.FND_MANAGER dependencies on FND_API

Line 1752: primary_node IN VARCHAR2 DEFAULT fnd_api.g_miss_char,

1748: -- Node names may be set to null.
1749:
1750: PROCEDURE update_node(short_name IN VARCHAR2,
1751: application IN VARCHAR2,
1752: primary_node IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1753: secondary_node IN VARCHAR2 DEFAULT fnd_api.g_miss_char) IS
1754:
1755: mgr_appl_id fnd_application.application_id%TYPE;
1756: mgr_id fnd_concurrent_queues.concurrent_queue_id%type;

Line 1753: secondary_node IN VARCHAR2 DEFAULT fnd_api.g_miss_char) IS

1749:
1750: PROCEDURE update_node(short_name IN VARCHAR2,
1751: application IN VARCHAR2,
1752: primary_node IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1753: secondary_node IN VARCHAR2 DEFAULT fnd_api.g_miss_char) IS
1754:
1755: mgr_appl_id fnd_application.application_id%TYPE;
1756: mgr_id fnd_concurrent_queues.concurrent_queue_id%type;
1757: pnode varchar2(31);

Line 1767: if (primary_node = fnd_api.g_miss_char and

1763:
1764: check_notnull(application);
1765: check_notnull(short_name);
1766:
1767: if (primary_node = fnd_api.g_miss_char and
1768: secondary_node = fnd_api.g_miss_char) then
1769: return; /* Do nothing. */
1770: end if;
1771:

Line 1768: secondary_node = fnd_api.g_miss_char) then

1764: check_notnull(application);
1765: check_notnull(short_name);
1766:
1767: if (primary_node = fnd_api.g_miss_char and
1768: secondary_node = fnd_api.g_miss_char) then
1769: return; /* Do nothing. */
1770: end if;
1771:
1772: /* Get concurrent queue id */

Line 1779: if (primary_node <> fnd_api.g_miss_char and

1775: mgr_id := manager_id_f(mgr_appl_id, short_name);
1776:
1777: /* Verify node(s) */
1778:
1779: if (primary_node <> fnd_api.g_miss_char and
1780: primary_node is not null) then
1781: pnode := node_name_f(primary_node);
1782: else
1783: pnode := primary_node;

Line 1786: if (secondary_node <> fnd_api.g_miss_char and

1782: else
1783: pnode := primary_node;
1784: end if;
1785:
1786: if (secondary_node <> fnd_api.g_miss_char and
1787: secondary_node is not null) then
1788: snode := node_name_f(secondary_node);
1789: else
1790: snode := secondary_node;

Line 1794: if (snode = fnd_api.g_miss_char) then /* No secondary */

1790: snode := secondary_node;
1791: end if;
1792:
1793: /* Update */
1794: if (snode = fnd_api.g_miss_char) then /* No secondary */
1795: update fnd_concurrent_queues
1796: set node_name = pnode
1797: where concurrent_queue_id = mgr_id
1798: and application_id = mgr_appl_id;

Line 1800: elsif (pnode = fnd_api.g_miss_char) then /* No primary */

1796: set node_name = pnode
1797: where concurrent_queue_id = mgr_id
1798: and application_id = mgr_appl_id;
1799:
1800: elsif (pnode = fnd_api.g_miss_char) then /* No primary */
1801: update fnd_concurrent_queues
1802: set node_name2 = snode
1803: where concurrent_queue_id = mgr_id
1804: and application_id = mgr_appl_id;