1 PACKAGE OKL_RV_INTERFACE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRRVIS.pls 120.1 2005/07/28 06:33:25 smadhava noship $*/
3
4 -- Residual Value Percentage record definition
5 TYPE rv_rec_type IS RECORD
6 (ITEM_ID OKL_ITM_CAT_RV_PRCS.CAT_ID1%TYPE
7 ,ORG_ID OKL_ITM_CAT_RV_PRCS.CAT_ID2%TYPE
8 ,TERM_IN_MONTHS OKL_ITM_CAT_RV_PRCS.TERM_IN_MONTHS%TYPE
9 ,RESIDUAL_VALUE_PERCENT OKL_ITM_CAT_RV_PRCS.RESIDUAL_VALUE_PERCENT%TYPE
10 ,START_DATE OKL_ITM_CAT_RV_PRCS.START_DATE%TYPE
11 ,END_DATE OKL_ITM_CAT_RV_PRCS.END_DATE%TYPE
12 ,BATCH_NUMER NUMBER
13 ,STATUS VARCHAR2(30)
14 );
15
16
17 TYPE rv_tbl IS TABLE OF rv_rec_type
18 INDEX BY BINARY_INTEGER;
19
20 l_rv_rec rv_rec_type;
21
22 PROCEDURE purge_record (
23 errbuf OUT NOCOPY VARCHAR2
24 ,retcode OUT NOCOPY VARCHAR2
25 ,p_batch_number IN VARCHAR2
26 ,p_org_id IN NUMBER
27 ,p_status IN VARCHAR2
28 );
29
30
31 PROCEDURE Process_Record (
32 errbuf OUT NOCOPY VARCHAR2,
33 retcode OUT NOCOPY VARCHAR2,
34 p_batch_number IN VARCHAR2,
35 p_org_id IN NUMBER
36 );
37
38 PROCEDURE Check_Input_Record(
39 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2,
43 p_batch_number IN VARCHAR2,
44 p_org_id IN NUMBER,
45 x_total_checked OUT NOCOPY NUMBER,
46 x_total_failed OUT NOCOPY NUMBER
47 );
48
49
50 PROCEDURE Load_Input_Record(
51 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 p_batch_number IN VARCHAR2,
56 x_total_loaded OUT NOCOPY NUMBER
57 );
58
59
60 PROCEDURE Report_Error(
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2
63 );
64
65 PROCEDURE Update_Interface_Status (p_batch_number IN VARCHAR2
66 ,p_status IN VARCHAR2
67 ,p_item_id IN NUMBER
68 ,p_org_id IN NUMBER
69 ,p_term IN NUMBER
70 ,p_rv_percent IN NUMBER
71 ,p_start_date IN date
72 ,p_end_date IN date
73 ,x_return_status OUT NOCOPY VARCHAR2);
74
75
76 PROCEDURE GENERATE_RV (
77 ERRBUF OUT NOCOPY VARCHAR2
78 ,RETCODE OUT NOCOPY VARCHAR2
79 ,P_BATCH_NUMBER IN VARCHAR2
80 ,P_ORG_ID IN NUMBER
81 ,P_SO_ITEMS_ONLY_YN IN VARCHAR2 -- get only items used in quotes
82 ,P_START_DATE IN VARCHAR2
83 ,P_END_DATE IN VARCHAR2
84 ,P_TERM_LOWER_RANGE IN NUMBER -- MIN 1
85 ,P_TERM_UPPER_RANGE IN NUMBER
86 ,P_TERM_INTERVAL IN NUMBER -- IN MONTHS
87 ,P_INITIAL_RV IN NUMBER -- MAX 100
88 ,P_DECREMENT_RV_BY IN NUMBER -- MIN 1
89 );
90
91 PROCEDURE GENERATE_RESIDUAL_VALUES (
92 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
93 ,x_return_status OUT NOCOPY VARCHAR2
94 ,x_msg_count OUT NOCOPY NUMBER
95 ,x_msg_data OUT NOCOPY VARCHAR2
96 ,P_ORG_ID IN NUMBER
97 ,P_SO_ITEMS_ONLY_YN IN VARCHAR2 -- get only items used in quoting
98 ,P_START_DATE IN DATE
99 ,P_END_DATE IN DATE
100 ,P_TERM_LOWER_RANGE IN NUMBER -- MIN 1
101 ,P_TERM_UPPER_RANGE IN NUMBER
102 ,P_TERM_INTERVAL IN NUMBER -- IN MONTHS
103 ,P_INITIAL_RV IN NUMBER -- MAX 100
104 ,P_DECREMENT_RV_BY IN NUMBER -- MIN 1
105 ,x_rv_tbl OUT NOCOPY rv_tbl
106 );
107
108 END OKL_RV_INTERFACE_PVT;