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.17 2008/04/27 08:56:05 adbharga noship $ */
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 925: ( p_timecard_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE

921: RETURN g_assignments_cache(p_po_line_id);
922: END get_assignment;
923:
924: FUNCTION get_rcv_transaction
925: ( p_timecard_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
926: , p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
927: ) RETURN rcv_transactions_cr IS
928: l_api_name CONSTANT varchar2(30) := 'get_rcv_transaction';
929: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;

Line 984: ( p_timecard_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE

980: RETURN g_rcv_transactions_cache(p_timecard_bb_id);
981: END get_rcv_transaction;
982:
983: FUNCTION get_rcv_transaction
984: ( p_timecard_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
985: , p_po_line_id IN PO_LINES_ALL.po_line_id%TYPE
986: , p_po_distribution_id IN PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE
987: ) RETURN rcv_transactions_cr IS
988: l_api_name CONSTANT varchar2(30) := 'get_rcv_transaction';

Line 1047: ( p_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE

1043: END get_rcv_transaction;
1044:
1045: -- cached wrapper for build_block
1046: FUNCTION build_block
1047: ( p_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
1048: , p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
1049: ) RETURN HXC_USER_TYPE_DEFINITION_GRP.building_block_info IS
1050: BEGIN
1051: g_build_block_calls := g_build_block_calls + 1;

Line 1048: , p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE

1044:
1045: -- cached wrapper for build_block
1046: FUNCTION build_block
1047: ( p_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
1048: , p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
1049: ) RETURN HXC_USER_TYPE_DEFINITION_GRP.building_block_info IS
1050: BEGIN
1051: g_build_block_calls := g_build_block_calls + 1;
1052:

Line 1067: ( p_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE

1063: -- Cached wrapper for build_attribute
1064: -- Returns the first record in the table returned by OTL
1065: -- since 8i does not support table of tables
1066: FUNCTION build_attribute
1067: ( p_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
1068: , p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
1069: , p_attribute_category IN HXC_TIME_ATTRIBUTES.attribute_category%TYPE
1070: ) RETURN HXC_USER_TYPE_DEFINITION_GRP.attribute_info IS
1071: BEGIN

Line 1068: , p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE

1064: -- Returns the first record in the table returned by OTL
1065: -- since 8i does not support table of tables
1066: FUNCTION build_attribute
1067: ( p_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
1068: , p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
1069: , p_attribute_category IN HXC_TIME_ATTRIBUTES.attribute_category%TYPE
1070: ) RETURN HXC_USER_TYPE_DEFINITION_GRP.attribute_info IS
1071: BEGIN
1072: g_build_attribute_calls := g_build_attribute_calls + 1;

Line 1166: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;

1162: PROCEDURE Sort_Attributes
1163: ( p_all_attributes IN OUT NOCOPY TimecardAttributesTbl
1164: , p_raw_attributes IN HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info
1165: ) IS
1166: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
1167: l_api_name CONSTANT varchar2(30) := 'Sort_Attributes';
1168: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
1169: BEGIN
1170: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

Line 3307: ( p_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE

3303: );
3304: END Capture_Old_Timecard_Info;
3305:
3306: PROCEDURE Query_Timecard_Info
3307: ( p_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
3308: , p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
3309: , p_attributes_rec IN OUT NOCOPY TimecardAttributesRec
3310: ) IS
3311: l_api_name CONSTANT varchar2(30) := 'Query_Timecard_Info';

Line 3308: , p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE

3304: END Capture_Old_Timecard_Info;
3305:
3306: PROCEDURE Query_Timecard_Info
3307: ( p_bb_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
3308: , p_bb_ovn IN HXC_TIME_BUILDING_BLOCKS.object_version_number%TYPE
3309: , p_attributes_rec IN OUT NOCOPY TimecardAttributesRec
3310: ) IS
3311: l_api_name CONSTANT varchar2(30) := 'Query_Timecard_Info';
3312: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;

Line 3364: ( failed_timecard_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE

3360: RAISE;
3361: END Query_Timecard_Info;
3362:
3363: PROCEDURE Fail_ROI_Rows
3364: ( failed_timecard_id IN HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE
3365: , p_rti_rows IN OUT NOCOPY rti_table
3366: ) IS
3367: BEGIN
3368: -- we have to search the entire table because we cannot keep the rows in order of timecard_id

Line 3403: failed_timecard_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;

3399: last_old_blk_idx BINARY_INTEGER;
3400: last_att_idx BINARY_INTEGER;
3401: last_old_att_idx BINARY_INTEGER;
3402:
3403: failed_timecard_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
3404: -- Bug6357273
3405: -- This is added to Propagate the errored Detail block id on those we will get
3406: -- Skipped by this failed Block
3407: failed_detail_block_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;

Line 3407: failed_detail_block_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;

3403: failed_timecard_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
3404: -- Bug6357273
3405: -- This is added to Propagate the errored Detail block id on those we will get
3406: -- Skipped by this failed Block
3407: failed_detail_block_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
3408:
3409: TRANSACTION_FAILED EXCEPTION;
3410: l_api_name CONSTANT varchar2(30) := 'Retrieve_Timecards_Body';
3411: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;

Line 3823: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;

3819: , message => 'Setting Detail Status for blk_idx=' || blk_idx || ' bb_id=' || p_blocks(blk_idx).bb_id
3820: );
3821:
3822: DECLARE
3823: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
3824: l_transaction_type VARCHAR2(100);
3825: l_receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;
3826: l_deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;
3827: l_delete_receive_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;

Line 4135: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;

4131:
4132: -- errors/warnings cannot be raised during update
4133: PROCEDURE Update_Timecard( p_operation IN VARCHAR2 )
4134: IS
4135: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
4136:
4137: l_all_attributes TimecardAttributesTbl;
4138:
4139: l_blocks HXC_USER_TYPE_DEFINITION_GRP.timecard_info;

Line 4221: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;

4217: l_all_attributes TimecardAttributesTbl;
4218: l_old_attributes TimecardAttributesTbl;
4219: l_attributes_rec TimecardAttributesRec;
4220: l_old_attributes_rec TimecardAttributesRec;
4221: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
4222:
4223: l_blocks HXC_USER_TYPE_DEFINITION_GRP.timecard_info;
4224: l_attributes HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;
4225: l_messages HXC_USER_TYPE_DEFINITION_GRP.message_table;