APPS.PSA_UTILS dependencies on FND_USER

Line 1298: p_user_id IN fnd_user.user_id%TYPE,

1294:
1295: PROCEDURE undo_xla_accounting_for_inv
1296: (
1297: p_invoice_id IN NUMBER,
1298: p_user_id IN fnd_user.user_id%TYPE,
1299: p_resp_id IN fnd_responsibility.responsibility_id%TYPE,
1300: p_gl_date IN DATE,
1301: p_tar_number IN VARCHAR2,
1302: p_bug_number IN VARCHAR2,

Line 1311: l_user_name fnd_user.user_name%TYPE;

1307: IS
1308: l_path_name VARCHAR2(500);
1309: l_retcode NUMBER;
1310: l_errbuf VARCHAR2(2000);
1311: l_user_name fnd_user.user_name%TYPE;
1312: l_start_log_id NUMBER;
1313: l_end_log_id NUMBER;
1314: l_org_id NUMBER;
1315: l_ledger_id NUMBER;

Line 1462: p_user_id IN fnd_user.user_id%TYPE,

1458:
1459: PROCEDURE undo_xla_accounting_for_po
1460: (
1461: p_po_header_id IN NUMBER,
1462: p_user_id IN fnd_user.user_id%TYPE,
1463: p_resp_id IN fnd_responsibility.responsibility_id%TYPE,
1464: p_gl_date IN DATE,
1465: p_tar_number IN VARCHAR2,
1466: p_bug_number IN VARCHAR2,

Line 1474: l_user_name fnd_user.user_name%TYPE;

1470: IS
1471: l_path_name VARCHAR2(500);
1472: l_retcode NUMBER;
1473: l_errbuf VARCHAR2(2000);
1474: l_user_name fnd_user.user_name%TYPE;
1475: l_start_log_id NUMBER;
1476: l_end_log_id NUMBER;
1477: l_org_id NUMBER;
1478: l_ledger_id NUMBER;

Line 1568: p_user_id IN fnd_user.user_id%TYPE,

1564:
1565: PROCEDURE redo_xla_accounting_for_po
1566: (
1567: p_po_header_id IN NUMBER,
1568: p_user_id IN fnd_user.user_id%TYPE,
1569: p_resp_id IN fnd_responsibility.responsibility_id%TYPE,
1570: p_tar_number IN VARCHAR2,
1571: p_bug_number IN VARCHAR2,
1572: p_start_deb_id OUT NOCOPY NUMBER,

Line 1579: l_user_name fnd_user.user_name%TYPE;

1575: IS
1576: l_path_name VARCHAR2(500);
1577: l_retcode NUMBER;
1578: l_errbuf VARCHAR2(2000);
1579: l_user_name fnd_user.user_name%TYPE;
1580: l_start_log_id NUMBER;
1581: l_end_log_id NUMBER;
1582: l_org_id NUMBER;
1583: l_ledger_id NUMBER;

Line 1712: FROM fnd_user

1708: end_date
1709: INTO p_user_id,
1710: l_start_date,
1711: l_end_date
1712: FROM fnd_user
1713: WHERE user_name = UPPER(p_user_name);
1714: IF (SYSDATE between l_start_date and NVL(l_end_date, SYSDATE)) THEN
1715: NULL;
1716: ELSE

Line 1747: FROM fnd_user

1743: SELECT start_date,
1744: end_date
1745: INTO l_start_date,
1746: l_end_date
1747: FROM fnd_user
1748: WHERE user_id = p_user_id;
1749: IF (SYSDATE between l_start_date and NVL(l_end_date, SYSDATE)) THEN
1750: NULL;
1751: ELSE

Line 1820: FROM fnd_user_resp_groups_direct a

1816: a.responsibility_application_id
1817: INTO l_start_date,
1818: l_end_date,
1819: l_resp_appl_id
1820: FROM fnd_user_resp_groups_direct a
1821: WHERE a.responsibility_id = p_resp_id
1822: AND a.user_id = p_user_id;
1823:
1824: IF (SYSDATE BETWEEN l_start_date AND NVL(l_end_date, SYSDATE)) THEN

Line 1839: undo_error('Getting fnd_user_resp_groups_direct:'||SQLERRM);

1835: WHEN NO_DATA_FOUND THEN
1836: undo_error ('User does not have access to the Repsonsibility');
1837: RAISE;
1838: WHEN OTHERS THEN
1839: undo_error('Getting fnd_user_resp_groups_direct:'||SQLERRM);
1840: RAISE;
1841: END;
1842:
1843: EXCEPTION