1 package PA_CI_SUPPLIER_UTILS AUTHID CURRENT_USER AS
2 --$Header: PASIUTLS.pls 115.7 2003/01/16 23:29:08 riyengar noship $
3
4 --TYPE PA_VC_1000_150 IS VARRAY(1000) OF VARCHAR2(150);
5 --TYPE PA_VC_1000_NUM IS VARRAY(1000) OF NUMBER;
6
7 PROCEDURE print_msg(p_msg varchar2);
8
9
10 PROCEDURE deleteSIrecord(P_CALLING_MODE IN varchar2
11 ,p_ROWID IN varchar2
12 ,P_CI_TRANSACTION_ID IN number
13 ,X_RETURN_STATUS IN OUT NOCOPY varchar2
14 ,x_MSG_DATA IN OUT NOCOPY varchar2
15 ,X_MSG_COUNT IN OUT NOCOPY number );
16
17 PROCEDURE validate_SI_record(
18 p_RECORD_STATUS IN VARCHAR2
19 ,p_CI_ID IN NUMBER
20 ,P_CALLING_MODE IN VARCHAR2
21 ,P_CI_STATUS IN VARCHAR2
22 ,P_ORG_ID IN VARCHAR2
23 ,x_VENDOR_ID IN OUT NOCOPY NUMBER
24 ,p_VENDOR_NAME IN VARCHAR2
25 ,x_PO_HEADER_ID IN OUT NOCOPY NUMBER
26 ,p_PO_NUMBER IN VARCHAR2
27 ,x_PO_LINE_ID IN OUT NOCOPY NUMBER
28 ,p_PO_LINE_NUM IN NUMBER
29 ,p_ADJUSTED_TRANSACTION_ID IN NUMBER
30 ,p_CURRENCY_CODE IN VARCHAR2
31 ,p_CHANGE_AMOUNT IN NUMBER
32 ,p_CHANGE_TYPE IN VARCHAR2
33 ,p_CHANGE_DESCRIPTION IN VARCHAR2
34 ,p_ci_transaction_id IN NUMBER
35 ,x_return_status OUT NOCOPY VARCHAR2
36 ,x_error_msg_code OUT NOCOPY VARCHAR2
37 );
38
39 PROCEDURE validate_insert_SI(
40 p_ROWID IN OUT NOCOPY PA_VC_1000_150
41 ,p_RECORD_STATUS IN PA_VC_1000_150
42 ,p_CI_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
43 ,p_CI_TYPE_ID IN PA_VC_1000_150
44 ,p_CI_IMPACT_ID IN PA_VC_1000_150
45 ,P_CALLING_MODE IN VARCHAR2
46 ,P_CI_STATUS IN PA_VC_1000_150
47 ,P_ORG_ID IN PA_VC_1000_150
48 ,x_VENDOR_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
49 ,p_VENDOR_NAME IN PA_VC_1000_150
50 ,x_PO_HEADER_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
51 ,p_PO_NUMBER IN PA_VC_1000_150
52 ,x_PO_LINE_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
53 ,p_PO_LINE_NUM IN PA_VC_1000_150 --PA_VC_1000_NUM
54 ,p_ADJUSTED_TRANSACTION_ID IN PA_VC_1000_150 --PA_VC_1000_NUM
55 ,p_CURRENCY_CODE IN PA_VC_1000_150
56 ,p_CHANGE_AMOUNT IN PA_VC_1000_150 --PA_VC_1000_NUM
57 ,p_CHANGE_TYPE IN PA_VC_1000_150
58 ,p_CHANGE_DESCRIPTION IN PA_VC_1000_150
59 ,p_ci_transaction_id IN OUT NOCOPY PA_VC_1000_150
60 ,p_RECORD_ID IN OUT NOCOPY PA_VC_1000_150
61 ,p_REC_RETURN_STATUS IN OUT NOCOPY PA_VC_1000_150
62 ,x_return_status IN OUT NOCOPY VARCHAR2
63 ,x_msg_data IN OUT NOCOPY VARCHAR2
64 ,x_msg_count IN OUT NOCOPY NUMBER
65 );
66 -- This API calls validate the supplier impact record and calls table
67 -- handler depending on the record status if record status is NEW it inserts
68 -- else it UPDATES pa_info_supplier_info table.
69 -- This API is called from PaSupplierImplementVORowImpl.java method for each row
70 PROCEDURE validateSI(p_ROWID IN OUT NOCOPY VARCHAR2
71 ,p_RECORD_STATUS IN VARCHAR2
72 ,p_CI_ID IN VARCHAR2
73 ,p_CI_TYPE_ID IN VARCHAR2
74 ,p_CI_IMPACT_ID IN VARCHAR2
75 ,P_CALLING_MODE IN VARCHAR2
76 ,P_ORG_ID IN VARCHAR2
77 ,p_VENDOR_NAME IN VARCHAR2
78 ,p_PO_NUMBER IN VARCHAR2
79 ,p_PO_LINE_NUM IN VARCHAR2
80 ,p_ADJUSTED_TRANSACTION_ID IN VARCHAR2
81 ,p_CURRENCY_CODE IN VARCHAR2
82 ,p_CHANGE_AMOUNT IN VARCHAR2
83 ,p_CHANGE_TYPE IN VARCHAR2
84 ,p_CHANGE_DESCRIPTION IN VARCHAR2
85 ,p_CI_TRANSACTION_ID IN OUT NOCOPY VARCHAR2
86 ,x_return_status IN OUT NOCOPY VARCHAR2
87 ,x_msg_data IN OUT NOCOPY VARCHAR2
88 ,x_msg_count IN OUT NOCOPY NUMBER
89 );
90
91 PROCEDURE Merge_suppliers
92 ( p_from_ci_item_id IN NUMBER
93 ,p_to_ci_item_id IN NUMBER
94 ,x_return_status OUT NOCOPY VARCHAR2
95 ,x_error_msg OUT NOCOPY VARCHAR2
96 );
97
98 PROCEDURE DELETE_IMPACT(p_ci_id IN NUMBER
99 ,x_return_status OUT NOCOPY VARCHAR2
100 ,x_msg_data OUT NOCOPY VARCHAR2
101 ,x_msg_count OUT NOCOPY NUMBER
102 );
103
104 PROCEDURE IS_SI_DELETE_OK(p_ci_id IN NUMBER
105 ,x_return_status OUT NOCOPY VARCHAR2
106 ,x_msg_data OUT NOCOPY VARCHAR2
107 ,x_msg_count OUT NOCOPY NUMBER
108 );
109
110 FUNCTION IS_SI_DELETE_OK(p_ci_id IN NUMBER) return varchar2;
111
112 FUNCTION get_formated_amount(p_currency_code varchar2
113 ,p_amount number ) return varchar2 ;
114
115
116
117 END PA_CI_SUPPLIER_UTILS;