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.QP_LIMIT_BALANCE_CHECK_PVT dependencies on FND_GLOBAL

Line 236: last_updated_by = fnd_global.user_id

232: SET available_amount = DECODE (ROUND(round(available_amount,2) - l_given_amount
233: + nvl(g_limit_balance_line(i).transaction_amount, 0),1),0,0,round(available_amount,2) - l_given_amount
234: + nvl(g_limit_balance_line(i).transaction_amount, 0)),
235: last_update_date = sysdate,
236: last_updated_by = fnd_global.user_id
237: WHERE round(available_amount,2) >=
238: DECODE(g_limit_balance_line(i).limit_exceed_action_code,
239: 'HARD', l_given_amount -
240: nvl(g_limit_balance_line(i).transaction_amount, 0),

Line 257: last_updated_by = fnd_global.user_id

253: SET available_amount = DECODE (ROUND(round(available_amount,2) - l_given_amount
254: + nvl(g_limit_balance_line(i).transaction_amount, 0),1),0,0,round(available_amount,2) - l_given_amount
255: + nvl(g_limit_balance_line(i).transaction_amount, 0)),
256: last_update_date = sysdate,
257: last_updated_by = fnd_global.user_id
258: WHERE round(available_amount,2) >=
259: DECODE(g_limit_balance_line(i).limit_exceed_action_code,
260: 'HARD',l_given_amount -
261: nvl(g_limit_balance_line(i).transaction_amount, 0),

Line 271: last_updated_by = fnd_global.user_id

267: /* UPDATE qp_limit_balances
268: SET available_amount = round(available_amount,2) - l_given_amount
269: + nvl(g_limit_balance_line(i).transaction_amount, 0),
270: last_update_date = sysdate,
271: last_updated_by = fnd_global.user_id
272: WHERE round(available_amount,2) >=
273: DECODE(g_limit_balance_line(i).limit_exceed_action_code,
274: 'HARD',l_given_amount -
275: nvl(g_limit_balance_line(i).transaction_amount, 0),

Line 330: fnd_global.user_id,

326: VALUES
327: (g_limit_balance_line(i).limit_id,
328: g_limit_balance_line(i).limit_balance_id,
329: sysdate,
330: fnd_global.user_id,
331: sysdate,
332: fnd_global.user_id,
333: DECODE(ROUND(g_limit_balance_line(i).limit_amount - l_given_amount
334: + nvl(g_limit_balance_line(i).transaction_amount, 0),1),0,0,g_limit_balance_line(i).limit_amount - l_given_amount

Line 332: fnd_global.user_id,

328: g_limit_balance_line(i).limit_balance_id,
329: sysdate,
330: fnd_global.user_id,
331: sysdate,
332: fnd_global.user_id,
333: DECODE(ROUND(g_limit_balance_line(i).limit_amount - l_given_amount
334: + nvl(g_limit_balance_line(i).transaction_amount, 0),1),0,0,g_limit_balance_line(i).limit_amount - l_given_amount
335: + nvl(g_limit_balance_line(i).transaction_amount, 0)),
336: 0,

Line 2487: fnd_global.user_id,

2483: VALUES
2484: (
2485: g_limit_balance_line(j).limit_balance_id,
2486: sysdate,
2487: fnd_global.user_id,
2488: sysdate,
2489: fnd_global.user_id,
2490: g_limit_balance_line(j).list_header_id,
2491: g_limit_balance_line(j).list_line_id,

Line 2489: fnd_global.user_id,

2485: g_limit_balance_line(j).limit_balance_id,
2486: sysdate,
2487: fnd_global.user_id,
2488: sysdate,
2489: fnd_global.user_id,
2490: g_limit_balance_line(j).list_header_id,
2491: g_limit_balance_line(j).list_line_id,
2492: sysdate,
2493: g_limit_balance_line(j).request_type_code,

Line 2511: last_updated_by = fnd_global.user_id,

2507: --sql statement upd4
2508: update qp_limit_transactions
2509: set amount = g_limit_balance_line(j).given_amount,
2510: last_update_date = sysdate,
2511: last_updated_by = fnd_global.user_id,
2512: price_request_date = sysdate
2513: where limit_balance_id = g_limit_balance_line(j).limit_balance_id and list_header_id = g_limit_balance_line(j).list_header_id
2514: and list_line_id = g_limit_balance_line(j).list_line_id
2515: and price_request_code =

Line 2886: fnd_global.user_id,

2882: VALUES
2883: (
2884: g_limit_balance_line(j).limit_balance_id,
2885: sysdate,
2886: fnd_global.user_id,
2887: sysdate,
2888: fnd_global.user_id,
2889: g_limit_balance_line(j).list_header_id,
2890: g_limit_balance_line(j).list_line_id,

Line 2888: fnd_global.user_id,

2884: g_limit_balance_line(j).limit_balance_id,
2885: sysdate,
2886: fnd_global.user_id,
2887: sysdate,
2888: fnd_global.user_id,
2889: g_limit_balance_line(j).list_header_id,
2890: g_limit_balance_line(j).list_line_id,
2891: sysdate,
2892: g_limit_balance_line(j).request_type_code,

Line 2915: last_updated_by = fnd_global.user_id,

2911: --sql statement upd10
2912: update qp_limit_transactions
2913: set amount = g_limit_balance_line(j).given_amount,
2914: last_update_date = sysdate,
2915: last_updated_by = fnd_global.user_id,
2916: price_request_date = sysdate
2917: where limit_balance_id = g_limit_balance_line(j).limit_balance_id
2918: and list_header_id = g_limit_balance_line(j).list_header_id
2919: and list_line_id = g_limit_balance_line(j).list_line_id