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_PUB dependencies on PA_BUDGET_LINES

Line 407: FROM pa_budget_lines bl

403: --AND RESOURCE_LIST_MEMBER_ID = l_da_resource_list_members_tab(i)
404: AND ( ra.transaction_source_code IS NOT NULL
405: OR ( ra.transaction_source_code IS NULL
406: AND NOT EXISTS ( SELECT 1
407: FROM pa_budget_lines bl
408: WHERE bl.resource_assignment_id =
409: ra.resource_assignment_id
410: AND bl.start_date >=
411: DECODE(l_fp_cols_rec.x_plan_class_code,

Line 731: l_start_date PA_BUDGET_LINES.START_DATE%TYPE;

727: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
728:
729: l_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
730: l_time_phase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
731: l_start_date PA_BUDGET_LINES.START_DATE%TYPE;
732: l_end_date PA_BUDGET_LINES.END_DATE%TYPE;
733: l_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;
734: l_pc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
735: l_pfc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;

Line 732: l_end_date PA_BUDGET_LINES.END_DATE%TYPE;

728:
729: l_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
730: l_time_phase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
731: l_start_date PA_BUDGET_LINES.START_DATE%TYPE;
732: l_end_date PA_BUDGET_LINES.END_DATE%TYPE;
733: l_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;
734: l_pc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
735: l_pfc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
736:

Line 733: l_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;

729: l_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
730: l_time_phase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
731: l_start_date PA_BUDGET_LINES.START_DATE%TYPE;
732: l_end_date PA_BUDGET_LINES.END_DATE%TYPE;
733: l_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;
734: l_pc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
735: l_pfc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
736:
737: /* Plan amount pl/sql tables */

Line 764: l_plan_qty PA_BUDGET_LINES.QUANTITY%TYPE;

760:
761: l_curr_ra_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
762:
763: /* Scalar variables for summing Plan amounts per ra_id */
764: l_plan_qty PA_BUDGET_LINES.QUANTITY%TYPE;
765: l_plan_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
766: l_plan_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
767: l_plan_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
768: l_plan_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;

Line 765: l_plan_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;

761: l_curr_ra_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
762:
763: /* Scalar variables for summing Plan amounts per ra_id */
764: l_plan_qty PA_BUDGET_LINES.QUANTITY%TYPE;
765: l_plan_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
766: l_plan_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
767: l_plan_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
768: l_plan_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
769: l_plan_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 766: l_plan_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;

762:
763: /* Scalar variables for summing Plan amounts per ra_id */
764: l_plan_qty PA_BUDGET_LINES.QUANTITY%TYPE;
765: l_plan_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
766: l_plan_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
767: l_plan_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
768: l_plan_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
769: l_plan_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
770:

Line 767: l_plan_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;

763: /* Scalar variables for summing Plan amounts per ra_id */
764: l_plan_qty PA_BUDGET_LINES.QUANTITY%TYPE;
765: l_plan_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
766: l_plan_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
767: l_plan_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
768: l_plan_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
769: l_plan_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
770:
771: /* Scalar variables for summing Actual amounts per ra_id */

Line 768: l_plan_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;

764: l_plan_qty PA_BUDGET_LINES.QUANTITY%TYPE;
765: l_plan_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
766: l_plan_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
767: l_plan_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
768: l_plan_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
769: l_plan_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
770:
771: /* Scalar variables for summing Actual amounts per ra_id */
772: l_init_qty PA_BUDGET_LINES.QUANTITY%TYPE;

Line 772: l_init_qty PA_BUDGET_LINES.QUANTITY%TYPE;

768: l_plan_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
769: l_plan_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
770:
771: /* Scalar variables for summing Actual amounts per ra_id */
772: l_init_qty PA_BUDGET_LINES.QUANTITY%TYPE;
773: l_init_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
774: l_init_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
775: l_init_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
776: l_init_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;

Line 773: l_init_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;

769: l_plan_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
770:
771: /* Scalar variables for summing Actual amounts per ra_id */
772: l_init_qty PA_BUDGET_LINES.QUANTITY%TYPE;
773: l_init_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
774: l_init_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
775: l_init_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
776: l_init_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
777: l_init_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 774: l_init_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;

770:
771: /* Scalar variables for summing Actual amounts per ra_id */
772: l_init_qty PA_BUDGET_LINES.QUANTITY%TYPE;
773: l_init_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
774: l_init_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
775: l_init_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
776: l_init_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
777: l_init_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
778:

Line 775: l_init_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;

771: /* Scalar variables for summing Actual amounts per ra_id */
772: l_init_qty PA_BUDGET_LINES.QUANTITY%TYPE;
773: l_init_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
774: l_init_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
775: l_init_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
776: l_init_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
777: l_init_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
778:
779: /* Variables for unspent amounts per ra_id */

Line 776: l_init_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;

772: l_init_qty PA_BUDGET_LINES.QUANTITY%TYPE;
773: l_init_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
774: l_init_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
775: l_init_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
776: l_init_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
777: l_init_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
778:
779: /* Variables for unspent amounts per ra_id */
780: l_unspent_amt_currency PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;

Line 780: l_unspent_amt_currency PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;

776: l_init_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
777: l_init_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
778:
779: /* Variables for unspent amounts per ra_id */
780: l_unspent_amt_currency PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
781: l_unspent_qty PA_BUDGET_LINES.QUANTITY%TYPE;
782: l_unspent_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
783: l_unspent_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
784:

Line 781: l_unspent_qty PA_BUDGET_LINES.QUANTITY%TYPE;

777: l_init_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
778:
779: /* Variables for unspent amounts per ra_id */
780: l_unspent_amt_currency PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
781: l_unspent_qty PA_BUDGET_LINES.QUANTITY%TYPE;
782: l_unspent_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
783: l_unspent_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
784:
785: l_txn_raw_cost_rate NUMBER;

Line 782: l_unspent_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;

778:
779: /* Variables for unspent amounts per ra_id */
780: l_unspent_amt_currency PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
781: l_unspent_qty PA_BUDGET_LINES.QUANTITY%TYPE;
782: l_unspent_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
783: l_unspent_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
784:
785: l_txn_raw_cost_rate NUMBER;
786: l_txn_burd_cost_rate NUMBER;

Line 783: l_unspent_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;

779: /* Variables for unspent amounts per ra_id */
780: l_unspent_amt_currency PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
781: l_unspent_qty PA_BUDGET_LINES.QUANTITY%TYPE;
782: l_unspent_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
783: l_unspent_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
784:
785: l_txn_raw_cost_rate NUMBER;
786: l_txn_burd_cost_rate NUMBER;
787:

Line 791: l_upd_bl_id PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;

787:
788: /* Variables for insert/update of Unspent Amount budget lines */
789: l_insert_flag VARCHAR2(1);
790: l_update_flag VARCHAR2(1);
791: l_upd_bl_id PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;
792: l_index NUMBER;
793:
794: /* Variables for amounts of budget lines to be updated */
795: l_quantity PA_BUDGET_LINES.QUANTITY%TYPE;

Line 795: l_quantity PA_BUDGET_LINES.QUANTITY%TYPE;

791: l_upd_bl_id PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;
792: l_index NUMBER;
793:
794: /* Variables for amounts of budget lines to be updated */
795: l_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
796: l_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
797: l_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
798:
799: l_last_updated_by PA_BUDGET_LINES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.user_id;

Line 796: l_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;

792: l_index NUMBER;
793:
794: /* Variables for amounts of budget lines to be updated */
795: l_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
796: l_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
797: l_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
798:
799: l_last_updated_by PA_BUDGET_LINES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.user_id;
800: l_last_update_login PA_BUDGET_LINES.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.login_id;

Line 797: l_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;

793:
794: /* Variables for amounts of budget lines to be updated */
795: l_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
796: l_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
797: l_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
798:
799: l_last_updated_by PA_BUDGET_LINES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.user_id;
800: l_last_update_login PA_BUDGET_LINES.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.login_id;
801: l_sysdate DATE := SYSDATE;

Line 799: l_last_updated_by PA_BUDGET_LINES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.user_id;

795: l_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
796: l_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
797: l_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
798:
799: l_last_updated_by PA_BUDGET_LINES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.user_id;
800: l_last_update_login PA_BUDGET_LINES.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.login_id;
801: l_sysdate DATE := SYSDATE;
802:
803: /* Tables for budget line Insert */

Line 800: l_last_update_login PA_BUDGET_LINES.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.login_id;

796: l_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
797: l_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
798:
799: l_last_updated_by PA_BUDGET_LINES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.user_id;
800: l_last_update_login PA_BUDGET_LINES.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.login_id;
801: l_sysdate DATE := SYSDATE;
802:
803: /* Tables for budget line Insert */
804: l_ins_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 977: FROM pa_budget_lines bl

973: AND ra.resource_list_member_id = tmp4.txn_resource_list_member_id
974: AND ( ra.transaction_source_code IS NOT NULL
975: OR ( ra.transaction_source_code IS NULL
976: AND NOT EXISTS ( SELECT 1
977: FROM pa_budget_lines bl
978: WHERE bl.resource_assignment_id =
979: ra.resource_assignment_id
980: AND bl.start_date >= l_etc_start_date
981: AND rownum = 1 )))

Line 1055: FROM pa_budget_lines bl,

1051: l_init_pc_raw_cost_tab,
1052: l_init_txn_raw_cost_tab,
1053: l_init_pc_burd_cost_tab,
1054: l_init_txn_burd_cost_tab
1055: FROM pa_budget_lines bl,
1056: pa_res_list_map_tmp4 tmp4
1057: WHERE bl.resource_assignment_id = tmp4.txn_resource_assignment_id
1058: AND bl.start_date < l_etc_start_date
1059: GROUP BY tmp4.txn_resource_assignment_id,

Line 1258: FROM pa_budget_lines

1254: INTO l_upd_bl_id,
1255: l_quantity,
1256: l_txn_raw_cost,
1257: l_txn_burdened_cost
1258: FROM pa_budget_lines
1259: WHERE resource_assignment_id = l_curr_ra_id
1260: AND txn_currency_code = l_unspent_amt_currency
1261: AND start_date = DECODE(l_time_phase, 'N', start_date, l_start_date);
1262: EXCEPTION

Line 1296: INSERT INTO PA_BUDGET_LINES (

1292:
1293: IF l_ins_ra_id_tab.count > 0 THEN
1294:
1295: FORALL i IN 1..l_ins_ra_id_tab.count
1296: INSERT INTO PA_BUDGET_LINES (
1297: BUDGET_LINE_ID,
1298: BUDGET_VERSION_ID,
1299: RESOURCE_ASSIGNMENT_ID,
1300: START_DATE,

Line 1317: pa_budget_lines_s.nextval,

1313: LAST_UPDATE_LOGIN,
1314: PROJECT_CURRENCY_CODE,
1315: PROJFUNC_CURRENCY_CODE)
1316: VALUES (
1317: pa_budget_lines_s.nextval,
1318: p_budget_version_id,
1319: l_ins_ra_id_tab(i),
1320: NVL(l_start_date,l_ins_start_date_tab(i)),
1321: l_ins_txn_curr_code_tab(i),

Line 1379: UPDATE PA_BUDGET_LINES

1375: --dbms_output.put_line('l_upd_bl_id_tab.count = ' || l_upd_bl_id_tab.count);
1376:
1377: IF l_upd_bl_id_tab.count > 0 THEN
1378: FORALL i IN 1..l_upd_bl_id_tab.count
1379: UPDATE PA_BUDGET_LINES
1380: SET LAST_UPDATE_DATE = l_sysdate
1381: , LAST_UPDATED_BY = l_last_updated_by
1382: , LAST_UPDATE_LOGIN = l_last_update_login
1383: , QUANTITY = nvl(quantity,0) + nvl(l_upd_quantity_tab(i),0)

Line 1564: P_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,

1560: */
1561: PROCEDURE PRORATE_UNALIGNED_PERIOD_AMTS
1562: (P_SRC_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
1563: P_TARGET_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1564: P_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1565: P_CURRENCY_CODE_FLAG IN VARCHAR2,
1566: P_ACTUAL_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
1567: X_QUANTITY OUT NOCOPY PA_BUDGET_LINES.QUANTITY%TYPE,
1568: X_TXN_RAW_COST OUT NOCOPY PA_BUDGET_LINES.TXN_RAW_COST%TYPE,

Line 1567: X_QUANTITY OUT NOCOPY PA_BUDGET_LINES.QUANTITY%TYPE,

1563: P_TARGET_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1564: P_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1565: P_CURRENCY_CODE_FLAG IN VARCHAR2,
1566: P_ACTUAL_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
1567: X_QUANTITY OUT NOCOPY PA_BUDGET_LINES.QUANTITY%TYPE,
1568: X_TXN_RAW_COST OUT NOCOPY PA_BUDGET_LINES.TXN_RAW_COST%TYPE,
1569: X_TXN_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE,
1570: X_TXN_REVENUE OUT NOCOPY PA_BUDGET_LINES.TXN_REVENUE%TYPE,
1571: X_PROJ_RAW_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE,

Line 1568: X_TXN_RAW_COST OUT NOCOPY PA_BUDGET_LINES.TXN_RAW_COST%TYPE,

1564: P_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1565: P_CURRENCY_CODE_FLAG IN VARCHAR2,
1566: P_ACTUAL_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
1567: X_QUANTITY OUT NOCOPY PA_BUDGET_LINES.QUANTITY%TYPE,
1568: X_TXN_RAW_COST OUT NOCOPY PA_BUDGET_LINES.TXN_RAW_COST%TYPE,
1569: X_TXN_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE,
1570: X_TXN_REVENUE OUT NOCOPY PA_BUDGET_LINES.TXN_REVENUE%TYPE,
1571: X_PROJ_RAW_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE,
1572: X_PROJ_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE,

Line 1569: X_TXN_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE,

1565: P_CURRENCY_CODE_FLAG IN VARCHAR2,
1566: P_ACTUAL_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
1567: X_QUANTITY OUT NOCOPY PA_BUDGET_LINES.QUANTITY%TYPE,
1568: X_TXN_RAW_COST OUT NOCOPY PA_BUDGET_LINES.TXN_RAW_COST%TYPE,
1569: X_TXN_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE,
1570: X_TXN_REVENUE OUT NOCOPY PA_BUDGET_LINES.TXN_REVENUE%TYPE,
1571: X_PROJ_RAW_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE,
1572: X_PROJ_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE,
1573: X_PROJ_REVENUE OUT NOCOPY PA_BUDGET_LINES.PROJECT_REVENUE%TYPE,

Line 1570: X_TXN_REVENUE OUT NOCOPY PA_BUDGET_LINES.TXN_REVENUE%TYPE,

1566: P_ACTUAL_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
1567: X_QUANTITY OUT NOCOPY PA_BUDGET_LINES.QUANTITY%TYPE,
1568: X_TXN_RAW_COST OUT NOCOPY PA_BUDGET_LINES.TXN_RAW_COST%TYPE,
1569: X_TXN_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE,
1570: X_TXN_REVENUE OUT NOCOPY PA_BUDGET_LINES.TXN_REVENUE%TYPE,
1571: X_PROJ_RAW_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE,
1572: X_PROJ_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE,
1573: X_PROJ_REVENUE OUT NOCOPY PA_BUDGET_LINES.PROJECT_REVENUE%TYPE,
1574: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 1571: X_PROJ_RAW_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE,

1567: X_QUANTITY OUT NOCOPY PA_BUDGET_LINES.QUANTITY%TYPE,
1568: X_TXN_RAW_COST OUT NOCOPY PA_BUDGET_LINES.TXN_RAW_COST%TYPE,
1569: X_TXN_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE,
1570: X_TXN_REVENUE OUT NOCOPY PA_BUDGET_LINES.TXN_REVENUE%TYPE,
1571: X_PROJ_RAW_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE,
1572: X_PROJ_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE,
1573: X_PROJ_REVENUE OUT NOCOPY PA_BUDGET_LINES.PROJECT_REVENUE%TYPE,
1574: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1575: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 1572: X_PROJ_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE,

1568: X_TXN_RAW_COST OUT NOCOPY PA_BUDGET_LINES.TXN_RAW_COST%TYPE,
1569: X_TXN_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE,
1570: X_TXN_REVENUE OUT NOCOPY PA_BUDGET_LINES.TXN_REVENUE%TYPE,
1571: X_PROJ_RAW_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE,
1572: X_PROJ_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE,
1573: X_PROJ_REVENUE OUT NOCOPY PA_BUDGET_LINES.PROJECT_REVENUE%TYPE,
1574: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1575: X_MSG_COUNT OUT NOCOPY NUMBER,
1576: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

Line 1573: X_PROJ_REVENUE OUT NOCOPY PA_BUDGET_LINES.PROJECT_REVENUE%TYPE,

1569: X_TXN_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE,
1570: X_TXN_REVENUE OUT NOCOPY PA_BUDGET_LINES.TXN_REVENUE%TYPE,
1571: X_PROJ_RAW_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE,
1572: X_PROJ_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE,
1573: X_PROJ_REVENUE OUT NOCOPY PA_BUDGET_LINES.PROJECT_REVENUE%TYPE,
1574: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1575: X_MSG_COUNT OUT NOCOPY NUMBER,
1576: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1577:

Line 1582: l_target_period_name pa_budget_lines.period_name%TYPE;

1578: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1579: l_org_id pa_projects_all.org_id%TYPE;
1580: l_target_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1581: l_target_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1582: l_target_period_name pa_budget_lines.period_name%TYPE;
1583: l_target_start_date pa_budget_lines.start_date%TYPE;
1584: l_target_end_date pa_budget_lines.end_date%TYPE;
1585: l_source_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1586: l_source_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;

Line 1583: l_target_start_date pa_budget_lines.start_date%TYPE;

1579: l_org_id pa_projects_all.org_id%TYPE;
1580: l_target_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1581: l_target_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1582: l_target_period_name pa_budget_lines.period_name%TYPE;
1583: l_target_start_date pa_budget_lines.start_date%TYPE;
1584: l_target_end_date pa_budget_lines.end_date%TYPE;
1585: l_source_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1586: l_source_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1587: l_source_period_name pa_budget_lines.period_name%TYPE;

Line 1584: l_target_end_date pa_budget_lines.end_date%TYPE;

1580: l_target_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1581: l_target_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1582: l_target_period_name pa_budget_lines.period_name%TYPE;
1583: l_target_start_date pa_budget_lines.start_date%TYPE;
1584: l_target_end_date pa_budget_lines.end_date%TYPE;
1585: l_source_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1586: l_source_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1587: l_source_period_name pa_budget_lines.period_name%TYPE;
1588: l_source_start_date pa_budget_lines.start_date%TYPE;

Line 1587: l_source_period_name pa_budget_lines.period_name%TYPE;

1583: l_target_start_date pa_budget_lines.start_date%TYPE;
1584: l_target_end_date pa_budget_lines.end_date%TYPE;
1585: l_source_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1586: l_source_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1587: l_source_period_name pa_budget_lines.period_name%TYPE;
1588: l_source_start_date pa_budget_lines.start_date%TYPE;
1589: l_source_end_date pa_budget_lines.end_date%TYPE;
1590:
1591: l_prorated_multiplier NUMBER;

Line 1588: l_source_start_date pa_budget_lines.start_date%TYPE;

1584: l_target_end_date pa_budget_lines.end_date%TYPE;
1585: l_source_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1586: l_source_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1587: l_source_period_name pa_budget_lines.period_name%TYPE;
1588: l_source_start_date pa_budget_lines.start_date%TYPE;
1589: l_source_end_date pa_budget_lines.end_date%TYPE;
1590:
1591: l_prorated_multiplier NUMBER;
1592: l_quantity NUMBER;

Line 1589: l_source_end_date pa_budget_lines.end_date%TYPE;

1585: l_source_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1586: l_source_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1587: l_source_period_name pa_budget_lines.period_name%TYPE;
1588: l_source_start_date pa_budget_lines.start_date%TYPE;
1589: l_source_end_date pa_budget_lines.end_date%TYPE;
1590:
1591: l_prorated_multiplier NUMBER;
1592: l_quantity NUMBER;
1593: l_txn_raw_cost NUMBER;

Line 1620: l_source_bv_id pa_budget_lines.budget_version_id%TYPE;

1616: adjustment_period_flag = 'N' and
1617: c_amt_thru between start_date and end_date;
1618: gl_period_rec gl_period_csr%ROWTYPE;
1619:
1620: l_source_bv_id pa_budget_lines.budget_version_id%TYPE;
1621: BEGIN
1622:
1623: IF P_PA_DEBUG_MODE = 'Y' THEN
1624: pa_debug.set_curr_function( p_function => 'PRORATE_UNALIGNED_PERIOD_AMTS',

Line 1736: pa_budget_lines sbl

1732: l_txn_raw_cost,
1733: l_txn_burdened_cost,
1734: l_txn_revenue
1735: FROM pa_fp_gen_rate_tmp tmp,
1736: pa_budget_lines sbl
1737: WHERE tmp.target_res_asg_id = sbl.resource_assignment_id
1738: and sbl.budget_version_id = l_source_bv_id
1739: and sbl.period_name = l_source_period_name
1740: and sbl.txn_currency_code = decode(p_currency_code_flag,

Line 1803: pa_budget_lines bl

1799: CURSOR multi_bl_fixed_date_ra_cur IS
1800: SELECT DISTINCT(bl.resource_assignment_id)
1801: FROM pa_resource_assignments ra,
1802: pa_spread_curves_b sp,
1803: pa_budget_lines bl
1804: WHERE ra.budget_version_id = p_budget_version_id
1805: AND sp.spread_curve_id = ra.spread_curve_id
1806: AND sp.spread_curve_code = lc_FixedDate
1807: AND bl.resource_assignment_id = ra.resource_assignment_id

Line 1822: pa_budget_lines bl

1818: CURSOR one_bl_fixed_date_ra_cur IS
1819: SELECT DISTINCT(bl.resource_assignment_id)
1820: FROM pa_resource_assignments ra,
1821: pa_spread_curves_b sp,
1822: pa_budget_lines bl
1823: WHERE ra.budget_version_id = p_budget_version_id
1824: AND sp.spread_curve_id = ra.spread_curve_id
1825: AND sp.spread_curve_code = lc_FixedDate
1826: AND bl.resource_assignment_id = ra.resource_assignment_id