212: FUNCTION Get_Charge_name
213: ( p_list_header_id IN qp_list_headers_b.list_header_id%type
214: , p_Charge_Type_code IN QP_CHARGE_LOOKUP.lookup_code%type
215: , p_Charge_Subtype_code IN QP_LOOKUPS.lookup_code%type
216: , p_list_line_type_code IN QP_LIST_LINES.list_line_type_code%type
217: )
218: RETURN QP_LOOKUPS.Meaning%Type;
219:
220: FUNCTION Get_Formula
222: )
223: RETURN QP_PRICE_FORMULAS_VL.Name%Type;
224:
225: FUNCTION Get_Expiration_Date
226: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
227: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
228: )
229: RETURN QP_LIST_LINES.Expiration_Date%Type;
230:
223: RETURN QP_PRICE_FORMULAS_VL.Name%Type;
224:
225: FUNCTION Get_Expiration_Date
226: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
227: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
228: )
229: RETURN QP_LIST_LINES.Expiration_Date%Type;
230:
231: FUNCTION Get_Exp_Period_Start_Date
225: FUNCTION Get_Expiration_Date
226: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
227: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
228: )
229: RETURN QP_LIST_LINES.Expiration_Date%Type;
230:
231: FUNCTION Get_Exp_Period_Start_Date
232: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
233: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
228: )
229: RETURN QP_LIST_LINES.Expiration_Date%Type;
230:
231: FUNCTION Get_Exp_Period_Start_Date
232: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
233: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
234: )
235: RETURN QP_LIST_LINES.Expiration_Period_Start_Date%Type;
236:
229: RETURN QP_LIST_LINES.Expiration_Date%Type;
230:
231: FUNCTION Get_Exp_Period_Start_Date
232: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
233: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
234: )
235: RETURN QP_LIST_LINES.Expiration_Period_Start_Date%Type;
236:
237: FUNCTION Get_Number_Expiration_Periods
231: FUNCTION Get_Exp_Period_Start_Date
232: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
233: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
234: )
235: RETURN QP_LIST_LINES.Expiration_Period_Start_Date%Type;
236:
237: FUNCTION Get_Number_Expiration_Periods
238: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
239: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
234: )
235: RETURN QP_LIST_LINES.Expiration_Period_Start_Date%Type;
236:
237: FUNCTION Get_Number_Expiration_Periods
238: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
239: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
240: )
241: RETURN QP_LIST_LINES.Number_Expiration_Periods%Type;
242:
235: RETURN QP_LIST_LINES.Expiration_Period_Start_Date%Type;
236:
237: FUNCTION Get_Number_Expiration_Periods
238: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
239: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
240: )
241: RETURN QP_LIST_LINES.Number_Expiration_Periods%Type;
242:
243: FUNCTION Get_Expiration_Period_UOM
237: FUNCTION Get_Number_Expiration_Periods
238: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
239: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
240: )
241: RETURN QP_LIST_LINES.Number_Expiration_Periods%Type;
242:
243: FUNCTION Get_Expiration_Period_UOM
244: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
245: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
240: )
241: RETURN QP_LIST_LINES.Number_Expiration_Periods%Type;
242:
243: FUNCTION Get_Expiration_Period_UOM
244: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
245: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
246: )
247: RETURN QP_LIST_LINES.Expiration_Period_UOM%Type;
248:
241: RETURN QP_LIST_LINES.Number_Expiration_Periods%Type;
242:
243: FUNCTION Get_Expiration_Period_UOM
244: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
245: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
246: )
247: RETURN QP_LIST_LINES.Expiration_Period_UOM%Type;
248:
249: FUNCTION Get_Rebate_Txn_Type
243: FUNCTION Get_Expiration_Period_UOM
244: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
245: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
246: )
247: RETURN QP_LIST_LINES.Expiration_Period_UOM%Type;
248:
249: FUNCTION Get_Rebate_Txn_Type
250: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
251: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
246: )
247: RETURN QP_LIST_LINES.Expiration_Period_UOM%Type;
248:
249: FUNCTION Get_Rebate_Txn_Type
250: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
251: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
252: , p_list_line_type_code IN QP_LIST_LINES.list_line_type_code%type
253: , p_rebate_transaction_type_code IN QP_LIST_LINES.REBATE_TRANSACTION_TYPE_CODE%type
254: )
247: RETURN QP_LIST_LINES.Expiration_Period_UOM%Type;
248:
249: FUNCTION Get_Rebate_Txn_Type
250: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
251: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
252: , p_list_line_type_code IN QP_LIST_LINES.list_line_type_code%type
253: , p_rebate_transaction_type_code IN QP_LIST_LINES.REBATE_TRANSACTION_TYPE_CODE%type
254: )
255: RETURN QP_LOOKUPS.Meaning%Type;
248:
249: FUNCTION Get_Rebate_Txn_Type
250: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
251: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
252: , p_list_line_type_code IN QP_LIST_LINES.list_line_type_code%type
253: , p_rebate_transaction_type_code IN QP_LIST_LINES.REBATE_TRANSACTION_TYPE_CODE%type
254: )
255: RETURN QP_LOOKUPS.Meaning%Type;
256:
249: FUNCTION Get_Rebate_Txn_Type
250: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
251: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
252: , p_list_line_type_code IN QP_LIST_LINES.list_line_type_code%type
253: , p_rebate_transaction_type_code IN QP_LIST_LINES.REBATE_TRANSACTION_TYPE_CODE%type
254: )
255: RETURN QP_LOOKUPS.Meaning%Type;
256:
257: FUNCTION Get_Benefit_Qty
254: )
255: RETURN QP_LOOKUPS.Meaning%Type;
256:
257: FUNCTION Get_Benefit_Qty
258: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
259: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
260: )
261: RETURN QP_LIST_LINES.Benefit_Qty%Type;
262:
255: RETURN QP_LOOKUPS.Meaning%Type;
256:
257: FUNCTION Get_Benefit_Qty
258: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
259: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
260: )
261: RETURN QP_LIST_LINES.Benefit_Qty%Type;
262:
263: FUNCTION Get_Benefit_UOM_Code
257: FUNCTION Get_Benefit_Qty
258: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
259: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
260: )
261: RETURN QP_LIST_LINES.Benefit_Qty%Type;
262:
263: FUNCTION Get_Benefit_UOM_Code
264: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
265: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
260: )
261: RETURN QP_LIST_LINES.Benefit_Qty%Type;
262:
263: FUNCTION Get_Benefit_UOM_Code
264: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
265: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
266: )
267: RETURN QP_LIST_LINES.Benefit_UOM_Code%Type;
268:
261: RETURN QP_LIST_LINES.Benefit_Qty%Type;
262:
263: FUNCTION Get_Benefit_UOM_Code
264: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
265: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
266: )
267: RETURN QP_LIST_LINES.Benefit_UOM_Code%Type;
268:
269: FUNCTION Get_Benefit_List_Line_No
263: FUNCTION Get_Benefit_UOM_Code
264: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
265: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
266: )
267: RETURN QP_LIST_LINES.Benefit_UOM_Code%Type;
268:
269: FUNCTION Get_Benefit_List_Line_No
270: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
271: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
266: )
267: RETURN QP_LIST_LINES.Benefit_UOM_Code%Type;
268:
269: FUNCTION Get_Benefit_List_Line_No
270: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
271: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
272: )
273: RETURN QP_LIST_LINES.List_Line_No%Type;
274:
267: RETURN QP_LIST_LINES.Benefit_UOM_Code%Type;
268:
269: FUNCTION Get_Benefit_List_Line_No
270: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
271: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
272: )
273: RETURN QP_LIST_LINES.List_Line_No%Type;
274:
275: FUNCTION Get_Accrual_Flag
269: FUNCTION Get_Benefit_List_Line_No
270: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
271: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
272: )
273: RETURN QP_LIST_LINES.List_Line_No%Type;
274:
275: FUNCTION Get_Accrual_Flag
276: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
277: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
272: )
273: RETURN QP_LIST_LINES.List_Line_No%Type;
274:
275: FUNCTION Get_Accrual_Flag
276: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
277: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
278: )
279: RETURN QP_LIST_LINES.Accrual_Flag%Type;
280:
273: RETURN QP_LIST_LINES.List_Line_No%Type;
274:
275: FUNCTION Get_Accrual_Flag
276: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
277: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
278: )
279: RETURN QP_LIST_LINES.Accrual_Flag%Type;
280:
281: FUNCTION Get_Accrual_Conversion_Rate
275: FUNCTION Get_Accrual_Flag
276: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
277: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
278: )
279: RETURN QP_LIST_LINES.Accrual_Flag%Type;
280:
281: FUNCTION Get_Accrual_Conversion_Rate
282: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
283: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
278: )
279: RETURN QP_LIST_LINES.Accrual_Flag%Type;
280:
281: FUNCTION Get_Accrual_Conversion_Rate
282: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
283: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
284: )
285: RETURN QP_LIST_LINES.Accrual_Conversion_Rate%Type;
286:
279: RETURN QP_LIST_LINES.Accrual_Flag%Type;
280:
281: FUNCTION Get_Accrual_Conversion_Rate
282: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
283: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
284: )
285: RETURN QP_LIST_LINES.Accrual_Conversion_Rate%Type;
286:
287: FUNCTION Get_Estim_Accrual_Rate
281: FUNCTION Get_Accrual_Conversion_Rate
282: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
283: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
284: )
285: RETURN QP_LIST_LINES.Accrual_Conversion_Rate%Type;
286:
287: FUNCTION Get_Estim_Accrual_Rate
288: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
289: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
284: )
285: RETURN QP_LIST_LINES.Accrual_Conversion_Rate%Type;
286:
287: FUNCTION Get_Estim_Accrual_Rate
288: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
289: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
290: )
291: RETURN QP_LIST_LINES.Estim_Accrual_Rate%Type;
292:
285: RETURN QP_LIST_LINES.Accrual_Conversion_Rate%Type;
286:
287: FUNCTION Get_Estim_Accrual_Rate
288: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
289: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
290: )
291: RETURN QP_LIST_LINES.Estim_Accrual_Rate%Type;
292:
293: FUNCTION Get_Break_Line_Type_Code
287: FUNCTION Get_Estim_Accrual_Rate
288: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
289: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
290: )
291: RETURN QP_LIST_LINES.Estim_Accrual_Rate%Type;
292:
293: FUNCTION Get_Break_Line_Type_Code
294: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
295: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
290: )
291: RETURN QP_LIST_LINES.Estim_Accrual_Rate%Type;
292:
293: FUNCTION Get_Break_Line_Type_Code
294: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
295: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
296: )
297: RETURN QP_LIST_LINES.List_Line_Type_Code%Type;
298:
291: RETURN QP_LIST_LINES.Estim_Accrual_Rate%Type;
292:
293: FUNCTION Get_Break_Line_Type_Code
294: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
295: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
296: )
297: RETURN QP_LIST_LINES.List_Line_Type_Code%Type;
298:
299: FUNCTION Get_Break_Line_Type
293: FUNCTION Get_Break_Line_Type_Code
294: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
295: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
296: )
297: RETURN QP_LIST_LINES.List_Line_Type_Code%Type;
298:
299: FUNCTION Get_Break_Line_Type
300: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
301: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
296: )
297: RETURN QP_LIST_LINES.List_Line_Type_Code%Type;
298:
299: FUNCTION Get_Break_Line_Type
300: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
301: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
302: , p_break_line_type_code IN QP_LIST_LINES.list_line_type_code%type
303: )
304: RETURN QP_LOOKUPS.Meaning%Type;
297: RETURN QP_LIST_LINES.List_Line_Type_Code%Type;
298:
299: FUNCTION Get_Break_Line_Type
300: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
301: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
302: , p_break_line_type_code IN QP_LIST_LINES.list_line_type_code%type
303: )
304: RETURN QP_LOOKUPS.Meaning%Type;
305:
298:
299: FUNCTION Get_Break_Line_Type
300: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
301: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
302: , p_break_line_type_code IN QP_LIST_LINES.list_line_type_code%type
303: )
304: RETURN QP_LOOKUPS.Meaning%Type;
305:
306: FUNCTION Get_Context(p_FlexField_Name IN VARCHAR2
343: ,p_attr_value_To IN VARCHAR2
344: ) RETURN VARCHAR2;
345:
346: FUNCTION Get_To_Rltd_Modifier_ID
347: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type
348: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
349: )
350: RETURN QP_RLTD_MODIFIERS.To_Rltd_Modifier_ID%Type;
351:
344: ) RETURN VARCHAR2;
345:
346: FUNCTION Get_To_Rltd_Modifier_ID
347: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type
348: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
349: )
350: RETURN QP_RLTD_MODIFIERS.To_Rltd_Modifier_ID%Type;
351:
352: FUNCTION Get_Rltd_Modifier_ID
349: )
350: RETURN QP_RLTD_MODIFIERS.To_Rltd_Modifier_ID%Type;
351:
352: FUNCTION Get_Rltd_Modifier_ID
353: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type
354: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
355: )
356: RETURN QP_RLTD_MODIFIERS.Rltd_Modifier_ID%Type;
357:
350: RETURN QP_RLTD_MODIFIERS.To_Rltd_Modifier_ID%Type;
351:
352: FUNCTION Get_Rltd_Modifier_ID
353: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type
354: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
355: )
356: RETURN QP_RLTD_MODIFIERS.Rltd_Modifier_ID%Type;
357:
358: FUNCTION Get_Rltd_Modifier_Grp_Type
355: )
356: RETURN QP_RLTD_MODIFIERS.Rltd_Modifier_ID%Type;
357:
358: FUNCTION Get_Rltd_Modifier_Grp_Type
359: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type
360: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
361: )
362: RETURN QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_Type%Type;
363:
356: RETURN QP_RLTD_MODIFIERS.Rltd_Modifier_ID%Type;
357:
358: FUNCTION Get_Rltd_Modifier_Grp_Type
359: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type
360: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
361: )
362: RETURN QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_Type%Type;
363:
364: FUNCTION Get_Rltd_Modifier_Grp_No
361: )
362: RETURN QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_Type%Type;
363:
364: FUNCTION Get_Rltd_Modifier_Grp_No
365: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type
366: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
367: )
368: RETURN QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_No%Type;
369:
362: RETURN QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_Type%Type;
363:
364: FUNCTION Get_Rltd_Modifier_Grp_No
365: ( p_list_line_id IN QP_LIST_LINES.List_Line_ID%Type
366: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
367: )
368: RETURN QP_RLTD_MODIFIERS.Rltd_Modifier_Grp_No%Type;
369:
370: