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.HXC_FIND_NOTIFY_APRS_PKG dependencies on HXC_TIME_BUILDING_BLOCKS

Line 16: FROM HXC_TIME_BUILDING_BLOCKS tcbb

12: cursor csr_tc_info(b_tc_bbid number, b_tc_bbovn number) is
13: SELECT tcbb.resource_id,
14: tcbb.start_time,
15: tcbb.stop_time
16: FROM HXC_TIME_BUILDING_BLOCKS tcbb
17: WHERE tcbb.time_building_block_id = b_tc_bbid
18: and tcbb.object_version_number = b_tc_bbovn;
19:
20: --

Line 30: HXC_TIME_BUILDING_BLOCKS apbb

26: apbb.stop_time,
27: ta.attribute1 recipient_app
28: FROM HXC_TIME_ATTRIBUTES ta,
29: HXC_TIME_ATTRIBUTE_USAGES tau,
30: HXC_TIME_BUILDING_BLOCKS apbb
31: WHERE apbb.time_building_block_id = b_ap_bbid
32: and apbb.object_version_number = b_ap_bbovn
33: and tau.time_building_block_id =
34: apbb.time_building_block_id

Line 51: HXC_TIME_BUILDING_BLOCKS htb_time,

47: apc.wf_item_type,
48: apc.wf_name
49: FROM HXC_APPROVAL_COMPS apc,
50: HXC_APPROVAL_STYLES aps,
51: HXC_TIME_BUILDING_BLOCKS htb_time,
52: hxc_time_building_blocks htb_appln
53: WHERE htb_appln.TIME_BUILDING_BLOCK_ID = b_ap_bbid AND
54: htb_appln.object_version_number = b_ap_bbovn
55: AND

Line 52: hxc_time_building_blocks htb_appln

48: apc.wf_name
49: FROM HXC_APPROVAL_COMPS apc,
50: HXC_APPROVAL_STYLES aps,
51: HXC_TIME_BUILDING_BLOCKS htb_time,
52: hxc_time_building_blocks htb_appln
53: WHERE htb_appln.TIME_BUILDING_BLOCK_ID = b_ap_bbid AND
54: htb_appln.object_version_number = b_ap_bbovn
55: AND
56: htb_time.resource_id = htb_appln.resource_id AND

Line 512: (p_app_bb_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

508:
509: END cancel_notifications;
510:
511: procedure cancel_previous_notifications
512: (p_app_bb_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
513: ,p_app_bb_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
514: ) is
515:
516: cursor c_appl_periods

Line 513: ,p_app_bb_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

509: END cancel_notifications;
510:
511: procedure cancel_previous_notifications
512: (p_app_bb_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
513: ,p_app_bb_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
514: ) is
515:
516: cursor c_appl_periods
517: (p_app_bb_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

Line 517: (p_app_bb_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

513: ,p_app_bb_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
514: ) is
515:
516: cursor c_appl_periods
517: (p_app_bb_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
518: ,p_app_bb_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
519: ) IS
520: select distinct apps.time_building_block_id
521: from hxc_time_building_blocks apps

Line 518: ,p_app_bb_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

514: ) is
515:
516: cursor c_appl_periods
517: (p_app_bb_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
518: ,p_app_bb_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
519: ) IS
520: select distinct apps.time_building_block_id
521: from hxc_time_building_blocks apps
522: ,hxc_time_building_blocks refapps

Line 521: from hxc_time_building_blocks apps

517: (p_app_bb_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
518: ,p_app_bb_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
519: ) IS
520: select distinct apps.time_building_block_id
521: from hxc_time_building_blocks apps
522: ,hxc_time_building_blocks refapps
523: where refapps.resource_id = apps.resource_id
524: and refapps.scope = apps.scope
525: and refapps.date_to = hr_general.end_of_time

Line 522: ,hxc_time_building_blocks refapps

518: ,p_app_bb_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
519: ) IS
520: select distinct apps.time_building_block_id
521: from hxc_time_building_blocks apps
522: ,hxc_time_building_blocks refapps
523: where refapps.resource_id = apps.resource_id
524: and refapps.scope = apps.scope
525: and refapps.date_to = hr_general.end_of_time
526: and refapps.start_time <= apps.stop_time

Line 557: l_app_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;

553: IS
554: l_resource_id NUMBER;
555: l_tc_start DATE;
556: l_tc_stop DATE;
557: l_app_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
558:
559: CURSOR c_appl_periods(
560: p_tc_start_time IN hxc_time_building_blocks.start_time%TYPE
561: ,p_tc_stop_time IN hxc_time_building_blocks.stop_time%TYPE

Line 560: p_tc_start_time IN hxc_time_building_blocks.start_time%TYPE

556: l_tc_stop DATE;
557: l_app_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
558:
559: CURSOR c_appl_periods(
560: p_tc_start_time IN hxc_time_building_blocks.start_time%TYPE
561: ,p_tc_stop_time IN hxc_time_building_blocks.stop_time%TYPE
562: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
563: )
564: IS

Line 561: ,p_tc_stop_time IN hxc_time_building_blocks.stop_time%TYPE

557: l_app_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
558:
559: CURSOR c_appl_periods(
560: p_tc_start_time IN hxc_time_building_blocks.start_time%TYPE
561: ,p_tc_stop_time IN hxc_time_building_blocks.stop_time%TYPE
562: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
563: )
564: IS
565: SELECT time_building_block_id

Line 562: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE

558:
559: CURSOR c_appl_periods(
560: p_tc_start_time IN hxc_time_building_blocks.start_time%TYPE
561: ,p_tc_stop_time IN hxc_time_building_blocks.stop_time%TYPE
562: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
563: )
564: IS
565: SELECT time_building_block_id
566: FROM hxc_time_building_blocks

Line 566: FROM hxc_time_building_blocks

562: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
563: )
564: IS
565: SELECT time_building_block_id
566: FROM hxc_time_building_blocks
567: WHERE scope = 'APPLICATION_PERIOD'
568: AND resource_id = p_resource_id
569: AND date_to = hr_general.end_of_time
570: AND TRUNC(start_time) <= TRUNC(p_tc_stop_time)

Line 614: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

610:
611:
612:
613: PROCEDURE cancel_previous_notifications(
614: p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
615: )
616: IS
617:
618: --bug 4946511.

Line 621: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE

617:
618: --bug 4946511.
619:
620: CURSOR c_app_periods(
621: p_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE
622: )
623: IS
624: SELECT aps.application_period_id
625: FROM hxc_tc_ap_links tcl, hxc_app_period_summary aps

Line 630: l_app_id hxc_time_building_blocks.time_building_block_id%TYPE;

626: WHERE tcl.timecard_id = p_timecard_id
627: AND tcl.application_period_id = aps.application_period_id
628: AND aps.notification_status = 'NOTIFIED';
629:
630: l_app_id hxc_time_building_blocks.time_building_block_id%TYPE;
631:
632: BEGIN
633: g_debug:=hr_utility.debug_enabled;
634: OPEN c_app_periods(p_timecard_id);

Line 750: p_ap_bb_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

746: p_result in out nocopy varchar2)
747: is
748:
749: CURSOR c_approval_comp(
750: p_ap_bb_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
751: ,p_ap_bb_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
752: )
753: IS
754: SELECT apc.approval_mechanism,

Line 751: ,p_ap_bb_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

747: is
748:
749: CURSOR c_approval_comp(
750: p_ap_bb_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
751: ,p_ap_bb_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
752: )
753: IS
754: SELECT apc.approval_mechanism,
755: apc.approval_mechanism_id,

Line 793: ,hxc_time_building_blocks tbb

789: apc.wf_name
790: FROM hxc_app_period_summary apsum
791: ,hxc_approval_comps apc
792: ,hxc_tc_ap_links tcl
793: ,hxc_time_building_blocks tbb
794: WHERE apsum.application_period_id = p_application_period_id
795: AND apsum.application_period_ovn = p_application_period_ovn
796: and apsum.application_period_id = tcl.application_period_id
797: and tcl.timecard_id = tbb.time_building_block_id

Line 804: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE

800: and tbb.approval_style_id = apc.approval_style_id
801: and apsum.time_recipient_id = apc.time_recipient_id;
802:
803: CURSOR c_tc_info(
804: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE
805: )
806: IS
807: SELECT tcsum.resource_id,
808: tcsum.start_time,

Line 815: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;

811: WHERE tcsum.timecard_id = p_tc_bbid;
812:
813:
814: l_proc constant varchar2(61) := g_pkg || '.' || 'find_apr_style';
815: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
816: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
817: l_ap_bb_id hxc_time_building_blocks.time_building_block_id%type;
818: l_ap_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
819: l_login fnd_user.user_name%type;

Line 816: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;

812:
813:
814: l_proc constant varchar2(61) := g_pkg || '.' || 'find_apr_style';
815: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
816: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
817: l_ap_bb_id hxc_time_building_blocks.time_building_block_id%type;
818: l_ap_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
819: l_login fnd_user.user_name%type;
820: l_resource_id hxc_time_building_blocks.resource_id%TYPE;

Line 817: l_ap_bb_id hxc_time_building_blocks.time_building_block_id%type;

813:
814: l_proc constant varchar2(61) := g_pkg || '.' || 'find_apr_style';
815: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
816: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
817: l_ap_bb_id hxc_time_building_blocks.time_building_block_id%type;
818: l_ap_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
819: l_login fnd_user.user_name%type;
820: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
821: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;

Line 818: l_ap_bb_ovn hxc_time_building_blocks.time_building_block_id%type;

814: l_proc constant varchar2(61) := g_pkg || '.' || 'find_apr_style';
815: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
816: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
817: l_ap_bb_id hxc_time_building_blocks.time_building_block_id%type;
818: l_ap_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
819: l_login fnd_user.user_name%type;
820: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
821: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
822: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;

Line 820: l_resource_id hxc_time_building_blocks.resource_id%TYPE;

816: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
817: l_ap_bb_id hxc_time_building_blocks.time_building_block_id%type;
818: l_ap_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
819: l_login fnd_user.user_name%type;
820: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
821: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
822: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
823: l_approval_mechanism hxc_approval_comps.approval_mechanism%TYPE;
824: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE;

Line 821: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;

817: l_ap_bb_id hxc_time_building_blocks.time_building_block_id%type;
818: l_ap_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
819: l_login fnd_user.user_name%type;
820: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
821: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
822: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
823: l_approval_mechanism hxc_approval_comps.approval_mechanism%TYPE;
824: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE;
825: l_wf_item_type hxc_approval_comps.wf_item_type%TYPE;

Line 822: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;

818: l_ap_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
819: l_login fnd_user.user_name%type;
820: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
821: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
822: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
823: l_approval_mechanism hxc_approval_comps.approval_mechanism%TYPE;
824: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE;
825: l_wf_item_type hxc_approval_comps.wf_item_type%TYPE;
826: l_wf_name hxc_approval_comps.wf_name%TYPE;

Line 1378: p_ap_bb_id hxc_time_building_blocks.time_building_block_id%TYPE

1374: )
1375: is
1376:
1377: CURSOR c_project_id(
1378: p_ap_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
1379: )
1380: IS
1381: SELECT hta.attribute1
1382: FROM hxc_ap_detail_links apdet

Line 1383: ,hxc_time_building_blocks htbb

1379: )
1380: IS
1381: SELECT hta.attribute1
1382: FROM hxc_ap_detail_links apdet
1383: ,hxc_time_building_blocks htbb
1384: ,hxc_time_attribute_usages htau
1385: ,hxc_time_attributes hta
1386: WHERE apdet.application_period_id = p_ap_bb_id
1387: AND apdet.time_building_block_id = htbb.time_building_block_id

Line 1395: (p_app_bb_id in hxc_time_building_blocks.time_building_block_id%type) is

1391: AND htau.time_attribute_id = hta.time_attribute_id
1392: AND hta.attribute_category = 'PROJECTS';
1393:
1394: cursor c_project_id_deleted_detail
1395: (p_app_bb_id in hxc_time_building_blocks.time_building_block_id%type) is
1396: select to_number(ta.attribute1)
1397: from hxc_time_building_blocks details,
1398: hxc_time_building_blocks days,
1399: hxc_time_attribute_usages tau,

Line 1397: from hxc_time_building_blocks details,

1393:
1394: cursor c_project_id_deleted_detail
1395: (p_app_bb_id in hxc_time_building_blocks.time_building_block_id%type) is
1396: select to_number(ta.attribute1)
1397: from hxc_time_building_blocks details,
1398: hxc_time_building_blocks days,
1399: hxc_time_attribute_usages tau,
1400: hxc_app_period_summary aps,
1401: hxc_time_Attributes ta

Line 1398: hxc_time_building_blocks days,

1394: cursor c_project_id_deleted_detail
1395: (p_app_bb_id in hxc_time_building_blocks.time_building_block_id%type) is
1396: select to_number(ta.attribute1)
1397: from hxc_time_building_blocks details,
1398: hxc_time_building_blocks days,
1399: hxc_time_attribute_usages tau,
1400: hxc_app_period_summary aps,
1401: hxc_time_Attributes ta
1402: where aps.application_period_id = p_app_bb_id

Line 1411: from hxc_time_building_blocks details2

1407: and details.parent_building_block_ovn = days.object_version_number
1408: and details.date_to <> hr_general.end_of_time
1409: and details.object_version_number =
1410: (select max(details2.object_version_number)
1411: from hxc_time_building_blocks details2
1412: where details.time_building_block_id = details2.time_building_block_id)
1413: and details.time_building_block_id = tau.time_building_block_id
1414: and details.object_version_number = tau.time_building_block_ovn
1415: and tau.time_Attribute_Id = ta.time_attribute_id

Line 1564: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE

1560: p_result in out nocopy varchar2)
1561: is
1562:
1563: CURSOR c_tc_info(
1564: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE
1565: )
1566: IS
1567: SELECT tcsum.resource_id,
1568: tcsum.start_time,

Line 1582: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;

1578: FROM hxc_approval_styles
1579: WHERE approval_style_id = p_app_style_id;
1580:
1581: l_proc constant varchar2(61) := g_pkg || '.' || 'auto_approval';
1582: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
1583: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
1584: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
1585: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
1586: l_pref_table hxc_preference_evaluation.t_pref_table;

Line 1583: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;

1579: WHERE approval_style_id = p_app_style_id;
1580:
1581: l_proc constant varchar2(61) := g_pkg || '.' || 'auto_approval';
1582: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
1583: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
1584: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
1585: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
1586: l_pref_table hxc_preference_evaluation.t_pref_table;
1587: l_master_pref_table hxc_preference_evaluation.t_pref_table;

Line 1584: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;

1580:
1581: l_proc constant varchar2(61) := g_pkg || '.' || 'auto_approval';
1582: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
1583: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
1584: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
1585: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
1586: l_pref_table hxc_preference_evaluation.t_pref_table;
1587: l_master_pref_table hxc_preference_evaluation.t_pref_table;
1588: l_resource_id hxc_time_building_blocks.resource_id%TYPE;

Line 1585: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;

1581: l_proc constant varchar2(61) := g_pkg || '.' || 'auto_approval';
1582: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
1583: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
1584: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
1585: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
1586: l_pref_table hxc_preference_evaluation.t_pref_table;
1587: l_master_pref_table hxc_preference_evaluation.t_pref_table;
1588: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
1589: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;

Line 1588: l_resource_id hxc_time_building_blocks.resource_id%TYPE;

1584: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
1585: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
1586: l_pref_table hxc_preference_evaluation.t_pref_table;
1587: l_master_pref_table hxc_preference_evaluation.t_pref_table;
1588: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
1589: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
1590: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
1591:
1592: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;

Line 1589: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;

1585: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
1586: l_pref_table hxc_preference_evaluation.t_pref_table;
1587: l_master_pref_table hxc_preference_evaluation.t_pref_table;
1588: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
1589: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
1590: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
1591:
1592: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;
1593: l_approval_style_name hxc_approval_styles.name%TYPE;

Line 1590: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;

1586: l_pref_table hxc_preference_evaluation.t_pref_table;
1587: l_master_pref_table hxc_preference_evaluation.t_pref_table;
1588: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
1589: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
1590: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
1591:
1592: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;
1593: l_approval_style_name hxc_approval_styles.name%TYPE;
1594:

Line 1731: FROM hxc_time_building_blocks tbb

1727:
1728: CURSOR csr_get_timecard(p_app_per_id NUMBER) IS
1729: SELECT adl.TIME_BUILDING_BLOCK_ID bb_id,
1730: adl.TIME_BUILDING_BLOCK_OVN ovn
1731: FROM hxc_time_building_blocks tbb
1732: , hxc_ap_detail_links adl
1733: WHERE adl.APPLICATION_PERIOD_ID = p_app_per_id
1734: AND
1735: tbb.time_building_block_id = adl.time_building_block_id AND

Line 1741: FROM hxc_time_building_blocks tbb

1737: tbb.date_to = hr_general.end_of_time;
1738:
1739: CURSOR csr_get_person_id(p_app_per_id NUMBER) IS
1740: SELECT resource_id
1741: FROM hxc_time_building_blocks tbb
1742: WHERE tbb.time_building_block_id = p_app_per_id;
1743:
1744: /* Bug fix for 5526281 */
1745: CURSOR get_timecard_start_date(p_app_per_id NUMBER) IS

