DBA Data[Home] [Help]

APPS.HXC_TIMECARD_PROPERTIES dependencies on HXC_TIMECARD_PROP_TABLE_TYPE

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