APPS.ASO_PA_APR_INT dependencies on ASO_APR_APPROVAL_DETAILS_TEMP

Line 1943: from ASO_APR_APPROVAL_DETAILS_TEMP

1939:
1940:
1941:
1942: select count(*) into l_count
1943: from ASO_APR_APPROVAL_DETAILS_TEMP
1944: where object_approval_id = p_object_appr_id;
1945:
1946: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1947: aso_debug_pub.ADD ('insert_approvers_gtt: temp count'||l_count,1,'N');

Line 1951: Delete from ASO_APR_APPROVAL_DETAILS_TEMP

1947: aso_debug_pub.ADD ('insert_approvers_gtt: temp count'||l_count,1,'N');
1948: --pp_debug('insert_approvers_gtt: temp count'||l_count);
1949: end if;
1950: if l_count>0 then
1951: Delete from ASO_APR_APPROVAL_DETAILS_TEMP
1952: where object_approval_id = p_object_appr_id;
1953: end if;
1954:
1955: if (l_approval_status='PEND') then

Line 1990: insert into ASO_APR_APPROVAL_DETAILS_TEMP

1986: end;
1987:
1988:
1989: -- Inserting into the temp table for display
1990: insert into ASO_APR_APPROVAL_DETAILS_TEMP
1991: (APPROVAL_DET_ID,OBJECT_APPROVAL_ID,APPROVER_PERSON_ID,APPROVER_USER_ID,APPROVER_SEQUENCE,
1992: APPROVER_STATUS,NAME,APPROVER_NAME,APPROVAL_COMMENTS,APPROVER_CATEGORY,APPROVER_CATEGORY_DESC,
1993: APPROVER_TYPE_DESC,SUB_LIST_DESC,ITEM_ID,ITEM_CLASS, ACTION_TYPE, ACTION_TYPE_ID,
1994: CHAIN_NUMBER,AUTHORITY)

Line 2004: from ASO_APR_APPROVAL_DETAILS_TEMP

2000: );
2001:
2002: end loop;
2003: select count(*) into l_count
2004: from ASO_APR_APPROVAL_DETAILS_TEMP
2005: where object_approval_id = p_object_appr_id;
2006:
2007: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2008: aso_debug_pub.ADD ('insert_approvers_gtt: After inserting into temp table count'||l_count,1,'N');

Line 2082: insert into ASO_APR_APPROVAL_DETAILS_TEMP

2078:
2079:
2080:
2081:
2082: insert into ASO_APR_APPROVAL_DETAILS_TEMP
2083: (APPROVAL_DET_ID,OBJECT_APPROVAL_ID,APPROVER_PERSON_ID,APPROVER_USER_ID,APPROVER_SEQUENCE,
2084: APPROVER_STATUS,NAME,APPROVER_NAME,APPROVAL_COMMENTS,APPROVER_CATEGORY,APPROVER_CATEGORY_DESC,
2085: APPROVER_TYPE_DESC,SUB_LIST_DESC,ITEM_ID,ITEM_CLASS, ACTION_TYPE, ACTION_TYPE_ID,
2086: CHAIN_NUMBER,AUTHORITY)

Line 2099: from ASO_APR_APPROVAL_DETAILS_TEMP

2095: end if; -- l_approval_status
2096:
2097: /*
2098: Select count(*) into l_count
2099: from ASO_APR_APPROVAL_DETAILS_TEMP
2100: where object_approval_id = p_object_appr_id;
2101:
2102: Insert into test_pa_approval_debug_log values ('ASO_APR_APPROVAL_DETAILS_TEMP Record Count :'||l_count);
2103:

Line 2102: Insert into test_pa_approval_debug_log values ('ASO_APR_APPROVAL_DETAILS_TEMP Record Count :'||l_count);

2098: Select count(*) into l_count
2099: from ASO_APR_APPROVAL_DETAILS_TEMP
2100: where object_approval_id = p_object_appr_id;
2101:
2102: Insert into test_pa_approval_debug_log values ('ASO_APR_APPROVAL_DETAILS_TEMP Record Count :'||l_count);
2103:
2104: COMMIT;
2105: */
2106: