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.HXC_SELF_SERVICE_TIMECARD dependencies on HXC_ATTRIBUTE_TABLE_TYPE

Line 31: FUNCTION get_timecard_layout_id(p_attribute_array IN HXC_ATTRIBUTE_TABLE_TYPE) RETURN varchar2

27: INDEX BY BINARY_INTEGER;
28:
29: --Function to get the timecard layout id.
30:
31: FUNCTION get_timecard_layout_id(p_attribute_array IN HXC_ATTRIBUTE_TABLE_TYPE) RETURN varchar2
32: is
33: l_index number;
34:
35: BEGIN

Line 77: FUNCTION chk_template_override_appr_set(p_template_attributes IN HXC_ATTRIBUTE_TABLE_TYPE)

73: end loop;
74: end get_layout_display_attributes;
75:
76:
77: FUNCTION chk_template_override_appr_set(p_template_attributes IN HXC_ATTRIBUTE_TABLE_TYPE)
78: RETURN BOOLEAN IS
79: l_attribute_index NUMBER;
80: BEGIN
81: l_attribute_index := p_template_attributes.first;

Line 93: PROCEDURE remove_override_approver(p_timecard_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE)

89: return false;
90: END chk_template_override_appr_set;
91:
92: -- remove the override approver.
93: PROCEDURE remove_override_approver(p_timecard_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE)
94: IS
95: l_attribute_index NUMBER;
96: BEGIN
97: l_attribute_index := p_timecard_attributes.first;

Line 114: ,p_timecard_attributes IN HXC_ATTRIBUTE_TABLE_TYPE

110: --Hrs Tempalte preference set.
111:
112: PROCEDURE remove_redundant_attributesets(
113: p_timecard_blocks IN HXC_BLOCK_TABLE_TYPE
114: ,p_timecard_attributes IN HXC_ATTRIBUTE_TABLE_TYPE
115: ,p_zero_template_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
116: ,p_zero_template_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
117: )
118: IS

Line 116: ,p_zero_template_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

112: PROCEDURE remove_redundant_attributesets(
113: p_timecard_blocks IN HXC_BLOCK_TABLE_TYPE
114: ,p_timecard_attributes IN HXC_ATTRIBUTE_TABLE_TYPE
115: ,p_zero_template_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
116: ,p_zero_template_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
117: )
118: IS
119:
120: -- Type to contain the detail building blocks id which needs to be removed as index.

Line 135: l_timecard_detail_attributes HXC_ATTRIBUTE_TABLE_TYPE;

131:
132: l_del_bb_ids r_bb_ids;
133:
134:
135: l_timecard_detail_attributes HXC_ATTRIBUTE_TABLE_TYPE;
136: l_zero_hrs_temp_dtl_attr HXC_ATTRIBUTE_TABLE_TYPE;
137:
138: l_index BINARY_INTEGER;
139: l_index_day BINARY_INTEGER;

Line 136: l_zero_hrs_temp_dtl_attr HXC_ATTRIBUTE_TABLE_TYPE;

132: l_del_bb_ids r_bb_ids;
133:
134:
135: l_timecard_detail_attributes HXC_ATTRIBUTE_TABLE_TYPE;
136: l_zero_hrs_temp_dtl_attr HXC_ATTRIBUTE_TABLE_TYPE;
137:
138: l_index BINARY_INTEGER;
139: l_index_day BINARY_INTEGER;
140: l_index_detail BINARY_INTEGER;

Line 169: l_zero_hrs_temp_dtl_attr := HXC_ATTRIBUTE_TABLE_TYPE ();

165: --details.
166:
167:
168: -- Initialize the Temp Attribute Table
169: l_zero_hrs_temp_dtl_attr := HXC_ATTRIBUTE_TABLE_TYPE ();
170: l_timecard_detail_attributes := HXC_ATTRIBUTE_TABLE_TYPE ();
171:
172:
173:

Line 170: l_timecard_detail_attributes := HXC_ATTRIBUTE_TABLE_TYPE ();

166:
167:
168: -- Initialize the Temp Attribute Table
169: l_zero_hrs_temp_dtl_attr := HXC_ATTRIBUTE_TABLE_TYPE ();
170: l_timecard_detail_attributes := HXC_ATTRIBUTE_TABLE_TYPE ();
171:
172:
173:
174: -- Fetch all the detail attributes of the Zero Hrs Template records.

