APPS.ASO_PA_APR_INT dependencies on ASO_APR_APPROVAL_DETAILS

Line 104: from ASO_APR_APPROVAL_DETAILS

100: /* cursor to fetch approver details */
101: cursor get_approver_details(p_object_appr_id number) is
102: select APPROVAL_DET_ID, APPROVER_PERSON_ID, approver_user_id,APPROVER_SEQUENCE, APPROVER_STATUS, APPROVER_COMMENTS,
103: name,item_class, item_id,action_type_id, group_or_chain_id, occurrence, authority,approver_category
104: from ASO_APR_APPROVAL_DETAILS
105: where object_approval_id = p_object_appr_id
106: order by APPROVAL_DET_ID;
107:
108: l_name varchar2(320);

Line 1876: from ASO_APR_APPROVAL_DETAILS

1872: as
1873: cursor get_approver_details(p_object_appr_id number) is
1874: select APPROVAL_DET_ID, APPROVER_PERSON_ID, approver_user_id,APPROVER_SEQUENCE, APPROVER_STATUS, APPROVER_COMMENTS,
1875: name,item_class, item_id,action_type_id, group_or_chain_id, occurrence, authority,approver_category
1876: from ASO_APR_APPROVAL_DETAILS
1877: where object_approval_id = p_object_appr_id
1878: order by APPROVAL_DET_ID;
1879:
1880: /* Cursor to fetch approver category description*/

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 1966: from ASO_APR_APPROVAL_DETAILS

1962: for i in 1..approvertblin.count loop
1963: begin
1964: select APPROVAL_DET_ID , approver_comments
1965: into l_approval_Detail_id, l_approver_comments
1966: from ASO_APR_APPROVAL_DETAILS
1967: where object_approval_id = p_object_appr_id
1968: and nvl(approver_person_id,approver_user_id)=nvl(approvertblin(i).approver_person_id,approvertblin(i).approver_user_id)
1969: and name=approvertblin(i).name
1970: and APPROVER_SEQUENCE=approvertblin(i).approver_sequence

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: