APPS.HXC_SELF_SERVICE_TIMECARD dependencies on HXC_TIME_RECIPIENTS

Line 2715: p_template_procedure HXC_TIME_RECIPIENTS.APPL_DYNAMIC_TEMPLATE_PROCESS%TYPE,

2711: p_blocks.delete(p_block_index);
2712: End remove_blocks;
2713:
2714: procedure get_dynamic_templates_info(
2715: p_template_procedure HXC_TIME_RECIPIENTS.APPL_DYNAMIC_TEMPLATE_PROCESS%TYPE,
2716: p_tp_resource_id IN NUMBER,
2717: p_tp_start_time IN DATE,
2718: p_tp_stop_time IN DATE,
2719: p_attribute_string IN OUT NOCOPY VARCHAR2,

Line 2806: l_template_procedure HXC_TIME_RECIPIENTS.APPL_DYNAMIC_TEMPLATE_PROCESS%TYPE;

2802: l_attribute_index NUMBER := 1;
2803: l_detail_start_date DATE;
2804: l_detail_stop_date DATE;
2805: l_zero_template VARCHAR2(1);
2806: l_template_procedure HXC_TIME_RECIPIENTS.APPL_DYNAMIC_TEMPLATE_PROCESS%TYPE;
2807: l_dyn_template_sql VARCHAR2(2000);
2808: l_process_id HXC_RETRIEVAL_PROCESSES.RETRIEVAL_PROCESS_ID%TYPE;
2809: l_tp_resource_id NUMBER := TO_NUMBER(p_resource_id);
2810: l_tp_start_time DATE := TO_DATE(p_start_time, 'YYYY/MM/DD');

Line 2840: from hxc_time_recipients htr,

2836: p_dyn_template_app IN VARCHAR2
2837: )
2838: IS
2839: select htr.appl_dynamic_template_process
2840: from hxc_time_recipients htr,
2841: fnd_application fa
2842: where fa.application_short_name = p_dyn_template_app
2843: and htr.application_id = fa.application_id;
2844:

Line 2873: p_dyn_template_process IN hxc_time_recipients.appl_dynamic_template_process%TYPE

2869: FROM hxc_retrieval_processes
2870: WHERE name = p_process_name;
2871:
2872: CURSOR c_retrieval_process(
2873: p_dyn_template_process IN hxc_time_recipients.appl_dynamic_template_process%TYPE
2874: )
2875: IS
2876: SELECT hrp.retrieval_process_id
2877: FROM hxc_retrieval_processes hrp,

Line 2878: hxc_time_recipients htr

2874: )
2875: IS
2876: SELECT hrp.retrieval_process_id
2877: FROM hxc_retrieval_processes hrp,
2878: hxc_time_recipients htr
2879: WHERE htr.appl_dynamic_template_process = p_dyn_template_process
2880: AND htr.time_recipient_id = hrp.time_recipient_id;
2881:
2882: BEGIN

Line 4284: ,hxc_time_recipients htr

4280: ,apsum.approver_id
4281: ,apsum.time_category_id
4282: FROM hxc_app_period_summary apsum
4283: ,fnd_application_tl favtl
4284: ,hxc_time_recipients htr
4285: WHERE apsum.application_period_id = p_app_period_id
4286: AND favtl.application_id = htr.application_id
4287: AND htr.time_recipient_id = apsum.time_recipient_id
4288: AND favtl.language = userenv('LANG');

Line 5203: l_template_procedure HXC_TIME_RECIPIENTS.APPL_DYNAMIC_TEMPLATE_PROCESS%TYPE;

5199: l_attribute_count NUMBER;
5200: l_detail_start_date DATE;
5201: l_detail_stop_date DATE;
5202:
5203: l_template_procedure HXC_TIME_RECIPIENTS.APPL_DYNAMIC_TEMPLATE_PROCESS%TYPE;
5204:
5205: l_process_id HXC_RETRIEVAL_PROCESSES.RETRIEVAL_PROCESS_ID%TYPE;
5206: l_tp_resource_id NUMBER := TO_NUMBER(p_resource_id);
5207: l_tp_start_time DATE := TO_DATE(p_start_time, 'YYYY/MM/DD');

Line 5221: from hxc_time_recipients htr,

5217: p_dyn_template_app IN VARCHAR2
5218: )
5219: IS
5220: select htr.appl_dynamic_template_process
5221: from hxc_time_recipients htr,
5222: fnd_application fa
5223: where fa.application_short_name = p_dyn_template_app
5224: and htr.application_id = fa.application_id;
5225:

Line 5235: p_dyn_template_process IN hxc_time_recipients.appl_dynamic_template_process%TYPE

5231: FROM hxc_retrieval_processes
5232: WHERE name = p_process_name;
5233:
5234: CURSOR c_retrieval_process(
5235: p_dyn_template_process IN hxc_time_recipients.appl_dynamic_template_process%TYPE
5236: )
5237: IS
5238: SELECT hrp.retrieval_process_id
5239: FROM hxc_retrieval_processes hrp,

Line 5240: hxc_time_recipients htr

5236: )
5237: IS
5238: SELECT hrp.retrieval_process_id
5239: FROM hxc_retrieval_processes hrp,
5240: hxc_time_recipients htr
5241: WHERE htr.appl_dynamic_template_process = p_dyn_template_process
5242: AND htr.time_recipient_id = hrp.time_recipient_id;
5243:
5244: BEGIN