DBA Data[Home] [Help]

APPS.OKL_INV_LINE_TYPE_DELETE_PVT dependencies on OKL_API

Line 7: id NUMBER := Okl_Api.G_MISS_NUM,

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

Line 8: ity_id NUMBER := Okl_Api.G_MISS_NUM,

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

Line 10: NAME okl_invc_line_types_v.NAME%TYPE := Okl_Api.G_MISS_CHAR,

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

Line 11: DESCRIPTION okl_invc_line_types_v.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR

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;

Line 20: G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;

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;

Line 21: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;

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;

Line 22: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;

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;

Line 23: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;

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;

Line 24: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;

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;

Line 25: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;

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;

Line 26: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;

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:

Line 27: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;

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';

Line 28: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;

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';

Line 29: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;

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';

Line 40: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;

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:

Line 52: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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

Line 60: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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