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.25.12020000.3 2012/09/13 10:18:37 bbayragi ship $ */
3:
4: c_alias_name CONSTANT varchar2(27) := 'TcWTcrdAliasesTimecardAlias';
5: c_alias_type CONSTANT varchar2(23) := 'TcWTcrdAliasesAliasType';

Line 488: p_props in out nocopy hxc_timecard_prop_table_type) is

484: -- in begin_approval to determine whether to 'approve
485: -- on submit'
486: procedure get_assignment_information
487: (p_resource_id in number,
488: p_props in out nocopy hxc_timecard_prop_table_type) is
489: -- fix v115.18 bug no. 3491084
490: -- New boolean
491: l_asg_exists BOOLEAN:= FALSE;
492:

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

583: -- Populate property structure
584: --
585: for i in 1..l_asg_index loop
586: p_props.extend();
587: p_props(p_props.last) := hxc_timecard_prop_type
588: ('ResourceAssignmentId',
589: null,
590: l_assignment_start(i),
591: l_assignment_end(i),

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

593: );
594: end loop;
595: for i in 1..l_asg_index loop
596: p_props.extend();
597: p_props(p_props.last) := hxc_timecard_prop_type
598: ('ResourceAssignmentNumber',
599: null,
600: l_assignment_start(i),
601: l_assignment_end(i),

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

603: );
604: end loop;
605: for i in 1..l_asg_index loop
606: p_props.extend();
607: p_props(p_props.last) := hxc_timecard_prop_type
608: ('ResourceAssignmentStartDate',
609: null,
610: l_assignment_start(i),
611: l_assignment_end(i),

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

613: );
614: end loop;
615: for i in 1..l_asg_index loop
616: p_props.extend();
617: p_props(p_props.last) := hxc_timecard_prop_type
618: ('ResourceAssignmentEndDate',
619: null,
620: l_assignment_start(i),
621: l_assignment_end(i),

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

623: );
624: end loop;
625: for i in 1..l_asg_index loop
626: p_props.extend();
627: p_props(p_props.last) := hxc_timecard_prop_type
628: ('ResourceAssignmentStatusType',
629: null,
630: l_assignment_start(i),
631: l_assignment_end(i),

Line 670: ,p_props in out nocopy hxc_timecard_prop_table_type) is

666: END setup_mo_global_params;
667:
668:
669: PROCEDURE get_org_id ( p_resource_id in number
670: ,p_props in out nocopy hxc_timecard_prop_table_type) is
671:
672: l_operating_unit_id NUMBER(15);
673:
674: BEGIN

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

682: -- now add the operating unit to the timecard props record
683:
684: p_props.extend();
685:
686: p_props(p_props.last) := hxc_timecard_prop_type
687: ('ResourceOrgId'
688: ,null
689: ,hr_general.start_of_time
690: ,hr_general.end_of_time

Line 704: ,p_props in out nocopy hxc_timecard_prop_table_type) is

700: procedure get_period_information
701: (p_period_id in NUMBER
702: ,p_start_date in date
703: ,p_end_date in date
704: ,p_props in out nocopy hxc_timecard_prop_table_type) is
705:
706: cursor c_period_info
707: (p_recurring_period_id in HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE) is
708: select rp.period_type

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

755: if(NOT g_period_list_cache.exists(p_period_id)) then
756: g_period_list_cache(p_period_id) := p_props.last;
757: end if;
758:
759: p_props(p_props.last) := hxc_timecard_prop_type
760: ('PeriodType'
761: ,null
762: ,p_start_date
763: ,p_end_date

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

764: ,l_period_type
765: );
766:
767: p_props.extend();
768: p_props(p_props.last) := hxc_timecard_prop_type
769: ('PeriodDurationInDays'
770: ,null
771: ,p_start_date
772: ,p_end_date

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

773: ,l_duration_in_days
774: );
775:
776: p_props.extend();
777: p_props(p_props.last) := hxc_timecard_prop_type
778: ('PeriodNumberPerFiscalYear'
779: ,null
780: ,p_start_date
781: ,p_end_date

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

782: ,l_number_per_fiscal_year
783: );
784:
785: p_props.extend();
786: p_props(p_props.last) := hxc_timecard_prop_type
787: ('PeriodStartDate'
788: ,null
789: ,p_start_date
790: ,p_end_date

Line 798: ,p_props in out nocopy hxc_timecard_prop_table_type) is

