3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ity_del_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: inf_id NUMBER := Okl_Api.G_MISS_NUM,
9: name OKL_INVOICE_TYPES_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
10: description OKL_INVOICE_TYPES_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
11: GROUP_ASSET_YN OKL_INVOICE_TYPES_V.GROUP_ASSET_YN%TYPE := Okl_Api.G_MISS_CHAR,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ity_del_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: inf_id NUMBER := Okl_Api.G_MISS_NUM,
9: name OKL_INVOICE_TYPES_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
10: description OKL_INVOICE_TYPES_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
11: GROUP_ASSET_YN OKL_INVOICE_TYPES_V.GROUP_ASSET_YN%TYPE := Okl_Api.G_MISS_CHAR,
12: GROUP_BY_CONTRACT_YN OKL_INVOICE_TYPES_V.GROUP_BY_CONTRACT_YN%TYPE := Okl_Api.G_MISS_CHAR
5: ---------------------------------------------------------------------------
6: TYPE ity_del_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: inf_id NUMBER := Okl_Api.G_MISS_NUM,
9: name OKL_INVOICE_TYPES_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
10: description OKL_INVOICE_TYPES_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
11: GROUP_ASSET_YN OKL_INVOICE_TYPES_V.GROUP_ASSET_YN%TYPE := Okl_Api.G_MISS_CHAR,
12: GROUP_BY_CONTRACT_YN OKL_INVOICE_TYPES_V.GROUP_BY_CONTRACT_YN%TYPE := Okl_Api.G_MISS_CHAR
13: );
6: TYPE ity_del_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: inf_id NUMBER := Okl_Api.G_MISS_NUM,
9: name OKL_INVOICE_TYPES_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
10: description OKL_INVOICE_TYPES_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
11: GROUP_ASSET_YN OKL_INVOICE_TYPES_V.GROUP_ASSET_YN%TYPE := Okl_Api.G_MISS_CHAR,
12: GROUP_BY_CONTRACT_YN OKL_INVOICE_TYPES_V.GROUP_BY_CONTRACT_YN%TYPE := Okl_Api.G_MISS_CHAR
13: );
14:
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: inf_id NUMBER := Okl_Api.G_MISS_NUM,
9: name OKL_INVOICE_TYPES_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
10: description OKL_INVOICE_TYPES_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
11: GROUP_ASSET_YN OKL_INVOICE_TYPES_V.GROUP_ASSET_YN%TYPE := Okl_Api.G_MISS_CHAR,
12: GROUP_BY_CONTRACT_YN OKL_INVOICE_TYPES_V.GROUP_BY_CONTRACT_YN%TYPE := Okl_Api.G_MISS_CHAR
13: );
14:
15: TYPE ity_del_tbl_type IS TABLE OF ity_del_rec_type
8: inf_id NUMBER := Okl_Api.G_MISS_NUM,
9: name OKL_INVOICE_TYPES_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
10: description OKL_INVOICE_TYPES_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
11: GROUP_ASSET_YN OKL_INVOICE_TYPES_V.GROUP_ASSET_YN%TYPE := Okl_Api.G_MISS_CHAR,
12: GROUP_BY_CONTRACT_YN OKL_INVOICE_TYPES_V.GROUP_BY_CONTRACT_YN%TYPE := Okl_Api.G_MISS_CHAR
13: );
14:
15: TYPE ity_del_tbl_type IS TABLE OF ity_del_rec_type
16: INDEX BY BINARY_INTEGER;
17:
18: ---------------------------------------------------------------------------
19: -- GLOBAL MESSAGE CONSTANTS
20: ---------------------------------------------------------------------------
21: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
22: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
23: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
24: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
25: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
18: ---------------------------------------------------------------------------
19: -- GLOBAL MESSAGE CONSTANTS
20: ---------------------------------------------------------------------------
21: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
22: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
23: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
24: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
25: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
26: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
19: -- GLOBAL MESSAGE CONSTANTS
20: ---------------------------------------------------------------------------
21: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
22: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
23: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
24: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
25: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
26: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
27: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
20: ---------------------------------------------------------------------------
21: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
22: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
23: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
24: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
25: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
26: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
27: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
28: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
21: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
22: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
23: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
24: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
25: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
26: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
27: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
28: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
29: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
22: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
23: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
24: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
25: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
26: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
27: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
28: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
29: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
30: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
23: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
24: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
25: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
26: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
27: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
28: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
29: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
30: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
31:
24: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
25: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
26: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
27: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
28: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
29: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
30: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
31:
32: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
25: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
26: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
27: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
28: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
29: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
30: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
31:
32: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
33: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
26: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
27: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
28: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
29: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
30: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
31:
32: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
33: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
34: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
37: ---------------------------------------------------------------------------
38: -- GLOBAL VARIABLES
39: ---------------------------------------------------------------------------
40: G_PKG_NAME CONSTANT VARCHAR2(200) := 'Okl_inv_type_delete_Pvt';
41: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
42:
43: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_BPD_INV_TYPES_UV';
44: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
45:
49: ---------------------------------------------------------------------------
50:
51: PROCEDURE delete_type(
52: p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
54: x_return_status OUT NOCOPY VARCHAR2,
55: x_msg_count OUT NOCOPY NUMBER,
56: x_msg_data OUT NOCOPY VARCHAR2,
57: p_ity_del_rec IN ity_del_rec_type);
57: p_ity_del_rec IN ity_del_rec_type);
58:
59: PROCEDURE delete_type(
60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
64: x_msg_data OUT NOCOPY VARCHAR2,
65: p_ity_del_tbl IN ity_del_tbl_type);