APPS.QP_LIMIT_BALANCE_CHECK_PVT dependencies on FND_GLOBAL

Line 231: last_updated_by = fnd_global.user_id

227: UPDATE qp_limit_balances
228: SET available_amount = round(available_amount,2) - l_given_amount
229: + nvl(g_limit_balance_line(i).transaction_amount, 0),
230: last_update_date = sysdate,
231: last_updated_by = fnd_global.user_id
232: WHERE round(available_amount,2) >=
233: DECODE(g_limit_balance_line(i).limit_exceed_action_code,
234: 'HARD', l_given_amount -
235: nvl(g_limit_balance_line(i).transaction_amount, 0),

Line 249: last_updated_by = fnd_global.user_id

245: UPDATE qp_limit_balances
246: SET available_amount = round(available_amount,2) - l_given_amount
247: + nvl(g_limit_balance_line(i).transaction_amount, 0),
248: last_update_date = sysdate,
249: last_updated_by = fnd_global.user_id
250: WHERE round(available_amount,2) >=
251: DECODE(g_limit_balance_line(i).limit_exceed_action_code,
252: 'HARD',l_given_amount -
253: nvl(g_limit_balance_line(i).transaction_amount, 0),

Line 308: fnd_global.user_id,

304: VALUES
305: (g_limit_balance_line(i).limit_id,
306: g_limit_balance_line(i).limit_balance_id,
307: sysdate,
308: fnd_global.user_id,
309: sysdate,
310: fnd_global.user_id,
311: g_limit_balance_line(i).limit_amount - l_given_amount
312: + nvl(g_limit_balance_line(i).transaction_amount, 0),

Line 310: fnd_global.user_id,

306: g_limit_balance_line(i).limit_balance_id,
307: sysdate,
308: fnd_global.user_id,
309: sysdate,
310: fnd_global.user_id,
311: g_limit_balance_line(i).limit_amount - l_given_amount
312: + nvl(g_limit_balance_line(i).transaction_amount, 0),
313: 0,
314: 0,

Line 2426: fnd_global.user_id,

2422: VALUES
2423: (
2424: g_limit_balance_line(j).limit_balance_id,
2425: sysdate,
2426: fnd_global.user_id,
2427: sysdate,
2428: fnd_global.user_id,
2429: g_limit_balance_line(j).list_header_id,
2430: g_limit_balance_line(j).list_line_id,

Line 2428: fnd_global.user_id,

2424: g_limit_balance_line(j).limit_balance_id,
2425: sysdate,
2426: fnd_global.user_id,
2427: sysdate,
2428: fnd_global.user_id,
2429: g_limit_balance_line(j).list_header_id,
2430: g_limit_balance_line(j).list_line_id,
2431: sysdate,
2432: g_limit_balance_line(j).request_type_code,

Line 2450: last_updated_by = fnd_global.user_id,

2446: --sql statement upd4
2447: update qp_limit_transactions
2448: set amount = g_limit_balance_line(j).given_amount,
2449: last_update_date = sysdate,
2450: last_updated_by = fnd_global.user_id,
2451: price_request_date = sysdate
2452: where limit_balance_id = g_limit_balance_line(j).limit_balance_id and list_header_id = g_limit_balance_line(j).list_header_id
2453: and list_line_id = g_limit_balance_line(j).list_line_id
2454: and price_request_code =

Line 2811: fnd_global.user_id,

2807: VALUES
2808: (
2809: g_limit_balance_line(j).limit_balance_id,
2810: sysdate,
2811: fnd_global.user_id,
2812: sysdate,
2813: fnd_global.user_id,
2814: g_limit_balance_line(j).list_header_id,
2815: g_limit_balance_line(j).list_line_id,

Line 2813: fnd_global.user_id,

2809: g_limit_balance_line(j).limit_balance_id,
2810: sysdate,
2811: fnd_global.user_id,
2812: sysdate,
2813: fnd_global.user_id,
2814: g_limit_balance_line(j).list_header_id,
2815: g_limit_balance_line(j).list_line_id,
2816: sysdate,
2817: g_limit_balance_line(j).request_type_code,

Line 2840: last_updated_by = fnd_global.user_id,

2836: --sql statement upd10
2837: update qp_limit_transactions
2838: set amount = g_limit_balance_line(j).given_amount,
2839: last_update_date = sysdate,
2840: last_updated_by = fnd_global.user_id,
2841: price_request_date = sysdate
2842: where limit_balance_id = g_limit_balance_line(j).limit_balance_id
2843: and list_header_id = g_limit_balance_line(j).list_header_id
2844: and list_line_id = g_limit_balance_line(j).list_line_id