DBA Data[Home] [Help]

APPS.OKL_SERVICE_INTEGRATION_PVT dependencies on OKC_K_HEADERS_V

Line 49: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Lease Contract Header ID

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

Line 50: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Service Contract Header 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: );

Line 62: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Lease Contract Header ID

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: );

Line 63: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Service Contract Header ID

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:

Line 84: p_lease_contract_id IN OKC_K_HEADERS_V.ID%TYPE,

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 (

Line 85: x_service_contract_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE

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,

Line 94: p_lease_contract_id IN OKC_K_HEADERS_V.ID%TYPE,

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:

Line 96: x_service_contract_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE

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,

Line 105: p_lease_contract_id IN OKC_K_HEADERS_V.ID%TYPE,

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:

Line 107: x_service_contract_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE

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,

Line 116: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Lease Contract Header ID

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

Line 117: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Service Contract Header 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: );

Line 129: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Lease Contract Header ID

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,

Line 130: p_oks_chr_id IN OKC_K_HEADERS_V.ID%TYPE, -- Service Contract Header ID

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,

Line 193: p_okl_chr_id IN OKC_K_HEADERS_V.ID%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

Line 194: p_oks_chr_id IN OKC_K_HEADERS_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: );

Line 206: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE

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,

Line 215: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE

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,

Line 224: p_okl_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

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

Line 225: p_oks_chr_id IN OKC_K_HEADERS_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: );