DBA Data[Home] [Help]

APPS.OKS_COVERAGES_PVT dependencies on OKC_K_ITEMS

Line 151: (bp_id OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,

147:
148:
149:
150: TYPE res_rec_type IS RECORD
151: (bp_id OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
152: cro_code OKC_CONTACTS_V.CRO_CODE%TYPE,
153: object1_id1 OKC_CONTACTS_V.object1_id1%TYPE,
154: resource_class OKC_CONTACTS_V.RESOURCE_CLASS%TYPE);
155:

Line 165: (object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,

161:
162:
163:
164: TYPE bp_rec_type IS RECORD
165: (object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
166: bp_line_id OKC_K_LINES_V.ID%TYPE,
167: start_date DATE,
168: end_date DATE);
169:

Line 177: (bp_id OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,

173: x_source_bp_tbl_type bp_tbl_type ;
174: x_target_bp_tbl_type bp_tbl_type ;
175:
176: TYPE bp_line_rec_type IS RECORD
177: (bp_id OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
178: src_bp_line_id OKC_K_LINES_V.ID%TYPE,
179: tgt_bp_line_id OKC_K_LINES_V.ID%TYPE);
180:
181: TYPE bp_line_tbl_type IS TABLE OF bp_line_rec_type INDEX BY BINARY_INTEGER;

Line 187: (OBJECT1_ID1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,

183: l_bp_tbl bp_line_tbl_type;
184:
185:
186: TYPE COVER_TIME_REC_TYPE IS RECORD
187: (OBJECT1_ID1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
188: START_DAY OKC_TIMEVALUES_V.DAY_OF_WEEK%TYPE,
189: START_HOUR OKC_TIMEVALUES_V.HOUR%TYPE,
190: START_MINUTE OKC_TIMEVALUES_V.MINUTE%TYPE,
191: END_DAY OKC_TIMEVALUES_V.DAY_OF_WEEK%TYPE,

Line 316: OBJECT1_ID1 OKC_K_ITEMS.OBJECT1_ID1%TYPE,

312:
313: --------------------CHECK COVERAGE MATCH------------------------------------------
314: TYPE oks_bp_rec IS RECORD
315: (PRICE_LIST_ID OKC_K_LINES_B.PRICE_LIST_ID%TYPE,
316: OBJECT1_ID1 OKC_K_ITEMS.OBJECT1_ID1%TYPE,
317: DISCOUNT_LIST OKS_K_LINES_B.DISCOUNT_LIST%TYPE,
318: OFFSET_DURATION OKS_K_LINES_B.OFFSET_DURATION%TYPE,
319: OFFSET_PERIOD OKS_K_LINES_B.OFFSET_PERIOD%TYPE,
320: ALLOW_BT_DISCOUNT OKS_K_LINES_B.ALLOW_BT_DISCOUNT%TYPE,

Line 330: (object1_id1 OKC_K_ITEMS.object1_id1%TYPE,

326: x_source_bp_tbl oks_bp_tbl;
327: x_target_bp_tbl oks_bp_tbl;
328:
329: TYPE bp_cover_time_rec IS RECORD
330: (object1_id1 OKC_K_ITEMS.object1_id1%TYPE,
331: timezone_id OKS_COVERAGE_TIMEZONES.timezone_id%TYPE,
332: default_yn OKS_COVERAGE_TIMEZONES.default_yn%TYPE,
333: start_hour OKS_COVERAGE_TIMES.start_hour%TYPE,
334: start_minute OKS_COVERAGE_TIMES.start_minute%TYPE,

Line 374: (object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,

370: x_source_react_time_tbl react_time_tbl;
371: x_target_react_time_tbl react_time_tbl;
372:
373: TYPE bill_type_rec IS RECORD
374: (object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
375: bill_type_line_id NUMBER,
376: billing_type VARCHAR2(30),
377: discount_amount OKS_K_LINES_B.DISCOUNT_AMOUNT%TYPE,
378: discount_percent OKS_K_LINES_B.DISCOUNT_PERCENT%TYPE);