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_TIMECARD_PROPERTIES dependencies on HXC_TIMECARD

Line 1: PACKAGE BODY hxc_timecard_properties AS

1: PACKAGE BODY hxc_timecard_properties AS
2: /* $Header: hxctcprops.pkb 120.14 2008/02/25 10:58:32 rchennur noship $ */
3:
4: c_alias_name CONSTANT varchar2(27) := 'TcWTcrdAliasesTimecardAlias';
5: c_alias_type CONSTANT varchar2(23) := 'TcWTcrdAliasesAliasType';

Line 466: p_props in out nocopy hxc_timecard_prop_table_type) is

462: -- in begin_approval to determine whether to 'approve
463: -- on submit'
464: procedure get_assignment_information
465: (p_resource_id in number,
466: p_props in out nocopy hxc_timecard_prop_table_type) is
467: -- fix v115.18 bug no. 3491084
468: -- New boolean
469: l_asg_exists BOOLEAN:= FALSE;
470:

Line 560: p_props(p_props.last) := hxc_timecard_prop_type

556: -- Populate property structure
557: --
558: for i in 1..l_asg_index loop
559: p_props.extend();
560: p_props(p_props.last) := hxc_timecard_prop_type
561: ('ResourceAssignmentId',
562: null,
563: l_assignment_start(i),
564: l_assignment_end(i),

Line 570: p_props(p_props.last) := hxc_timecard_prop_type

566: );
567: end loop;
568: for i in 1..l_asg_index loop
569: p_props.extend();
570: p_props(p_props.last) := hxc_timecard_prop_type
571: ('ResourceAssignmentNumber',
572: null,
573: l_assignment_start(i),
574: l_assignment_end(i),

Line 580: p_props(p_props.last) := hxc_timecard_prop_type

576: );
577: end loop;
578: for i in 1..l_asg_index loop
579: p_props.extend();
580: p_props(p_props.last) := hxc_timecard_prop_type
581: ('ResourceAssignmentStartDate',
582: null,
583: l_assignment_start(i),
584: l_assignment_end(i),

Line 590: p_props(p_props.last) := hxc_timecard_prop_type

586: );
587: end loop;
588: for i in 1..l_asg_index loop
589: p_props.extend();
590: p_props(p_props.last) := hxc_timecard_prop_type
591: ('ResourceAssignmentEndDate',
592: null,
593: l_assignment_start(i),
594: l_assignment_end(i),

Line 600: p_props(p_props.last) := hxc_timecard_prop_type

596: );
597: end loop;
598: for i in 1..l_asg_index loop
599: p_props.extend();
600: p_props(p_props.last) := hxc_timecard_prop_type
601: ('ResourceAssignmentStatusType',
602: null,
603: l_assignment_start(i),
604: l_assignment_end(i),

Line 643: ,p_props in out nocopy hxc_timecard_prop_table_type) is

639: END setup_mo_global_params;
640:
641:
642: PROCEDURE get_org_id ( p_resource_id in number
643: ,p_props in out nocopy hxc_timecard_prop_table_type) is
644:
645: l_operating_unit_id NUMBER(15);
646:
647: BEGIN

Line 659: p_props(p_props.last) := hxc_timecard_prop_type

655: -- now add the operating unit to the timecard props record
656:
657: p_props.extend();
658:
659: p_props(p_props.last) := hxc_timecard_prop_type
660: ('ResourceOrgId'
661: ,null
662: ,hr_general.start_of_time
663: ,hr_general.end_of_time

Line 677: ,p_props in out nocopy hxc_timecard_prop_table_type) is

673: procedure get_period_information
674: (p_period_id in NUMBER
675: ,p_start_date in date
676: ,p_end_date in date
677: ,p_props in out nocopy hxc_timecard_prop_table_type) is
678:
679: cursor c_period_info
680: (p_recurring_period_id in HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE) is
681: select rp.period_type

Line 732: p_props(p_props.last) := hxc_timecard_prop_type

