eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POR_UTIL_PKG dependencies on PO_CLMREQ_LINE_AWD_REFS_V

Line 3941: SELECT 'AWARD_CREATED' INTO l_line_status FROM PO_CLMREQ_LINE_AWD_REFS_V prh

3937: IF(l_line_loc_id <0) THEN
3938: --Soft linked so check whether atleast one award linked to req line is not in approved status
3939: -- we will put l_line_status as AWARD_APPROVED only when all awards linked to req line are in approved status.
3940: BEGIN
3941: SELECT 'AWARD_CREATED' INTO l_line_status FROM PO_CLMREQ_LINE_AWD_REFS_V prh
3942: WHERE prh.requisition_line_id= p_req_line_id and Nvl(prh.authorization_status,'INCOMPLETE') <> 'APPROVED' and ROWNUM=1;
3943: EXCEPTION
3944: WHEN No_Data_Found THEN
3945: l_line_status := 'AWARD_APPROVED';

Line 4029: SELECT 'AWARD_CREATED' INTO l_line_status FROM PO_CLMREQ_LINE_AWD_REFS_V prh

4025: IF(l_line_loc_id <0) THEN
4026: --Soft linked so check whether atleast one award linked to req line is not in approved status
4027: -- we will put l_line_status as AWARD_APPROVED only when all awards linked to req line are in approved status.
4028: BEGIN
4029: SELECT 'AWARD_CREATED' INTO l_line_status FROM PO_CLMREQ_LINE_AWD_REFS_V prh
4030: WHERE prh.requisition_line_id= c_get_req_details_rec.REQUISITION_LINE_ID and Nvl(prh.authorization_status,'INCOMPLETE') <> 'APPROVED' and ROWNUM=1;
4031: EXCEPTION
4032: WHEN No_Data_Found THEN
4033: l_line_status := 'AWARD_APPROVED';