Line 592: p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE,

588: PROCEDURE modify_to_zero_hrs_template (
589: p_start_time IN VARCHAR2,
590: p_stop_time IN VARCHAR2,
591: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,
592: p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE,
593: p_clear_comment IN VARCHAR2
594: )
595: IS
596:

Line 617: l_detail_attributes HXC_ATTRIBUTE_TABLE_TYPE;

613: l_day_found BOOLEAN;
614: l_det_row_found BOOLEAN;
615:
616: -- Local Types used
617: l_detail_attributes HXC_ATTRIBUTE_TABLE_TYPE;
618: l_detail_sub_attributes HXC_ATTRIBUTE_TABLE_TYPE;
619:
620:
621: l_del_bb_ids r_del_bb_ids;

Line 618: l_detail_sub_attributes HXC_ATTRIBUTE_TABLE_TYPE;

614: l_det_row_found BOOLEAN;
615:
616: -- Local Types used
617: l_detail_attributes HXC_ATTRIBUTE_TABLE_TYPE;
618: l_detail_sub_attributes HXC_ATTRIBUTE_TABLE_TYPE;
619:
620:
621: l_del_bb_ids r_del_bb_ids;
622:

Line 710: l_detail_attributes := HXC_ATTRIBUTE_TABLE_TYPE ();

706: l_index := p_attribute_array.NEXT (l_index);
707: END LOOP; -- l_index IS NOT NULL
708:
709: -- Initialize the Local Attribute Types
710: l_detail_attributes := HXC_ATTRIBUTE_TABLE_TYPE ();
711: l_detail_sub_attributes := HXC_ATTRIBUTE_TABLE_TYPE();
712:
713:
714: -- Initialize the TBB ID delete table

Line 711: l_detail_sub_attributes := HXC_ATTRIBUTE_TABLE_TYPE();

707: END LOOP; -- l_index IS NOT NULL
708:
709: -- Initialize the Local Attribute Types
710: l_detail_attributes := HXC_ATTRIBUTE_TABLE_TYPE ();
711: l_detail_sub_attributes := HXC_ATTRIBUTE_TABLE_TYPE();
712:
713:
714: -- Initialize the TBB ID delete table
715: IF (l_del_bb_ids.COUNT > 0)

Line 1413: RETURN HXC_ATTRIBUTE_TABLE_TYPE

1409: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1410: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
1411: ,p_template_type IN VARCHAR2
1412: )
1413: RETURN HXC_ATTRIBUTE_TABLE_TYPE
1414: IS
1415: l_block_attributes HXC_ATTRIBUTE_TABLE_TYPE;
1416: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
1417: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;

Line 1415: l_block_attributes HXC_ATTRIBUTE_TABLE_TYPE;

1411: ,p_template_type IN VARCHAR2
1412: )
1413: RETURN HXC_ATTRIBUTE_TABLE_TYPE
1414: IS
1415: l_block_attributes HXC_ATTRIBUTE_TABLE_TYPE;
1416: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
1417: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
1418: l_app_attribute_index NUMBER;
1419: l_block_attribute_index NUMBER := 0;

Line 1422: l_block_attributes := HXC_ATTRIBUTE_TABLE_TYPE();

1418: l_app_attribute_index NUMBER;
1419: l_block_attribute_index NUMBER := 0;
1420:
1421: BEGIN
1422: l_block_attributes := HXC_ATTRIBUTE_TABLE_TYPE();
1423:
1424: l_app_attributes := p_app_attributes;
1425: l_app_attribute_index := l_app_attributes.first;
1426:

Line 1539: ,p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

1535: -----------------------------------------------------------------------------
1536: PROCEDURE assign_block_ids(
1537: p_start_id IN NUMBER
1538: ,p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
1539: ,p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
1540: )
1541: IS
1542: l_timecard_block_id hxc_time_building_blocks.time_building_block_id%TYPE := p_start_id;
1543: l_day_block_id hxc_time_building_blocks.time_building_block_id%TYPE

Line 1844: p_attributes IN HXC_ATTRIBUTE_TABLE_TYPE

1840:
1841:
1842:
1843: FUNCTION get_next_attribute_id(
1844: p_attributes IN HXC_ATTRIBUTE_TABLE_TYPE
1845: )
1846: RETURN NUMBER
1847: IS
1848:

Line 1873: ,p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

