5: ---------------------------------------------------------------------------
6: TYPE inf_del_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
9: name OKL_INVOICE_FORMATS_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
10: description OKL_INVOICE_FORMATS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
11: contract_level_yn OKL_INVOICE_FORMATS_V.CONTRACT_LEVEL_YN%TYPE := Okl_Api.G_MISS_CHAR,
12: start_date OKL_INVOICE_FORMATS_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: end_date OKL_INVOICE_FORMATS_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE
6: TYPE inf_del_rec_type IS RECORD (
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
9: name OKL_INVOICE_FORMATS_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
10: description OKL_INVOICE_FORMATS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
11: contract_level_yn OKL_INVOICE_FORMATS_V.CONTRACT_LEVEL_YN%TYPE := Okl_Api.G_MISS_CHAR,
12: start_date OKL_INVOICE_FORMATS_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: end_date OKL_INVOICE_FORMATS_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE
14: );
7: id NUMBER := Okl_Api.G_MISS_NUM,
8: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
9: name OKL_INVOICE_FORMATS_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
10: description OKL_INVOICE_FORMATS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
11: contract_level_yn OKL_INVOICE_FORMATS_V.CONTRACT_LEVEL_YN%TYPE := Okl_Api.G_MISS_CHAR,
12: start_date OKL_INVOICE_FORMATS_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: end_date OKL_INVOICE_FORMATS_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE
14: );
15:
8: ilt_id NUMBER := Okl_Api.G_MISS_NUM,
9: name OKL_INVOICE_FORMATS_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
10: description OKL_INVOICE_FORMATS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
11: contract_level_yn OKL_INVOICE_FORMATS_V.CONTRACT_LEVEL_YN%TYPE := Okl_Api.G_MISS_CHAR,
12: start_date OKL_INVOICE_FORMATS_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: end_date OKL_INVOICE_FORMATS_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE
14: );
15:
16: TYPE inf_del_tbl_type IS TABLE OF inf_del_rec_type
9: name OKL_INVOICE_FORMATS_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
10: description OKL_INVOICE_FORMATS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
11: contract_level_yn OKL_INVOICE_FORMATS_V.CONTRACT_LEVEL_YN%TYPE := Okl_Api.G_MISS_CHAR,
12: start_date OKL_INVOICE_FORMATS_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
13: end_date OKL_INVOICE_FORMATS_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE
14: );
15:
16: TYPE inf_del_tbl_type IS TABLE OF inf_del_rec_type
17: INDEX BY BINARY_INTEGER;
40: ---------------------------------------------------------------------------
41: G_PKG_NAME CONSTANT VARCHAR2(200) := 'Okl_inv_format_delete_Pvt';
42: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
43:
44: G_VIEW CONSTANT VARCHAR2(30) := 'OKL_INVOICE_FORMATS_V';
45: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
46:
47:
48: ---------------------------------------------------------------------------