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 792: l_detail_attributes := HXC_ATTRIBUTE_TABLE_TYPE ();

788:
789:
790:
791: -- Initialize the Local Attribute Types
792: l_detail_attributes := HXC_ATTRIBUTE_TABLE_TYPE ();
793: l_detail_sub_attributes := HXC_ATTRIBUTE_TABLE_TYPE();
794:
795:
796: -- Initialize the TBB ID delete table

Line 793: l_detail_sub_attributes := HXC_ATTRIBUTE_TABLE_TYPE();

789:
790:
791: -- Initialize the Local Attribute Types
792: l_detail_attributes := HXC_ATTRIBUTE_TABLE_TYPE ();
793: l_detail_sub_attributes := HXC_ATTRIBUTE_TABLE_TYPE();
794:
795:
796: -- Initialize the TBB ID delete table
797: IF (l_del_bb_ids.COUNT > 0)

Line 1711: RETURN HXC_ATTRIBUTE_TABLE_TYPE

1707: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1708: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
1709: ,p_template_type IN VARCHAR2
1710: )
1711: RETURN HXC_ATTRIBUTE_TABLE_TYPE
1712: IS
1713: l_block_attributes HXC_ATTRIBUTE_TABLE_TYPE;
1714: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
1715: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;

Line 1713: l_block_attributes HXC_ATTRIBUTE_TABLE_TYPE;

1709: ,p_template_type IN VARCHAR2
1710: )
1711: RETURN HXC_ATTRIBUTE_TABLE_TYPE
1712: IS
1713: l_block_attributes HXC_ATTRIBUTE_TABLE_TYPE;
1714: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
1715: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
1716: l_app_attribute_index NUMBER;
1717: l_block_attribute_index NUMBER := 0;

Line 1720: l_block_attributes := HXC_ATTRIBUTE_TABLE_TYPE();

1716: l_app_attribute_index NUMBER;
1717: l_block_attribute_index NUMBER := 0;
1718:
1719: BEGIN
1720: l_block_attributes := HXC_ATTRIBUTE_TABLE_TYPE();
1721:
1722: l_app_attributes := p_app_attributes;
1723: l_app_attribute_index := l_app_attributes.first;
1724:

Line 1837: ,p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

1833: -----------------------------------------------------------------------------
1834: PROCEDURE assign_block_ids(
1835: p_start_id IN NUMBER
1836: ,p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
1837: ,p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
1838: )
1839: IS
1840: l_timecard_block_id hxc_time_building_blocks.time_building_block_id%TYPE := p_start_id;
1841: l_day_block_id hxc_time_building_blocks.time_building_block_id%TYPE

Line 2142: p_attributes IN HXC_ATTRIBUTE_TABLE_TYPE

2138:
2139:
2140:
2141: FUNCTION get_next_attribute_id(
2142: p_attributes IN HXC_ATTRIBUTE_TABLE_TYPE
2143: )
2144: RETURN NUMBER
2145: IS
2146:

Line 2171: ,p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

2167:
2168: -- update new attributes to ensure we get unique attribute ids
2169: PROCEDURE assign_attribute_ids(
2170: p_start_id IN NUMBER
2171: ,p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
2172: )
2173: IS
2174: l_new_attribute_id NUMBER := p_start_id;
2175: l_new_attribute_index NUMBER;

Line 2190: p_total_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

2186: END assign_attribute_ids;
2187:
2188:
2189: PROCEDURE add_attribute(
2190: p_total_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
2191: ,p_new_attribute IN HXC_ATTRIBUTE_TYPE
2192: ,p_new_block_id IN NUMBER
2193: ,p_new_attribute_id IN OUT NOCOPY NUMBER
2194: )

Line 2210: p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

2206: END add_attribute;
2207:
2208:
2209: PROCEDURE translate_alias(
2210: p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
2211: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
2212: ,p_resource_id IN VARCHAR2
2213: ,p_start_time IN VARCHAR2
2214: ,p_stop_time IN VARCHAR2

Line 2418: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

2414:
2415:
2416: PROCEDURE append_blocks(
2417: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
2418: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
2419: ,p_new_blocks IN HXC_BLOCK_TABLE_TYPE
2420: ,p_new_attributes IN HXC_ATTRIBUTE_TABLE_TYPE
2421: ,p_overwrite IN VARCHAR2
2422: ,p_start_time IN VARCHAR2

Line 2420: ,p_new_attributes IN HXC_ATTRIBUTE_TABLE_TYPE

2416: PROCEDURE append_blocks(
2417: p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
2418: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
2419: ,p_new_blocks IN HXC_BLOCK_TABLE_TYPE
2420: ,p_new_attributes IN HXC_ATTRIBUTE_TABLE_TYPE
2421: ,p_overwrite IN VARCHAR2
2422: ,p_start_time IN VARCHAR2
2423: ,p_stop_time IN VARCHAR2
2424: ,p_resource_id IN VARCHAR2

Line 2431: l_complete_attributes HXC_ATTRIBUTE_TABLE_TYPE;

2427: ,p_remove_redundant_entries IN BOOLEAN
2428: )
2429: IS
2430: l_complete_blocks HXC_BLOCK_TABLE_TYPE;
2431: l_complete_attributes HXC_ATTRIBUTE_TABLE_TYPE;
2432: l_new_blocks HXC_BLOCK_TABLE_TYPE;
2433: l_new_blocks_array HXC_BLOCK_TABLE_TYPE;
2434: l_new_attributes HXC_ATTRIBUTE_TABLE_TYPE;
2435: l_next_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;

Line 2434: l_new_attributes HXC_ATTRIBUTE_TABLE_TYPE;

2430: l_complete_blocks HXC_BLOCK_TABLE_TYPE;
2431: l_complete_attributes HXC_ATTRIBUTE_TABLE_TYPE;
2432: l_new_blocks HXC_BLOCK_TABLE_TYPE;
2433: l_new_blocks_array HXC_BLOCK_TABLE_TYPE;
2434: l_new_attributes HXC_ATTRIBUTE_TABLE_TYPE;
2435: l_next_detail_id hxc_time_building_blocks.time_building_block_id%TYPE;
2436: l_complete_block_count NUMBER;
2437: l_complete_attribute_count NUMBER;
2438: l_new_block_index NUMBER;

Line 2849: RETURN HXC_ATTRIBUTE_TABLE_TYPE

2845: /*
2846: FUNCTION attributes_to_array(
2847: p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
2848: )
2849: RETURN HXC_ATTRIBUTE_TABLE_TYPE
2850: IS
2851: l_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;
2852: l_attribute HXC_ATTRIBUTE_TYPE;
2853: l_array_index NUMBER := 0;

Line 2851: l_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;

2847: p_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
2848: )
2849: RETURN HXC_ATTRIBUTE_TABLE_TYPE
2850: IS
2851: l_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;
2852: l_attribute HXC_ATTRIBUTE_TYPE;
2853: l_array_index NUMBER := 0;
2854: l_attribute_index NUMBER;
2855: l_proc VARCHAR2(50);

Line 2865: l_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();

2861: hr_utility.set_location ( g_package||l_proc, 10);
2862: END IF;
2863:
2864: --initialize attribute array
2865: l_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
2866:
2867: l_attribute_index := p_attributes.first;
2868: LOOP
2869: EXIT WHEN NOT p_attributes.exists(l_attribute_index);

Line 2992: p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE,

2988: */
2989:
2990: PROCEDURE remove_blocks
2991: (p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,
2992: p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE,
2993: p_block_index IN NUMBER
2994: ) is
2995: l_index NUMBER;
2996: l_attr_index NUMBER;

Line 3082: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

3078: ,p_template_code IN VARCHAR2
3079: ,p_approval_status IN VARCHAR2
3080: ,p_approval_style IN VARCHAR2
3081: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
3082: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
3083: ,p_message_string OUT NOCOPY VARCHAR2
3084: ,p_overwrite IN VARCHAR2 DEFAULT 'Y'
3085: ,p_exclude_hours_template in VARCHAR2 DEFAULT 'N'
3086: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE

Line 3094: l_attributes HXC_ATTRIBUTE_TABLE_TYPE;

3090: l_template_handle VARCHAR2(500) := '';
3091: l_template_action VARCHAR2(20) :='';
3092: l_temp_blocks hxc_self_service_time_deposit.timecard_info;
3093: l_blocks HXC_BLOCK_TABLE_TYPE;
3094: l_attributes HXC_ATTRIBUTE_TABLE_TYPE;
3095: l_temp_attributes hxc_self_service_time_deposit.building_block_attribute_info;
3096: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
3097: l_block_string VARCHAR2(32767) := '';
3098: l_attribute_string VARCHAR2(32767) := '';

Line 3901: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

3897: p_resource_id IN VARCHAR2
3898: ,p_start_time IN VARCHAR2
3899: ,p_stop_time IN VARCHAR2
3900: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
3901: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
3902: )
3903: IS
3904: l_resource_id VARCHAR2(50) := NULL;
3905:

Line 3952: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

3948: ,p_resource_type IN VARCHAR2
3949: ,p_start_time IN VARCHAR2
3950: ,p_stop_time IN VARCHAR2
3951: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
3952: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
3953: ,p_message_string OUT NOCOPY VARCHAR2
3954: ,p_review IN VARCHAR2
3955: )
3956: IS

Line 4356: p_attributes in out nocopy hxc_attribute_table_type

4352: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type,
4353: p_start_time in date,
4354: p_stop_time in date,
4355: p_blocks in out nocopy hxc_block_table_type,
4356: p_attributes in out nocopy hxc_attribute_table_type
4357: ) IS
4358:
4359: Begin
4360:

Line 4388: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

4384: p_resource_id IN VARCHAR2
4385: ,p_resource_type IN VARCHAR2
4386: ,p_app_period_id IN VARCHAR2
4387: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
4388: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
4389: ,p_message_string OUT NOCOPY VARCHAR2
4390: ,p_review IN VARCHAR2
4391: ,p_return_timecard IN VARCHAR2 DEFAULT 'Y'
4392: ,p_mode IN VARCHAR2 DEFAULT c_for_approver

Line 4901: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

4897: ,p_template_code IN VARCHAR2
4898: ,p_approval_status IN VARCHAR2
4899: ,p_create_template IN VARCHAR2
4900: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
4901: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
4902: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
4903: ,p_message_string OUT NOCOPY VARCHAR2
4904: ,p_overwrite IN VARCHAR2
4905: ,p_review IN VARCHAR2

Line 4946: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

4942: ,p_template_code IN VARCHAR2
4943: ,p_approval_status IN VARCHAR2
4944: ,p_create_template IN VARCHAR2
4945: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
4946: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
4947: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
4948: ,p_message_string OUT NOCOPY VARCHAR2
4949: ,p_overwrite IN VARCHAR2
4950: ,p_review IN VARCHAR2

Line 4992: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

4988: ,p_template_code IN VARCHAR2
4989: ,p_approval_status IN VARCHAR2
4990: ,p_create_template IN VARCHAR2
4991: ,p_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
4992: ,p_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
4993: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
4994: ,p_message_string OUT NOCOPY VARCHAR2
4995: ,p_overwrite IN VARCHAR2
4996: ,p_review IN VARCHAR2

Line 5032: l_temp_attributes hxc_attribute_table_type;

5028: l_temp_block HXC_BLOCK_TYPE;
5029: l_row_data hxc_trans_display_key_utils.translation_row_used;
5030: l_missing_rows boolean;
5031: l_timecard_id hxc_timecard_summary.timecard_id%type;
5032: l_temp_attributes hxc_attribute_table_type;
5033: i number;
5034:
5035: l_proc VARCHAR2(50);
5036:

Line 5211: l_temp_attributes := hxc_attribute_table_type();

5207: l_timecard_id := p_timecard_id;
5208: end if;
5209:
5210: if(p_attribute_array is null) then
5211: l_temp_attributes := hxc_attribute_table_type();
5212: p_attribute_array := hxc_attribute_table_type();
5213: else
5214: l_temp_attributes := p_attribute_array;
5215: end if;

Line 5212: p_attribute_array := hxc_attribute_table_type();

5208: end if;
5209:
5210: if(p_attribute_array is null) then
5211: l_temp_attributes := hxc_attribute_table_type();
5212: p_attribute_array := hxc_attribute_table_type();
5213: else
5214: l_temp_attributes := p_attribute_array;
5215: end if;
5216:

Line 5282: p_attribute_array := hxc_attribute_table_type();

5278: p_message_string := NULL;
5279: RETURN;
5280: ELSE
5281: p_block_array := hxc_block_table_type();
5282: p_attribute_array := hxc_attribute_table_type();
5283: END IF;
5284:
5285:
5286: IF g_debug THEN

Line 5472: ,p_final_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

5468:
5469:
5470: PROCEDURE add_block_attributes(
5471: p_final_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
5472: ,p_final_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
5473: ,p_new_block_array IN HXC_BLOCK_TABLE_TYPE
5474: ,p_new_attribute_array IN HXC_ATTRIBUTE_TABLE_TYPE
5475: ,p_start_att_id IN NUMBER
5476: )

Line 5474: ,p_new_attribute_array IN HXC_ATTRIBUTE_TABLE_TYPE

5470: PROCEDURE add_block_attributes(
5471: p_final_block_array IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
5472: ,p_final_attribute_array IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
5473: ,p_new_block_array IN HXC_BLOCK_TABLE_TYPE
5474: ,p_new_attribute_array IN HXC_ATTRIBUTE_TABLE_TYPE
5475: ,p_start_att_id IN NUMBER
5476: )
5477: IS
5478: l_final_index NUMBER;

Line 5518: ,p_attribute_array OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE

5514: p_resource_id IN VARCHAR2
5515: ,p_resource_type IN VARCHAR2
5516: ,p_timecard_id IN VARCHAR2
5517: ,p_block_array OUT NOCOPY HXC_BLOCK_TABLE_TYPE
5518: ,p_attribute_array OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
5519: ,p_message_string OUT NOCOPY VARCHAR2
5520: )
5521: IS
5522:

Line 5538: l_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;

5534: l_app_period_id hxc_time_building_blocks.time_building_block_id%TYPE;
5535: l_start_time hxc_timecard_summary.start_time%type;
5536: l_stop_time hxc_timecard_summary.stop_time%type;
5537: l_block_array HXC_BLOCK_TABLE_TYPE;
5538: l_attribute_array HXC_ATTRIBUTE_TABLE_TYPE;
5539: l_message_string VARCHAR(2000) := NULL;
5540: l_count NUMBER;
5541: l_start_block_id NUMBER;
5542: l_start_att_id NUMBER;

Line 5545: p_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();

5541: l_start_block_id NUMBER;
5542: l_start_att_id NUMBER;
5543: BEGIN
5544: p_block_array := HXC_BLOCK_TABLE_TYPE();
5545: p_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
5546:
5547: l_block_array := HXC_BLOCK_TABLE_TYPE();
5548: l_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
5549:

Line 5548: l_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();

5544: p_block_array := HXC_BLOCK_TABLE_TYPE();
5545: p_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
5546:
5547: l_block_array := HXC_BLOCK_TABLE_TYPE();
5548: l_attribute_array := HXC_ATTRIBUTE_TABLE_TYPE();
5549:
5550: l_count := 0;
5551: l_start_block_id := -2;
5552: l_start_att_id := -2;

Line 5610: l_attributes HXC_ATTRIBUTE_TABLE_TYPE;

5606: l_template_handle VARCHAR2(500) := '';
5607: l_template_action VARCHAR2(20) :='';
5608: l_temp_blocks hxc_self_service_time_deposit.timecard_info;
5609: l_blocks HXC_BLOCK_TABLE_TYPE;
5610: l_attributes HXC_ATTRIBUTE_TABLE_TYPE;
5611: l_temp_attributes hxc_self_service_time_deposit.building_block_attribute_info;
5612: l_app_attributes hxc_self_service_time_deposit.app_attributes_info;
5613: l_block_string VARCHAR2(32767) := '';
5614: l_attribute_string VARCHAR2(32767) := '';