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.ASO_PA_APR_WF_PVT dependencies on ASO_APR_OBJ_APPROVALS

Line 25: FROM aso_apr_obj_approvals

21: l_api_name varchar2(240):= 'start_aso_approvals';
22:
23: CURSOR C_get_appr_id IS
24: SELECT min(object_approval_id)
25: FROM aso_apr_obj_approvals
26: WHERE object_id = (SELECT object_id
27: FROM aso_apr_obj_approvals
28: WHERE object_approval_id = P_Object_approval_id)
29: AND approval_status = 'PEND';

Line 27: FROM aso_apr_obj_approvals

23: CURSOR C_get_appr_id IS
24: SELECT min(object_approval_id)
25: FROM aso_apr_obj_approvals
26: WHERE object_id = (SELECT object_id
27: FROM aso_apr_obj_approvals
28: WHERE object_approval_id = P_Object_approval_id)
29: AND approval_status = 'PEND';
30:
31: BEGIN

Line 201: from aso_apr_obj_approvals

197: END IF;
198:
199: IF p_update_header_or_detail_flag = 'HEADER' THEN
200: select nvl(object_version_number,0) into l_object_version_number
201: from aso_apr_obj_approvals
202: where object_approval_id=p_object_approval_id;
203:
204: l_object_version_number:=l_object_version_number+1;
205: IF (p_status = 'PEND')

Line 207: UPDATE aso_apr_obj_approvals

203:
204: l_object_version_number:=l_object_version_number+1;
205: IF (p_status = 'PEND')
206: THEN
207: UPDATE aso_apr_obj_approvals
208: SET approval_status = p_status,
209: object_version_number = l_object_version_number,
210: last_update_date = SYSDATE,
211: last_updated_by = g_user_id,

Line 215: UPDATE aso_apr_obj_approvals

211: last_updated_by = g_user_id,
212: last_update_login = g_user_id
213: WHERE object_approval_id = p_object_approval_id;
214: ELSE
215: UPDATE aso_apr_obj_approvals
216: SET approval_status = p_status,
217: object_version_number = l_object_version_number,
218: last_update_date = SYSDATE,
219: end_date = SYSDATE,

Line 288: FROM aso_apr_obj_approvals aoa

284: CURSOR get_application_id (
285: c_object_approval_id NUMBER
286: ) IS
287: SELECT DISTINCT object_id, object_type, application_id
288: FROM aso_apr_obj_approvals aoa
289: WHERE object_approval_id = c_object_approval_id;
290:
291: Begin
292:

Line 361: -- updating the ASO_APR_OBJ_APPROVALS

357: 'Get_Next_Approvers: Unable to get the surrogate approver from AME.',
358: itemtype,
359: itemkey);
360:
361: -- updating the ASO_APR_OBJ_APPROVALS
362: update_approval_status (
363: p_update_header_or_detail_flag => 'HEADER' ,
364: p_object_approval_id => l_approval_id,
365: p_approval_det_id =>null,

Line 463: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa

459: CURSOR OBJECT (
460: c_approval_id NUMBER
461: ) IS
462: SELECT quote_name, quote_number,org_id,quote_header_id
463: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa
464: WHERE qha.quote_header_id = aoa.object_id
465: AND aoa.object_approval_id = c_approval_id;
466:
467: BEGIN

Line 1413: FROM aso_apr_obj_approvals aoa

1409: CURSOR get_application_id (
1410: c_object_approval_id NUMBER
1411: ) IS
1412: SELECT DISTINCT object_id, object_type, application_id
1413: FROM aso_apr_obj_approvals aoa
1414: WHERE object_approval_id = c_object_approval_id;
1415:
1416: begin
1417:

Line 2361: FROM aso_apr_obj_approvals

2357: CURSOR get_quote_header_id (
2358: c_object_approval_id NUMBER
2359: ) IS
2360: SELECT object_id
2361: FROM aso_apr_obj_approvals
2362: WHERE object_approval_id = c_object_approval_id;
2363:
2364: CURSOR check_contract_enabled (
2365: c_quote_header_id NUMBER

Line 2776: FROM aso_apr_obj_approvals aoa, fnd_user fu

2772: CURSOR get_requestor (
2773: l_approval_id NUMBER
2774: ) IS
2775: SELECT aoa.requester_userid, fu.employee_id
2776: FROM aso_apr_obj_approvals aoa, fnd_user fu
2777: WHERE object_approval_id = l_approval_id
2778: AND aoa.requester_userid = fu.user_id
2779: AND SYSDATE BETWEEN fu.start_date AND NVL (
2780: fu.end_date,

Line 2812: from aso_apr_obj_approvals

2808:
2809: END IF;
2810:
2811: select object_id into l_object_id
2812: from aso_apr_obj_approvals
2813: where object_approval_id=approval_id
2814: and approval_Status='PEND';
2815:
2816: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN -- bug 16699364

Line 2827: 'Updating table aso_apr_obj_approvals, status is CAN and approval id :'

2823: END IF;
2824: -- Updating the approval obj table status
2825: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2826: aso_debug_pub.ADD (
2827: 'Updating table aso_apr_obj_approvals, status is CAN and approval id :'
2828: || approval_id,
2829: 1,
2830: 'N'
2831: );

Line 3248: -- updating the ASO_APR_OBJ_APPROVALS

3244: aso_debug_pub.ADD ('Approval ID is : ' || l_approval_id,1,'N');
3245:
3246: aso_debug_pub.ADD ('Calling the update entity procedure setting quote status to REJECTED',1,'N' );
3247: END IF;
3248: -- updating the ASO_APR_OBJ_APPROVALS
3249: update_approval_status (
3250: p_update_header_or_detail_flag => 'HEADER' ,
3251: p_object_approval_id => l_approval_id,
3252: p_approval_det_id =>null,

Line 3335: -- updating the ASO_APR_OBJ_APPROVALS

3331:
3332: aso_debug_pub.ADD ('Calling the update entity procedure setting quote status to APPROVED',1,'N' );
3333: END IF;
3334:
3335: -- updating the ASO_APR_OBJ_APPROVALS
3336: update_approval_status (
3337: p_update_header_or_detail_flag => 'HEADER' ,
3338: p_object_approval_id => l_approval_id,
3339: p_approval_det_id =>null,

Line 3642: from aso_apr_obj_approvals

3638:
3639: l_approval_id:=p_approval_id;
3640:
3641: select object_id into l_qte_header_id
3642: from aso_apr_obj_approvals
3643: where object_approval_id=l_approval_id;
3644:
3645: select quote_name,quote_number into l_quote_name,l_qte_number
3646: from aso_quote_headers_all