eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_BUDGET_VERSIONS

Line 15: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

11: * for list of valid parameter values.
12: **/
13: PROCEDURE GENERATE_BUDGET_AMT_WRP
14: (P_PROJECT_ID IN pa_projects_all.PROJECT_ID%TYPE,
15: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
16: P_CALLED_MODE IN VARCHAR2,
17: P_COMMIT_FLAG IN VARCHAR2,
18: P_INIT_MSG_FLAG IN VARCHAR2,
19: P_CHECK_SRC_ERRORS_FLAG IN VARCHAR2,

Line 27: l_cost_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

23: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
24:
25: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_WRP';
26:
27: l_cost_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
28: l_ci_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
29: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
30: l_deleted_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
31: l_commit_flag VARCHAR2(1);

Line 47: l_source_bv_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

43: -- g_mrc_exception EXCEPTION;
44:
45: l_wp_track_cost_flag VARCHAR2(1);
46:
47: l_source_bv_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
48:
49: l_record_version_number PA_BUDGET_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
50:
51: l_res_as_id PA_PLSQL_DATATYPES.IdTabTyp; /* Bug 4160375 */

Line 49: l_record_version_number PA_BUDGET_VERSIONS.RECORD_VERSION_NUMBER%TYPE;

45: l_wp_track_cost_flag VARCHAR2(1);
46:
47: l_source_bv_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
48:
49: l_record_version_number PA_BUDGET_VERSIONS.RECORD_VERSION_NUMBER%TYPE;
50:
51: l_res_as_id PA_PLSQL_DATATYPES.IdTabTyp; /* Bug 4160375 */
52: BEGIN
53: --hr_utility.trace_on(null,'mftest');

Line 164: FROM pa_budget_versions

160: --acquire version lock
161:
162: SELECT record_version_number
163: INTO l_record_version_number
164: FROM pa_budget_versions
165: WHERE budget_version_id = p_budget_version_id;
166: IF p_pa_debug_mode = 'Y' THEN
167: pa_fp_gen_amount_utils.fp_debug
168: (p_called_mode => p_called_mode,

Line 587: FROM pa_proj_fp_options opt, pa_budget_versions bv

583: 'COST', opt.gen_src_cost_plan_version_id,
584: 'REVENUE',opt.gen_src_rev_plan_version_id,
585: 'ALL',opt.gen_src_all_plan_version_id)
586: INTO l_source_bv_id
587: FROM pa_proj_fp_options opt, pa_budget_versions bv
588: WHERE bv.budget_version_id = opt.fin_plan_version_id
589: AND bv.budget_version_id = p_budget_version_id ;
590: END IF;
591:

Line 904: UPDATE PA_BUDGET_VERSIONS SET PLAN_PROCESSING_CODE = 'E'

900: END;
901:
902: PROCEDURE UPDATE_BUDG_VERSION(p_budget_version_id IN NUMBER ) IS
903: BEGIN
904: UPDATE PA_BUDGET_VERSIONS SET PLAN_PROCESSING_CODE = 'E'
905: WHERE BUDGET_VERSION_ID = p_budget_version_id;
906: COMMIT;
907: END;
908:

Line 913: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

909: /* Procedure to generate budget amount when
910: planning level is Resource Schedule */
911: PROCEDURE GENERATE_BUDGET_AMT_RES_SCH
912: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
913: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
914: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
915: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
916: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
917: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,

Line 918: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

914: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
915: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
916: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
917: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
918: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
919: P_RETAIN_MANUAL_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
920: P_CALLED_MODE IN VARCHAR2,
921: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
922: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,

Line 1404: ,pa_budget_versions bv

1400: ,pp.labor_sch_type
1401: ,pp.non_labor_sch_type
1402: ,pp.name project_name
1403: FROM pa_proj_fp_options pfo
1404: ,pa_budget_versions bv
1405: ,pa_projects_all pp
1406: WHERE pfo.fin_plan_version_id = bv.budget_version_id
1407: AND bv.budget_version_id = p_budget_version_id
1408: AND pp.project_id = bv.project_id

Line 1621: l_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;

1617: l_labor_sch_fixed_dt Pa_Projects_All.LABOR_SCHEDULE_FIXED_DATE%TYPE;
1618: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
1619:
1620:
1621: l_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1622: l_version_number PA_BUDGET_VERSIONS.VERSION_NUMBER%TYPE;
1623: l_plan_processing_code PA_BUDGET_VERSIONS.PLAN_PROCESSING_CODE%TYPE;
1624:
1625: --Declaring PL/SQL tables for bulk binding

Line 1622: l_version_number PA_BUDGET_VERSIONS.VERSION_NUMBER%TYPE;

1618: l_labor_sch_type Pa_Projects_All.LABOR_SCH_TYPE%TYPE;
1619:
1620:
1621: l_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1622: l_version_number PA_BUDGET_VERSIONS.VERSION_NUMBER%TYPE;
1623: l_plan_processing_code PA_BUDGET_VERSIONS.PLAN_PROCESSING_CODE%TYPE;
1624:
1625: --Declaring PL/SQL tables for bulk binding
1626: l_proj_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;

Line 1623: l_plan_processing_code PA_BUDGET_VERSIONS.PLAN_PROCESSING_CODE%TYPE;

1619:
1620:
1621: l_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
1622: l_version_number PA_BUDGET_VERSIONS.VERSION_NUMBER%TYPE;
1623: l_plan_processing_code PA_BUDGET_VERSIONS.PLAN_PROCESSING_CODE%TYPE;
1624:
1625: --Declaring PL/SQL tables for bulk binding
1626: l_proj_assignment_id PA_PLSQL_DATATYPES.IdTabTyp;
1627: l_proj_start_date PA_PLSQL_DATATYPES.DateTabTyp;

Line 4409: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

4405: END GENERATE_BUDGET_AMT_RES_SCH;
4406:
4407: PROCEDURE CREATE_RES_ASG
4408: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
4409: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
4410: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,
4411: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
4412: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4413: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,

Line 4413: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,

4409: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
4410: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,
4411: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
4412: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4413: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,
4414: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
4415: X_MSG_COUNT OUT NOCOPY NUMBER,
4416: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
4417:

Line 4806: l_wp_version_flag pa_budget_Versions.wp_version_flag%TYPE;

4802: l_rec_ver_number_1 NUMBER:=1;
4803:
4804: l_count NUMBER;
4805: l_count1 NUMBER;
4806: l_wp_version_flag pa_budget_Versions.wp_version_flag%TYPE;
4807: l_gen_src_code pa_proj_fp_options.gen_all_src_code%TYPE := null;
4808:
4809: --Bug 4052036. This tbl will hold the ra ids that are inserted in this API
4810: l_ins_ra_id_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 4868: FROM pa_budget_versions

4864: END IF;
4865:
4866: SELECT NVL(wp_version_flag,'N')
4867: INTO l_wp_version_flag
4868: FROM pa_budget_versions
4869: WHERE budget_version_id=P_BUDGET_VERSION_ID;
4870:
4871: FORALL i IN 1..l_res_list_member_id.count
4872: INSERT INTO PA_RESOURCE_ASSIGNMENTS(RESOURCE_ASSIGNMENT_ID,

Line 5801: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

5797: /* Procedure to update the reosurce_assignment_id
5798: in the resource assignment table*/
5799: PROCEDURE UPDATE_RES_ASG
5800: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
5801: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
5802: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,
5803: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
5804: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5805: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,

Line 5805: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,

5801: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
5802: P_STRU_SHARING_CODE IN PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE,
5803: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
5804: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5805: P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE,
5806: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
5807: X_MSG_COUNT OUT NOCOPY NUMBER,
5808: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
5809:

Line 6243: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

6239: by the previous source in the same run.
6240: */
6241: PROCEDURE DEL_MANUAL_BDGT_LINES
6242: ( P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
6243: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6244: PX_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
6245: PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
6246: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6247: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 6343: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

6339: END DEL_MANUAL_BDGT_LINES;
6340:
6341: PROCEDURE UPDATE_INIT_AMOUNTS
6342: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
6343: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6344: P_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
6345: --this pl/sql table will have newly created res_asg_id from the source
6346: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6347: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 6404: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

6400: /* Procedure to update the latest amount
6401: generation date in the budget versions table*/
6402: PROCEDURE UPDATE_BV_FOR_GEN_DATE
6403: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
6404: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6405: P_ETC_START_DATE IN PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,
6406: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6407: X_MSG_COUNT OUT NOCOPY NUMBER,
6408: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 6405: P_ETC_START_DATE IN PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,

6401: generation date in the budget versions table*/
6402: PROCEDURE UPDATE_BV_FOR_GEN_DATE
6403: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
6404: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6405: P_ETC_START_DATE IN PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,
6406: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6407: X_MSG_COUNT OUT NOCOPY NUMBER,
6408: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6409:

Line 6426: UPDATE PA_BUDGET_VERSIONS

6422: pa_debug.set_curr_function( p_function => 'UPDATE_BV_FOR_GEN_DATE'
6423: ,p_debug_mode => p_pa_debug_mode);
6424: END IF;
6425:
6426: UPDATE PA_BUDGET_VERSIONS
6427: SET LAST_AMT_GEN_DATE = l_sysdate,
6428: LAST_UPDATE_DATE = l_sysdate,
6429: LAST_UPDATED_BY = l_last_updated_by,
6430: CREATION_DATE = l_sysdate,

Line 6460: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

6456: END UPDATE_BV_FOR_GEN_DATE;
6457:
6458: PROCEDURE GET_GENERATED_RES_ASG
6459: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
6460: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6461: PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
6462: P_CHK_DUPLICATE_FLAG IN VARCHAR2,
6463: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6464: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 6552: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

6548: missing currencies to all the workplan versions
6549: ******************************************************************************/
6550: PROCEDURE INSERT_TXN_CURRENCY
6551: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
6552: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6553: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
6554: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6555: X_MSG_COUNT OUT NOCOPY NUMBER,
6556: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 6571: l_wp_version_flag pa_budget_versions.wp_version_flag%type;

6567: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
6568: l_last_update_login NUMBER := FND_GLOBAL.login_id;
6569: l_sysdate DATE := SYSDATE;
6570:
6571: l_wp_version_flag pa_budget_versions.wp_version_flag%type;
6572:
6573: BEGIN
6574: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6575: X_MSG_COUNT := 0;

Line 6628: FROM pa_budget_versions

6624: type and then all the working workplan versions*/
6625:
6626: SELECT nvl(wp_version_flag,'N')
6627: INTO l_wp_version_flag
6628: FROM pa_budget_versions
6629: WHERE budget_version_id = p_budget_version_id;
6630:
6631: IF l_wp_version_flag = 'N' THEN
6632:

Line 6649: FROM pa_budget_versions bv,

6645: ,pfo.proj_fp_options_id
6646: BULK COLLECT INTO
6647: l_budget_version_id_tbl,
6648: l_proj_fp_options_id_tbl
6649: FROM pa_budget_versions bv,
6650: --bug 3919127 pa_proj_elem_ver_structure ver,
6651: pa_proj_fp_options pfo
6652: WHERE bv.project_id = p_project_id
6653: AND bv.wp_version_flag = 'Y'

Line 6755: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

6751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6752: END INSERT_TXN_CURRENCY;
6753:
6754: PROCEDURE RESET_COST_AMOUNTS
6755: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6756: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
6757: X_MSG_COUNT OUT NOCOPY NUMBER,
6758: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6759: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.RESET_COST_AMOUNTS';

Line 6809: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

6805: END RESET_COST_AMOUNTS;
6806:
6807: PROCEDURE GEN_REV_BDGT_AMT_RES_SCH_WRP
6808: (P_PROJECT_ID IN pa_projects_all.PROJECT_ID%TYPE,
6809: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6810: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
6811: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
6812: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
6813: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,

Line 6814: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

6810: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
6811: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
6812: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
6813: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
6814: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6815: P_RETAIN_MANUAL_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
6816: P_CALLED_MODE IN VARCHAR2,
6817: P_INC_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
6818: P_INC_BILL_EVENT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,

Line 7358: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

7354: END GEN_REV_BDGT_AMT_RES_SCH_WRP;
7355:
7356: PROCEDURE GEN_WP_REV_BDGT_AMT_WRP
7357: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
7358: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
7359: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
7360: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
7361: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
7362: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

Line 7362: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

7358: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
7359: P_PLAN_CLASS_CODE IN PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
7360: P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
7361: P_COST_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.GEN_SRC_COST_PLAN_TYPE_ID%TYPE,
7362: P_COST_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
7363: P_RETAIN_MANUAL_FLAG IN VARCHAR2,
7364: P_CALLED_MODE IN VARCHAR2,
7365: P_INC_CHG_DOC_FLAG IN VARCHAR2,
7366: P_INC_BILL_EVENT_FLAG IN VARCHAR2,