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.RCV_HXT_GRP dependencies on HXC_TIME_BUILDING_BLOCKS

Line 6: ( timecard_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE

2: /* $Header: RCVGHXTB.pls 120.19.12020000.3 2013/02/10 23:10:04 vegajula ship $ */
3:
4: -- record for all timecard attributes interesting to Purchasing
5: TYPE TimecardAttributesRec IS RECORD
6: ( timecard_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
7: , timecard_bb_ovn HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
8: , timecard_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE
9: , timecard_stop_time HXC_TIME_BUILDING_BLOCKS.stop_time%TYPE
10: , timecard_approval_status HXC_TIMECARD_SUMMARY.approval_status%TYPE

Line 7: , timecard_bb_ovn HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE

3:
4: -- record for all timecard attributes interesting to Purchasing
5: TYPE TimecardAttributesRec IS RECORD
6: ( timecard_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
7: , timecard_bb_ovn HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
8: , timecard_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE
9: , timecard_stop_time HXC_TIME_BUILDING_BLOCKS.stop_time%TYPE
10: , timecard_approval_status HXC_TIMECARD_SUMMARY.approval_status%TYPE
11: , timecard_approval_date HXC_TIME_BUILDING_BLOCKS.date_from%TYPE

Line 8: , timecard_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE

4: -- record for all timecard attributes interesting to Purchasing
5: TYPE TimecardAttributesRec IS RECORD
6: ( timecard_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
7: , timecard_bb_ovn HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
8: , timecard_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE
9: , timecard_stop_time HXC_TIME_BUILDING_BLOCKS.stop_time%TYPE
10: , timecard_approval_status HXC_TIMECARD_SUMMARY.approval_status%TYPE
11: , timecard_approval_date HXC_TIME_BUILDING_BLOCKS.date_from%TYPE
12: , timecard_submission_date HXC_TIMECARD_SUMMARY.submission_date%TYPE

Line 9: , timecard_stop_time HXC_TIME_BUILDING_BLOCKS.stop_time%TYPE

5: TYPE TimecardAttributesRec IS RECORD
6: ( timecard_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
7: , timecard_bb_ovn HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
8: , timecard_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE
9: , timecard_stop_time HXC_TIME_BUILDING_BLOCKS.stop_time%TYPE
10: , timecard_approval_status HXC_TIMECARD_SUMMARY.approval_status%TYPE
11: , timecard_approval_date HXC_TIME_BUILDING_BLOCKS.date_from%TYPE
12: , timecard_submission_date HXC_TIMECARD_SUMMARY.submission_date%TYPE
13: , timecard_comment HXC_TIME_BUILDING_BLOCKS.comment_text%TYPE

Line 11: , timecard_approval_date HXC_TIME_BUILDING_BLOCKS.date_from%TYPE

7: , timecard_bb_ovn HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
8: , timecard_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE
9: , timecard_stop_time HXC_TIME_BUILDING_BLOCKS.stop_time%TYPE
10: , timecard_approval_status HXC_TIMECARD_SUMMARY.approval_status%TYPE
11: , timecard_approval_date HXC_TIME_BUILDING_BLOCKS.date_from%TYPE
12: , timecard_submission_date HXC_TIMECARD_SUMMARY.submission_date%TYPE
13: , timecard_comment HXC_TIME_BUILDING_BLOCKS.comment_text%TYPE
14: , day_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
15: , day_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE

Line 13: , timecard_comment HXC_TIME_BUILDING_BLOCKS.comment_text%TYPE

9: , timecard_stop_time HXC_TIME_BUILDING_BLOCKS.stop_time%TYPE
10: , timecard_approval_status HXC_TIMECARD_SUMMARY.approval_status%TYPE
11: , timecard_approval_date HXC_TIME_BUILDING_BLOCKS.date_from%TYPE
12: , timecard_submission_date HXC_TIMECARD_SUMMARY.submission_date%TYPE
13: , timecard_comment HXC_TIME_BUILDING_BLOCKS.comment_text%TYPE
14: , day_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
15: , day_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE
16: , detail_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
17: , detail_bb_ovn HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE

Line 14: , day_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE

10: , timecard_approval_status HXC_TIMECARD_SUMMARY.approval_status%TYPE
11: , timecard_approval_date HXC_TIME_BUILDING_BLOCKS.date_from%TYPE
12: , timecard_submission_date HXC_TIMECARD_SUMMARY.submission_date%TYPE
13: , timecard_comment HXC_TIME_BUILDING_BLOCKS.comment_text%TYPE
14: , day_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
15: , day_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE
16: , detail_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
17: , detail_bb_ovn HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
18: , detail_type HXC_TIME_BUILDING_BLOCKS.type%TYPE

Line 15: , day_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE

11: , timecard_approval_date HXC_TIME_BUILDING_BLOCKS.date_from%TYPE
12: , timecard_submission_date HXC_TIMECARD_SUMMARY.submission_date%TYPE
13: , timecard_comment HXC_TIME_BUILDING_BLOCKS.comment_text%TYPE
14: , day_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
15: , day_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE
16: , detail_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
17: , detail_bb_ovn HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
18: , detail_type HXC_TIME_BUILDING_BLOCKS.type%TYPE
19: , detail_measure HXC_TIME_BUILDING_BLOCKS.measure%TYPE

Line 16: , detail_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE

12: , timecard_submission_date HXC_TIMECARD_SUMMARY.submission_date%TYPE
13: , timecard_comment HXC_TIME_BUILDING_BLOCKS.comment_text%TYPE
14: , day_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
15: , day_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE
16: , detail_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
17: , detail_bb_ovn HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
18: , detail_type HXC_TIME_BUILDING_BLOCKS.type%TYPE
19: , detail_measure HXC_TIME_BUILDING_BLOCKS.measure%TYPE
20: , detail_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE

Line 17: , detail_bb_ovn HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE

13: , timecard_comment HXC_TIME_BUILDING_BLOCKS.comment_text%TYPE
14: , day_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
15: , day_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE
16: , detail_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
17: , detail_bb_ovn HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
18: , detail_type HXC_TIME_BUILDING_BLOCKS.type%TYPE
19: , detail_measure HXC_TIME_BUILDING_BLOCKS.measure%TYPE
20: , detail_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE
21: , detail_stop_time HXC_TIME_BUILDING_BLOCKS.stop_time%TYPE

Line 18: , detail_type HXC_TIME_BUILDING_BLOCKS.type%TYPE

14: , day_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
15: , day_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE
16: , detail_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
17: , detail_bb_ovn HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
18: , detail_type HXC_TIME_BUILDING_BLOCKS.type%TYPE
19: , detail_measure HXC_TIME_BUILDING_BLOCKS.measure%TYPE
20: , detail_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE
21: , detail_stop_time HXC_TIME_BUILDING_BLOCKS.stop_time%TYPE
22: , detail_uom HXC_TIME_BUILDING_BLOCKS.unit_of_measure%TYPE

Line 19: , detail_measure HXC_TIME_BUILDING_BLOCKS.measure%TYPE

15: , day_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE
16: , detail_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
17: , detail_bb_ovn HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
18: , detail_type HXC_TIME_BUILDING_BLOCKS.type%TYPE
19: , detail_measure HXC_TIME_BUILDING_BLOCKS.measure%TYPE
20: , detail_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE
21: , detail_stop_time HXC_TIME_BUILDING_BLOCKS.stop_time%TYPE
22: , detail_uom HXC_TIME_BUILDING_BLOCKS.unit_of_measure%TYPE
23: , detail_changed VARCHAR2(30)

Line 20: , detail_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE

16: , detail_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
17: , detail_bb_ovn HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
18: , detail_type HXC_TIME_BUILDING_BLOCKS.type%TYPE
19: , detail_measure HXC_TIME_BUILDING_BLOCKS.measure%TYPE
20: , detail_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE
21: , detail_stop_time HXC_TIME_BUILDING_BLOCKS.stop_time%TYPE
22: , detail_uom HXC_TIME_BUILDING_BLOCKS.unit_of_measure%TYPE
23: , detail_changed VARCHAR2(30)
24: , detail_new VARCHAR2(30)

Line 21: , detail_stop_time HXC_TIME_BUILDING_BLOCKS.stop_time%TYPE

17: , detail_bb_ovn HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
18: , detail_type HXC_TIME_BUILDING_BLOCKS.type%TYPE
19: , detail_measure HXC_TIME_BUILDING_BLOCKS.measure%TYPE
20: , detail_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE
21: , detail_stop_time HXC_TIME_BUILDING_BLOCKS.stop_time%TYPE
22: , detail_uom HXC_TIME_BUILDING_BLOCKS.unit_of_measure%TYPE
23: , detail_changed VARCHAR2(30)
24: , detail_new VARCHAR2(30)
25: , detail_deleted VARCHAR2(30)

Line 22: , detail_uom HXC_TIME_BUILDING_BLOCKS.unit_of_measure%TYPE

18: , detail_type HXC_TIME_BUILDING_BLOCKS.type%TYPE
19: , detail_measure HXC_TIME_BUILDING_BLOCKS.measure%TYPE
20: , detail_start_time HXC_TIME_BUILDING_BLOCKS.start_time%TYPE
21: , detail_stop_time HXC_TIME_BUILDING_BLOCKS.stop_time%TYPE
22: , detail_uom HXC_TIME_BUILDING_BLOCKS.unit_of_measure%TYPE
23: , detail_changed VARCHAR2(30)
24: , detail_new VARCHAR2(30)
25: , detail_deleted VARCHAR2(30)
26: , detail_date_from HXC_TIME_BUILDING_BLOCKS.date_from%TYPE

Line 26: , detail_date_from HXC_TIME_BUILDING_BLOCKS.date_from%TYPE

22: , detail_uom HXC_TIME_BUILDING_BLOCKS.unit_of_measure%TYPE
23: , detail_changed VARCHAR2(30)
24: , detail_new VARCHAR2(30)
25: , detail_deleted VARCHAR2(30)
26: , detail_date_from HXC_TIME_BUILDING_BLOCKS.date_from%TYPE
27: , detail_date_to HXC_TIME_BUILDING_BLOCKS.date_to%TYPE
28: , resource_id HXC_TIME_BUILDING_BLOCKS.resource_id%TYPE
29: , po_number PO_HEADERS_ALL.segment1%TYPE
30: , po_header_id PO_HEADERS_ALL.po_header_id%TYPE

Line 27: , detail_date_to HXC_TIME_BUILDING_BLOCKS.date_to%TYPE

23: , detail_changed VARCHAR2(30)
24: , detail_new VARCHAR2(30)
25: , detail_deleted VARCHAR2(30)
26: , detail_date_from HXC_TIME_BUILDING_BLOCKS.date_from%TYPE
27: , detail_date_to HXC_TIME_BUILDING_BLOCKS.date_to%TYPE
28: , resource_id HXC_TIME_BUILDING_BLOCKS.resource_id%TYPE
29: , po_number PO_HEADERS_ALL.segment1%TYPE
30: , po_header_id PO_HEADERS_ALL.po_header_id%TYPE
31: , po_line PO_LINES_ALL.line_num%TYPE

Line 28: , resource_id HXC_TIME_BUILDING_BLOCKS.resource_id%TYPE

24: , detail_new VARCHAR2(30)
25: , detail_deleted VARCHAR2(30)
26: , detail_date_from HXC_TIME_BUILDING_BLOCKS.date_from%TYPE
27: , detail_date_to HXC_TIME_BUILDING_BLOCKS.date_to%TYPE
28: , resource_id HXC_TIME_BUILDING_BLOCKS.resource_id%TYPE
29: , po_number PO_HEADERS_ALL.segment1%TYPE
30: , po_header_id PO_HEADERS_ALL.po_header_id%TYPE
31: , po_line PO_LINES_ALL.line_num%TYPE
32: , po_line_id PO_LINES_ALL.po_line_id%TYPE

Line 932: ( p_timecard_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE

928: RETURN g_assignments_cache(p_po_line_id);
929: END get_assignment;
930:
931: FUNCTION get_rcv_transaction
932: ( p_timecard_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
933: , p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
934: ) RETURN rcv_transactions_cr IS
935: l_api_name CONSTANT varchar2(30) := 'get_rcv_transaction';
936: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;

Line 991: ( p_timecard_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE

987: RETURN g_rcv_transactions_cache(p_timecard_bb_id);
988: END get_rcv_transaction;
989:
990: FUNCTION get_rcv_transaction
991: ( p_timecard_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
992: , p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
993: , p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE
994: , p_project_id IN PO_DISTRIBUTIONS_ALL.project_id%TYPE /* Bug 14609848 */
995: , p_task_id IN PO_DISTRIBUTIONS_ALL.task_id%TYPE /* Bug 14609848 */

Line 1065: ( p_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE

1061: END get_rcv_transaction;
1062:
1063: -- cached wrapper for build_block
1064: FUNCTION build_block
1065: ( p_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
1066: , p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
1067: ) RETURN HXC_USER_TYPE_DEFINITION_GRP.building_block_info IS
1068: BEGIN
1069: g_build_block_calls := g_build_block_calls + 1;

Line 1066: , p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE

1062:
1063: -- cached wrapper for build_block
1064: FUNCTION build_block
1065: ( p_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
1066: , p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
1067: ) RETURN HXC_USER_TYPE_DEFINITION_GRP.building_block_info IS
1068: BEGIN
1069: g_build_block_calls := g_build_block_calls + 1;
1070:

Line 1085: ( p_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE

1081: -- Cached wrapper for build_attribute
1082: -- Returns the first record in the table returned by OTL
1083: -- since 8i does not support table of tables
1084: FUNCTION build_attribute
1085: ( p_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
1086: , p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
1087: , p_attribute_category IN HXC_TIME_ATTRIBUTES.attribute_category%TYPE
1088: ) RETURN HXC_USER_TYPE_DEFINITION_GRP.attribute_info IS
1089: BEGIN

Line 1086: , p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE

1082: -- Returns the first record in the table returned by OTL
1083: -- since 8i does not support table of tables
1084: FUNCTION build_attribute
1085: ( p_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
1086: , p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
1087: , p_attribute_category IN HXC_TIME_ATTRIBUTES.attribute_category%TYPE
1088: ) RETURN HXC_USER_TYPE_DEFINITION_GRP.attribute_info IS
1089: BEGIN
1090: g_build_attribute_calls := g_build_attribute_calls + 1;

Line 1206: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;

1202: PROCEDURE Sort_Attributes
1203: ( p_all_attributes IN OUT NOCOPY TimecardAttributesTbl
1204: , p_raw_attributes IN HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info
1205: ) IS
1206: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
1207: l_api_name CONSTANT varchar2(30) := 'Sort_Attributes';
1208: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
1209: BEGIN
1210: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

Line 3365: ( p_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE

3361: );
3362: END Capture_Old_Timecard_Info;
3363:
3364: PROCEDURE Query_Timecard_Info
3365: ( p_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
3366: , p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
3367: , p_attributes_rec IN OUT NOCOPY TimecardAttributesRec
3368: ) IS
3369: l_api_name CONSTANT varchar2(30) := 'Query_Timecard_Info';

Line 3366: , p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE

3362: END Capture_Old_Timecard_Info;
3363:
3364: PROCEDURE Query_Timecard_Info
3365: ( p_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
3366: , p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
3367: , p_attributes_rec IN OUT NOCOPY TimecardAttributesRec
3368: ) IS
3369: l_api_name CONSTANT varchar2(30) := 'Query_Timecard_Info';
3370: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;

Line 3432: ( failed_timecard_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE

3428: RAISE;
3429: END Query_Timecard_Info;
3430:
3431: PROCEDURE Fail_ROI_Rows
3432: ( failed_timecard_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
3433: , p_rti_rows IN OUT NOCOPY rti_table
3434: ) IS
3435: BEGIN
3436: -- we have to search the entire table because we cannot keep the rows in order of timecard_id

Line 3471: failed_timecard_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;

3467: last_old_blk_idx BINARY_INTEGER;
3468: last_att_idx BINARY_INTEGER;
3469: last_old_att_idx BINARY_INTEGER;
3470:
3471: failed_timecard_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
3472: -- Bug6357273
3473: -- This is added to Propagate the errored Detail block id on those we will get
3474: -- Skipped by this failed Block
3475: failed_detail_block_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;

Line 3475: failed_detail_block_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;

3471: failed_timecard_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
3472: -- Bug6357273
3473: -- This is added to Propagate the errored Detail block id on those we will get
3474: -- Skipped by this failed Block
3475: failed_detail_block_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
3476:
3477: TRANSACTION_FAILED EXCEPTION;
3478: l_api_name CONSTANT varchar2(30) := 'Retrieve_Timecards_Body';
3479: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;

Line 3895: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;

3891: , message => 'Setting Detail Status for blk_idx=' || blk_idx || ' bb_id=' || p_blocks(blk_idx).bb_id
3892: );
3893:
3894: DECLARE
3895: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
3896: l_transaction_type VARCHAR2(100);
3897: l_receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;
3898: l_deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;
3899: l_delete_receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;

Line 4205: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;

4201:
4202: -- errors/warnings cannot be raised during update
4203: PROCEDURE Update_Timecard( p_operation IN VARCHAR2 )
4204: IS
4205: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
4206:
4207: l_all_attributes TimecardAttributesTbl;
4208:
4209: l_blocks HXC_USER_TYPE_DEFINITION_GRP.timecard_info;

Line 4291: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;

4287: l_all_attributes TimecardAttributesTbl;
4288: l_old_attributes TimecardAttributesTbl;
4289: l_attributes_rec TimecardAttributesRec;
4290: l_old_attributes_rec TimecardAttributesRec;
4291: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
4292:
4293: l_blocks HXC_USER_TYPE_DEFINITION_GRP.timecard_info;
4294: l_attributes HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;
4295: l_messages HXC_USER_TYPE_DEFINITION_GRP.message_table;