DBA Data[Home] [Help]

PACKAGE: APPS.ECX_XREF_DTL_PKG

Source


1 package ECX_XREF_DTL_PKG AUTHID CURRENT_USER as
2 /* $Header: ECXXRFDS.pls 115.3 2003/11/14 17:44:39 mtai ship $ */
3 
4 procedure TRANSLATE_ROW (
5   X_XREF_CATEGORY_ID IN NUMBER,
6   X_STANDARD_ID IN NUMBER,
7   X_TP_HEADER_ID IN NUMBER,
8   X_XREF_EXT_VALUE IN VARCHAR2,
9   X_XREF_INT_VALUE IN VARCHAR2,
10   X_DIRECTION IN VARCHAR2,
11   X_DESCRIPTION IN VARCHAR2,
12   X_OWNER IN VARCHAR2,
13   X_CUSTOM_MODE IN VARCHAR2);
14 
15 procedure LOAD_ROW (
16   X_XREF_CATEGORY_CODE IN VARCHAR2,
17   X_STANDARD_CODE IN VARCHAR2,
18   X_TP_HEADER_ID IN NUMBER,
19   X_XREF_EXT_VALUE IN VARCHAR2,
20   X_XREF_INT_VALUE IN VARCHAR2,
21   X_DIRECTION IN VARCHAR2,
22   X_DESCRIPTION IN VARCHAR2,
23   X_OWNER IN VARCHAR2,
24   X_CUSTOM_MODE IN VARCHAR2,
25   X_STANDARD_TYPE IN VARCHAR2 default 'XML');
26 
27 procedure INSERT_ROW (
28   X_ROWID in out NOCOPY VARCHAR2,
29   X_XREF_DTL_ID in NUMBER,
30   X_XREF_CATEGORY_ID in NUMBER,
31   X_STANDARD_ID in NUMBER,
32   X_XREF_STANDARD_CODE in VARCHAR2,
33   X_TP_HEADER_ID in NUMBER,
34   X_XREF_EXT_VALUE in VARCHAR2,
35   X_XREF_INT_VALUE in VARCHAR2,
36   X_DIRECTION in VARCHAR2,
37   X_DESCRIPTION in VARCHAR2,
38   X_CREATION_DATE in DATE,
39   X_CREATED_BY in NUMBER,
40   X_LAST_UPDATE_DATE in DATE,
41   X_LAST_UPDATED_BY in NUMBER,
42   X_LAST_UPDATE_LOGIN in NUMBER);
43 procedure LOCK_ROW (
44   X_XREF_DTL_ID in NUMBER,
45   X_XREF_CATEGORY_ID in NUMBER,
46   X_STANDARD_ID in NUMBER,
47   X_XREF_STANDARD_CODE in VARCHAR2,
48   X_TP_HEADER_ID in NUMBER,
49   X_XREF_EXT_VALUE in VARCHAR2,
50   X_XREF_INT_VALUE in VARCHAR2,
51   X_DIRECTION in VARCHAR2,
52   X_DESCRIPTION in VARCHAR2
53 );
54 procedure UPDATE_ROW (
55   X_XREF_DTL_ID in NUMBER,
56   X_XREF_CATEGORY_ID in NUMBER,
57   X_STANDARD_ID in NUMBER,
58   X_XREF_STANDARD_CODE in VARCHAR2,
59   X_TP_HEADER_ID in NUMBER,
60   X_XREF_EXT_VALUE in VARCHAR2,
61   X_XREF_INT_VALUE in VARCHAR2,
62   X_DIRECTION in VARCHAR2,
63   X_DESCRIPTION in VARCHAR2,
64   X_LAST_UPDATE_DATE in DATE,
65   X_LAST_UPDATED_BY in NUMBER,
66   X_LAST_UPDATE_LOGIN in NUMBER
67 );
68 procedure DELETE_ROW (
69   X_XREF_DTL_ID in NUMBER
70 );
71 procedure ADD_LANGUAGE;
72 end ECX_XREF_DTL_PKG;