794: end get_period_information;
795:
796: procedure get_personal_information
797: (p_resource_id in number
798: ,p_props in out nocopy hxc_timecard_prop_table_type) is
799:
800: cursor c_full_name(p_pid in number) is
801: select distinct full_name, effective_start_date, effective_end_date
802: from per_all_people_f

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

809: for name_rec in c_full_name(p_resource_id) loop
810:
811: p_props.extend();
812:
813: p_props(p_props.last) := hxc_timecard_prop_type
814: ('ResourceIdentifierName'
815: ,null
816: ,name_rec.effective_start_date
817: ,name_rec.effective_end_date

Line 859: ,p_props in out nocopy hxc_timecard_prop_table_type

855: (p_alias_definition_id in number
856: ,p_alias_property_number in varchar2
857: ,p_date_from in date
858: ,p_date_to in date
859: ,p_props in out nocopy hxc_timecard_prop_table_type
860: ) is
861:
862: l_alias_reference hxc_alias_types.reference_object%type;
863: begin

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

865: l_alias_reference := get_alias_reference_object(p_alias_definition_id);
866: if(l_alias_reference is not null) then
867:
868: p_props.extend();
869: p_props(p_props.last) := hxc_timecard_prop_type
870: (c_alias_type||p_alias_property_number
871: ,null
872: ,p_date_from
873: ,p_date_to

Line 904: ,p_property_table out nocopy HXC_TIMECARD_PROP_TABLE_TYPE

900: (p_validate in VARCHAR2
901: ,p_resource_id in NUMBER
902: ,p_timecard_start_time in VARCHAR2
903: ,p_timecard_stop_time in VARCHAR2
904: ,p_property_table out nocopy HXC_TIMECARD_PROP_TABLE_TYPE
905: ) is
906:
907: l_messages hxc_message_table_type;
908: l_timecard_start_time date := sysdate;

Line 930: hxc_timecard_message_helper.processErrors(l_messages);

926: ,p_messages => l_messages
927: ,p_property_table => p_property_table
928: );
929:
930: hxc_timecard_message_helper.processErrors(l_messages);
931:
932: End get_preference_properties;
933:
934: --

Line 942: p_property_table out nocopy HXC_TIMECARD_PROP_TABLE_TYPE,

938: (p_validate in VARCHAR2,
939: p_resource_id in NUMBER,
940: p_timecard_start_time in VARCHAR2,
941: p_timecard_stop_time in VARCHAR2,
942: p_property_table out nocopy HXC_TIMECARD_PROP_TABLE_TYPE,
943: p_messages out nocopy HXC_MESSAGE_TABLE_TYPE
944: ) is
945:
946: l_timecard_start_time date;

Line 981: ,p_property_table out nocopy HXC_TIMECARD_PROP_TABLE_TYPE

977: ,p_timecard_start_time in date
978: ,p_timecard_stop_time in date
979: ,p_for_timecard in BOOLEAN
980: ,p_messages in out nocopy hxc_message_table_type
981: ,p_property_table out nocopy HXC_TIMECARD_PROP_TABLE_TYPE
982: ) is
983: Begin
984:
985: get_preference_properties

Line 1008: ,p_property_table out nocopy HXC_TIMECARD_PROP_TABLE_TYPE