1869:
1870: -- update new attributes to ensure we get unique attribute ids
1871: PROCEDURE assign_attribute_ids(
1872: p_start_id IN NUMBER
1873: ,p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
1874: )
1875: IS
1876: l_new_attribute_id NUMBER := p_start_id;
1877: l_new_attribute_index NUMBER;

Line 1892: p_total_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

1888: END assign_attribute_ids;
1889:
1890:
1891: PROCEDURE add_attribute(
1892: p_total_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
1893: ,p_new_attribute IN HXC_ATTRIBUTE_TYPE
1894: ,p_new_block_id IN NUMBER
1895: ,p_new_attribute_id IN OUT NOCOPY NUMBER
1896: )

Line 1912: p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

1908: END add_attribute;
1909:
1910:
1911: PROCEDURE translate_alias(
1912: p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
1913: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
1914: ,p_resource_id IN VARCHAR2
1915: ,p_start_time IN VARCHAR2
1916: ,p_stop_time IN VARCHAR2

Line 2120: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

2116:
2117:
2118: PROCEDURE append_blocks(
2119: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
2120: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
2121: ,p_new_blocks IN HXC_BLOCK_TABLE_TYPE
2122: ,p_new_attributes IN HXC_ATTRIBUTE_TABLE_TYPE
2123: ,p_overwrite IN VARCHAR2
2124: ,p_start_time IN VARCHAR2

Line 2122: ,p_new_attributes IN HXC_ATTRIBUTE_TABLE_TYPE

2118: PROCEDURE append_blocks(
2119: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
2120: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
2121: ,p_new_blocks IN HXC_BLOCK_TABLE_TYPE
2122: ,p_new_attributes IN HXC_ATTRIBUTE_TABLE_TYPE
2123: ,p_overwrite IN VARCHAR2
2124: ,p_start_time IN VARCHAR2
2125: ,p_stop_time IN VARCHAR2
2126: ,p_resource_id IN VARCHAR2

Line 2133: l_complete_attributes HXC_ATTRIBUTE_TABLE_TYPE;

2129: ,p_remove_redundant_entries IN BOOLEAN
2130: )
2131: IS
2132: l_complete_blocks HXC_BLOCK_TABLE_TYPE;
2133: l_complete_attributes HXC_ATTRIBUTE_TABLE_TYPE;
2134: l_new_blocks HXC_BLOCK_TABLE_TYPE;
2135: l_new_blocks_array HXC_BLOCK_TABLE_TYPE;
2136: l_new_attributes HXC_ATTRIBUTE_TABLE_TYPE;
2137: l_next_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;

Line 2136: l_new_attributes HXC_ATTRIBUTE_TABLE_TYPE;

2132: l_complete_blocks HXC_BLOCK_TABLE_TYPE;
2133: l_complete_attributes HXC_ATTRIBUTE_TABLE_TYPE;
2134: l_new_blocks HXC_BLOCK_TABLE_TYPE;
2135: l_new_blocks_array HXC_BLOCK_TABLE_TYPE;
2136: l_new_attributes HXC_ATTRIBUTE_TABLE_TYPE;
2137: l_next_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;
2138: l_complete_block_count NUMBER;
2139: l_complete_attribute_count NUMBER;
2140: l_new_block_index NUMBER;

Line 2549: RETURN HXC_ATTRIBUTE_TABLE_TYPE

2545: /*
2546: FUNCTION attributes_to_array(
2547: p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
2548: )
2549: RETURN HXC_ATTRIBUTE_TABLE_TYPE
2550: IS
2551: l_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;
2552: l_attribute HXC_ATTRIBUTE_TYPE;
2553: l_array_index NUMBER := 0;

Line 2551: l_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;

2547: p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
2548: )
2549: RETURN HXC_ATTRIBUTE_TABLE_TYPE
2550: IS
2551: l_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;
2552: l_attribute HXC_ATTRIBUTE_TYPE;
2553: l_array_index NUMBER := 0;
2554: l_attribute_index NUMBER;
2555: l_proc VARCHAR2(50);

Line 2565: l_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();

2561: hr_utility.set_location ( g_package||l_proc, 10);
2562: END IF;
2563:
2564: --initialize attribute array
2565: l_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
2566:
2567: l_attribute_index := p_attributes.first;
2568: LOOP
2569: EXIT WHEN NOT p_attributes.exists(l_attribute_index);

Line 2692: p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE,

2688: */
2689:
2690: PROCEDURE remove_blocks
2691: (p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,
2692: p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE,
2693: p_block_index IN NUMBER
2694: ) is
2695: l_index NUMBER;
2696: l_attr_index NUMBER;

Line 2782: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

2778: ,p_template_code IN VARCHAR2
2779: ,p_approval_status IN VARCHAR2
2780: ,p_approval_style IN VARCHAR2
2781: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
2782: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
2783: ,p_message_string OUT NOCOPY VARCHAR2
2784: ,p_overwrite IN VARCHAR2 DEFAULT 'Y'
2785: ,p_exclude_hours_template in VARCHAR2 DEFAULT 'N'
2786: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

Line 2794: l_attributes HXC_ATTRIBUTE_TABLE_TYPE;

2790: l_template_handle VARCHAR2(500) := '';
2791: l_template_action VARCHAR2(20) :='';
2792: l_temp_blocks hxc_self_service_time_deposit.timecard_info;
2793: l_blocks HXC_BLOCK_TABLE_TYPE;
2794: l_attributes HXC_ATTRIBUTE_TABLE_TYPE;
2795: l_temp_attributes hxc_self_service_time_deposit.building_block_attribute_info;
2796: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
2797: l_block_string VARCHAR2(32767) := '';
2798: l_attribute_string VARCHAR2(32767) := '';

Line 3565: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

3561: p_resource_id IN VARCHAR2
3562: ,p_start_time IN VARCHAR2
3563: ,p_stop_time IN VARCHAR2
3564: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
3565: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
3566: )
3567: IS
3568: l_resource_id VARCHAR2(50) := NULL;
3569:

Line 3616: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

3612: ,p_resource_type IN VARCHAR2
3613: ,p_start_time IN VARCHAR2
3614: ,p_stop_time IN VARCHAR2
3615: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
3616: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
3617: ,p_message_string OUT NOCOPY VARCHAR2
3618: ,p_review IN VARCHAR2
3619: )
3620: IS

