DBA Data[Home] [Help]

APPS.PA_FP_OF_WEBADI_PKG dependencies on PA_FP_OF_WEBADI_XFACE

Line 293: delete from pa_fp_of_webadi_xface

289: l_session_id := p_session_id;
290: l_budget_version_id := p_budget_version_id;
291: l_amount_type_code := p_amount_type_code;
292:
293: delete from pa_fp_of_webadi_xface
294: where session_id = l_session_id
295: and amount_type_code = l_amount_type_code;
296:
297:

Line 410: INSERT INTO pa_fp_of_webadi_xface

406:
407: CLOSE C3;
408:
409: FORALL x in Category_id_tab.first..Category_id_tab.last
410: INSERT INTO pa_fp_of_webadi_xface
411: (Session_id,
412: budget_version_id,
413: amount_type_code,
414: Category_id,

Line 650: Insert INTO pa_fp_of_webadi_xface

646:
647: --dbms_output.put_line('Done calculating org total');
648:
649:
650: Insert INTO pa_fp_of_webadi_xface
651: (Session_id,
652: budget_version_id,
653: amount_type_code,
654: Category_id,

Line 951: Insert INTO pa_fp_of_webadi_xface

947:
948: --dbms_output.put_line('done calculating cat total');
949:
950:
951: Insert INTO pa_fp_of_webadi_xface
952: (Session_id,
953: budget_version_id,
954: amount_type_code,
955: category_id,