APPS.PQH_ROUTING_HISTORY_API dependencies on PQH_ROUTING_HIST_ATTRIBS

Line 465: -- DELETE rows from pqh_routing_hist_attribs

461: --
462: end;
463: --
464: --
465: -- DELETE rows from pqh_routing_hist_attribs
466: --
467: delete from pqh_routing_hist_attribs
468: where routing_history_id = p_routing_history_id;
469: --

Line 467: delete from pqh_routing_hist_attribs

463: --
464: --
465: -- DELETE rows from pqh_routing_hist_attribs
466: --
467: delete from pqh_routing_hist_attribs
468: where routing_history_id = p_routing_history_id;
469: --
470: --
471: --

Line 599: pqh_routing_hist_attribs by calling create_routing_hist_attrib API in loop

595: ,p_rha_tab in t_rha_tab
596: ) is
597: /*
598: This procedure will call the create_routing_history API and then insert records into
599: pqh_routing_hist_attribs by calling create_routing_hist_attrib API in loop
600: */
601:
602:
603: l_proc varchar2(72) := g_package||'create_routing_history_bp';

Line 606: l_routing_hist_attrib_id pqh_routing_hist_attribs.routing_hist_attrib_id%TYPE;

602:
603: l_proc varchar2(72) := g_package||'create_routing_history_bp';
604: l_routing_history_id pqh_routing_history.routing_history_id%TYPE;
605: l_object_version_number pqh_routing_history.object_version_number%TYPE;
606: l_routing_hist_attrib_id pqh_routing_hist_attribs.routing_hist_attrib_id%TYPE;
607:
608: begin
609:
610: -- call the create_routing_history API

Line 655: hr_utility.set_location(' Inserting Into pqh_routing_hist_attribs: '||l_proc, 5);

651:
652: FOR i in NVL(p_rha_tab.FIRST,0)..NVL(p_rha_tab.LAST,-1)
653: LOOP
654:
655: hr_utility.set_location(' Inserting Into pqh_routing_hist_attribs: '||l_proc, 5);
656:
657:
658:
659: pqh_routing_hist_attrib_api.create_routing_hist_attrib

Line 679: hr_utility.set_location(' Done Inserting Into pqh_routing_hist_attribs: '||l_routing_hist_attrib_id, 7);

675: ,p_value_char => p_rha_tab(i).value_char
676: ,p_effective_date => p_effective_date
677: );
678:
679: hr_utility.set_location(' Done Inserting Into pqh_routing_hist_attribs: '||l_routing_hist_attrib_id, 7);
680:
681: END LOOP;
682:
683: