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 775: ,hxc_time_building_blocks tbb

771: apc.wf_name
772: FROM hxc_app_period_summary apsum
773: ,hxc_approval_comps apc
774: ,hxc_tc_ap_links tcl
775: ,hxc_time_building_blocks tbb
776: WHERE apsum.application_period_id = p_application_period_id
777: AND apsum.application_period_ovn = p_application_period_ovn
778: and apsum.application_period_id = tcl.application_period_id
779: and tcl.timecard_id = tbb.time_building_block_id

Line 786: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE

782: and tbb.approval_style_id = apc.approval_style_id
783: and apsum.time_recipient_id = apc.time_recipient_id;
784:
785: CURSOR c_tc_info(
786: p_tc_bbid hxc_time_building_blocks.time_building_block_id%TYPE
787: )
788: IS
789: SELECT tcsum.resource_id,
790: tcsum.start_time,

Line 797: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;

793: WHERE tcsum.timecard_id = p_tc_bbid;
794:
795:
796: l_proc constant varchar2(61) := g_pkg || '.' || 'find_apr_style';
797: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
798: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
799: l_ap_bb_id hxc_time_building_blocks.time_building_block_id%type;
800: l_ap_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
801: l_login fnd_user.user_name%type;

Line 798: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;

794:
795:
796: l_proc constant varchar2(61) := g_pkg || '.' || 'find_apr_style';
797: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
798: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
799: l_ap_bb_id hxc_time_building_blocks.time_building_block_id%type;
800: l_ap_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
801: l_login fnd_user.user_name%type;
802: l_resource_id hxc_time_building_blocks.resource_id%TYPE;

Line 799: l_ap_bb_id hxc_time_building_blocks.time_building_block_id%type;

795:
796: l_proc constant varchar2(61) := g_pkg || '.' || 'find_apr_style';
797: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
798: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
799: l_ap_bb_id hxc_time_building_blocks.time_building_block_id%type;
800: l_ap_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
801: l_login fnd_user.user_name%type;
802: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
803: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;

Line 800: l_ap_bb_ovn hxc_time_building_blocks.time_building_block_id%type;

796: l_proc constant varchar2(61) := g_pkg || '.' || 'find_apr_style';
797: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
798: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
799: l_ap_bb_id hxc_time_building_blocks.time_building_block_id%type;
800: l_ap_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
801: l_login fnd_user.user_name%type;
802: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
803: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
804: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;

Line 802: l_resource_id hxc_time_building_blocks.resource_id%TYPE;

798: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
799: l_ap_bb_id hxc_time_building_blocks.time_building_block_id%type;
800: l_ap_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
801: l_login fnd_user.user_name%type;
802: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
803: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
804: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
805: l_approval_mechanism hxc_approval_comps.approval_mechanism%TYPE;
806: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE;

Line 803: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;

799: l_ap_bb_id hxc_time_building_blocks.time_building_block_id%type;
800: l_ap_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
801: l_login fnd_user.user_name%type;
802: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
803: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
804: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
805: l_approval_mechanism hxc_approval_comps.approval_mechanism%TYPE;
806: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE;
807: l_wf_item_type hxc_approval_comps.wf_item_type%TYPE;

Line 804: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;

800: l_ap_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
801: l_login fnd_user.user_name%type;
802: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
803: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
804: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
805: l_approval_mechanism hxc_approval_comps.approval_mechanism%TYPE;
806: l_approval_mechanism_id hxc_approval_comps.approval_mechanism_id%TYPE;
807: l_wf_item_type hxc_approval_comps.wf_item_type%TYPE;
808: l_wf_name hxc_approval_comps.wf_name%TYPE;

Line 1345: p_ap_bb_id hxc_time_building_blocks.time_building_block_id%TYPE

1341: )
1342: is
1343:
1344: CURSOR c_project_id(
1345: p_ap_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
1346: )
1347: IS
1348: SELECT hta.attribute1
1349: FROM hxc_ap_detail_links apdet

Line 1350: ,hxc_time_building_blocks htbb

