APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKL_TRX_MSGS

Line 1330: FROM okl_trx_msgs tmgb

1326: IS
1327: SELECT tmgb.message_text message_text ,
1328: tmgb.id id ,
1329: tmgb.trx_id trx_id
1330: FROM okl_trx_msgs tmgb
1331: WHERE tmgb.trx_id = p_trx_id
1332: AND tmgb.message_text LIKE '%Item Key=oracle.apps.okl.am.sendquote%)%';
1333:
1334: -- Cursor to get the status of the workflow

Line 1351: l_message_text okl_trx_msgs.message_text%TYPE;

1347:
1348: -- Declaration of variables required
1349: l_key_start NUMBER;
1350: l_key_end NUMBER;
1351: l_message_text okl_trx_msgs.message_text%TYPE;
1352: l_item_type wf_items.item_type%TYPE := 'OKLAMNQT';
1353: l_item_key wf_items.item_key%TYPE;
1354: l_item_status VARCHAR2(1000);
1355: l_can_abort_wf VARCHAR2(100);