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