1004: ,p_for_timecard in BOOLEAN
1005: ,p_timecard_bb_id in hxc_time_building_blocks.time_building_block_id%type
1006: ,p_timecard_bb_ovn in hxc_time_building_blocks.object_version_number%type
1007: ,p_messages in out nocopy hxc_message_table_type
1008: ,p_property_table out nocopy HXC_TIMECARD_PROP_TABLE_TYPE
1009: ) is
1010:
1011: l_pref_table HXC_PREFERENCE_EVALUATION.T_PREF_TABLE;
1012:

Line 1040: p_property_table := hxc_timecard_prop_table_type();

1036: if(p_messages is null) then
1037: p_messages := hxc_message_table_type();
1038: end if;
1039:
1040: p_property_table := hxc_timecard_prop_table_type();
1041:
1042: -- l_date := earliest_date(p_resource_id);
1043:
1044: l_date := to_date('1990/01/01','YYYY/MM/DD');

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

1157: -- operation, but pass submit in anyway, this value
1158: -- isn't used in that package.
1159: --
1160:
1161: if(p_validate = hxc_timecard.c_yes) then
1162: hxc_setup_validation_pkg.execute_otc_validation
1163: (p_operation => hxc_timecard.c_submit
1164: ,p_resource_id => p_resource_id
1165: ,p_timecard_bb_id => p_timecard_bb_id

Line 1163: (p_operation => hxc_timecard.c_submit

1159: --
1160:
1161: if(p_validate = hxc_timecard.c_yes) then
1162: hxc_setup_validation_pkg.execute_otc_validation
1163: (p_operation => hxc_timecard.c_submit
1164: ,p_resource_id => p_resource_id
1165: ,p_timecard_bb_id => p_timecard_bb_id
1166: ,p_timecard_bb_ovn => p_timecard_bb_ovn
1167: ,p_start_date => p_timecard_start_time

Line 1181: p_property_table(l_prop_index) := hxc_timecard_prop_type

1177: -- the period list generation code.
1178: --
1179: p_property_table.extend();
1180: l_prop_index := p_property_table.last;
1181: p_property_table(l_prop_index) := hxc_timecard_prop_type
1182: ('ResourceEarliestAssignmentDate'
1183: ,null
1184: ,to_date('0001/01/01','YYYY/MM/DD')
1185: ,to_date('4712/12/31','YYYY/MM/DD')

Line 1235: p_property_table(l_prop_index) := hxc_timecard_prop_type

1231: l_property_name := 'EffectiveTimecardPeriodFutureDate';
1232: l_property_value := to_char((sysdate+to_number(l_property_value)),'YYYY/MM/DD');
1233: end if;
1234:
1235: p_property_table(l_prop_index) := hxc_timecard_prop_type
1236: (l_property_name
1237: ,null
1238: ,l_pref_table(l_index).start_date
1239: ,l_pref_table(l_index).end_date

Line 1283: -- properties now matters to hxc_timecard_approval

1279:
1280: get_org_id ( p_resource_id, p_property_table );
1281: -- 115.31
1282: -- Made this the last call as the order of the
1283: -- properties now matters to hxc_timecard_approval
1284: get_assignment_information
1285: (p_resource_id
1286: ,p_property_table
1287: );

Line 1292: (p_props in HXC_TIMECARD_PROP_TABLE_TYPE

1288:
1289: end get_preference_properties;
1290:
1291: Function find_property_value
1292: (p_props in HXC_TIMECARD_PROP_TABLE_TYPE
1293: ,p_name in varchar2
1294: ,p_code in varchar2
1295: ,p_segment in number
1296: ,p_start_date in date

Line 1327: (p_props in HXC_TIMECARD_PROP_TABLE_TYPE

1323:
1324: End find_property_value;
1325:
1326: Function find_property_value
1327: (p_props in HXC_TIMECARD_PROP_TABLE_TYPE
1328: ,p_name in varchar2
1329: ,p_code in hxc_pref_hierarchies.code%type
1330: ,p_segment in number
1331: ,p_date in date

Line 1402: END hxc_timecard_properties;

1398: return l_property_value;
1399:
1400: End find_property_value;
1401:
1402: END hxc_timecard_properties;
1403: