eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SERVICE_INTEGRATION_PVT dependencies on OKC_K_LINES_V

Line 26: okl_service_line_id OKC_K_LINES_V.ID%TYPE,

22: SUBTYPE klev_tbl_type IS okl_contract_pub.klev_tbl_type;
23: SUBTYPE cimv_tbl_type IS okl_okc_migration_pvt.cimv_tbl_type;
24:
25: TYPE link_line_rec_type IS RECORD (
26: okl_service_line_id OKC_K_LINES_V.ID%TYPE,
27: oks_service_line_id OKC_K_LINES_V.ID%TYPE
28: );
29:
30: TYPE link_line_tbl_type IS TABLE OF link_line_rec_type INDEX BY BINARY_INTEGER;

Line 27: oks_service_line_id OKC_K_LINES_V.ID%TYPE

23: SUBTYPE cimv_tbl_type IS okl_okc_migration_pvt.cimv_tbl_type;
24:
25: TYPE link_line_rec_type IS RECORD (
26: okl_service_line_id OKC_K_LINES_V.ID%TYPE,
27: oks_service_line_id OKC_K_LINES_V.ID%TYPE
28: );
29:
30: TYPE link_line_tbl_type IS TABLE OF link_line_rec_type INDEX BY BINARY_INTEGER;
31:

Line 33: oks_cov_prod_line_id OKC_K_LINES_V.ID%TYPE

29:
30: TYPE link_line_tbl_type IS TABLE OF link_line_rec_type INDEX BY BINARY_INTEGER;
31:
32: TYPE srv_cov_rec_type IS RECORD (
33: oks_cov_prod_line_id OKC_K_LINES_V.ID%TYPE
34: );
35:
36: TYPE srv_cov_tbl_type IS TABLE OF srv_cov_rec_type INDEX BY BINARY_INTEGER;
37:

Line 51: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Service Contract Service Top Line ID

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

Line 53: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE -- Returns Lease Service TOP Line ID

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: );
55:
56: PROCEDURE link_service_line(
57: p_api_version IN NUMBER,

Line 64: p_okl_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Lease Service Top Line ID

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:
68: PROCEDURE delete_service_line(

Line 65: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE -- Service Contract - Service TOP Line ID

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:
68: PROCEDURE delete_service_line(
69: p_api_version IN NUMBER,

Line 95: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE,

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:
99: PROCEDURE get_service_link_line (

Line 118: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Service Contract Service Top Line ID

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

Line 120: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE -- Returns Contract Service TOP Line ID

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: );
122:
123: PROCEDURE update_service_line(
124: p_api_version IN NUMBER,

Line 131: p_oks_service_line_id IN OKC_K_LINES_V.ID%TYPE, -- Service Contract Service Top Line ID

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,
135: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE

Line 135: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE

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,
135: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE
136: );
137:
138: PROCEDURE create_cov_asset_line(
139: p_api_version IN NUMBER,

Line 197: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE

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: );
199:
200: PROCEDURE delink_service_contract(
201: p_api_version IN NUMBER,

Line 228: x_okl_service_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE

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: );
230:
231: END OKL_SERVICE_INTEGRATION_PVT;