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.PO_R12_CAT_UPG_PVT dependencies on PO_REQEXPRESS_LINES_ALL

Line 7805: -- SQL Why : To update the po_reqexpress_lines_all columns

7801: -- SQL What: Update all the ReqTemplate lines.
7802: -- For these, only the IP_CATEGORY_ID and DESCRIPTION is allowed
7803: -- to be updated. The other columns, if provided in the interface
7804: -- tables, will be ignored. Here, g_NULL_IP_CATEGORY_ID is -2.
7805: -- SQL Why : To update the po_reqexpress_lines_all columns
7806: -- SQL Join: express_name, sequence_num (They form the PK)
7807: FORALL i IN 1..p_rt_lines_rec.ip_category_id.COUNT
7808: UPDATE PO_REQEXPRESS_LINES_ALL
7809: SET

Line 7808: UPDATE PO_REQEXPRESS_LINES_ALL

7804: -- tables, will be ignored. Here, g_NULL_IP_CATEGORY_ID is -2.
7805: -- SQL Why : To update the po_reqexpress_lines_all columns
7806: -- SQL Join: express_name, sequence_num (They form the PK)
7807: FORALL i IN 1..p_rt_lines_rec.ip_category_id.COUNT
7808: UPDATE PO_REQEXPRESS_LINES_ALL
7809: SET
7810: ip_category_id = DECODE(p_rt_lines_rec.ip_category_id(i),
7811: NULL, ip_category_id,
7812: g_NULLIFY_NUM, g_NULL_IP_CATEGORY_ID,