8: SUBTYPE taiv_rec_type IS okl_trx_ar_invoices_pub.taiv_rec_type;
9: SUBTYPE taiv_tbl_type IS okl_trx_ar_invoices_pub.taiv_tbl_type;
10:
11: TYPE ariv_rec_type IS RECORD (
12: P_ACN_ID NUMBER := OKC_API.G_MISS_NUM,
13: P_ACS_CODE VARCHAR2(200) := OKC_API.G_MISS_CHAR,
14: P_PART_NAME VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
15: P_CONDITION_TYPE VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
16: P_DAMAGE_TYPE VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
9: SUBTYPE taiv_tbl_type IS okl_trx_ar_invoices_pub.taiv_tbl_type;
10:
11: TYPE ariv_rec_type IS RECORD (
12: P_ACN_ID NUMBER := OKC_API.G_MISS_NUM,
13: P_ACS_CODE VARCHAR2(200) := OKC_API.G_MISS_CHAR,
14: P_PART_NAME VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
15: P_CONDITION_TYPE VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
16: P_DAMAGE_TYPE VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
17: P_ACTUAL_REPAIR_COST NUMBER := OKC_API.G_MISS_NUM,
10:
11: TYPE ariv_rec_type IS RECORD (
12: P_ACN_ID NUMBER := OKC_API.G_MISS_NUM,
13: P_ACS_CODE VARCHAR2(200) := OKC_API.G_MISS_CHAR,
14: P_PART_NAME VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
15: P_CONDITION_TYPE VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
16: P_DAMAGE_TYPE VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
17: P_ACTUAL_REPAIR_COST NUMBER := OKC_API.G_MISS_NUM,
18: P_DATE_APPROVED DATE := OKC_API.G_MISS_DATE,
11: TYPE ariv_rec_type IS RECORD (
12: P_ACN_ID NUMBER := OKC_API.G_MISS_NUM,
13: P_ACS_CODE VARCHAR2(200) := OKC_API.G_MISS_CHAR,
14: P_PART_NAME VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
15: P_CONDITION_TYPE VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
16: P_DAMAGE_TYPE VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
17: P_ACTUAL_REPAIR_COST NUMBER := OKC_API.G_MISS_NUM,
18: P_DATE_APPROVED DATE := OKC_API.G_MISS_DATE,
19: P_BILL_TO NUMBER := OKC_API.G_MISS_NUM,
12: P_ACN_ID NUMBER := OKC_API.G_MISS_NUM,
13: P_ACS_CODE VARCHAR2(200) := OKC_API.G_MISS_CHAR,
14: P_PART_NAME VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
15: P_CONDITION_TYPE VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
16: P_DAMAGE_TYPE VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
17: P_ACTUAL_REPAIR_COST NUMBER := OKC_API.G_MISS_NUM,
18: P_DATE_APPROVED DATE := OKC_API.G_MISS_DATE,
19: P_BILL_TO NUMBER := OKC_API.G_MISS_NUM,
20: P_DATE_INVOICE DATE := OKC_API.G_MISS_DATE,
13: P_ACS_CODE VARCHAR2(200) := OKC_API.G_MISS_CHAR,
14: P_PART_NAME VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
15: P_CONDITION_TYPE VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
16: P_DAMAGE_TYPE VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
17: P_ACTUAL_REPAIR_COST NUMBER := OKC_API.G_MISS_NUM,
18: P_DATE_APPROVED DATE := OKC_API.G_MISS_DATE,
19: P_BILL_TO NUMBER := OKC_API.G_MISS_NUM,
20: P_DATE_INVOICE DATE := OKC_API.G_MISS_DATE,
21: P_APPROVED_YN VARCHAR2(1) := OKC_API.G_MISS_CHAR,
14: P_PART_NAME VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
15: P_CONDITION_TYPE VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
16: P_DAMAGE_TYPE VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
17: P_ACTUAL_REPAIR_COST NUMBER := OKC_API.G_MISS_NUM,
18: P_DATE_APPROVED DATE := OKC_API.G_MISS_DATE,
19: P_BILL_TO NUMBER := OKC_API.G_MISS_NUM,
20: P_DATE_INVOICE DATE := OKC_API.G_MISS_DATE,
21: P_APPROVED_YN VARCHAR2(1) := OKC_API.G_MISS_CHAR,
22: P_ACD_ID_COST NUMBER := OKC_API.G_MISS_NUM,
15: P_CONDITION_TYPE VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
16: P_DAMAGE_TYPE VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
17: P_ACTUAL_REPAIR_COST NUMBER := OKC_API.G_MISS_NUM,
18: P_DATE_APPROVED DATE := OKC_API.G_MISS_DATE,
19: P_BILL_TO NUMBER := OKC_API.G_MISS_NUM,
20: P_DATE_INVOICE DATE := OKC_API.G_MISS_DATE,
21: P_APPROVED_YN VARCHAR2(1) := OKC_API.G_MISS_CHAR,
22: P_ACD_ID_COST NUMBER := OKC_API.G_MISS_NUM,
23: P_OBJECT_VERSION_NUMBER NUMBER := OKC_API.G_MISS_NUM);
16: P_DAMAGE_TYPE VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
17: P_ACTUAL_REPAIR_COST NUMBER := OKC_API.G_MISS_NUM,
18: P_DATE_APPROVED DATE := OKC_API.G_MISS_DATE,
19: P_BILL_TO NUMBER := OKC_API.G_MISS_NUM,
20: P_DATE_INVOICE DATE := OKC_API.G_MISS_DATE,
21: P_APPROVED_YN VARCHAR2(1) := OKC_API.G_MISS_CHAR,
22: P_ACD_ID_COST NUMBER := OKC_API.G_MISS_NUM,
23: P_OBJECT_VERSION_NUMBER NUMBER := OKC_API.G_MISS_NUM);
24:
17: P_ACTUAL_REPAIR_COST NUMBER := OKC_API.G_MISS_NUM,
18: P_DATE_APPROVED DATE := OKC_API.G_MISS_DATE,
19: P_BILL_TO NUMBER := OKC_API.G_MISS_NUM,
20: P_DATE_INVOICE DATE := OKC_API.G_MISS_DATE,
21: P_APPROVED_YN VARCHAR2(1) := OKC_API.G_MISS_CHAR,
22: P_ACD_ID_COST NUMBER := OKC_API.G_MISS_NUM,
23: P_OBJECT_VERSION_NUMBER NUMBER := OKC_API.G_MISS_NUM);
24:
25: TYPE tld_rec_type IS RECORD (
18: P_DATE_APPROVED DATE := OKC_API.G_MISS_DATE,
19: P_BILL_TO NUMBER := OKC_API.G_MISS_NUM,
20: P_DATE_INVOICE DATE := OKC_API.G_MISS_DATE,
21: P_APPROVED_YN VARCHAR2(1) := OKC_API.G_MISS_CHAR,
22: P_ACD_ID_COST NUMBER := OKC_API.G_MISS_NUM,
23: P_OBJECT_VERSION_NUMBER NUMBER := OKC_API.G_MISS_NUM);
24:
25: TYPE tld_rec_type IS RECORD (
26: inv_tld_id NUMBER := OKC_API.G_MISS_NUM,
19: P_BILL_TO NUMBER := OKC_API.G_MISS_NUM,
20: P_DATE_INVOICE DATE := OKC_API.G_MISS_DATE,
21: P_APPROVED_YN VARCHAR2(1) := OKC_API.G_MISS_CHAR,
22: P_ACD_ID_COST NUMBER := OKC_API.G_MISS_NUM,
23: P_OBJECT_VERSION_NUMBER NUMBER := OKC_API.G_MISS_NUM);
24:
25: TYPE tld_rec_type IS RECORD (
26: inv_tld_id NUMBER := OKC_API.G_MISS_NUM,
27: cm_tld_id NUMBER := OKC_API.G_MISS_NUM);
22: P_ACD_ID_COST NUMBER := OKC_API.G_MISS_NUM,
23: P_OBJECT_VERSION_NUMBER NUMBER := OKC_API.G_MISS_NUM);
24:
25: TYPE tld_rec_type IS RECORD (
26: inv_tld_id NUMBER := OKC_API.G_MISS_NUM,
27: cm_tld_id NUMBER := OKC_API.G_MISS_NUM);
28:
29: TYPE sdd_rec_type IS RECORD (
30: lsm_id NUMBER := OKC_API.G_MISS_NUM,
23: P_OBJECT_VERSION_NUMBER NUMBER := OKC_API.G_MISS_NUM);
24:
25: TYPE tld_rec_type IS RECORD (
26: inv_tld_id NUMBER := OKC_API.G_MISS_NUM,
27: cm_tld_id NUMBER := OKC_API.G_MISS_NUM);
28:
29: TYPE sdd_rec_type IS RECORD (
30: lsm_id NUMBER := OKC_API.G_MISS_NUM,
31: tld_id NUMBER := OKC_API.G_MISS_NUM,
26: inv_tld_id NUMBER := OKC_API.G_MISS_NUM,
27: cm_tld_id NUMBER := OKC_API.G_MISS_NUM);
28:
29: TYPE sdd_rec_type IS RECORD (
30: lsm_id NUMBER := OKC_API.G_MISS_NUM,
31: tld_id NUMBER := OKC_API.G_MISS_NUM,
32: amount NUMBER := OKC_API.G_MISS_NUM);
33:
34: TYPE ariv_tbl_type IS TABLE OF ariv_rec_type
27: cm_tld_id NUMBER := OKC_API.G_MISS_NUM);
28:
29: TYPE sdd_rec_type IS RECORD (
30: lsm_id NUMBER := OKC_API.G_MISS_NUM,
31: tld_id NUMBER := OKC_API.G_MISS_NUM,
32: amount NUMBER := OKC_API.G_MISS_NUM);
33:
34: TYPE ariv_tbl_type IS TABLE OF ariv_rec_type
35: INDEX BY BINARY_INTEGER;
28:
29: TYPE sdd_rec_type IS RECORD (
30: lsm_id NUMBER := OKC_API.G_MISS_NUM,
31: tld_id NUMBER := OKC_API.G_MISS_NUM,
32: amount NUMBER := OKC_API.G_MISS_NUM);
33:
34: TYPE ariv_tbl_type IS TABLE OF ariv_rec_type
35: INDEX BY BINARY_INTEGER;
36:
84: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
85: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) :=
86: 'OKL_CONTRACTS_UNEXPECTED_ERROR';
87:
88: G_OKC_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
91: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
92:
85: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) :=
86: 'OKL_CONTRACTS_UNEXPECTED_ERROR';
87:
88: G_OKC_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
91: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
92:
93: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
86: 'OKL_CONTRACTS_UNEXPECTED_ERROR';
87:
88: G_OKC_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
91: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
92:
93: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
94:
87:
88: G_OKC_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
91: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
92:
93: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
94:
95: ---------------------------------------------------------------------------
114:
115: -- Create Invoice for Asset Repair
116: PROCEDURE Create_Repair_Invoice (
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
121: x_return_status OUT NOCOPY VARCHAR2,
122: p_ariv_tbl IN ariv_tbl_type,
124:
125: -- Create Invoice for Remarket Sale
126: PROCEDURE Create_Remarket_Invoice (
127: p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: x_return_status OUT NOCOPY VARCHAR2,
132: p_order_line_id IN NUMBER,
134:
135: -- Create Invoice from Termination or Repurchase Quote
136: PROCEDURE Create_Quote_Invoice (
137: p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
139: x_msg_count OUT NOCOPY NUMBER,
140: x_msg_data OUT NOCOPY VARCHAR2,
141: x_return_status OUT NOCOPY VARCHAR2,
142: p_quote_id IN NUMBER,
144:
145: -- Create Credit Memo for Security Deposit Disposition
146: PROCEDURE Create_Scrt_Dpst_Dsps_Inv (
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
151: x_return_status OUT NOCOPY VARCHAR2,
152: p_contract_id IN NUMBER,