APPS.ASO_PA_APR_INT dependencies on ASO_APR_OBJ_APPROVALS

Line 206: from aso_apr_obj_approvals

202:
203: if (p_data_flag='W') or (p_data_flag='N') then
204: if p_object_approval_id is not null then
205: select approval_Status into l_appr_instance_status
206: from aso_apr_obj_approvals
207: where object_approval_id= p_object_approval_id;
208: end if;
209: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
210: aso_debug_pub.ADD ('Inside get_all_approvers approval_Status'||l_appr_instance_status,1,'N');

Line 499: from aso_apr_obj_approvals

495:
496: -- Checking if rule needs to be fetched from ASO table or AME.
497: if p_object_approval_id is not null then
498: select approval_Status into l_appr_instance_status
499: from aso_apr_obj_approvals
500: where p_object_approval_id=object_approval_id;
501:
502: if l_appr_instance_status<>'PEND' then
503: --pp_debug('Fetching rules from table');

Line 758: FROM aso_apr_obj_approvals

754: ) + 1
755: ),
756: 1
757: )
758: FROM aso_apr_obj_approvals
759: WHERE object_id = c_object_id;
760:
761: cursor get_employee_id(l_user_id NUMBER) IS
762: select employee_id

Line 768: FROM aso_apr_obj_approvals

764: where user_id = l_user_id;
765:
766: CURSOR C_get_duplicate_approval IS
767: SELECT count(*)
768: FROM aso_apr_obj_approvals
769: WHERE object_id = p_object_id
770: AND approval_status = 'PEND';
771:
772: BEGIN

Line 1068: update aso_apr_obj_approvals

1064: --pp_debug('l_process_out'||l_process_out);
1065: --pp_debug('approverlist: : '||approverlist.count);
1066:
1067: if approverlist.count=0 then -- No approvers
1068: update aso_apr_obj_approvals
1069: set approval_status = 'APPR',
1070: end_date = sysdate
1071: where object_approval_id = p_object_approval_id;
1072: END IF;

Line 1219: FROM aso_apr_obj_approvals

1215: c_object_id NUMBER,
1216: c_object_type VARCHAR2
1217: ) IS
1218: SELECT object_approval_id
1219: FROM aso_apr_obj_approvals
1220: WHERE object_id = c_object_id
1221: AND object_type = c_object_type
1222: AND approval_instance_id = (SELECT MAX (
1223: approval_instance_id

Line 1225: FROM aso_apr_obj_approvals

1221: AND object_type = c_object_type
1222: AND approval_instance_id = (SELECT MAX (
1223: approval_instance_id
1224: )
1225: FROM aso_apr_obj_approvals
1226: WHERE object_id = c_object_id
1227: AND object_type = c_object_type);
1228:
1229:

Line 1683: from aso_apr_obj_approvals

1679: WHERE Status_Code = 'APPROVAL PENDING';
1680:
1681: cursor c_get_object(l_qte_header_id number) is
1682: select object_approval_id,object_type,application_id,object_version_number
1683: from aso_apr_obj_approvals
1684: where OBJECT_ID=l_qte_header_id
1685: and approval_Status='PEND';
1686:
1687: BEGIN

Line 1796: update aso_apr_obj_approvals

1792: if (approverlist.count=0) or (l_appr_cat_count=0) then --No approvers
1793:
1794: --pp_debug('Self approval scenario');
1795:
1796: update aso_apr_obj_approvals
1797: set approval_status = 'APPR',
1798: object_version_number = l_apr_object_version,
1799: end_date = x_last_update_date,
1800: last_update_date = x_last_update_date

Line 1932: from ASO_APR_OBJ_APPROVALS

1928: SAVEPOINT insert_approvers_gtt;
1929:
1930: select approval_status
1931: into l_approval_status
1932: from ASO_APR_OBJ_APPROVALS
1933: where OBJECT_APPROVAL_ID=p_object_appr_id;
1934:
1935: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1936: aso_debug_pub.ADD ('insert_approvers_gtt:',1,'N');