APPS.PA_TRANSACTION_SOURCES_PKG dependencies on PA_TRANSACTION_SOURCES

Line 1: PACKAGE BODY PA_TRANSACTION_SOURCES_PKG AS

1: PACKAGE BODY PA_TRANSACTION_SOURCES_PKG AS
2: /* $Header: PAXTIXSB.pls 120.2 2005/08/03 13:58:37 aaggarwa noship $ */
3:
4: -- =====================================================================
5: -- This procedure performs a referential integrity check for

Line 60: FROM pa_transaction_sources

56: INTO dummy
57: FROM dual
58: WHERE NOT EXISTS
59: ( SELECT 1
60: FROM pa_transaction_sources
61: WHERE ( transaction_source = nvl(X_trx_source, -99)
62: OR user_transaction_source = X_user_trx_source)
63: AND ( ( X_rowid IS NULL )
64: OR ( rowid <> X_rowid ) ) );

Line 75: END PA_TRANSACTION_SOURCES_PKG;

71: status := SQLCODE;
72:
73: END check_unique;
74:
75: END PA_TRANSACTION_SOURCES_PKG;