1346: )
1347: IS
1348: SELECT hta.attribute1
1349: FROM hxc_ap_detail_links apdet
1350: ,hxc_time_building_blocks htbb
1351: ,hxc_time_attribute_usages htau
1352: ,hxc_time_attributes hta
1353: WHERE apdet.application_period_id = p_ap_bb_id
1354: AND apdet.time_building_block_id = htbb.time_building_block_id

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

1358: AND htau.time_attribute_id = hta.time_attribute_id
1359: AND hta.attribute_category = 'PROJECTS';
1360:
1361: cursor c_project_id_deleted_detail
1362: (p_app_bb_id in hxc_time_building_blocks.time_building_block_id%type) is
1363: select to_number(ta.attribute1)
1364: from hxc_time_building_blocks details,
1365: hxc_time_building_blocks days,
1366: hxc_time_attribute_usages tau,

Line 1364: from hxc_time_building_blocks details,

1360:
1361: cursor c_project_id_deleted_detail
1362: (p_app_bb_id in hxc_time_building_blocks.time_building_block_id%type) is
1363: select to_number(ta.attribute1)
1364: from hxc_time_building_blocks details,
1365: hxc_time_building_blocks days,
1366: hxc_time_attribute_usages tau,
1367: hxc_app_period_summary aps,
1368: hxc_time_Attributes ta

Line 1365: hxc_time_building_blocks days,

1361: cursor c_project_id_deleted_detail
1362: (p_app_bb_id in hxc_time_building_blocks.time_building_block_id%type) is
1363: select to_number(ta.attribute1)
1364: from hxc_time_building_blocks details,
1365: hxc_time_building_blocks days,
1366: hxc_time_attribute_usages tau,
1367: hxc_app_period_summary aps,
1368: hxc_time_Attributes ta
1369: where aps.application_period_id = p_app_bb_id

Line 1378: from hxc_time_building_blocks details2

1374: and details.parent_building_block_ovn = days.object_version_number
1375: and details.date_to <> hr_general.end_of_time
1376: and details.object_version_number =
1377: (select max(details2.object_version_number)
1378: from hxc_time_building_blocks details2
1379: where details.time_building_block_id = details2.time_building_block_id)
1380: and details.time_building_block_id = tau.time_building_block_id
1381: and details.object_version_number = tau.time_building_block_ovn
1382: and tau.time_Attribute_Id = ta.time_attribute_id

Line 1530: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;

1526: p_funcmode in varchar2,
1527: p_result in out nocopy varchar2)
1528: is
1529: l_proc constant varchar2(61) := g_pkg || '.' || 'auto_approval';
1530: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
1531: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
1532: begin
1533: --sb_msgs_pkg.begin_call(l_proc);
1534:

Line 1531: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;

1527: p_result in out nocopy varchar2)
1528: is
1529: l_proc constant varchar2(61) := g_pkg || '.' || 'auto_approval';
1530: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
1531: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
1532: begin
1533: --sb_msgs_pkg.begin_call(l_proc);
1534:
1535: if p_funcmode = 'RUN' then

Line 1590: FROM hxc_time_building_blocks tbb

1586:
1587: CURSOR csr_get_timecard(p_app_per_id NUMBER) IS
1588: SELECT adl.TIME_BUILDING_BLOCK_ID bb_id,
1589: adl.TIME_BUILDING_BLOCK_OVN ovn
1590: FROM hxc_time_building_blocks tbb
1591: , hxc_ap_detail_links adl
1592: WHERE adl.APPLICATION_PERIOD_ID = p_app_per_id
1593: AND
1594: tbb.time_building_block_id = adl.time_building_block_id AND

Line 1600: FROM hxc_time_building_blocks tbb

1596: tbb.date_to = hr_general.end_of_time;
1597:
1598: CURSOR csr_get_person_id(p_app_per_id NUMBER) IS
1599: SELECT resource_id
1600: FROM hxc_time_building_blocks tbb
1601: WHERE tbb.time_building_block_id = p_app_per_id;
1602:
1603: /* Bug fix for 5526281 */
1604: CURSOR get_timecard_start_date(p_app_per_id NUMBER) IS

Line 1607: hxc_time_building_blocks tbb

1603: /* Bug fix for 5526281 */
1604: CURSOR get_timecard_start_date(p_app_per_id NUMBER) IS
1605: SELECT tbb.start_time ,tbb.stop_time
1606: FROM hxc_tc_ap_links htl,
1607: hxc_time_building_blocks tbb
1608: WHERE htl.application_period_id = p_app_per_id
1609: AND tbb.time_building_block_id = htl.timecard_id;
1610:
1611: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS

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

1607: hxc_time_building_blocks tbb
1608: WHERE htl.application_period_id = p_app_per_id
1609: AND tbb.time_building_block_id = htl.timecard_id;
1610:
1611: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS
1612: select date_start from per_periods_of_service where person_id=p_resource_id order by date_start desc;
1613: /* end of bug fix for 5526281 */
1614:
1615: l_tc_rec csr_get_timecard%ROWTYPE;

Line 1619: l_resource_id hxc_time_building_blocks.resource_id%TYPE;

1615: l_tc_rec csr_get_timecard%ROWTYPE;
1616: l_timecard_hrs NUMBER := 0;
1617: l_detail_hrs NUMBER := 0;
1618: l_time_category_id hxc_time_categories.time_category_id%TYPE;
1619: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
1620: l_precision VARCHAR2(4);
1621: l_rounding_rule VARCHAR2(20);
1622: l_tc_start_date date;
1623:

Line 1713: from hxc_time_building_blocks timecard,

1709:
1710: CURSOR csr_get_details
1711: IS
1712: select details.time_building_block_id bb_id, details.object_version_number ovn
1713: from hxc_time_building_blocks timecard,
1714: hxc_time_building_blocks details,
1715: hxc_time_building_blocks days
1716: where timecard.time_building_block_id = days.parent_building_block_id
1717: and timecard.object_version_number = days.parent_building_block_ovn

Line 1714: hxc_time_building_blocks details,

1710: CURSOR csr_get_details
1711: IS
1712: select details.time_building_block_id bb_id, details.object_version_number ovn
1713: from hxc_time_building_blocks timecard,
1714: hxc_time_building_blocks details,
1715: hxc_time_building_blocks days
1716: where timecard.time_building_block_id = days.parent_building_block_id
1717: and timecard.object_version_number = days.parent_building_block_ovn
1718: and days.time_building_block_id = details.parent_building_block_id

Line 1715: hxc_time_building_blocks days

1711: IS
1712: select details.time_building_block_id bb_id, details.object_version_number ovn
1713: from hxc_time_building_blocks timecard,
1714: hxc_time_building_blocks details,
1715: hxc_time_building_blocks days
1716: where timecard.time_building_block_id = days.parent_building_block_id
1717: and timecard.object_version_number = days.parent_building_block_ovn
1718: and days.time_building_block_id = details.parent_building_block_id
1719: and days.object_version_number = details.parent_building_block_ovn

Line 2052: p_tc_id IN hxc_time_building_blocks.time_building_block_id%TYPE

2048:
2049:
2050:
2051: PROCEDURE process_extension_func2(
2052: p_tc_id IN hxc_time_building_blocks.time_building_block_id%TYPE
2053: ,p_tc_ovn IN hxc_time_building_blocks.object_version_number%TYPE
2054: ,p_time_recipient IN hxc_time_recipients.time_recipient_id%TYPE
2055: ,p_ext_func2 IN hxc_time_recipients.extension_function2%TYPE
2056: ,p_previous_approver IN NUMBER

Line 2053: ,p_tc_ovn IN hxc_time_building_blocks.object_version_number%TYPE

2049:
2050:
2051: PROCEDURE process_extension_func2(
2052: p_tc_id IN hxc_time_building_blocks.time_building_block_id%TYPE
2053: ,p_tc_ovn IN hxc_time_building_blocks.object_version_number%TYPE
2054: ,p_time_recipient IN hxc_time_recipients.time_recipient_id%TYPE
2055: ,p_ext_func2 IN hxc_time_recipients.extension_function2%TYPE
2056: ,p_previous_approver IN NUMBER
2057: ,p_next_approver OUT NOCOPY NUMBER

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

2143: where htr.time_recipient_id = p_time_recipient;
2144:
2145:
2146:
2147: cursor c_details_of_timecard( l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type )
2148: is
2149: select 'Y'
2150: from hxc_tc_ap_links tcl,
2151: hxc_ap_detail_links adl

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

2152: where tcl.timecard_id = l_tc_bb_id
2153: and tcl.application_period_id = adl.application_period_id
2154: and rownum < 2;
2155:
2156: cursor c_find_app_per_id( l_ap_bb_id in hxc_time_building_blocks.time_building_block_id%type)
2157: is
2158: SELECT 'Y'
2159: FROM hxc_app_period_summary
2160: WHERE time_category_id = 0

Line 2203: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;

2199: --
2200: l_supervisor_id per_all_assignments_f.supervisor_id%type;
2201: l_next_supervisor_id per_all_assignments_f.supervisor_id%type;
2202: l_login fnd_user.user_name%type;
2203: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
2204: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
2205:
2206:
2207:

Line 2204: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;

2200: l_supervisor_id per_all_assignments_f.supervisor_id%type;
2201: l_next_supervisor_id per_all_assignments_f.supervisor_id%type;
2202: l_login fnd_user.user_name%type;
2203: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
2204: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
2205:
2206:
2207:
2208: l_ap_bb_id hxc_time_building_blocks.time_building_block_id%type;

Line 2208: l_ap_bb_id hxc_time_building_blocks.time_building_block_id%type;

2204: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
2205:
2206:
2207:
2208: l_ap_bb_id hxc_time_building_blocks.time_building_block_id%type;
2209: l_validate_flag varchar2(15);
2210: l_tc_has_details_flag varchar2(15);
2211:
2212: --

Line 3418: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;

3414: p_result in out nocopy varchar2)
3415: is
3416: l_proc constant varchar2(61) := g_pkg || '.' || 'launch_wf_process';
3417: l_item_key number;
3418: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
3419: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
3420: l_wf_item_type hxc_approval_comps.wf_item_type%type;
3421: l_wf_process_name hxc_approval_comps.wf_name%type;
3422: l_apr_person_id per_all_assignments_f.person_id%type;

Line 3419: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;

3415: is
3416: l_proc constant varchar2(61) := g_pkg || '.' || 'launch_wf_process';
3417: l_item_key number;
3418: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
3419: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
3420: l_wf_item_type hxc_approval_comps.wf_item_type%type;
3421: l_wf_process_name hxc_approval_comps.wf_name%type;
3422: l_apr_person_id per_all_assignments_f.person_id%type;
3423: l_resource_id per_all_assignments_f.person_id%type;

Line 3541: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;

3537: p_result in out nocopy varchar2)
3538: is
3539: l_proc constant varchar2(61) := g_pkg || '.' || 'test_wf_result';
3540: l_datetime constant date := SYSDATE;
3541: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
3542: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
3543: l_apr_rej_reason varchar2(2000);
3544: l_wf_apr_result varchar2(80);
3545: begin

Line 3542: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;

3538: is
3539: l_proc constant varchar2(61) := g_pkg || '.' || 'test_wf_result';
3540: l_datetime constant date := SYSDATE;
3541: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
3542: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
3543: l_apr_rej_reason varchar2(2000);
3544: l_wf_apr_result varchar2(80);
3545: begin
3546: --sb_msgs_pkg.begin_call(l_proc);

Line 3621: l_next_period_id hxc_time_building_blocks.time_building_block_id%TYPE;

3617: p_funcmode in varchar2,
3618: p_result in out nocopy varchar2
3619: )
3620: IS
3621: l_next_period_id hxc_time_building_blocks.time_building_block_id%TYPE;
3622: l_next_period_ovn hxc_time_building_blocks.object_version_number%TYPE;
3623:
3624:
3625: l_proc VARCHAR2(150);

Line 3622: l_next_period_ovn hxc_time_building_blocks.object_version_number%TYPE;

3618: p_result in out nocopy varchar2
3619: )
3620: IS
3621: l_next_period_id hxc_time_building_blocks.time_building_block_id%TYPE;
3622: l_next_period_ovn hxc_time_building_blocks.object_version_number%TYPE;
3623:
3624:
3625: l_proc VARCHAR2(150);
3626: