APPS.HXC_SELF_SERVICE_TIMECARD dependencies on HXC_TIME_RECIPIENTS

Line 3015: p_template_procedure HXC_TIME_RECIPIENTS.APPL_DYNAMIC_TEMPLATE_PROCESS%TYPE,

3011: p_blocks.delete(p_block_index);
3012: End remove_blocks;
3013:
3014: procedure get_dynamic_templates_info(
3015: p_template_procedure HXC_TIME_RECIPIENTS.APPL_DYNAMIC_TEMPLATE_PROCESS%TYPE,
3016: p_tp_resource_id IN NUMBER,
3017: p_tp_start_time IN DATE,
3018: p_tp_stop_time IN DATE,
3019: p_attribute_string IN OUT NOCOPY VARCHAR2,

Line 3106: l_template_procedure HXC_TIME_RECIPIENTS.APPL_DYNAMIC_TEMPLATE_PROCESS%TYPE;

3102: l_attribute_index NUMBER := 1;
3103: l_detail_start_date DATE;
3104: l_detail_stop_date DATE;
3105: l_zero_template VARCHAR2(1);
3106: l_template_procedure HXC_TIME_RECIPIENTS.APPL_DYNAMIC_TEMPLATE_PROCESS%TYPE;
3107: l_dyn_template_sql VARCHAR2(2000);
3108: l_process_id HXC_RETRIEVAL_PROCESSES.RETRIEVAL_PROCESS_ID%TYPE;
3109: l_tp_resource_id NUMBER := TO_NUMBER(p_resource_id);
3110: l_tp_start_time DATE := TO_DATE(p_start_time, 'YYYY/MM/DD');

Line 3140: from hxc_time_recipients htr,

3136: p_dyn_template_app IN VARCHAR2
3137: )
3138: IS
3139: select htr.appl_dynamic_template_process
3140: from hxc_time_recipients htr,
3141: fnd_application fa
3142: where fa.application_short_name = p_dyn_template_app
3143: and htr.application_id = fa.application_id;
3144:

Line 3173: p_dyn_template_process IN hxc_time_recipients.appl_dynamic_template_process%TYPE

3169: FROM hxc_retrieval_processes
3170: WHERE name = p_process_name;
3171:
3172: CURSOR c_retrieval_process(
3173: p_dyn_template_process IN hxc_time_recipients.appl_dynamic_template_process%TYPE
3174: )
3175: IS
3176: SELECT hrp.retrieval_process_id
3177: FROM hxc_retrieval_processes hrp,

Line 3178: hxc_time_recipients htr

3174: )
3175: IS
3176: SELECT hrp.retrieval_process_id
3177: FROM hxc_retrieval_processes hrp,
3178: hxc_time_recipients htr
3179: WHERE htr.appl_dynamic_template_process = p_dyn_template_process
3180: AND htr.time_recipient_id = hrp.time_recipient_id;
3181:
3182: BEGIN

Line 4620: ,hxc_time_recipients htr

4616: ,apsum.approver_id
4617: ,apsum.time_category_id
4618: FROM hxc_app_period_summary apsum
4619: ,fnd_application_tl favtl
4620: ,hxc_time_recipients htr
4621: WHERE apsum.application_period_id = p_app_period_id
4622: AND favtl.application_id = htr.application_id
4623: AND htr.time_recipient_id = apsum.time_recipient_id
4624: AND favtl.language = userenv('LANG');

Line 5622: l_template_procedure HXC_TIME_RECIPIENTS.APPL_DYNAMIC_TEMPLATE_PROCESS%TYPE;

5618: l_attribute_count NUMBER;
5619: l_detail_start_date DATE;
5620: l_detail_stop_date DATE;
5621:
5622: l_template_procedure HXC_TIME_RECIPIENTS.APPL_DYNAMIC_TEMPLATE_PROCESS%TYPE;
5623:
5624: l_process_id HXC_RETRIEVAL_PROCESSES.RETRIEVAL_PROCESS_ID%TYPE;
5625: l_tp_resource_id NUMBER := TO_NUMBER(p_resource_id);
5626: l_tp_start_time DATE := TO_DATE(p_start_time, 'YYYY/MM/DD');

Line 5640: from hxc_time_recipients htr,

5636: p_dyn_template_app IN VARCHAR2
5637: )
5638: IS
5639: select htr.appl_dynamic_template_process
5640: from hxc_time_recipients htr,
5641: fnd_application fa
5642: where fa.application_short_name = p_dyn_template_app
5643: and htr.application_id = fa.application_id;
5644:

Line 5654: p_dyn_template_process IN hxc_time_recipients.appl_dynamic_template_process%TYPE

5650: FROM hxc_retrieval_processes
5651: WHERE name = p_process_name;
5652:
5653: CURSOR c_retrieval_process(
5654: p_dyn_template_process IN hxc_time_recipients.appl_dynamic_template_process%TYPE
5655: )
5656: IS
5657: SELECT hrp.retrieval_process_id
5658: FROM hxc_retrieval_processes hrp,

Line 5659: hxc_time_recipients htr

5655: )
5656: IS
5657: SELECT hrp.retrieval_process_id
5658: FROM hxc_retrieval_processes hrp,
5659: hxc_time_recipients htr
5660: WHERE htr.appl_dynamic_template_process = p_dyn_template_process
5661: AND htr.time_recipient_id = hrp.time_recipient_id;
5662:
5663: BEGIN