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 2237: FROM aso_apr_obj_approvals

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

Line 2694: FROM aso_apr_obj_approvals

2690: CURSOR get_object_id (
2691: c_object_approval_id NUMBER
2692: ) IS
2693: SELECT DISTINCT object_id, object_type, application_id
2694: FROM aso_apr_obj_approvals
2695: WHERE object_approval_id = c_object_approval_id;
2696:
2697: CURSOR get_existing_approvers (
2698: c_object_approval_id NUMBER

Line 3480: FROM aso_apr_obj_approvals aoa

3476: CURSOR get_application_id (
3477: c_object_approval_id NUMBER
3478: ) IS
3479: SELECT DISTINCT object_id, object_type, application_id
3480: FROM aso_apr_obj_approvals aoa
3481: WHERE object_approval_id = c_object_approval_id;
3482: BEGIN
3483: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3484: aso_debug_pub.ADD (

Line 4221: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa

4217: CURSOR get_object_details (
4218: c_approval_id NUMBER
4219: ) IS
4220: SELECT quote_header_id, quote_name, quote_number, quote_expiration_date
4221: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa
4222: WHERE qha.quote_header_id = aoa.object_id
4223: AND aoa.object_approval_id = c_approval_id;
4224:
4225: CURSOR get_customer_name (

Line 4250: aso_apr_obj_approvals aoa

4246: ) IS
4247: SELECT ala.description
4248: FROM as_leads_all ala,
4249: aso_quote_related_objects qro,
4250: aso_apr_obj_approvals aoa
4251: WHERE ala.lead_id = qro.object_id
4252: AND qro.relationship_type_code = 'OPP_QUOTE'
4253: AND qro.quote_object_id = aoa.object_id
4254: AND aoa.object_approval_id = c_approval_id;

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

4256: -- bug 3934660
4257:
4258: CURSOR get_party_type (c_approval_id NUMBER) IS
4259: SELECT P.PARTY_TYPE
4260: FROM hz_parties p, aso_quote_headers_all qh,aso_apr_obj_approvals aoa
4261: WHERE p.party_id = qh.party_id
4262: AND qh.quote_header_id = aoa.object_id
4263: AND aoa.object_approval_id = c_approval_id;
4264:

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

4267: CURSOR get_contact_name (
4268: c_approval_id NUMBER
4269: ) IS
4270: SELECT party_name
4271: FROM hz_parties p, hz_relationships r, aso_quote_headers_all qh,aso_apr_obj_approvals aoa
4272: WHERE p.party_id = r.object_id
4273: AND r.party_id = qh.party_id
4274: AND r.subject_id = qh.cust_party_id
4275: AND r.object_type = 'PERSON'

Line 4618: FROM aso_apr_obj_approvals

4614: CURSOR get_requester_details (
4615: c_approval_id NUMBER
4616: ) IS
4617: SELECT requester_comments
4618: FROM aso_apr_obj_approvals
4619: WHERE object_approval_id = c_approval_id;
4620: BEGIN
4621: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4622: aso_debug_pub.ADD (

Line 5054: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa

5050: CURSOR get_object_details (
5051: c_approval_id NUMBER
5052: ) IS
5053: SELECT quote_header_id, quote_number,qha.org_id
5054: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa
5055: WHERE qha.quote_header_id = aoa.object_id
5056: AND aoa.object_approval_id = c_approval_id;
5057:
5058: -- bug 3934660 replace qha.party_id with cust_party_id

Line 5299: FROM aso_apr_obj_approvals

5295: CURSOR get_application_id (
5296: c_approval_id NUMBER
5297: ) IS
5298: SELECT application_id
5299: FROM aso_apr_obj_approvals
5300: WHERE object_approval_id = c_approval_id;
5301:
5302: -- hyang, bug 2860045, performance fix.
5303: CURSOR get_label (

Line 5456: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa

5452: CURSOR OBJECT (
5453: c_approval_id NUMBER
5454: ) IS
5455: SELECT quote_name, quote_number,org_id,quote_header_id
5456: FROM aso_quote_headers_all qha, aso_apr_obj_approvals aoa
5457: WHERE qha.quote_header_id = aoa.object_id
5458: AND aoa.object_approval_id = c_approval_id;
5459:
5460: BEGIN

Line 5609: UPDATE aso_apr_obj_approvals

5605:
5606: IF p_update_header_or_detail_flag = 'HEADER' THEN
5607: IF (p_status = 'PEND')
5608: THEN
5609: UPDATE aso_apr_obj_approvals
5610: SET approval_status = p_status,
5611: last_update_date = SYSDATE,
5612: last_updated_by = g_user_id,
5613: last_update_login = g_user_id

Line 5616: UPDATE aso_apr_obj_approvals

5612: last_updated_by = g_user_id,
5613: last_update_login = g_user_id
5614: WHERE object_approval_id = p_object_approval_id;
5615: ELSE
5616: UPDATE aso_apr_obj_approvals
5617: SET approval_status = p_status,
5618: last_update_date = SYSDATE,
5619: end_date = SYSDATE,
5620: last_updated_by = g_user_id,