DBA Data[Home] [Help]

APPS.OKL_AM_INVOICES_PVT dependencies on OKC_API

Line 12: P_ACN_ID NUMBER := OKC_API.G_MISS_NUM,

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,

Line 13: P_ACS_CODE VARCHAR2(200) := 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,

Line 14: P_PART_NAME VARCHAR2(2000) := OKC_API.G_MISS_CHAR,

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,

Line 15: P_CONDITION_TYPE VARCHAR2(2000) := OKC_API.G_MISS_CHAR,

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,

Line 16: P_DAMAGE_TYPE VARCHAR2(2000) := OKC_API.G_MISS_CHAR,

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,

Line 17: P_ACTUAL_REPAIR_COST 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,
21: P_APPROVED_YN VARCHAR2(1) := OKC_API.G_MISS_CHAR,

Line 18: P_DATE_APPROVED DATE := OKC_API.G_MISS_DATE,

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,

Line 19: P_BILL_TO 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);

Line 20: P_DATE_INVOICE DATE := OKC_API.G_MISS_DATE,

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:

Line 21: P_APPROVED_YN VARCHAR2(1) := 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:
25: TYPE tld_rec_type IS RECORD (

Line 22: P_ACD_ID_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 (
26: inv_tld_id NUMBER := OKC_API.G_MISS_NUM,

Line 23: P_OBJECT_VERSION_NUMBER 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);

Line 26: inv_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,

Line 27: cm_tld_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,

Line 30: lsm_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

Line 31: 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
35: INDEX BY BINARY_INTEGER;

Line 32: amount 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;
36:

Line 88: G_OKC_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

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:

Line 89: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

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;

Line 90: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

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:

Line 91: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

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

Line 118: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 128: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 138: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,