DBA Data[Home] [Help]

APPS.PSA_UTILS dependencies on FND_RESPONSIBILITY

Line 1299: p_resp_id IN fnd_responsibility.responsibility_id%TYPE,

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,
1303: p_mode in varchar2 default 'B',

Line 1463: p_resp_id IN fnd_responsibility.responsibility_id%TYPE,

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,
1467: p_start_deb_id OUT NOCOPY NUMBER,

Line 1569: p_resp_id IN fnd_responsibility.responsibility_id%TYPE,

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,
1573: p_end_deb_id OUT NOCOPY NUMBER

Line 1795: FROM fnd_responsibility b

1791: SELECT b.start_date,
1792: b.end_date
1793: INTO l_start_date,
1794: l_end_date
1795: FROM fnd_responsibility b
1796: WHERE b.responsibility_id = p_resp_id;
1797:
1798: IF (SYSDATE BETWEEN l_start_date AND NVL(l_end_date, SYSDATE)) THEN
1799: NULL;

Line 1809: undo_error ('Getting fnd_responsibility: '||SQLERRM);

1805: WHEN NO_DATA_FOUND THEN
1806: undo_error ('No such Repsonsibility exists: '||p_resp_id);
1807: RAISE;
1808: WHEN OTHERS THEN
1809: undo_error ('Getting fnd_responsibility: '||SQLERRM);
1810: RAISE;
1811: END;
1812:
1813: BEGIN