1 package PA_CI_SUPPLIER_PKG AUTHID CURRENT_USER AS
2 --$Header: PACISIIS.pls 120.0.12010000.10 2010/04/13 15:47:19 gboomina ship $
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
8 PROCEDURE insert_row (
9 x_rowid in out NOCOPY VARCHAR2
10 ,x_CI_transaction_id IN OUT NOCOPY NUMBER
11 ,p_CI_TYPE_ID IN NUMBER
12 ,p_CI_ID IN NUMBER
13 ,p_CI_IMPACT_ID IN NUMBER
14 ,p_VENDOR_ID IN NUMBER
15 ,p_PO_HEADER_ID IN NUMBER
16 ,p_PO_LINE_ID IN NUMBER
17 ,p_ADJUSTED_TRANSACTION_ID IN NUMBER
18 ,p_CURRENCY_CODE IN VARCHAR2
19 ,p_CHANGE_AMOUNT IN NUMBER
20 ,p_CHANGE_TYPE IN VARCHAR2
21 ,p_CHANGE_DESCRIPTION IN VARCHAR2
22 ,p_CREATED_BY IN NUMBER
23 ,p_CREATION_DATE IN DATE
24 ,p_LAST_UPDATED_BY IN NUMBER
25 ,p_LAST_UPDATE_DATE IN DATE
26 ,p_LAST_UPDATE_LOGIN IN NUMBER
27 ,p_Task_Id IN NUMBER
28 ,p_Resource_List_Mem_Id IN NUMBER
29 ,p_From_Date IN varchar2
30 ,p_To_Date IN varchar2
31 ,p_Estimated_Cost IN NUMBER
32 ,p_Quoted_Cost IN NUMBER
33 ,p_Negotiated_Cost IN NUMBER
34 ,p_Burdened_cost IN NUMBER
35 ,p_Revenue IN NUMBER default NULL
36 ,p_revenue_override_rate in number
37 ,p_audit_history_number in number
38 ,p_current_audit_flag in varchar2
39 ,p_Original_supp_trans_id in number
40 ,p_Source_supp_trans_id in number
41 ,p_Sup_ref_no in number default null
42 ,p_version_type in varchar2 default 'ALL'
43 ,p_ci_status IN VARCHAR2 default null
44 -- gboomina modified for supplier cost 12.1.3 requirement - start
45 ,p_expenditure_type in varchar2 default null
46 ,p_expenditure_org_id in number default null
47 ,p_change_reason_code in varchar2 default null
48 ,p_quote_negotiation_reference in varchar2 default null
49 ,p_need_by_date in varchar2 default null
50 -- gboomina modified for supplier cost 12.1.3 requirement - end
51 ,x_return_status OUT NOCOPY VARCHAR2
52 ,x_error_msg_code OUT NOCOPY VARCHAR2
53 );
54
55 PROCEDURE update_row
56 (p_rowid IN VARCHAR2
57 ,p_ci_transaction_id IN NUMBER
58 ,p_CI_TYPE_ID IN NUMBER
59 ,p_CI_ID IN NUMBER
60 ,p_CI_IMPACT_ID IN NUMBER
61 ,p_VENDOR_ID IN NUMBER
62 ,p_PO_HEADER_ID IN NUMBER
63 ,p_PO_LINE_ID IN NUMBER
64 ,p_ADJUSTED_TRANSACTION_ID IN NUMBER
65 ,p_CURRENCY_CODE IN VARCHAR2
66 ,p_CHANGE_AMOUNT IN NUMBER
67 ,p_CHANGE_TYPE IN VARCHAR2
68 ,p_CHANGE_DESCRIPTION IN VARCHAR2
69 ,p_LAST_UPDATED_BY IN NUMBER
70 ,p_LAST_UPDATE_DATE IN DATE
71 ,p_LAST_UPDATE_LOGIN IN NUMBER
72 ,p_Task_Id IN NUMBER
73 ,p_Resource_List_Mem_Id IN NUMBER
74 ,p_From_Date IN varchar2
75 ,p_To_Date IN varchar2
76 ,p_Estimated_Cost IN NUMBER
77 ,p_Quoted_Cost IN NUMBER
78 ,p_Negotiated_Cost IN NUMBER
79 ,p_Burdened_cost IN NUMBER
80 ,p_Revenue IN NUMBER default NULL
81 ,p_revenue_override_rate in number
82 ,p_audit_history_number in number
83 ,p_current_audit_flag in varchar2
84 ,p_Original_supp_trans_id in number
85 ,p_Source_supp_trans_id in number
86 -- gboomina modified for supplier cost 12.1.3 requirement - start
87 ,p_Sup_ref_no in number default null
88 ,p_version_type in varchar2 default 'ALL'
89 ,p_ci_status IN VARCHAR2 default null
90 ,p_expenditure_type in varchar2 default null
91 ,p_expenditure_org_id in number default null
92 ,p_change_reason_code in varchar2 default null
93 ,p_quote_negotiation_reference in varchar2 default null
94 ,p_need_by_date in varchar2 default null
95 -- gboomina modified for supplier cost 12.1.3 requirement - end
96 ,x_return_status OUT NOCOPY VARCHAR2
97 ,x_error_msg_code OUT NOCOPY VARCHAR2
98 );
99 PROCEDURE delete_row (p_ci_transaction_id in NUMBER);
100
101 PROCEDURE delete_row (x_rowid in VARCHAR2);
102
103 PROCEDURE lock_row (x_rowid in VARCHAR2);
104
105
106 END PA_CI_SUPPLIER_PKG;