APPS.ASO_PA_APR_WF_PVT dependencies on ASO_APR_APPROVAL_DETAILS

Line 228: UPDATE aso_apr_approval_details

224:
225: END IF;
226:
227: IF p_update_header_or_detail_flag = 'DETAIL' THEN
228: UPDATE aso_apr_approval_details
229: SET approver_status = p_status,
230: date_received = SYSDATE,
231: last_update_date = SYSDATE,
232: approver_comments = note,

Line 992: -- This procedure updates the aso_apr_approval_details table based on the approvers response.

988: --Locks:
989: -- None.
990: --Function:
991: -- Workflow activity PL/SQL handler.
992: -- This procedure updates the aso_apr_approval_details table based on the approvers response.
993: --Parameters:
994: --IN:
995: -- Standard workflow IN parameters
996: --OUT:

Line 1406: from aso_apr_approval_details

1402:
1403: cursor get_approver_details(l_approval_det_id number)
1404: is
1405: select name,item_class, item_id,action_type_id,group_or_chain_id,OCCURRENCE
1406: from aso_apr_approval_details
1407: where APPROVAL_DET_ID =l_approval_det_id;
1408:
1409: CURSOR get_application_id (
1410: c_object_approval_id NUMBER

Line 1674: from aso_apr_approval_details

1670: itemkey=> l_child_wf_cur.item_key,
1671: aname=> 'APPROVAL_DET_ID');
1672:
1673: select name into l_child_username
1674: from aso_apr_approval_details
1675: where approval_det_id=l_approval_det_id;
1676:
1677: --pp_debug ('before aborting the flow for l_child_username:'|| l_child_username);
1678:

Line 2185: from ASO_APR_APPROVAL_DETAILS

2181: -- pp_debug('updating data for the l_approval_det_id'||l_approval_det_id);
2182:
2183: select nvl(APPROVER_CATEGORY,'A')
2184: into l_approver_category
2185: from ASO_APR_APPROVAL_DETAILS
2186: where APPROVAL_DET_ID=l_approval_det_id;
2187:
2188: -- updating ASO action history
2189: if l_approver_category='A' then

Line 2389: FROM aso_apr_approval_details

2385: CURSOR get_last_approver (
2386: c_object_approval_id NUMBER
2387: ) IS
2388: SELECT approver_person_id,approver_user_id
2389: FROM aso_apr_approval_details
2390: WHERE object_approval_id = c_object_approval_id
2391: AND approver_sequence = (select max(approver_sequence)
2392: FROM aso_apr_approval_details
2393: WHERE object_approval_id = c_object_approval_id)

Line 2392: FROM aso_apr_approval_details

2388: SELECT approver_person_id,approver_user_id
2389: FROM aso_apr_approval_details
2390: WHERE object_approval_id = c_object_approval_id
2391: AND approver_sequence = (select max(approver_sequence)
2392: FROM aso_apr_approval_details
2393: WHERE object_approval_id = c_object_approval_id)
2394: and rownum=1;
2395:
2396: CURSOR get_user_id ( c_employee_id NUMBER)

Line 2406: FROM aso_apr_approval_details

2402:
2403:
2404: CURSOR get_rejected_approver (c_object_approval_id NUMBER) IS
2405: SELECT approver_person_id,approver_user_id
2406: FROM aso_apr_approval_details
2407: WHERE object_approval_id = c_object_approval_id
2408: AND approver_status = 'REJ';
2409:
2410: BEGIN

Line 3344: from aso_apr_approval_details

3340: p_status => 'APPR',
3341: note => null);
3342:
3343: select count(*) into l_apr_count
3344: from aso_apr_approval_details
3345: where approver_category='A'
3346: and object_approval_id=l_approval_id;
3347:
3348: -- updating quote entity only if there are approvers in the quote