DBA Data[Home] [Help]

APPS.QP_FORMULA_PRICE_CALC_PVT dependencies on QP_FORMULA_RULES_PVT

Line 130: p_operand_tbl IN QP_FORMULA_RULES_PVT.T_OPERAND_TBL_TYPE)

126: -- corresponding operand values, then evaluates the resulting expression in
127: -- the SQL engine to produce a result
128: -----------------------------------------------------------------------------
129: FUNCTION Select_From_Dual(p_formula IN VARCHAR2,
130: p_operand_tbl IN QP_FORMULA_RULES_PVT.T_OPERAND_TBL_TYPE)
131: RETURN NUMBER
132: IS
133: l_char VARCHAR2(1) := '';
134: l_number VARCHAR2(2000) := '';

Line 493: l_Operand_Tbl QP_FORMULA_RULES_PVT.t_Operand_Tbl_Type;

489: E_FORMULA_COMPONENTS_REQ EXCEPTION;
490: E_CUSTOMIZE_GET_CUSTOM_PRICE EXCEPTION;
491: E_INVALID_NUMBER EXCEPTION;
492:
493: l_Operand_Tbl QP_FORMULA_RULES_PVT.t_Operand_Tbl_Type;
494:
495: l_formula_start_time NUMBER;
496: l_formula_end_time NUMBER;
497: l_time_difference NUMBER;

Line 1347: l_operand_tbl QP_FORMULA_RULES_PVT.t_Operand_Tbl_Type;

1343: IS
1344: head NUMBER;
1345: tail NUMBER;
1346: l_step_num NUMBER;
1347: l_operand_tbl QP_FORMULA_RULES_PVT.t_Operand_Tbl_Type;
1348: BEGIN
1349: -- parse the operands string into a table
1350: -- first read in step number, followed by step values
1351: -- head and tail indicate start and end positions of search in the string