728: if(NOT g_period_list_cache.exists(p_period_id)) then
729: g_period_list_cache(p_period_id) := p_props.last;
730: end if;
731:
732: p_props(p_props.last) := hxc_timecard_prop_type
733: ('PeriodType'
734: ,null
735: ,p_start_date
736: ,p_end_date

Line 741: p_props(p_props.last) := hxc_timecard_prop_type

737: ,l_period_type
738: );
739:
740: p_props.extend();
741: p_props(p_props.last) := hxc_timecard_prop_type
742: ('PeriodDurationInDays'
743: ,null
744: ,p_start_date
745: ,p_end_date

Line 750: p_props(p_props.last) := hxc_timecard_prop_type

746: ,l_duration_in_days
747: );
748:
749: p_props.extend();
750: p_props(p_props.last) := hxc_timecard_prop_type
751: ('PeriodNumberPerFiscalYear'
752: ,null
753: ,p_start_date
754: ,p_end_date

Line 759: p_props(p_props.last) := hxc_timecard_prop_type

755: ,l_number_per_fiscal_year
756: );
757:
758: p_props.extend();
759: p_props(p_props.last) := hxc_timecard_prop_type
760: ('PeriodStartDate'
761: ,null
762: ,p_start_date
763: ,p_end_date

Line 771: ,p_props in out nocopy hxc_timecard_prop_table_type) is

767: end get_period_information;
768:
769: procedure get_personal_information
770: (p_resource_id in number
771: ,p_props in out nocopy hxc_timecard_prop_table_type) is
772:
773: cursor c_full_name(p_pid in number) is
774: select distinct full_name, effective_start_date, effective_end_date
775: from per_all_people_f

Line 786: p_props(p_props.last) := hxc_timecard_prop_type

782: for name_rec in c_full_name(p_resource_id) loop
783:
784: p_props.extend();
785:
786: p_props(p_props.last) := hxc_timecard_prop_type
787: ('ResourceIdentifierName'
788: ,null
789: ,name_rec.effective_start_date
790: ,name_rec.effective_end_date

Line 832: ,p_props in out nocopy hxc_timecard_prop_table_type

828: (p_alias_definition_id in number
829: ,p_alias_property_number in varchar2
830: ,p_date_from in date
831: ,p_date_to in date
832: ,p_props in out nocopy hxc_timecard_prop_table_type
833: ) is
834:
835: l_alias_reference hxc_alias_types.reference_object%type;
836: begin

Line 842: p_props(p_props.last) := hxc_timecard_prop_type

838: l_alias_reference := get_alias_reference_object(p_alias_definition_id);
839: if(l_alias_reference is not null) then
840:
841: p_props.extend();
842: p_props(p_props.last) := hxc_timecard_prop_type
843: (c_alias_type||p_alias_property_number
844: ,null
845: ,p_date_from
846: ,p_date_to

Line 877: ,p_property_table out nocopy HXC_TIMECARD_PROP_TABLE_TYPE

873: (p_validate in VARCHAR2
874: ,p_resource_id in NUMBER
875: ,p_timecard_start_time in VARCHAR2
876: ,p_timecard_stop_time in VARCHAR2
877: ,p_property_table out nocopy HXC_TIMECARD_PROP_TABLE_TYPE
878: ) is
879:
880: l_messages hxc_message_table_type;
881: l_timecard_start_time date := sysdate;

Line 903: hxc_timecard_message_helper.processErrors(l_messages);

899: ,p_messages => l_messages
900: ,p_property_table => p_property_table
901: );
902:
903: hxc_timecard_message_helper.processErrors(l_messages);
904:
905: End get_preference_properties;
906:
907: --

Line 915: p_property_table out nocopy HXC_TIMECARD_PROP_TABLE_TYPE,

911: (p_validate in VARCHAR2,
912: p_resource_id in NUMBER,
913: p_timecard_start_time in VARCHAR2,
914: p_timecard_stop_time in VARCHAR2,
915: p_property_table out nocopy HXC_TIMECARD_PROP_TABLE_TYPE,
916: p_messages out nocopy HXC_MESSAGE_TABLE_TYPE
917: ) is
918:
919: l_timecard_start_time date;

Line 954: ,p_property_table out nocopy HXC_TIMECARD_PROP_TABLE_TYPE

950: ,p_timecard_start_time in date
951: ,p_timecard_stop_time in date
952: ,p_for_timecard in BOOLEAN
953: ,p_messages in out nocopy hxc_message_table_type
954: ,p_property_table out nocopy HXC_TIMECARD_PROP_TABLE_TYPE
955: ) is
956: Begin
957:
958: get_preference_properties

Line 981: ,p_property_table out nocopy HXC_TIMECARD_PROP_TABLE_TYPE

977: ,p_for_timecard in BOOLEAN
978: ,p_timecard_bb_id in hxc_time_building_blocks.time_building_block_id%type
979: ,p_timecard_bb_ovn in hxc_time_building_blocks.object_version_number%type
980: ,p_messages in out nocopy hxc_message_table_type
981: ,p_property_table out nocopy HXC_TIMECARD_PROP_TABLE_TYPE
982: ) is
983:
984: l_pref_table HXC_PREFERENCE_EVALUATION.T_PREF_TABLE;
985:

Line 1013: p_property_table := hxc_timecard_prop_table_type();

1009: if(p_messages is null) then
1010: p_messages := hxc_message_table_type();
1011: end if;
1012:
1013: p_property_table := hxc_timecard_prop_table_type();
1014:
1015: -- l_date := earliest_date(p_resource_id);
1016:
1017: l_date := to_date('1990/01/01','YYYY/MM/DD');

Line 1038: if(p_validate = hxc_timecard.c_yes) then

1034: -- operation, but pass submit in anyway, this value
1035: -- isn't used in that package.
1036: --
1037:
1038: if(p_validate = hxc_timecard.c_yes) then
1039: hxc_setup_validation_pkg.execute_otc_validation
1040: (p_operation => hxc_timecard.c_submit
1041: ,p_resource_id => p_resource_id
1042: ,p_timecard_bb_id => p_timecard_bb_id

Line 1040: (p_operation => hxc_timecard.c_submit

1036: --
1037:
1038: if(p_validate = hxc_timecard.c_yes) then
1039: hxc_setup_validation_pkg.execute_otc_validation
1040: (p_operation => hxc_timecard.c_submit
1041: ,p_resource_id => p_resource_id
1042: ,p_timecard_bb_id => p_timecard_bb_id
1043: ,p_timecard_bb_ovn => p_timecard_bb_ovn
1044: ,p_start_date => p_timecard_start_time

Line 1058: p_property_table(l_prop_index) := hxc_timecard_prop_type

1054: -- the period list generation code.
1055: --
1056: p_property_table.extend();
1057: l_prop_index := p_property_table.last;
1058: p_property_table(l_prop_index) := hxc_timecard_prop_type
1059: ('ResourceEarliestAssignmentDate'
1060: ,null
1061: ,to_date('0001/01/01','YYYY/MM/DD')
1062: ,to_date('4712/12/31','YYYY/MM/DD')

Line 1112: p_property_table(l_prop_index) := hxc_timecard_prop_type

1108: l_property_name := 'EffectiveTimecardPeriodFutureDate';
1109: l_property_value := to_char((sysdate+to_number(l_property_value)),'YYYY/MM/DD');
1110: end if;
1111:
1112: p_property_table(l_prop_index) := hxc_timecard_prop_type
1113: (l_property_name
1114: ,null
1115: ,l_pref_table(l_index).start_date
1116: ,l_pref_table(l_index).end_date

Line 1160: -- properties now matters to hxc_timecard_approval

1156:
1157: get_org_id ( p_resource_id, p_property_table );
1158: -- 115.31
1159: -- Made this the last call as the order of the
1160: -- properties now matters to hxc_timecard_approval
1161: get_assignment_information
1162: (p_resource_id
1163: ,p_property_table
1164: );

Line 1169: (p_props in HXC_TIMECARD_PROP_TABLE_TYPE

1165:
1166: end get_preference_properties;
1167:
1168: Function find_property_value
1169: (p_props in HXC_TIMECARD_PROP_TABLE_TYPE
1170: ,p_name in varchar2
1171: ,p_code in varchar2
1172: ,p_segment in number
1173: ,p_start_date in date

Line 1204: (p_props in HXC_TIMECARD_PROP_TABLE_TYPE

1200:
1201: End find_property_value;
1202:
1203: Function find_property_value
1204: (p_props in HXC_TIMECARD_PROP_TABLE_TYPE
1205: ,p_name in varchar2
1206: ,p_code in hxc_pref_hierarchies.code%type
1207: ,p_segment in number
1208: ,p_date in date

Line 1279: END hxc_timecard_properties;

1275: return l_property_value;
1276:
1277: End find_property_value;
1278:
1279: END hxc_timecard_properties;