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 666: from fnd_concurrent_queues

662: into max_procs,
663: run_procs,
664: ccode,
665: tnode
666: from fnd_concurrent_queues
667: where application_id = apid
668: and concurrent_queue_id = qid;
669:
670: if ((max_procs < run_procs) or

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

741: * its primary node.
742: *
743: * If the manager was started on its primary node, then
744: * the current instance number is retrieved from v$instance,
745: * stored in fnd_concurrent_queues, and returned to the caller.
746: *
747: * If the manager was started on its secondary node, then
748: * the instance number is retrieved from fnd_concurrent_queues
749: *

Line 748: * the instance number is retrieved from fnd_concurrent_queues

744: * the current instance number is retrieved from v$instance,
745: * stored in fnd_concurrent_queues, and returned to the caller.
746: *
747: * If the manager was started on its secondary node, then
748: * the instance number is retrieved from fnd_concurrent_queues
749: *
750: * Parameters:
751: * queue_appl_id - Concurrent queue application ID.
752: * queue_id - Concurrent queue ID.

Line 759: * The table fnd_concurrent_queues may be updated.

755: * Returns:
756: * An OPS instance number.
757: *
758: * Alters:
759: * The table fnd_concurrent_queues may be updated.
760: *
761: * Assumptions:
762: * This function assumes that the node names stored in
763: * fnd_concurrent_queues exactly match those in the manager's

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

759: * The table fnd_concurrent_queues may be updated.
760: *
761: * Assumptions:
762: * This function assumes that the node names stored in
763: * fnd_concurrent_queues exactly match those in the manager's
764: * sysinfo structure. (i.e. Both fully qualified, or both not
765: * fully qualified)
766: *
767: * Error conditions:

Line 776: primary_node fnd_concurrent_queues.node_name%type;

772: function get_inst_num (queue_appl_id in number,
773: queue_id in number,
774: current_node in varchar2)
775: return number is
776: primary_node fnd_concurrent_queues.node_name%type;
777: secondary_node fnd_concurrent_queues.node_name2%type;
778: inst_num number; /* OPS Instance Number */
779: begin
780: /* Are we on the primary node?*/

Line 777: secondary_node fnd_concurrent_queues.node_name2%type;

773: queue_id in number,
774: current_node in varchar2)
775: return number is
776: primary_node fnd_concurrent_queues.node_name%type;
777: secondary_node fnd_concurrent_queues.node_name2%type;
778: inst_num number; /* OPS Instance Number */
779: begin
780: /* Are we on the primary node?*/
781: select upper(node_name), upper(node_name2)

Line 783: from fnd_concurrent_queues

779: begin
780: /* Are we on the primary node?*/
781: select upper(node_name), upper(node_name2)
782: into primary_node, secondary_node
783: from fnd_concurrent_queues
784: where concurrent_queue_id = queue_id
785: and application_id = queue_appl_id;
786:
787:

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

790: select instance_number
791: into inst_num
792: from v$instance;
793:
794: /* Store it into fnd_concurrent_queues. */
795:
796: update fnd_concurrent_queues
797: set instance_number = inst_num
798: where application_id = queue_appl_id

Line 796: update fnd_concurrent_queues

792: from v$instance;
793:
794: /* Store it into fnd_concurrent_queues. */
795:
796: update fnd_concurrent_queues
797: set instance_number = inst_num
798: where application_id = queue_appl_id
799: and concurrent_queue_id = queue_id;
800:

Line 807: from fnd_concurrent_queues

803:
804: else /* we aren't on the primary node...maybe we still know the inst num*/
805: select INSTANCE_NUMBER
806: into inst_num
807: from fnd_concurrent_queues
808: where application_id = queue_appl_id
809: and concurrent_queue_id = queue_id;
810:
811: /* Update the global...if not null */

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

834: * NTRUE/TRUE/1 if this request can appear in query results
835: * NFALSE/FALSE/0 if this request should be filtered from query results
836: *
837: * Assumptions:
838: * The manager's target_node in fnd_concurrent_queues is it's current
839: * node. This should always be true for active managers in afpgrq.
840: *
841: * Error conditions:
842: *

Line 904: from fnd_concurrent_queues

900: if (retval = NFALSE) then
901: if (my_node is NULL) then
902: select target_node
903: into my_node
904: from fnd_concurrent_queues
905: where application_id = my_q_appl_id
906: and concurrent_queue_id = my_q_id;
907: end if;
908: