eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_WF dependencies on PQH_WORKFLOW

Line 54: , 'PQH_WORKFLOW'

50: , LAST_UPDATE_LOGIN
51: )
52: VALUES (
53: ghr_process_log_s.nextval
54: , 'PQH_WORKFLOW'
55: , p_log_text
56: , sysdate
57: , sysdate
58: , 1

Line 547: FOR i in NVL(pqh_workflow.g_routing_criterion.FIRST,0)..NVL(pqh_workflow.g_routing_criterion.LAST,-1) loop

543: j binary_integer := 0;
544: BEGIN
545: hr_utility.set_location(l_proc || 'Entering',10);
546: hr_utility.set_location(l_proc || 'p_approval_cd is '||p_approval_cd,12);
547: FOR i in NVL(pqh_workflow.g_routing_criterion.FIRST,0)..NVL(pqh_workflow.g_routing_criterion.LAST,-1) loop
548: if pqh_workflow.g_routing_criterion.exists(i) then
549: l_rha_tab(j).attribute_id := pqh_workflow.g_routing_criterion(i).Attribute_id;
550: l_rha_tab(j).from_char := pqh_workflow.g_routing_criterion(i).from_char;
551: l_rha_tab(j).from_date := pqh_workflow.g_routing_criterion(i).from_date;

Line 548: if pqh_workflow.g_routing_criterion.exists(i) then

544: BEGIN
545: hr_utility.set_location(l_proc || 'Entering',10);
546: hr_utility.set_location(l_proc || 'p_approval_cd is '||p_approval_cd,12);
547: FOR i in NVL(pqh_workflow.g_routing_criterion.FIRST,0)..NVL(pqh_workflow.g_routing_criterion.LAST,-1) loop
548: if pqh_workflow.g_routing_criterion.exists(i) then
549: l_rha_tab(j).attribute_id := pqh_workflow.g_routing_criterion(i).Attribute_id;
550: l_rha_tab(j).from_char := pqh_workflow.g_routing_criterion(i).from_char;
551: l_rha_tab(j).from_date := pqh_workflow.g_routing_criterion(i).from_date;
552: l_rha_tab(j).from_number := pqh_workflow.g_routing_criterion(i).from_num;

Line 549: l_rha_tab(j).attribute_id := pqh_workflow.g_routing_criterion(i).Attribute_id;

545: hr_utility.set_location(l_proc || 'Entering',10);
546: hr_utility.set_location(l_proc || 'p_approval_cd is '||p_approval_cd,12);
547: FOR i in NVL(pqh_workflow.g_routing_criterion.FIRST,0)..NVL(pqh_workflow.g_routing_criterion.LAST,-1) loop
548: if pqh_workflow.g_routing_criterion.exists(i) then
549: l_rha_tab(j).attribute_id := pqh_workflow.g_routing_criterion(i).Attribute_id;
550: l_rha_tab(j).from_char := pqh_workflow.g_routing_criterion(i).from_char;
551: l_rha_tab(j).from_date := pqh_workflow.g_routing_criterion(i).from_date;
552: l_rha_tab(j).from_number := pqh_workflow.g_routing_criterion(i).from_num;
553: l_rha_tab(j).to_char := pqh_workflow.g_routing_criterion(i).to_char;

Line 550: l_rha_tab(j).from_char := pqh_workflow.g_routing_criterion(i).from_char;

546: hr_utility.set_location(l_proc || 'p_approval_cd is '||p_approval_cd,12);
547: FOR i in NVL(pqh_workflow.g_routing_criterion.FIRST,0)..NVL(pqh_workflow.g_routing_criterion.LAST,-1) loop
548: if pqh_workflow.g_routing_criterion.exists(i) then
549: l_rha_tab(j).attribute_id := pqh_workflow.g_routing_criterion(i).Attribute_id;
550: l_rha_tab(j).from_char := pqh_workflow.g_routing_criterion(i).from_char;
551: l_rha_tab(j).from_date := pqh_workflow.g_routing_criterion(i).from_date;
552: l_rha_tab(j).from_number := pqh_workflow.g_routing_criterion(i).from_num;
553: l_rha_tab(j).to_char := pqh_workflow.g_routing_criterion(i).to_char;
554: l_rha_tab(j).to_date := pqh_workflow.g_routing_criterion(i).to_date;

Line 551: l_rha_tab(j).from_date := pqh_workflow.g_routing_criterion(i).from_date;

547: FOR i in NVL(pqh_workflow.g_routing_criterion.FIRST,0)..NVL(pqh_workflow.g_routing_criterion.LAST,-1) loop
548: if pqh_workflow.g_routing_criterion.exists(i) then
549: l_rha_tab(j).attribute_id := pqh_workflow.g_routing_criterion(i).Attribute_id;
550: l_rha_tab(j).from_char := pqh_workflow.g_routing_criterion(i).from_char;
551: l_rha_tab(j).from_date := pqh_workflow.g_routing_criterion(i).from_date;
552: l_rha_tab(j).from_number := pqh_workflow.g_routing_criterion(i).from_num;
553: l_rha_tab(j).to_char := pqh_workflow.g_routing_criterion(i).to_char;
554: l_rha_tab(j).to_date := pqh_workflow.g_routing_criterion(i).to_date;
555: l_rha_tab(j).to_number := pqh_workflow.g_routing_criterion(i).to_num;

Line 552: l_rha_tab(j).from_number := pqh_workflow.g_routing_criterion(i).from_num;

548: if pqh_workflow.g_routing_criterion.exists(i) then
549: l_rha_tab(j).attribute_id := pqh_workflow.g_routing_criterion(i).Attribute_id;
550: l_rha_tab(j).from_char := pqh_workflow.g_routing_criterion(i).from_char;
551: l_rha_tab(j).from_date := pqh_workflow.g_routing_criterion(i).from_date;
552: l_rha_tab(j).from_number := pqh_workflow.g_routing_criterion(i).from_num;
553: l_rha_tab(j).to_char := pqh_workflow.g_routing_criterion(i).to_char;
554: l_rha_tab(j).to_date := pqh_workflow.g_routing_criterion(i).to_date;
555: l_rha_tab(j).to_number := pqh_workflow.g_routing_criterion(i).to_num;
556: l_rha_tab(j).range_type_cd := pqh_workflow.g_routing_criterion(i).used_for;

Line 553: l_rha_tab(j).to_char := pqh_workflow.g_routing_criterion(i).to_char;

549: l_rha_tab(j).attribute_id := pqh_workflow.g_routing_criterion(i).Attribute_id;
550: l_rha_tab(j).from_char := pqh_workflow.g_routing_criterion(i).from_char;
551: l_rha_tab(j).from_date := pqh_workflow.g_routing_criterion(i).from_date;
552: l_rha_tab(j).from_number := pqh_workflow.g_routing_criterion(i).from_num;
553: l_rha_tab(j).to_char := pqh_workflow.g_routing_criterion(i).to_char;
554: l_rha_tab(j).to_date := pqh_workflow.g_routing_criterion(i).to_date;
555: l_rha_tab(j).to_number := pqh_workflow.g_routing_criterion(i).to_num;
556: l_rha_tab(j).range_type_cd := pqh_workflow.g_routing_criterion(i).used_for;
557: l_rha_tab(j).value_date := pqh_workflow.g_routing_criterion(i).value_date;

Line 554: l_rha_tab(j).to_date := pqh_workflow.g_routing_criterion(i).to_date;

550: l_rha_tab(j).from_char := pqh_workflow.g_routing_criterion(i).from_char;
551: l_rha_tab(j).from_date := pqh_workflow.g_routing_criterion(i).from_date;
552: l_rha_tab(j).from_number := pqh_workflow.g_routing_criterion(i).from_num;
553: l_rha_tab(j).to_char := pqh_workflow.g_routing_criterion(i).to_char;
554: l_rha_tab(j).to_date := pqh_workflow.g_routing_criterion(i).to_date;
555: l_rha_tab(j).to_number := pqh_workflow.g_routing_criterion(i).to_num;
556: l_rha_tab(j).range_type_cd := pqh_workflow.g_routing_criterion(i).used_for;
557: l_rha_tab(j).value_date := pqh_workflow.g_routing_criterion(i).value_date;
558: l_rha_tab(j).value_number := pqh_workflow.g_routing_criterion(i).value_num;

Line 555: l_rha_tab(j).to_number := pqh_workflow.g_routing_criterion(i).to_num;

551: l_rha_tab(j).from_date := pqh_workflow.g_routing_criterion(i).from_date;
552: l_rha_tab(j).from_number := pqh_workflow.g_routing_criterion(i).from_num;
553: l_rha_tab(j).to_char := pqh_workflow.g_routing_criterion(i).to_char;
554: l_rha_tab(j).to_date := pqh_workflow.g_routing_criterion(i).to_date;
555: l_rha_tab(j).to_number := pqh_workflow.g_routing_criterion(i).to_num;
556: l_rha_tab(j).range_type_cd := pqh_workflow.g_routing_criterion(i).used_for;
557: l_rha_tab(j).value_date := pqh_workflow.g_routing_criterion(i).value_date;
558: l_rha_tab(j).value_number := pqh_workflow.g_routing_criterion(i).value_num;
559: l_rha_tab(j).value_char := pqh_workflow.g_routing_criterion(i).value_char;

Line 556: l_rha_tab(j).range_type_cd := pqh_workflow.g_routing_criterion(i).used_for;

552: l_rha_tab(j).from_number := pqh_workflow.g_routing_criterion(i).from_num;
553: l_rha_tab(j).to_char := pqh_workflow.g_routing_criterion(i).to_char;
554: l_rha_tab(j).to_date := pqh_workflow.g_routing_criterion(i).to_date;
555: l_rha_tab(j).to_number := pqh_workflow.g_routing_criterion(i).to_num;
556: l_rha_tab(j).range_type_cd := pqh_workflow.g_routing_criterion(i).used_for;
557: l_rha_tab(j).value_date := pqh_workflow.g_routing_criterion(i).value_date;
558: l_rha_tab(j).value_number := pqh_workflow.g_routing_criterion(i).value_num;
559: l_rha_tab(j).value_char := pqh_workflow.g_routing_criterion(i).value_char;
560: j := j + 1;

Line 557: l_rha_tab(j).value_date := pqh_workflow.g_routing_criterion(i).value_date;

553: l_rha_tab(j).to_char := pqh_workflow.g_routing_criterion(i).to_char;
554: l_rha_tab(j).to_date := pqh_workflow.g_routing_criterion(i).to_date;
555: l_rha_tab(j).to_number := pqh_workflow.g_routing_criterion(i).to_num;
556: l_rha_tab(j).range_type_cd := pqh_workflow.g_routing_criterion(i).used_for;
557: l_rha_tab(j).value_date := pqh_workflow.g_routing_criterion(i).value_date;
558: l_rha_tab(j).value_number := pqh_workflow.g_routing_criterion(i).value_num;
559: l_rha_tab(j).value_char := pqh_workflow.g_routing_criterion(i).value_char;
560: j := j + 1;
561: end if;

Line 558: l_rha_tab(j).value_number := pqh_workflow.g_routing_criterion(i).value_num;

554: l_rha_tab(j).to_date := pqh_workflow.g_routing_criterion(i).to_date;
555: l_rha_tab(j).to_number := pqh_workflow.g_routing_criterion(i).to_num;
556: l_rha_tab(j).range_type_cd := pqh_workflow.g_routing_criterion(i).used_for;
557: l_rha_tab(j).value_date := pqh_workflow.g_routing_criterion(i).value_date;
558: l_rha_tab(j).value_number := pqh_workflow.g_routing_criterion(i).value_num;
559: l_rha_tab(j).value_char := pqh_workflow.g_routing_criterion(i).value_char;
560: j := j + 1;
561: end if;
562: END LOOP;

Line 559: l_rha_tab(j).value_char := pqh_workflow.g_routing_criterion(i).value_char;

555: l_rha_tab(j).to_number := pqh_workflow.g_routing_criterion(i).to_num;
556: l_rha_tab(j).range_type_cd := pqh_workflow.g_routing_criterion(i).used_for;
557: l_rha_tab(j).value_date := pqh_workflow.g_routing_criterion(i).value_date;
558: l_rha_tab(j).value_number := pqh_workflow.g_routing_criterion(i).value_num;
559: l_rha_tab(j).value_char := pqh_workflow.g_routing_criterion(i).value_char;
560: j := j + 1;
561: end if;
562: END LOOP;
563: hr_utility.set_location(l_proc || 'out of xfer ',14);

Line 587: ,p_from_range_name => pqh_workflow.g_current_member_range

583: ,p_transaction_category_id => p_transaction_category_id
584: ,p_transaction_id => p_transaction_id
585: ,p_user_action_cd => p_user_action_cd
586: ,p_object_version_number => l_object_version_number
587: ,p_from_range_name => pqh_workflow.g_current_member_range
588: ,p_to_range_name => pqh_workflow.g_next_member_range
589: ,p_list_range_name => pqh_workflow.g_list_range
590: ,p_effective_date => l_effective_date
591: ,p_rha_tab => l_rha_tab

Line 588: ,p_to_range_name => pqh_workflow.g_next_member_range

584: ,p_transaction_id => p_transaction_id
585: ,p_user_action_cd => p_user_action_cd
586: ,p_object_version_number => l_object_version_number
587: ,p_from_range_name => pqh_workflow.g_current_member_range
588: ,p_to_range_name => pqh_workflow.g_next_member_range
589: ,p_list_range_name => pqh_workflow.g_list_range
590: ,p_effective_date => l_effective_date
591: ,p_rha_tab => l_rha_tab
592: );

Line 589: ,p_list_range_name => pqh_workflow.g_list_range

585: ,p_user_action_cd => p_user_action_cd
586: ,p_object_version_number => l_object_version_number
587: ,p_from_range_name => pqh_workflow.g_current_member_range
588: ,p_to_range_name => pqh_workflow.g_next_member_range
589: ,p_list_range_name => pqh_workflow.g_list_range
590: ,p_effective_date => l_effective_date
591: ,p_rha_tab => l_rha_tab
592: );
593: p_routing_history_id := l_routing_history_id;

Line 2697: -- instead of this function, we use pqh_workflow.valid_user_opening procedure

2693: result := null;
2694: raise;
2695: END;
2696:
2697: -- instead of this function, we use pqh_workflow.valid_user_opening procedure
2698: -- which in turn builds the default role
2699:
2700: FUNCTION get_default_role (
2701: p_transaction_category_id NUMBER