Line 1748: hxc_time_building_blocks tbb

1744: /* Bug fix for 5526281 */
1745: CURSOR get_timecard_start_date(p_app_per_id NUMBER) IS
1746: SELECT tbb.start_time ,tbb.stop_time
1747: FROM hxc_tc_ap_links htl,
1748: hxc_time_building_blocks tbb
1749: WHERE htl.application_period_id = p_app_per_id
1750: AND tbb.time_building_block_id = htl.timecard_id;
1751:
1752: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS

Line 1752: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS

1748: hxc_time_building_blocks tbb
1749: WHERE htl.application_period_id = p_app_per_id
1750: AND tbb.time_building_block_id = htl.timecard_id;
1751:
1752: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS
1753: select date_start from per_periods_of_service where person_id=p_resource_id order by date_start desc;
1754: /* end of bug fix for 5526281 */
1755:
1756: l_tc_rec csr_get_timecard%ROWTYPE;

Line 1760: l_resource_id hxc_time_building_blocks.resource_id%TYPE;

1756: l_tc_rec csr_get_timecard%ROWTYPE;
1757: l_timecard_hrs NUMBER := 0;
1758: l_detail_hrs NUMBER := 0;
1759: l_time_category_id hxc_time_categories.time_category_id%TYPE;
1760: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
1761: l_precision VARCHAR2(4);
1762: l_rounding_rule VARCHAR2(20);
1763: l_tc_start_date date;
1764:

Line 1854: from hxc_time_building_blocks timecard,

1850:
1851: CURSOR csr_get_details
1852: IS
1853: select details.time_building_block_id bb_id, details.object_version_number ovn
1854: from hxc_time_building_blocks timecard,
1855: hxc_time_building_blocks details,
1856: hxc_time_building_blocks days
1857: where timecard.time_building_block_id = days.parent_building_block_id
1858: and timecard.object_version_number = days.parent_building_block_ovn

Line 1855: hxc_time_building_blocks details,

1851: CURSOR csr_get_details
1852: IS
1853: select details.time_building_block_id bb_id, details.object_version_number ovn
1854: from hxc_time_building_blocks timecard,
1855: hxc_time_building_blocks details,
1856: hxc_time_building_blocks days
1857: where timecard.time_building_block_id = days.parent_building_block_id
1858: and timecard.object_version_number = days.parent_building_block_ovn
1859: and days.time_building_block_id = details.parent_building_block_id

Line 1856: hxc_time_building_blocks days

1852: IS
1853: select details.time_building_block_id bb_id, details.object_version_number ovn
1854: from hxc_time_building_blocks timecard,
1855: hxc_time_building_blocks details,
1856: hxc_time_building_blocks days
1857: where timecard.time_building_block_id = days.parent_building_block_id
1858: and timecard.object_version_number = days.parent_building_block_ovn
1859: and days.time_building_block_id = details.parent_building_block_id
1860: and days.object_version_number = details.parent_building_block_ovn

Line 2193: p_tc_id IN hxc_time_building_blocks.time_building_block_id%TYPE

2189:
2190:
2191:
2192: PROCEDURE process_extension_func2(
2193: p_tc_id IN hxc_time_building_blocks.time_building_block_id%TYPE
2194: ,p_tc_ovn IN hxc_time_building_blocks.object_version_number%TYPE
2195: ,p_time_recipient IN hxc_time_recipients.time_recipient_id%TYPE
2196: ,p_ext_func2 IN hxc_time_recipients.extension_function2%TYPE
2197: ,p_previous_approver IN NUMBER

Line 2194: ,p_tc_ovn IN hxc_time_building_blocks.object_version_number%TYPE

2190:
2191:
2192: PROCEDURE process_extension_func2(
2193: p_tc_id IN hxc_time_building_blocks.time_building_block_id%TYPE
2194: ,p_tc_ovn IN hxc_time_building_blocks.object_version_number%TYPE
2195: ,p_time_recipient IN hxc_time_recipients.time_recipient_id%TYPE
2196: ,p_ext_func2 IN hxc_time_recipients.extension_function2%TYPE
2197: ,p_previous_approver IN NUMBER
2198: ,p_next_approver OUT NOCOPY NUMBER

Line 2288: cursor c_details_of_timecard( l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type )

2284: where htr.time_recipient_id = p_time_recipient;
2285:
2286:
2287:
2288: cursor c_details_of_timecard( l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type )
2289: is
2290: select 'Y'
2291: from hxc_tc_ap_links tcl,
2292: hxc_ap_detail_links adl

Line 2297: cursor c_find_app_per_id( l_ap_bb_id in hxc_time_building_blocks.time_building_block_id%type)

2293: where tcl.timecard_id = l_tc_bb_id
2294: and tcl.application_period_id = adl.application_period_id
2295: and rownum < 2;
2296:
2297: cursor c_find_app_per_id( l_ap_bb_id in hxc_time_building_blocks.time_building_block_id%type)
2298: is
2299: SELECT 'Y'
2300: FROM hxc_app_period_summary
2301: WHERE time_category_id = 0

Line 2344: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;

2340: --
2341: l_supervisor_id per_all_assignments_f.supervisor_id%type;
2342: l_next_supervisor_id per_all_assignments_f.supervisor_id%type;
2343: l_login fnd_user.user_name%type;
2344: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
2345: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
2346:
2347:
2348:

Line 2345: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;

2341: l_supervisor_id per_all_assignments_f.supervisor_id%type;
2342: l_next_supervisor_id per_all_assignments_f.supervisor_id%type;
2343: l_login fnd_user.user_name%type;
2344: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
2345: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
2346:
2347:
2348:
2349: l_ap_bb_id hxc_time_building_blocks.time_building_block_id%type;

Line 2349: l_ap_bb_id hxc_time_building_blocks.time_building_block_id%type;

2345: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
2346:
2347:
2348:
2349: l_ap_bb_id hxc_time_building_blocks.time_building_block_id%type;
2350: l_validate_flag varchar2(15);
2351: l_tc_has_details_flag varchar2(15);
2352:
2353: --

Line 3624: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;

3620: p_result in out nocopy varchar2)
3621: is
3622: l_proc constant varchar2(61) := g_pkg || '.' || 'launch_wf_process';
3623: l_item_key number;
3624: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
3625: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
3626: l_wf_item_type hxc_approval_comps.wf_item_type%type;
3627: l_wf_process_name hxc_approval_comps.wf_name%type;
3628: l_apr_person_id per_all_assignments_f.person_id%type;

Line 3625: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;

3621: is
3622: l_proc constant varchar2(61) := g_pkg || '.' || 'launch_wf_process';
3623: l_item_key number;
3624: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
3625: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
3626: l_wf_item_type hxc_approval_comps.wf_item_type%type;
3627: l_wf_process_name hxc_approval_comps.wf_name%type;
3628: l_apr_person_id per_all_assignments_f.person_id%type;
3629: l_resource_id per_all_assignments_f.person_id%type;

Line 3747: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;

3743: p_result in out nocopy varchar2)
3744: is
3745: l_proc constant varchar2(61) := g_pkg || '.' || 'test_wf_result';
3746: l_datetime constant date := SYSDATE;
3747: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
3748: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
3749: l_apr_rej_reason varchar2(2000);
3750: l_wf_apr_result varchar2(80);
3751: begin

Line 3748: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;

3744: is
3745: l_proc constant varchar2(61) := g_pkg || '.' || 'test_wf_result';
3746: l_datetime constant date := SYSDATE;
3747: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
3748: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
3749: l_apr_rej_reason varchar2(2000);
3750: l_wf_apr_result varchar2(80);
3751: begin
3752: --sb_msgs_pkg.begin_call(l_proc);

Line 3827: l_next_period_id hxc_time_building_blocks.time_building_block_id%TYPE;

3823: p_funcmode in varchar2,
3824: p_result in out nocopy varchar2
3825: )
3826: IS
3827: l_next_period_id hxc_time_building_blocks.time_building_block_id%TYPE;
3828: l_next_period_ovn hxc_time_building_blocks.object_version_number%TYPE;
3829:
3830:
3831: l_proc VARCHAR2(150);

Line 3828: l_next_period_ovn hxc_time_building_blocks.object_version_number%TYPE;

3824: p_result in out nocopy varchar2
3825: )
3826: IS
3827: l_next_period_id hxc_time_building_blocks.time_building_block_id%TYPE;
3828: l_next_period_ovn hxc_time_building_blocks.object_version_number%TYPE;
3829:
3830:
3831: l_proc VARCHAR2(150);
3832: