APPS.ASO_APR_WF_PVT dependencies on ASO_APR_OBJ_APPROVALS

Line 18: FROM aso_apr_obj_approvals

14:
15:
16: CURSOR C_get_appr_id IS
17: SELECT min(object_approval_id)
18: FROM aso_apr_obj_approvals
19: WHERE object_id = (SELECT object_id
20: FROM aso_apr_obj_approvals
21: WHERE object_approval_id = P_Object_approval_id)
22: AND approval_status = 'PEND';

Line 20: FROM aso_apr_obj_approvals

16: CURSOR C_get_appr_id IS
17: SELECT min(object_approval_id)
18: FROM aso_apr_obj_approvals
19: WHERE object_id = (SELECT object_id
20: FROM aso_apr_obj_approvals
21: WHERE object_approval_id = P_Object_approval_id)
22: AND approval_status = 'PEND';
23:
24: BEGIN

Line 1427: FROM aso_apr_obj_approvals aoa, fnd_user fu

1423: CURSOR get_requestor (
1424: l_approval_id NUMBER
1425: ) IS
1426: SELECT aoa.requester_userid, fu.employee_id
1427: FROM aso_apr_obj_approvals aoa, fnd_user fu
1428: WHERE object_approval_id = l_approval_id
1429: AND aoa.requester_userid = fu.user_id
1430: AND SYSDATE BETWEEN fu.start_date AND NVL (
1431: fu.end_date,

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

1451: END IF;
1452: -- Updating the approval obj table status
1453: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1454: aso_debug_pub.ADD (
1455: 'Updating table aso_apr_obj_approvals, status is CAN and approval id :'
1456: || approval_id,
1457: 1,
1458: 'N'
1459: );

Line 2236: FROM aso_apr_obj_approvals

2232: CURSOR get_quote_header_id (
2233: c_object_approval_id NUMBER
2234: ) IS
2235: SELECT object_id
2236: FROM aso_apr_obj_approvals
2237: WHERE object_approval_id = c_object_approval_id;
2238:
2239: CURSOR check_contract_enabled (
2240: c_quote_header_id NUMBER

Line 2665: FROM aso_apr_obj_approvals

2661: CURSOR get_object_id (
2662: c_object_approval_id NUMBER
2663: ) IS
2664: SELECT DISTINCT object_id, object_type, application_id
2665: FROM aso_apr_obj_approvals
2666: WHERE object_approval_id = c_object_approval_id;
2667:
2668: CURSOR get_existing_approvers (
2669: c_object_approval_id NUMBER

Line 3451: FROM aso_apr_obj_approvals aoa

3447: CURSOR get_application_id (
3448: c_object_approval_id NUMBER
3449: ) IS
3450: SELECT DISTINCT object_id, object_type, application_id
3451: FROM aso_apr_obj_approvals aoa
3452: WHERE object_approval_id = c_object_approval_id;
3453: BEGIN
3454: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3455: aso_debug_pub.ADD (

Line 4191: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa

4187: CURSOR get_object_details (
4188: c_approval_id NUMBER
4189: ) IS
4190: SELECT quote_header_id, quote_name, quote_number, quote_expiration_date
4191: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa
4192: WHERE qha.quote_header_id = aoa.object_id
4193: AND aoa.object_approval_id = c_approval_id;
4194:
4195: CURSOR get_customer_name (

Line 4220: aso_apr_obj_approvals aoa

4216: ) IS
4217: SELECT ala.description
4218: FROM as_leads_all ala,
4219: aso_quote_related_objects qro,
4220: aso_apr_obj_approvals aoa
4221: WHERE ala.lead_id = qro.object_id
4222: AND qro.relationship_type_code = 'OPP_QUOTE'
4223: AND qro.quote_object_id = aoa.object_id
4224: AND aoa.object_approval_id = c_approval_id;

Line 4230: FROM hz_parties p, aso_quote_headers_all qh,aso_apr_obj_approvals aoa

4226: -- bug 3934660
4227:
4228: CURSOR get_party_type (c_approval_id NUMBER) IS
4229: SELECT P.PARTY_TYPE
4230: FROM hz_parties p, aso_quote_headers_all qh,aso_apr_obj_approvals aoa
4231: WHERE p.party_id = qh.party_id
4232: AND qh.quote_header_id = aoa.object_id
4233: AND aoa.object_approval_id = c_approval_id;
4234:

Line 4241: FROM hz_parties p, hz_relationships r, aso_quote_headers_all qh,aso_apr_obj_approvals aoa

4237: CURSOR get_contact_name (
4238: c_approval_id NUMBER
4239: ) IS
4240: SELECT party_name
4241: FROM hz_parties p, hz_relationships r, aso_quote_headers_all qh,aso_apr_obj_approvals aoa
4242: WHERE p.party_id = r.object_id
4243: AND r.party_id = qh.party_id
4244: AND r.subject_id = qh.cust_party_id
4245: AND r.object_type = 'PERSON'

Line 4588: FROM aso_apr_obj_approvals

4584: CURSOR get_requester_details (
4585: c_approval_id NUMBER
4586: ) IS
4587: SELECT requester_comments
4588: FROM aso_apr_obj_approvals
4589: WHERE object_approval_id = c_approval_id;
4590: BEGIN
4591: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4592: aso_debug_pub.ADD (

Line 5024: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa

5020: CURSOR get_object_details (
5021: c_approval_id NUMBER
5022: ) IS
5023: SELECT quote_header_id, quote_number,qha.org_id
5024: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa
5025: WHERE qha.quote_header_id = aoa.object_id
5026: AND aoa.object_approval_id = c_approval_id;
5027:
5028: -- bug 3934660 replace qha.party_id with cust_party_id

Line 5269: FROM aso_apr_obj_approvals

5265: CURSOR get_application_id (
5266: c_approval_id NUMBER
5267: ) IS
5268: SELECT application_id
5269: FROM aso_apr_obj_approvals
5270: WHERE object_approval_id = c_approval_id;
5271:
5272: -- hyang, bug 2860045, performance fix.
5273: CURSOR get_label (

Line 5423: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa

5419: CURSOR OBJECT (
5420: c_approval_id NUMBER
5421: ) IS
5422: SELECT quote_name, quote_number,org_id,quote_header_id
5423: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa
5424: WHERE qha.quote_header_id = aoa.object_id
5425: AND aoa.object_approval_id = c_approval_id;
5426:
5427: BEGIN

Line 5574: UPDATE aso_apr_obj_approvals

5570:
5571: IF p_update_header_or_detail_flag = 'HEADER' THEN
5572: IF (p_status = 'PEND')
5573: THEN
5574: UPDATE aso_apr_obj_approvals
5575: SET approval_status = p_status,
5576: last_update_date = SYSDATE,
5577: last_updated_by = g_user_id,
5578: last_update_login = g_user_id

Line 5581: UPDATE aso_apr_obj_approvals

5577: last_updated_by = g_user_id,
5578: last_update_login = g_user_id
5579: WHERE object_approval_id = p_object_approval_id;
5580: ELSE
5581: UPDATE aso_apr_obj_approvals
5582: SET approval_status = p_status,
5583: last_update_date = SYSDATE,
5584: end_date = SYSDATE,
5585: last_updated_by = g_user_id,