APPS.HXC_RETRIEVE_ABSENCES dependencies on HXC_MESSAGE_TABLE_TYPE

Line 442: l_messages HXC_MESSAGE_TABLE_TYPE;

438: l_day_id NUMBER;
439: l_det_id NUMBER;
440: l_att_id NUMBER;
441: l_att_ind NUMBER;
442: l_messages HXC_MESSAGE_TABLE_TYPE;
443: l_UOM VARCHAR2(5);
444:
445:
446: l_tbb_id_reference_table hxc_alias_utility.t_tbb_id_reference;

Line 450: g_messages := HXC_MESSAGE_TABLE_TYPE();

446: l_tbb_id_reference_table hxc_alias_utility.t_tbb_id_reference;
447:
448: BEGIN
449:
450: g_messages := HXC_MESSAGE_TABLE_TYPE();
451:
452: --p_end_date:=trunc(p_end_date); --
453:
454:

Line 685: l_messages HXC_MESSAGE_TABLE_TYPE;

681: l_day_id NUMBER;
682: l_det_id NUMBER;
683: l_att_id NUMBER;
684: l_att_ind NUMBER;
685: l_messages HXC_MESSAGE_TABLE_TYPE;
686: l_UOM VARCHAR2(5);
687:
688: l_tbb_id_reference_table hxc_alias_utility.t_tbb_id_reference;
689:

Line 694: g_messages := HXC_MESSAGE_TABLE_TYPE();

690: i BINARY_INTEGER;
691:
692: BEGIN
693:
694: g_messages := HXC_MESSAGE_TABLE_TYPE();
695:
696: retrieve_absences( p_person_id,
697: p_start_date,
698: p_end_date,

Line 1381: g_messages := HXC_MESSAGE_TABLE_TYPE();

1377: -- Bug 8829088
1378: -- Added this init so that we avoid the ORA-6531 in case of
1379: -- absence of setup.
1380:
1381: g_messages := HXC_MESSAGE_TABLE_TYPE();
1382:
1383:
1384:
1385: IF NVL(FND_PROFILE.VALUE('HR_ABS_OTL_INTEGRATION'),'N') = 'N'

Line 1515: g_messages := HXC_MESSAGE_TABLE_TYPE();

1511: -- Bug 8829088
1512: -- Added this init so that we avoid the ORA-6531 in case of
1513: -- absence of setup.
1514:
1515: g_messages := HXC_MESSAGE_TABLE_TYPE();
1516:
1517: IF NVL(FND_PROFILE.VALUE('HR_ABS_OTL_INTEGRATION'),'N') = 'N'
1518: THEN
1519: RETURN;

Line 1893: l_messages HXC_MESSAGE_TABLE_TYPE;

1889: l_index BINARY_INTEGER;
1890: l_block_ind BINARY_INTEGER;
1891: l_att_ind BINARY_INTEGER;
1892:
1893: l_messages HXC_MESSAGE_TABLE_TYPE;
1894:
1895: l_timecard_id NUMBER := 0;
1896: l_timecard_ovn NUMBER := 0;
1897:

Line 1992: g_messages := HXC_MESSAGE_TABLE_TYPE();

1988: l_att_id := 0;
1989: END IF;
1990:
1991:
1992: g_messages := HXC_MESSAGE_TABLE_TYPE();
1993:
1994: retrieve_absences( p_person_id,
1995: p_start_date,
1996: p_end_date,

Line 2581: p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE)

2577:
2578: PROCEDURE verify_view_only_absences( p_blocks IN HXC_BLOCK_TABLE_TYPE,
2579: p_attributes IN HXC_ATTRIBUTE_TABLE_TYPE,
2580: p_lock_rowid IN VARCHAR2,
2581: p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE)
2582: IS
2583:
2584: CURSOR get_edit_status(p_element_type IN NUMBER)
2585: IS SELECT edit_flag,uom

Line 2775: PROCEDURE add_error_to_tc( p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE,

2771:
2772: END get_abs_name;
2773:
2774:
2775: PROCEDURE add_error_to_tc( p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE,
2776: p_error_code IN VARCHAR2,
2777: p_bb_id IN NUMBER,
2778: p_error_level IN VARCHAR2 DEFAULT hxc_timecard.c_error,
2779: p_token IN VARCHAR2 DEFAULT NULL)

Line 2907: PROCEDURE validate_overlap_absences( p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE,

2903:
2904: -- Bug 8855103
2905: -- Added the below functions to do recipient update validations.
2906:
2907: PROCEDURE validate_overlap_absences( p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE,
2908: p_usertab IN ABSTAB,
2909: p_resource_id IN NUMBER,
2910: p_start_time IN DATE,
2911: p_stop_time IN DATE,

Line 3051: PROCEDURE validate_run_totals_and_pto ( p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE,

3047: END validate_overlap_absences;
3048:
3049:
3050:
3051: PROCEDURE validate_run_totals_and_pto ( p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE,
3052: p_usertab IN ABSTAB,
3053: p_pendtab IN ABSTAB,
3054: p_resource_id IN NUMBER,
3055: p_start_time IN DATE,