45: p_init_msg_list IN VARCHAR2,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2,
49: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Lease Contract Header ID
50: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Service Contract Header ID
51: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Service Contract Service Top Line ID
52: p_supplier_id IN NUMBER,
53: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE -- Returns Lease Service TOP Line ID
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2,
49: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Lease Contract Header ID
50: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Service Contract Header ID
51: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Service Contract Service Top Line ID
52: p_supplier_id IN NUMBER,
53: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE -- Returns Lease Service TOP Line ID
54: );
58: p_init_msg_list IN VARCHAR2,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_msg_data OUT NOCOPY VARCHAR2,
62: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Lease Contract Header ID
63: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Service Contract Header ID
64: p_okl_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Lease Service Top Line ID
65: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE -- Service Contract - Service TOP Line ID
66: );
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_msg_data OUT NOCOPY VARCHAR2,
62: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Lease Contract Header ID
63: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Service Contract Header ID
64: p_okl_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Lease Service Top Line ID
65: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE -- Service Contract - Service TOP Line ID
66: );
67:
80: p_init_msg_list IN VARCHAR2,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2,
84: p_lease_contract_id IN OKC_K_HEADERS_V.ID%TYPE,
85: x_service_contract_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE
86: );
87:
88: PROCEDURE check_service_line_link (
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2,
84: p_lease_contract_id IN OKC_K_HEADERS_V.ID%TYPE,
85: x_service_contract_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE
86: );
87:
88: PROCEDURE check_service_line_link (
89: p_api_version IN NUMBER,
90: p_init_msg_list IN VARCHAR2,
91: x_return_status OUT NOCOPY VARCHAR2,
92: x_msg_count OUT NOCOPY NUMBER,
93: x_msg_data OUT NOCOPY VARCHAR2,
94: p_lease_contract_id IN OKC_K_HEADERS_V.ID%TYPE,
95: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE,
96: x_service_contract_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE
97: );
98:
92: x_msg_count OUT NOCOPY NUMBER,
93: x_msg_data OUT NOCOPY VARCHAR2,
94: p_lease_contract_id IN OKC_K_HEADERS_V.ID%TYPE,
95: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE,
96: x_service_contract_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE
97: );
98:
99: PROCEDURE get_service_link_line (
100: p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2,
102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,
104: x_msg_data OUT NOCOPY VARCHAR2,
105: p_lease_contract_id IN OKC_K_HEADERS_V.ID%TYPE,
106: x_link_line_tbl OUT NOCOPY LINK_LINE_TBL_TYPE,
107: x_service_contract_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE
108: );
109:
103: x_msg_count OUT NOCOPY NUMBER,
104: x_msg_data OUT NOCOPY VARCHAR2,
105: p_lease_contract_id IN OKC_K_HEADERS_V.ID%TYPE,
106: x_link_line_tbl OUT NOCOPY LINK_LINE_TBL_TYPE,
107: x_service_contract_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE
108: );
109:
110: PROCEDURE create_link_service_line(
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2,
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
116: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Lease Contract Header ID
117: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Service Contract Header ID
118: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Service Contract Service Top Line ID
119: p_supplier_id IN NUMBER,
120: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE -- Returns Contract Service TOP Line ID
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
116: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Lease Contract Header ID
117: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Service Contract Header ID
118: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Service Contract Service Top Line ID
119: p_supplier_id IN NUMBER,
120: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE -- Returns Contract Service TOP Line ID
121: );
125: p_init_msg_list IN VARCHAR2,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2,
129: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Lease Contract Header ID
130: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Service Contract Header ID
131: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Service Contract Service Top Line ID
132: p_supplier_id IN NUMBER,
133: p_clev_rec IN clev_rec_type,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2,
129: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Lease Contract Header ID
130: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Service Contract Header ID
131: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Service Contract Service Top Line ID
132: p_supplier_id IN NUMBER,
133: p_clev_rec IN clev_rec_type,
134: p_klev_rec IN klev_rec_type,
189: p_init_msg_list IN VARCHAR2,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
194: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
195: p_supplier_id IN NUMBER,
196: p_sty_id IN OKL_K_LINES.STY_ID%TYPE DEFAULT NULL,
197: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
194: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
195: p_supplier_id IN NUMBER,
196: p_sty_id IN OKL_K_LINES.STY_ID%TYPE DEFAULT NULL,
197: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE
198: );
202: p_init_msg_list IN VARCHAR2,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE
207: );
208:
209: PROCEDURE expire_lease_instance(
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE
216: );
217:
218: PROCEDURE relink_service_contract(
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2,
221: x_return_status OUT NOCOPY VARCHAR2,
222: x_msg_count OUT NOCOPY NUMBER,
223: x_msg_data OUT NOCOPY VARCHAR2,
224: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
225: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
226: p_supplier_id IN NUMBER,
227: p_sty_id IN OKL_K_LINES.STY_ID%TYPE DEFAULT NULL,
228: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE
221: x_return_status OUT NOCOPY VARCHAR2,
222: x_msg_count OUT NOCOPY NUMBER,
223: x_msg_data OUT NOCOPY VARCHAR2,
224: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
225: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
226: p_supplier_id IN NUMBER,
227: p_sty_id IN OKL_K_LINES.STY_ID%TYPE DEFAULT NULL,
228: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE
229: );