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 495: l_Operand_Tbl QP_FORMULA_RULES_PVT.t_Operand_Tbl_Type;

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

Line 1562: l_operand_tbl QP_FORMULA_RULES_PVT.t_Operand_Tbl_Type;

1558: IS
1559: head NUMBER;
1560: tail NUMBER;
1561: l_step_num NUMBER;
1562: l_operand_tbl QP_FORMULA_RULES_PVT.t_Operand_Tbl_Type;
1563: BEGIN
1564: -- parse the operands string into a table
1565: -- first read in step number, followed by step values
1566: -- head and tail indicate start and end positions of search in the string