APPS.FND_DCP dependencies on FND_CONCURRENT_QUEUES

Line 96: from fnd_concurrent_queues

92:
93: begin
94: select nvl (sleep_seconds, DEFSLEEP)
95: into ti
96: from fnd_concurrent_queues
97: where application_id = apid
98: and concurrent_queue_id = qid;
99:
100: select concurrent_process_id,

Line 707: from fnd_concurrent_queues

703: into max_procs,
704: run_procs,
705: ccode,
706: tnode
707: from fnd_concurrent_queues
708: where application_id = apid
709: and concurrent_queue_id = qid;
710:
711: if ((max_procs < run_procs) or

Line 786: * stored in fnd_concurrent_queues, and returned to the caller.

782: * its primary node.
783: *
784: * If the manager was started on its primary node, then
785: * the current instance number is retrieved from v$instance,
786: * stored in fnd_concurrent_queues, and returned to the caller.
787: *
788: * If the manager was started on its secondary node, then
789: * the instance number is retrieved from fnd_concurrent_queues
790: *

Line 789: * the instance number is retrieved from fnd_concurrent_queues

785: * the current instance number is retrieved from v$instance,
786: * stored in fnd_concurrent_queues, and returned to the caller.
787: *
788: * If the manager was started on its secondary node, then
789: * the instance number is retrieved from fnd_concurrent_queues
790: *
791: * Parameters:
792: * queue_appl_id - Concurrent queue application ID.
793: * queue_id - Concurrent queue ID.

Line 800: * The table fnd_concurrent_queues may be updated.

796: * Returns:
797: * An OPS instance number.
798: *
799: * Alters:
800: * The table fnd_concurrent_queues may be updated.
801: *
802: * Assumptions:
803: * This function assumes that the node names stored in
804: * fnd_concurrent_queues exactly match those in the manager's

Line 804: * fnd_concurrent_queues exactly match those in the manager's

800: * The table fnd_concurrent_queues may be updated.
801: *
802: * Assumptions:
803: * This function assumes that the node names stored in
804: * fnd_concurrent_queues exactly match those in the manager's
805: * sysinfo structure. (i.e. Both fully qualified, or both not
806: * fully qualified)
807: *
808: * Error conditions:

Line 817: primary_node fnd_concurrent_queues.node_name%type;

813: function get_inst_num (queue_appl_id in number,
814: queue_id in number,
815: current_node in varchar2)
816: return number is
817: primary_node fnd_concurrent_queues.node_name%type;
818: secondary_node fnd_concurrent_queues.node_name2%type;
819: inst_num number; /* OPS Instance Number */
820: begin
821: /* Are we on the primary node?*/

Line 818: secondary_node fnd_concurrent_queues.node_name2%type;

814: queue_id in number,
815: current_node in varchar2)
816: return number is
817: primary_node fnd_concurrent_queues.node_name%type;
818: secondary_node fnd_concurrent_queues.node_name2%type;
819: inst_num number; /* OPS Instance Number */
820: begin
821: /* Are we on the primary node?*/
822: select upper(node_name), upper(node_name2)

Line 824: from fnd_concurrent_queues

820: begin
821: /* Are we on the primary node?*/
822: select upper(node_name), upper(node_name2)
823: into primary_node, secondary_node
824: from fnd_concurrent_queues
825: where concurrent_queue_id = queue_id
826: and application_id = queue_appl_id;
827:
828:

Line 835: /* Store it into fnd_concurrent_queues. */

831: select instance_number
832: into inst_num
833: from v$instance;
834:
835: /* Store it into fnd_concurrent_queues. */
836:
837: update fnd_concurrent_queues
838: set instance_number = inst_num
839: where application_id = queue_appl_id

Line 837: update fnd_concurrent_queues

833: from v$instance;
834:
835: /* Store it into fnd_concurrent_queues. */
836:
837: update fnd_concurrent_queues
838: set instance_number = inst_num
839: where application_id = queue_appl_id
840: and concurrent_queue_id = queue_id;
841:

Line 848: from fnd_concurrent_queues

844:
845: else /* we aren't on the primary node...maybe we still know the inst num*/
846: select INSTANCE_NUMBER
847: into inst_num
848: from fnd_concurrent_queues
849: where application_id = queue_appl_id
850: and concurrent_queue_id = queue_id;
851:
852: /* Update the global...if not null */

Line 879: * The manager's target_node in fnd_concurrent_queues is it's current

875: * NTRUE/TRUE/1 if this request can appear in query results
876: * NFALSE/FALSE/0 if this request should be filtered from query results
877: *
878: * Assumptions:
879: * The manager's target_node in fnd_concurrent_queues is it's current
880: * node. This should always be true for active managers in afpgrq.
881: *
882: * Error conditions:
883: *

Line 945: from fnd_concurrent_queues

941: if (retval = NFALSE) then
942: if (my_node is NULL) then
943: select target_node
944: into my_node
945: from fnd_concurrent_queues
946: where application_id = my_q_appl_id
947: and concurrent_queue_id = my_q_id;
948: end if;
949: