DBA Data[Home] [Help]

APPS.QP_PROCESS_OTHER_BENEFITS_PVT dependencies on QP_PROCESS_OTHER_BENEFITS_PVT

Line 1: PACKAGE BODY QP_Process_Other_Benefits_PVT AS

1: PACKAGE BODY QP_Process_Other_Benefits_PVT AS
2: /* $Header: QPXVOTHB.pls 120.8.12020000.3 2013/05/09 09:59:18 jputta ship $ */
3: l_debug VARCHAR2(3);
4: PROCEDURE Calculate_Recurring_Quantity(p_list_line_id NUMBER,
5: p_list_header_id NUMBER,

Line 61: v_routine_name CONSTANT VARCHAR2(240):='Routine:QP_Process_Other_Benefits_PVT.Calculate_Recurring_Quantity';

57: SELECT MODIFIER_LEVEL_CODE
58: FROM QP_LIST_LINES
59: WHERE LIST_LINE_ID = p_list_line_id;
60:
61: v_routine_name CONSTANT VARCHAR2(240):='Routine:QP_Process_Other_Benefits_PVT.Calculate_Recurring_Quantity';
62:
63: v_total_base_qty NUMBER;
64: v_group_qty NUMBER;
65: v_group_amount NUMBER;

Line 195: v_routine_name CONSTANT VARCHAR2(240):='QP_Process_Other_Benefits_PVT.Calculate_Recurring_Quantity';

191:
192: PROCEDURE Calculate_Recurring_Quantity(p_pricing_phase_id NUMBER,
193: x_return_status OUT NOCOPY VARCHAR2,
194: x_return_status_txt OUT NOCOPY VARCHAR2) IS
195: v_routine_name CONSTANT VARCHAR2(240):='QP_Process_Other_Benefits_PVT.Calculate_Recurring_Quantity';
196:
197: CURSOR get_recurring_details_cur IS
198: SELECT QPLT.LINE_DETAIL_INDEX,
199: QPLT.CREATED_FROM_LIST_LINE_ID,

Line 243: QP_Process_Other_Benefits_PVT.Calculate_Recurring_Quantity(

239: QP_PREQ_GRP.engine_debug('List Line Index: ' || l_LINE_INDEX_TBL(I) );
240: END IF;
241:
242: -- Call Recurring Routine
243: QP_Process_Other_Benefits_PVT.Calculate_Recurring_Quantity(
244: l_LIST_LINE_ID_TBL(I),
245: l_LIST_HEADER_ID_TBL(I),
246: l_LINE_INDEX_TBL(I),
247: NULL,

Line 1456: END QP_Process_Other_Benefits_PVT;

1452: END IF;
1453: x_return_status := FND_API.G_RET_STS_ERROR;
1454: x_return_status_txt := v_routine_name || ' ' || SQLERRM;
1455: END Process_Other_Benefits;
1456: END QP_Process_Other_Benefits_PVT;