Line 4020: p_attributes in out nocopy hxc_attribute_table_type

4016: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type,
4017: p_start_time in date,
4018: p_stop_time in date,
4019: p_blocks in out nocopy hxc_block_table_type,
4020: p_attributes in out nocopy hxc_attribute_table_type
4021: ) IS
4022:
4023: Begin
4024:

Line 4052: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

4048: p_resource_id IN VARCHAR2
4049: ,p_resource_type IN VARCHAR2
4050: ,p_app_period_id IN VARCHAR2
4051: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
4052: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
4053: ,p_message_string OUT NOCOPY VARCHAR2
4054: ,p_review IN VARCHAR2
4055: ,p_return_timecard IN VARCHAR2 DEFAULT 'Y'
4056: ,p_mode IN VARCHAR2 DEFAULT c_for_approver

Line 4565: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

4561: ,p_template_code IN VARCHAR2
4562: ,p_approval_status IN VARCHAR2
4563: ,p_create_template IN VARCHAR2
4564: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
4565: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
4566: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
4567: ,p_message_string OUT NOCOPY VARCHAR2
4568: ,p_overwrite IN VARCHAR2
4569: ,p_review IN VARCHAR2

Line 4610: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

4606: ,p_template_code IN VARCHAR2
4607: ,p_approval_status IN VARCHAR2
4608: ,p_create_template IN VARCHAR2
4609: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
4610: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
4611: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
4612: ,p_message_string OUT NOCOPY VARCHAR2
4613: ,p_overwrite IN VARCHAR2
4614: ,p_review IN VARCHAR2

Line 4656: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

4652: ,p_template_code IN VARCHAR2
4653: ,p_approval_status IN VARCHAR2
4654: ,p_create_template IN VARCHAR2
4655: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
4656: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
4657: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
4658: ,p_message_string OUT NOCOPY VARCHAR2
4659: ,p_overwrite IN VARCHAR2
4660: ,p_review IN VARCHAR2

Line 4696: l_temp_attributes hxc_attribute_table_type;

4692: l_temp_block HXC_BLOCK_TYPE;
4693: l_row_data hxc_trans_display_key_utils.translation_row_used;
4694: l_missing_rows boolean;
4695: l_timecard_id hxc_timecard_summary.timecard_id%type;
4696: l_temp_attributes hxc_attribute_table_type;
4697: i number;
4698:
4699: l_proc VARCHAR2(50);
4700:

Line 4857: l_temp_attributes := hxc_attribute_table_type();

4853: l_timecard_id := p_timecard_id;
4854: end if;
4855:
4856: if(p_attribute_array is null) then
4857: l_temp_attributes := hxc_attribute_table_type();
4858: p_attribute_array := hxc_attribute_table_type();
4859: else
4860: l_temp_attributes := p_attribute_array;
4861: end if;

Line 4858: p_attribute_array := hxc_attribute_table_type();

4854: end if;
4855:
4856: if(p_attribute_array is null) then
4857: l_temp_attributes := hxc_attribute_table_type();
4858: p_attribute_array := hxc_attribute_table_type();
4859: else
4860: l_temp_attributes := p_attribute_array;
4861: end if;
4862:

Line 4928: p_attribute_array := hxc_attribute_table_type();

4924: p_message_string := NULL;
4925: RETURN;
4926: ELSE
4927: p_block_array := hxc_block_table_type();
4928: p_attribute_array := hxc_attribute_table_type();
4929: END IF;
4930:
4931:
4932: IF g_debug THEN

Line 5053: ,p_final_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

5049:
5050:
5051: PROCEDURE add_block_attributes(
5052: p_final_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
5053: ,p_final_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
5054: ,p_new_block_array IN HXC_BLOCK_TABLE_TYPE
5055: ,p_new_attribute_array IN HXC_ATTRIBUTE_TABLE_TYPE
5056: ,p_start_att_id IN NUMBER
5057: )

Line 5055: ,p_new_attribute_array IN HXC_ATTRIBUTE_TABLE_TYPE

5051: PROCEDURE add_block_attributes(
5052: p_final_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
5053: ,p_final_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
5054: ,p_new_block_array IN HXC_BLOCK_TABLE_TYPE
5055: ,p_new_attribute_array IN HXC_ATTRIBUTE_TABLE_TYPE
5056: ,p_start_att_id IN NUMBER
5057: )
5058: IS
5059: l_final_index NUMBER;

Line 5099: ,p_attribute_array OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

5095: p_resource_id IN VARCHAR2
5096: ,p_resource_type IN VARCHAR2
5097: ,p_timecard_id IN VARCHAR2
5098: ,p_block_array OUT NOCOPY HXC_BLOCK_TABLE_TYPE
5099: ,p_attribute_array OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
5100: ,p_message_string OUT NOCOPY VARCHAR2
5101: )
5102: IS
5103:

Line 5119: l_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;

5115: l_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE;
5116: l_start_time hxc_timecard_summary.start_time%type;
5117: l_stop_time hxc_timecard_summary.stop_time%type;
5118: l_block_array HXC_BLOCK_TABLE_TYPE;
5119: l_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;
5120: l_message_string VARCHAR(2000) := NULL;
5121: l_count NUMBER;
5122: l_start_block_id NUMBER;
5123: l_start_att_id NUMBER;

Line 5126: p_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();

5122: l_start_block_id NUMBER;
5123: l_start_att_id NUMBER;
5124: BEGIN
5125: p_block_array := HXC_BLOCK_TABLE_TYPE();
5126: p_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
5127:
5128: l_block_array := HXC_BLOCK_TABLE_TYPE();
5129: l_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
5130:

Line 5129: l_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();

5125: p_block_array := HXC_BLOCK_TABLE_TYPE();
5126: p_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
5127:
5128: l_block_array := HXC_BLOCK_TABLE_TYPE();
5129: l_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
5130:
5131: l_count := 0;
5132: l_start_block_id := -2;
5133: l_start_att_id := -2;

Line 5191: l_attributes HXC_ATTRIBUTE_TABLE_TYPE;

5187: l_template_handle VARCHAR2(500) := '';
5188: l_template_action VARCHAR2(20) :='';
5189: l_temp_blocks hxc_self_service_time_deposit.timecard_info;
5190: l_blocks HXC_BLOCK_TABLE_TYPE;
5191: l_attributes HXC_ATTRIBUTE_TABLE_TYPE;
5192: l_temp_attributes hxc_self_service_time_deposit.building_block_attribute_info;
5193: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
5194: l_block_string VARCHAR2(32767) := '';
5195: l_attribute_string VARCHAR2(32767) := '';