1 package PA_CI_SUPPLIER_PKG AUTHID CURRENT_USER AS
2 --$Header: PACISIIS.pls 115.4 2002/12/02 23:34:41 riyengar noship $
3 PROCEDURE insert_row (
4 x_rowid in out NOCOPY VARCHAR2
5 ,x_CI_transaction_id IN OUT NOCOPY NUMBER
6 ,p_CI_TYPE_ID IN NUMBER
7 ,p_CI_ID IN NUMBER
8 ,p_CI_IMPACT_ID IN NUMBER
9 ,p_VENDOR_ID IN NUMBER
10 ,p_PO_HEADER_ID IN NUMBER
11 ,p_PO_LINE_ID IN NUMBER
12 ,p_ADJUSTED_TRANSACTION_ID IN NUMBER
13 ,p_CURRENCY_CODE IN VARCHAR2
14 ,p_CHANGE_AMOUNT IN NUMBER
15 ,p_CHANGE_TYPE IN VARCHAR2
16 ,p_CHANGE_DESCRIPTION IN VARCHAR2
17 ,p_CREATED_BY IN NUMBER
18 ,p_CREATION_DATE IN DATE
19 ,p_LAST_UPDATED_BY IN NUMBER
20 ,p_LAST_UPDATE_DATE IN DATE
21 ,p_LAST_UPDATE_LOGIN IN NUMBER
22 ,p_ci_status IN VARCHAR2
23 ,x_return_status OUT NOCOPY VARCHAR2
24 ,x_error_msg_code OUT NOCOPY VARCHAR2
25 );
26
27 PROCEDURE update_row
28 (p_rowid IN VARCHAR2
29 ,p_ci_transaction_id IN NUMBER
30 ,p_CI_TYPE_ID IN NUMBER
31 ,p_CI_ID IN NUMBER
32 ,p_CI_IMPACT_ID IN NUMBER
33 ,p_VENDOR_ID IN NUMBER
34 ,p_PO_HEADER_ID IN NUMBER
35 ,p_PO_LINE_ID IN NUMBER
36 ,p_ADJUSTED_TRANSACTION_ID IN NUMBER
37 ,p_CURRENCY_CODE IN VARCHAR2
38 ,p_CHANGE_AMOUNT IN NUMBER
39 ,p_CHANGE_TYPE IN VARCHAR2
40 ,p_CHANGE_DESCRIPTION IN VARCHAR2
41 ,p_LAST_UPDATED_BY IN NUMBER
42 ,p_LAST_UPDATE_DATE IN DATE
43 ,p_LAST_UPDATE_LOGIN IN NUMBER
44 ,p_ci_status IN VARCHAR2
45 ,x_return_status OUT NOCOPY VARCHAR2
46 ,x_error_msg_code OUT NOCOPY VARCHAR2
47 );
48 PROCEDURE delete_row (p_ci_transaction_id in NUMBER);
49
50 PROCEDURE delete_row (x_rowid in VARCHAR2);
51
52 PROCEDURE lock_row (x_rowid in VARCHAR2);
53
54
55 END PA_CI_SUPPLIER_PKG;
[Home] [Help]