APPS.HXC_SELF_SERVICE_TIME_DEPOSIT dependencies on HXC_TIME_RECIPIENTS

Line 1160: (p_time_recipient_id IN HXC_TIME_RECIPIENTS.TIME_RECIPIENT_ID%TYPE

1156:
1157: END set_workflow_info;
1158:
1159: PROCEDURE find_app_deposit_process
1160: (p_time_recipient_id IN HXC_TIME_RECIPIENTS.TIME_RECIPIENT_ID%TYPE
1161: ,p_app_function IN HXC_TIME_RECIPIENTS.APPLICATION_RETRIEVAL_FUNCTION%TYPE
1162: ,p_retrieval_process_id OUT NOCOPY NUMBER) IS
1163:
1164: c_ret_pro retrieval_ref_cursor;

Line 1161: ,p_app_function IN HXC_TIME_RECIPIENTS.APPLICATION_RETRIEVAL_FUNCTION%TYPE

1157: END set_workflow_info;
1158:
1159: PROCEDURE find_app_deposit_process
1160: (p_time_recipient_id IN HXC_TIME_RECIPIENTS.TIME_RECIPIENT_ID%TYPE
1161: ,p_app_function IN HXC_TIME_RECIPIENTS.APPLICATION_RETRIEVAL_FUNCTION%TYPE
1162: ,p_retrieval_process_id OUT NOCOPY NUMBER) IS
1163:
1164: c_ret_pro retrieval_ref_cursor;
1165:

Line 1167: (p_app IN HXC_TIME_RECIPIENTS.TIME_RECIPIENT_ID%TYPE

1163:
1164: c_ret_pro retrieval_ref_cursor;
1165:
1166: CURSOR c_retrieval_process
1167: (p_app IN HXC_TIME_RECIPIENTS.TIME_RECIPIENT_ID%TYPE
1168: ,p_process_name IN HXC_RETRIEVAL_PROCESSES.NAME%TYPE)
1169: IS
1170: SELECT retrieval_process_id
1171: FROM HXC_RETRIEVAL_PROCESSES

Line 3952: FROM hxc_time_recipients tr

3948: ,tr.OBJECT_VERSION_NUMBER
3949: ,tr.APPLICATION_RETRIEVAL_FUNCTION
3950: ,tr.APPLICATION_UPDATE_PROCESS
3951: ,tr.APPL_VALIDATION_PROCESS
3952: FROM hxc_time_recipients tr
3953: ,hxc_application_set_comps_v asc1
3954: where p_application_set_id = asc1.application_set_id
3955: and asc1.time_recipient_id = tr.time_recipient_id;
3956: --

Line 5571: FROM hxc_time_recipients tr

5567: IS
5568: CURSOR csr_time_recipients (p_time_recipient_id IN NUMBER)
5569: IS
5570: SELECT tr.application_retrieval_function
5571: FROM hxc_time_recipients tr
5572: WHERE tr.time_recipient_id = p_time_recipient_id;
5573:
5574: l_retrieval_process_id NUMBER := NULL;
5575: l_retrieval_function VARCHAR2 (2000);