DBA Data[Home] [Help]

APPS.OKL_ASSET_SUBSIDY_PVT dependencies on OKL_API

Line 8: subsidy_id NUMBER := OKL_API.G_MISS_NUM,

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_ASSET_SUBSIDIES_UV Record Spec
7: TYPE asb_rec_type IS RECORD (
8: subsidy_id NUMBER := OKL_API.G_MISS_NUM,
9: subsidy_cle_id NUMBER := OKL_API.G_MISS_NUM,
10: name OKL_SUBSIDIES_B.NAME%TYPE := OKL_API.G_MISS_CHAR,
11: description OKL_SUBSIDIES_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
12: amount NUMBER := OKL_API.G_MISS_NUM,

Line 9: subsidy_cle_id NUMBER := OKL_API.G_MISS_NUM,

5: ---------------------------------------------------------------------------
6: -- OKL_ASSET_SUBSIDIES_UV Record Spec
7: TYPE asb_rec_type IS RECORD (
8: subsidy_id NUMBER := OKL_API.G_MISS_NUM,
9: subsidy_cle_id NUMBER := OKL_API.G_MISS_NUM,
10: name OKL_SUBSIDIES_B.NAME%TYPE := OKL_API.G_MISS_CHAR,
11: description OKL_SUBSIDIES_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
12: amount NUMBER := OKL_API.G_MISS_NUM,
13: subsidy_override_amount NUMBER := OKL_API.G_MISS_NUM,

Line 10: name OKL_SUBSIDIES_B.NAME%TYPE := OKL_API.G_MISS_CHAR,

6: -- OKL_ASSET_SUBSIDIES_UV Record Spec
7: TYPE asb_rec_type IS RECORD (
8: subsidy_id NUMBER := OKL_API.G_MISS_NUM,
9: subsidy_cle_id NUMBER := OKL_API.G_MISS_NUM,
10: name OKL_SUBSIDIES_B.NAME%TYPE := OKL_API.G_MISS_CHAR,
11: description OKL_SUBSIDIES_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
12: amount NUMBER := OKL_API.G_MISS_NUM,
13: subsidy_override_amount NUMBER := OKL_API.G_MISS_NUM,
14: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,

Line 11: description OKL_SUBSIDIES_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,

7: TYPE asb_rec_type IS RECORD (
8: subsidy_id NUMBER := OKL_API.G_MISS_NUM,
9: subsidy_cle_id NUMBER := OKL_API.G_MISS_NUM,
10: name OKL_SUBSIDIES_B.NAME%TYPE := OKL_API.G_MISS_CHAR,
11: description OKL_SUBSIDIES_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
12: amount NUMBER := OKL_API.G_MISS_NUM,
13: subsidy_override_amount NUMBER := OKL_API.G_MISS_NUM,
14: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
15: asset_cle_id NUMBER := OKL_API.G_MISS_NUM,

Line 12: amount NUMBER := OKL_API.G_MISS_NUM,

8: subsidy_id NUMBER := OKL_API.G_MISS_NUM,
9: subsidy_cle_id NUMBER := OKL_API.G_MISS_NUM,
10: name OKL_SUBSIDIES_B.NAME%TYPE := OKL_API.G_MISS_CHAR,
11: description OKL_SUBSIDIES_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
12: amount NUMBER := OKL_API.G_MISS_NUM,
13: subsidy_override_amount NUMBER := OKL_API.G_MISS_NUM,
14: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
15: asset_cle_id NUMBER := OKL_API.G_MISS_NUM,
16: cpl_id NUMBER := OKL_API.G_MISS_NUM,

Line 13: subsidy_override_amount NUMBER := OKL_API.G_MISS_NUM,

9: subsidy_cle_id NUMBER := OKL_API.G_MISS_NUM,
10: name OKL_SUBSIDIES_B.NAME%TYPE := OKL_API.G_MISS_CHAR,
11: description OKL_SUBSIDIES_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
12: amount NUMBER := OKL_API.G_MISS_NUM,
13: subsidy_override_amount NUMBER := OKL_API.G_MISS_NUM,
14: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
15: asset_cle_id NUMBER := OKL_API.G_MISS_NUM,
16: cpl_id NUMBER := OKL_API.G_MISS_NUM,
17: vendor_id NUMBER := OKL_API.G_MISS_NUM,

Line 14: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,

10: name OKL_SUBSIDIES_B.NAME%TYPE := OKL_API.G_MISS_CHAR,
11: description OKL_SUBSIDIES_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
12: amount NUMBER := OKL_API.G_MISS_NUM,
13: subsidy_override_amount NUMBER := OKL_API.G_MISS_NUM,
14: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
15: asset_cle_id NUMBER := OKL_API.G_MISS_NUM,
16: cpl_id NUMBER := OKL_API.G_MISS_NUM,
17: vendor_id NUMBER := OKL_API.G_MISS_NUM,
18: vendor_name PO_VENDORS.VENDOR_NAME%TYPE := OKL_API.G_MISS_CHAR

Line 15: asset_cle_id NUMBER := OKL_API.G_MISS_NUM,

11: description OKL_SUBSIDIES_TL.SHORT_DESCRIPTION%TYPE := OKL_API.G_MISS_CHAR,
12: amount NUMBER := OKL_API.G_MISS_NUM,
13: subsidy_override_amount NUMBER := OKL_API.G_MISS_NUM,
14: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
15: asset_cle_id NUMBER := OKL_API.G_MISS_NUM,
16: cpl_id NUMBER := OKL_API.G_MISS_NUM,
17: vendor_id NUMBER := OKL_API.G_MISS_NUM,
18: vendor_name PO_VENDORS.VENDOR_NAME%TYPE := OKL_API.G_MISS_CHAR
19: );

Line 16: cpl_id NUMBER := OKL_API.G_MISS_NUM,

12: amount NUMBER := OKL_API.G_MISS_NUM,
13: subsidy_override_amount NUMBER := OKL_API.G_MISS_NUM,
14: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
15: asset_cle_id NUMBER := OKL_API.G_MISS_NUM,
16: cpl_id NUMBER := OKL_API.G_MISS_NUM,
17: vendor_id NUMBER := OKL_API.G_MISS_NUM,
18: vendor_name PO_VENDORS.VENDOR_NAME%TYPE := OKL_API.G_MISS_CHAR
19: );
20:

Line 17: vendor_id NUMBER := OKL_API.G_MISS_NUM,

13: subsidy_override_amount NUMBER := OKL_API.G_MISS_NUM,
14: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
15: asset_cle_id NUMBER := OKL_API.G_MISS_NUM,
16: cpl_id NUMBER := OKL_API.G_MISS_NUM,
17: vendor_id NUMBER := OKL_API.G_MISS_NUM,
18: vendor_name PO_VENDORS.VENDOR_NAME%TYPE := OKL_API.G_MISS_CHAR
19: );
20:
21: TYPE asb_tbl_type IS TABLE OF asb_rec_type

Line 18: vendor_name PO_VENDORS.VENDOR_NAME%TYPE := OKL_API.G_MISS_CHAR

14: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM,
15: asset_cle_id NUMBER := OKL_API.G_MISS_NUM,
16: cpl_id NUMBER := OKL_API.G_MISS_NUM,
17: vendor_id NUMBER := OKL_API.G_MISS_NUM,
18: vendor_name PO_VENDORS.VENDOR_NAME%TYPE := OKL_API.G_MISS_CHAR
19: );
20:
21: TYPE asb_tbl_type IS TABLE OF asb_rec_type
22: INDEX BY BINARY_INTEGER;

Line 30: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;

26:
27: ---------------------------------------------------------------------------
28: -- GLOBAL MESSAGE CONSTANTS
29: ---------------------------------------------------------------------------
30: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
31: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
32: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

Line 31: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;

27: ---------------------------------------------------------------------------
28: -- GLOBAL MESSAGE CONSTANTS
29: ---------------------------------------------------------------------------
30: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
31: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
32: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
35: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

Line 32: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;

28: -- GLOBAL MESSAGE CONSTANTS
29: ---------------------------------------------------------------------------
30: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
31: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
32: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
35: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
36: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

Line 33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;

29: ---------------------------------------------------------------------------
30: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
31: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
32: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
35: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
36: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
37: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

Line 34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;

30: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
31: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
32: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
35: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
36: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
37: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
38: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

Line 35: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

31: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
32: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
35: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
36: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
37: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
38: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
39: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

Line 36: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

32: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
35: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
36: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
37: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
38: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
39: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
40: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';

Line 37: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

33: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
35: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
36: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
37: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
38: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
39: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
40: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
41: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 38: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
35: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
36: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
37: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
38: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
39: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
40: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
41: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
42: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 39: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

35: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
36: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
37: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
38: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
39: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
40: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
41: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
42: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
43:

Line 53: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

49: ---------------------------------------------------------------------------
50: -- GLOBAL VARIABLES
51: ---------------------------------------------------------------------------
52: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ASSET_SUBSIDY_PVT';
53: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
54: ---------------------------------------------------------------------------
55: -- Procedures and Functions
56: ---------------------------------------------------------------------------
57: -------------------------------------------------------------------------------