DBA Data[Home] [Help]

APPS.CN_PAYMENT_SECURITY_PVT dependencies on FND_GLOBAL

Line 115: WHERE user_id = fnd_global.user_id;

111: BEGIN
112: SELECT resource_id
113: INTO l_resource_id
114: FROM jtf_rs_resource_extns
115: WHERE user_id = fnd_global.user_id;
116: EXCEPTION
117: WHEN NO_DATA_FOUND
118: THEN
119: -- resource not exist for this user

Line 188: WHERE user_id = fnd_global.user_id;

184: BEGIN
185: SELECT resource_id
186: INTO l_resource_id
187: FROM jtf_rs_resource_extns
188: WHERE user_id = fnd_global.user_id;
189: EXCEPTION
190: WHEN NO_DATA_FOUND
191: THEN
192: -- resource not exist for this user

Line 312: x_last_updated_by => fnd_global.user_id,

308:
309: -- update payrun status='PAID'
310: cn_payruns_pkg.UPDATE_RECORD (x_payrun_id => p_payrun_id,
311: x_status => 'PAID',
312: x_last_updated_by => fnd_global.user_id,
313: x_last_update_date => SYSDATE,
314: x_last_update_login => fnd_global.login_id,
315: x_object_version_number => l_ovn
316: );

Line 314: x_last_update_login => fnd_global.login_id,

310: cn_payruns_pkg.UPDATE_RECORD (x_payrun_id => p_payrun_id,
311: x_status => 'PAID',
312: x_last_updated_by => fnd_global.user_id,
313: x_last_update_date => SYSDATE,
314: x_last_update_login => fnd_global.login_id,
315: x_object_version_number => l_ovn
316: );
317:
318: -- raise wf event

Line 433: x_last_updated_by => fnd_global.user_id,

429: END IF;
430:
431: cn_payruns_pkg.UPDATE_RECORD (x_payrun_id => p_payrun_id,
432: x_status => l_new_status,
433: x_last_updated_by => fnd_global.user_id,
434: x_last_update_date => SYSDATE,
435: x_last_update_login => fnd_global.login_id,
436: x_object_version_number => l_ovn
437: );

Line 435: x_last_update_login => fnd_global.login_id,

431: cn_payruns_pkg.UPDATE_RECORD (x_payrun_id => p_payrun_id,
432: x_status => l_new_status,
433: x_last_updated_by => fnd_global.user_id,
434: x_last_update_date => SYSDATE,
435: x_last_update_login => fnd_global.login_id,
436: x_object_version_number => l_ovn
437: );
438: -- raise wf event
439: pmt_raise_event(

Line 1191: WHERE user_id = fnd_global.user_id;

1187: BEGIN
1188: SELECT resource_id
1189: INTO l_resource_id
1190: FROM jtf_rs_resource_extns
1191: WHERE user_id = fnd_global.user_id;
1192: EXCEPTION
1193: WHEN NO_DATA_FOUND
1194: THEN
1195: -- resource not exist for this user

Line 1529: AND submit_by_user_id = fnd_global.user_id AND approval_status = 'APPROVED';

1525: SELECT COUNT (1)
1526: INTO l_tmp
1527: FROM cn_pay_approval_flow
1528: WHERE payment_worksheet_id = p_worksheet_id
1529: AND submit_by_user_id = fnd_global.user_id AND approval_status = 'APPROVED';
1530:
1531: IF l_tmp > 0
1532: THEN
1533: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

Line 1620: l_ret_val := fnd_function.test_instance (function_name => l_func_name, user_name => fnd_global.user_name);

1616: l_access VARCHAR2 (20);
1617: BEGIN
1618: --Get permission.
1619: l_func_name := l_func_name || l_separator || p_type || l_separator || p_access;
1620: l_ret_val := fnd_function.test_instance (function_name => l_func_name, user_name => fnd_global.user_name);
1621:
1622: --If no access, then push the error on stacks.
1623: IF l_ret_val = FALSE
1624: THEN

Line 1663: user_name=> fnd_global.user_name

1659:
1660: l_ret_val := fnd_function.test_instance
1661: (
1662: function_name => funcName,
1663: user_name=> fnd_global.user_name
1664: );
1665:
1666: --If no access, then push the error on stacks.
1667: IF l_ret_val = TRUE