DBA Data[Home] [Help]

APPS.OKL_LA_ASSET_PVT dependencies on OKL_API

Line 7: year_manufactured NUMBER := OKL_API.G_MISS_NUM,

3: -------------------------------------------------------------------------------------------------
4: -- COMPOSITE VARIABLES
5: -------------------------------------------------------------------------------------------------
6: TYPE las_rec_type IS RECORD (asset_number FA_ADDITIONS_B.ASSET_NUMBER%TYPE,
7: year_manufactured NUMBER := OKL_API.G_MISS_NUM,
8: manufacturer_name FA_ADDITIONS_B.MANUFACTURER_NAME%TYPE,
9: description FA_ADDITIONS_TL.DESCRIPTION%TYPE,
10: current_units NUMBER := OKL_API.G_MISS_NUM,
11: from_oec NUMBER := OKL_API.G_MISS_NUM,

Line 10: current_units NUMBER := OKL_API.G_MISS_NUM,

6: TYPE las_rec_type IS RECORD (asset_number FA_ADDITIONS_B.ASSET_NUMBER%TYPE,
7: year_manufactured NUMBER := OKL_API.G_MISS_NUM,
8: manufacturer_name FA_ADDITIONS_B.MANUFACTURER_NAME%TYPE,
9: description FA_ADDITIONS_TL.DESCRIPTION%TYPE,
10: current_units NUMBER := OKL_API.G_MISS_NUM,
11: from_oec NUMBER := OKL_API.G_MISS_NUM,
12: to_oec NUMBER := OKL_API.G_MISS_NUM,
13: vendor_name PO_VENDORS.VENDOR_NAME%TYPE,
14: from_residual_value NUMBER := OKL_API.G_MISS_NUM,

Line 11: from_oec NUMBER := OKL_API.G_MISS_NUM,

7: year_manufactured NUMBER := OKL_API.G_MISS_NUM,
8: manufacturer_name FA_ADDITIONS_B.MANUFACTURER_NAME%TYPE,
9: description FA_ADDITIONS_TL.DESCRIPTION%TYPE,
10: current_units NUMBER := OKL_API.G_MISS_NUM,
11: from_oec NUMBER := OKL_API.G_MISS_NUM,
12: to_oec NUMBER := OKL_API.G_MISS_NUM,
13: vendor_name PO_VENDORS.VENDOR_NAME%TYPE,
14: from_residual_value NUMBER := OKL_API.G_MISS_NUM,
15: to_residual_value NUMBER := OKL_API.G_MISS_NUM,

Line 12: to_oec NUMBER := OKL_API.G_MISS_NUM,

8: manufacturer_name FA_ADDITIONS_B.MANUFACTURER_NAME%TYPE,
9: description FA_ADDITIONS_TL.DESCRIPTION%TYPE,
10: current_units NUMBER := OKL_API.G_MISS_NUM,
11: from_oec NUMBER := OKL_API.G_MISS_NUM,
12: to_oec NUMBER := OKL_API.G_MISS_NUM,
13: vendor_name PO_VENDORS.VENDOR_NAME%TYPE,
14: from_residual_value NUMBER := OKL_API.G_MISS_NUM,
15: to_residual_value NUMBER := OKL_API.G_MISS_NUM,
16: from_start_date OKC_K_LINES_B.START_DATE%TYPE,

Line 14: from_residual_value NUMBER := OKL_API.G_MISS_NUM,

10: current_units NUMBER := OKL_API.G_MISS_NUM,
11: from_oec NUMBER := OKL_API.G_MISS_NUM,
12: to_oec NUMBER := OKL_API.G_MISS_NUM,
13: vendor_name PO_VENDORS.VENDOR_NAME%TYPE,
14: from_residual_value NUMBER := OKL_API.G_MISS_NUM,
15: to_residual_value NUMBER := OKL_API.G_MISS_NUM,
16: from_start_date OKC_K_LINES_B.START_DATE%TYPE,
17: from_end_date OKC_K_LINES_B.END_DATE%TYPE,
18: from_date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,

Line 15: to_residual_value NUMBER := OKL_API.G_MISS_NUM,

11: from_oec NUMBER := OKL_API.G_MISS_NUM,
12: to_oec NUMBER := OKL_API.G_MISS_NUM,
13: vendor_name PO_VENDORS.VENDOR_NAME%TYPE,
14: from_residual_value NUMBER := OKL_API.G_MISS_NUM,
15: to_residual_value NUMBER := OKL_API.G_MISS_NUM,
16: from_start_date OKC_K_LINES_B.START_DATE%TYPE,
17: from_end_date OKC_K_LINES_B.END_DATE%TYPE,
18: from_date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
19: to_start_date OKC_K_LINES_B.START_DATE%TYPE,

Line 24: parent_line_id NUMBER := OKL_API.G_MISS_NUM,

20: to_end_date OKC_K_LINES_B.END_DATE%TYPE,
21: to_date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
22: sts_code OKC_K_LINES_B.STS_CODE%TYPE,
23: location_id VARCHAR(1995),
24: parent_line_id NUMBER := OKL_API.G_MISS_NUM,
25: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
26: p_order_by VARCHAR2(10) := 'AST',
27: p_sort_by VARCHAR2(10) := 'DESC',
28: include_split_yn VARCHAR2(1) := 'N');

Line 25: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,

21: to_date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
22: sts_code OKC_K_LINES_B.STS_CODE%TYPE,
23: location_id VARCHAR(1995),
24: parent_line_id NUMBER := OKL_API.G_MISS_NUM,
25: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
26: p_order_by VARCHAR2(10) := 'AST',
27: p_sort_by VARCHAR2(10) := 'DESC',
28: include_split_yn VARCHAR2(1) := 'N');
29:

Line 50: year_manufactured NUMBER := OKL_API.G_MISS_NUM,

46: TYPE fin_adj_tbl_type IS TABLE OF fin_adj_rec_type INDEX BY BINARY_INTEGER;
47:
48: /*
49: TYPE las_rec_type IS RECORD (asset_number FA_ADDITIONS_B.ASSET_NUMBER%TYPE,
50: year_manufactured NUMBER := OKL_API.G_MISS_NUM,
51: manufacturer_name FA_ADDITIONS_B.MANUFACTURER_NAME%TYPE,
52: description FA_ADDITIONS_TL.DESCRIPTION%TYPE,
53: current_units NUMBER := OKL_API.G_MISS_NUM,
54: oec NUMBER := OKL_API.G_MISS_NUM,

Line 53: current_units NUMBER := OKL_API.G_MISS_NUM,

49: TYPE las_rec_type IS RECORD (asset_number FA_ADDITIONS_B.ASSET_NUMBER%TYPE,
50: year_manufactured NUMBER := OKL_API.G_MISS_NUM,
51: manufacturer_name FA_ADDITIONS_B.MANUFACTURER_NAME%TYPE,
52: description FA_ADDITIONS_TL.DESCRIPTION%TYPE,
53: current_units NUMBER := OKL_API.G_MISS_NUM,
54: oec NUMBER := OKL_API.G_MISS_NUM,
55: vendor_name PO_VENDORS.VENDOR_NAME%TYPE,
56: residual_value NUMBER := OKL_API.G_MISS_NUM,
57: start_date OKC_K_LINES_B.START_DATE%TYPE,

Line 54: oec NUMBER := OKL_API.G_MISS_NUM,

50: year_manufactured NUMBER := OKL_API.G_MISS_NUM,
51: manufacturer_name FA_ADDITIONS_B.MANUFACTURER_NAME%TYPE,
52: description FA_ADDITIONS_TL.DESCRIPTION%TYPE,
53: current_units NUMBER := OKL_API.G_MISS_NUM,
54: oec NUMBER := OKL_API.G_MISS_NUM,
55: vendor_name PO_VENDORS.VENDOR_NAME%TYPE,
56: residual_value NUMBER := OKL_API.G_MISS_NUM,
57: start_date OKC_K_LINES_B.START_DATE%TYPE,
58: end_date OKC_K_LINES_B.END_DATE%TYPE,

Line 56: residual_value NUMBER := OKL_API.G_MISS_NUM,

52: description FA_ADDITIONS_TL.DESCRIPTION%TYPE,
53: current_units NUMBER := OKL_API.G_MISS_NUM,
54: oec NUMBER := OKL_API.G_MISS_NUM,
55: vendor_name PO_VENDORS.VENDOR_NAME%TYPE,
56: residual_value NUMBER := OKL_API.G_MISS_NUM,
57: start_date OKC_K_LINES_B.START_DATE%TYPE,
58: end_date OKC_K_LINES_B.END_DATE%TYPE,
59: date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
60: sts_code OKC_K_LINES_B.STS_CODE%TYPE,

Line 62: parent_line_id NUMBER := OKL_API.G_MISS_NUM,

58: end_date OKC_K_LINES_B.END_DATE%TYPE,
59: date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
60: sts_code OKC_K_LINES_B.STS_CODE%TYPE,
61: location_id VARCHAR(1995),
62: parent_line_id NUMBER := OKL_API.G_MISS_NUM,
63: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
64: p_order_by VARCHAR2(10) := 'AST',
65: p_sort_by VARCHAR2(10) := 'DESC');
66: */

Line 63: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,

59: date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
60: sts_code OKC_K_LINES_B.STS_CODE%TYPE,
61: location_id VARCHAR(1995),
62: parent_line_id NUMBER := OKL_API.G_MISS_NUM,
63: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
64: p_order_by VARCHAR2(10) := 'AST',
65: p_sort_by VARCHAR2(10) := 'DESC');
66: */
67:

Line 135: FUNCTION isContractActive(p_dnz_chr_id IN OKL_K_HEADERS_FULL_V.ID%TYPE DEFAULT OKL_API.G_MISS_NUM,

131: p_fin_adj_tbl IN fin_adj_tbl_type);
132:
133: -- gboomina added - Start
134: -- making isContractActive function public which is called from okl_deal_asset_pvt
135: FUNCTION isContractActive(p_dnz_chr_id IN OKL_K_HEADERS_FULL_V.ID%TYPE DEFAULT OKL_API.G_MISS_NUM,
136: p_deal_type IN OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
137: p_sts_code IN OKL_K_HEADERS_FULL_V.STS_CODE%TYPE)
138: RETURN BOOLEAN;
139: -- gboomina added - End