DBA Data[Home] [Help]

APPS.HXC_TIMECARD_PROPERTIES dependencies on HXC_TIMECARD_PROP_TABLE_TYPE

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 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 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 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 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 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 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 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