DBA Data[Home] [Help]

APPS.PA_FP_COPY_ACTUALS_PUB dependencies on PA_FP_COPY_ACTUALS_PUB

Line 1: PACKAGE body PA_FP_COPY_ACTUALS_PUB as

1: PACKAGE body PA_FP_COPY_ACTUALS_PUB as
2: /* $Header: PAFPCAPB.pls 120.6.12010000.2 2008/08/20 11:42:30 sugupta ship $ */
3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4:
5: /**This procedure is called to copy actuals to budget version lines**/

Line 17: l_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_copy_actuals_pub.copy_actuals';

13: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
14: X_MSG_COUNT OUT NOCOPY NUMBER,
15: X_MSG_DATA OUT NOCOPY VARCHAR2)
16: IS
17: l_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_copy_actuals_pub.copy_actuals';
18: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
19: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
20: l_struct_ver_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
21: l_calendar_type_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

Line 743: (p_msg => 'Before calling pa_fp_copy_actuals_pub.create_res_asg',

739: -- budget_version_id = p_budget_version_id;
740: --dbms_output.put_line('before calling cre res asg api: res_assign has: '||l_count);
741: IF P_PA_DEBUG_MODE = 'Y' THEN
742: pa_fp_gen_amount_utils.fp_debug
743: (p_msg => 'Before calling pa_fp_copy_actuals_pub.create_res_asg',
744: p_module_name => l_module_name,
745: p_log_level => 5);
746: END IF;
747: PA_FP_COPY_ACTUALS_PUB.CREATE_RES_ASG (

Line 747: PA_FP_COPY_ACTUALS_PUB.CREATE_RES_ASG (

743: (p_msg => 'Before calling pa_fp_copy_actuals_pub.create_res_asg',
744: p_module_name => l_module_name,
745: p_log_level => 5);
746: END IF;
747: PA_FP_COPY_ACTUALS_PUB.CREATE_RES_ASG (
748: P_PROJECT_ID => P_PROJECT_ID,
749: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
750: P_FP_COLS_REC => P_FP_COLS_REC,
751: X_RETURN_STATUS => x_return_status,

Line 774: PA_FP_COPY_ACTUALS_PUB.UPDATE_RES_ASG (

770: (p_msg => 'Before calling update_res_asg',
771: p_module_name => l_module_name,
772: p_log_level => 5);
773: END IF;
774: PA_FP_COPY_ACTUALS_PUB.UPDATE_RES_ASG (
775: P_PROJECT_ID => P_PROJECT_ID,
776: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
777: P_FP_COLS_REC => P_FP_COLS_REC,
778: X_RETURN_STATUS => x_return_status,

Line 1168: ( p_pkg_name => 'PA_FP_COPY_ACTUALS_PUB',

1164: x_msg_count := 1;
1165: x_msg_data := substr(sqlerrm,1,240);
1166: -- dbms_output.put_line('error msg :'||x_msg_data);
1167: FND_MSG_PUB.add_exc_msg
1168: ( p_pkg_name => 'PA_FP_COPY_ACTUALS_PUB',
1169: p_procedure_name => 'COPY_ACTUALS',
1170: p_error_text => substr(sqlerrm,1,240));
1171:
1172: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1193: l_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_copy_actuals_pub.create_res_asg';

1189: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1190: X_MSG_COUNT OUT NOCOPY NUMBER,
1191: X_MSG_DATA OUT NOCOPY VARCHAR2)
1192: IS
1193: l_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_copy_actuals_pub.create_res_asg';
1194:
1195: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1196: l_res_plan_level VARCHAR2(15);
1197:

Line 1567: ( p_pkg_name => 'PA_FP_COPY_ACTUALS_PUB',

1563: x_msg_count := 1;
1564: x_msg_data := substr(sqlerrm,1,240);
1565: -- dbms_output.put_line('error msg :'||x_msg_data);
1566: FND_MSG_PUB.add_exc_msg
1567: ( p_pkg_name => 'PA_FP_COPY_ACTUALS_PUB',
1568: p_procedure_name => 'CREATE_RES_ASG',
1569: p_error_text => substr(sqlerrm,1,240));
1570:
1571: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1591: l_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_copy_actuals_pub.update_res_asg';

1587: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1588: X_MSG_COUNT OUT NOCOPY NUMBER,
1589: X_MSG_DATA OUT NOCOPY VARCHAR2)
1590: IS
1591: l_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_copy_actuals_pub.update_res_asg';
1592: l_res_plan_level VARCHAR2(15);
1593:
1594: l_count NUMBER;
1595: l_msg_count NUMBER;

Line 1727: ( p_pkg_name => 'PA_FP_COPY_ACTUALS_PUB',

1723: x_msg_count := 1;
1724: x_msg_data := substr(sqlerrm,1,240);
1725: -- dbms_output.put_line('error msg :'||x_msg_data);
1726: FND_MSG_PUB.add_exc_msg
1727: ( p_pkg_name => 'PA_FP_COPY_ACTUALS_PUB',
1728: p_procedure_name => 'UPDATE_RES_ASG',
1729: p_error_text => substr(sqlerrm,1,240));
1730:
1731: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1742: END PA_FP_COPY_ACTUALS_PUB;

1738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1739: END UPDATE_RES_ASG;
1740:
1741:
1742: END PA_FP_COPY_ACTUALS_PUB;