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 744: l_start_date PA_BUDGET_LINES.START_DATE%TYPE;

740: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
741:
742: l_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
743: l_time_phase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
744: l_start_date PA_BUDGET_LINES.START_DATE%TYPE;
745: l_end_date PA_BUDGET_LINES.END_DATE%TYPE;
746: l_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;
747: l_pc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
748: l_pfc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;

Line 745: l_end_date PA_BUDGET_LINES.END_DATE%TYPE;

741:
742: l_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
743: l_time_phase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
744: l_start_date PA_BUDGET_LINES.START_DATE%TYPE;
745: l_end_date PA_BUDGET_LINES.END_DATE%TYPE;
746: l_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;
747: l_pc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
748: l_pfc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
749:

Line 746: l_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;

742: l_etc_start_date PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE;
743: l_time_phase PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
744: l_start_date PA_BUDGET_LINES.START_DATE%TYPE;
745: l_end_date PA_BUDGET_LINES.END_DATE%TYPE;
746: l_period_name PA_BUDGET_LINES.PERIOD_NAME%TYPE;
747: l_pc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE;
748: l_pfc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
749:
750: /* Plan amount pl/sql tables */

Line 777: l_plan_qty PA_BUDGET_LINES.QUANTITY%TYPE;

773:
774: l_curr_ra_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
775:
776: /* Scalar variables for summing Plan amounts per ra_id */
777: l_plan_qty PA_BUDGET_LINES.QUANTITY%TYPE;
778: l_plan_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
779: l_plan_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
780: l_plan_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
781: l_plan_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;

Line 778: l_plan_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;

774: l_curr_ra_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
775:
776: /* Scalar variables for summing Plan amounts per ra_id */
777: l_plan_qty PA_BUDGET_LINES.QUANTITY%TYPE;
778: l_plan_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
779: l_plan_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
780: l_plan_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
781: l_plan_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
782: l_plan_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 779: l_plan_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;

775:
776: /* Scalar variables for summing Plan amounts per ra_id */
777: l_plan_qty PA_BUDGET_LINES.QUANTITY%TYPE;
778: l_plan_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
779: l_plan_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
780: l_plan_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
781: l_plan_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
782: l_plan_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
783:

Line 780: l_plan_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;

776: /* Scalar variables for summing Plan amounts per ra_id */
777: l_plan_qty PA_BUDGET_LINES.QUANTITY%TYPE;
778: l_plan_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
779: l_plan_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
780: l_plan_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
781: l_plan_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
782: l_plan_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
783:
784: /* Scalar variables for summing Actual amounts per ra_id */

Line 781: l_plan_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;

777: l_plan_qty PA_BUDGET_LINES.QUANTITY%TYPE;
778: l_plan_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
779: l_plan_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
780: l_plan_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
781: l_plan_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
782: l_plan_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
783:
784: /* Scalar variables for summing Actual amounts per ra_id */
785: l_init_qty PA_BUDGET_LINES.QUANTITY%TYPE;

Line 785: l_init_qty PA_BUDGET_LINES.QUANTITY%TYPE;

781: l_plan_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
782: l_plan_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
783:
784: /* Scalar variables for summing Actual amounts per ra_id */
785: l_init_qty PA_BUDGET_LINES.QUANTITY%TYPE;
786: l_init_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
787: l_init_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
788: l_init_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
789: l_init_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;

Line 786: l_init_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;

782: l_plan_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
783:
784: /* Scalar variables for summing Actual amounts per ra_id */
785: l_init_qty PA_BUDGET_LINES.QUANTITY%TYPE;
786: l_init_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
787: l_init_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
788: l_init_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
789: l_init_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
790: l_init_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;

Line 787: l_init_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;

783:
784: /* Scalar variables for summing Actual amounts per ra_id */
785: l_init_qty PA_BUDGET_LINES.QUANTITY%TYPE;
786: l_init_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
787: l_init_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
788: l_init_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
789: l_init_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
790: l_init_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
791:

Line 788: l_init_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;

784: /* Scalar variables for summing Actual amounts per ra_id */
785: l_init_qty PA_BUDGET_LINES.QUANTITY%TYPE;
786: l_init_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
787: l_init_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
788: l_init_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
789: l_init_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
790: l_init_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
791:
792: /* Variables for unspent amounts per ra_id */

Line 789: l_init_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;

785: l_init_qty PA_BUDGET_LINES.QUANTITY%TYPE;
786: l_init_pc_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
787: l_init_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
788: l_init_pc_burd_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
789: l_init_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
790: l_init_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
791:
792: /* Variables for unspent amounts per ra_id */
793: l_unspent_amt_currency PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;

Line 793: l_unspent_amt_currency PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;

789: l_init_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
790: l_init_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
791:
792: /* Variables for unspent amounts per ra_id */
793: l_unspent_amt_currency PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
794: l_unspent_qty PA_BUDGET_LINES.QUANTITY%TYPE;
795: l_unspent_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
796: l_unspent_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
797:

Line 794: l_unspent_qty PA_BUDGET_LINES.QUANTITY%TYPE;

790: l_init_currency_tab PA_PLSQL_DATATYPES.Char30TabTyp;
791:
792: /* Variables for unspent amounts per ra_id */
793: l_unspent_amt_currency PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
794: l_unspent_qty PA_BUDGET_LINES.QUANTITY%TYPE;
795: l_unspent_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
796: l_unspent_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
797:
798: l_txn_raw_cost_rate NUMBER;

Line 795: l_unspent_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;

791:
792: /* Variables for unspent amounts per ra_id */
793: l_unspent_amt_currency PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
794: l_unspent_qty PA_BUDGET_LINES.QUANTITY%TYPE;
795: l_unspent_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
796: l_unspent_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
797:
798: l_txn_raw_cost_rate NUMBER;
799: l_txn_burd_cost_rate NUMBER;

Line 796: l_unspent_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;

792: /* Variables for unspent amounts per ra_id */
793: l_unspent_amt_currency PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
794: l_unspent_qty PA_BUDGET_LINES.QUANTITY%TYPE;
795: l_unspent_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
796: l_unspent_txn_burd_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
797:
798: l_txn_raw_cost_rate NUMBER;
799: l_txn_burd_cost_rate NUMBER;
800:

Line 804: l_upd_bl_id PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;

800:
801: /* Variables for insert/update of Unspent Amount budget lines */
802: l_insert_flag VARCHAR2(1);
803: l_update_flag VARCHAR2(1);
804: l_upd_bl_id PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;
805: l_index NUMBER;
806:
807: /* Variables for amounts of budget lines to be updated */
808: l_quantity PA_BUDGET_LINES.QUANTITY%TYPE;

Line 808: l_quantity PA_BUDGET_LINES.QUANTITY%TYPE;

804: l_upd_bl_id PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;
805: l_index NUMBER;
806:
807: /* Variables for amounts of budget lines to be updated */
808: l_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
809: l_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
810: l_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
811:
812: l_last_updated_by PA_BUDGET_LINES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.user_id;

Line 809: l_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;

805: l_index NUMBER;
806:
807: /* Variables for amounts of budget lines to be updated */
808: l_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
809: l_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
810: l_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
811:
812: l_last_updated_by PA_BUDGET_LINES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.user_id;
813: l_last_update_login PA_BUDGET_LINES.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.login_id;

Line 810: l_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;

806:
807: /* Variables for amounts of budget lines to be updated */
808: l_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
809: l_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
810: l_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
811:
812: l_last_updated_by PA_BUDGET_LINES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.user_id;
813: l_last_update_login PA_BUDGET_LINES.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.login_id;
814: l_sysdate DATE := SYSDATE;

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

808: l_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
809: l_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
810: l_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
811:
812: l_last_updated_by PA_BUDGET_LINES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.user_id;
813: l_last_update_login PA_BUDGET_LINES.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.login_id;
814: l_sysdate DATE := SYSDATE;
815:
816: /* Tables for budget line Insert */

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

809: l_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
810: l_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
811:
812: l_last_updated_by PA_BUDGET_LINES.LAST_UPDATED_BY%TYPE := FND_GLOBAL.user_id;
813: l_last_update_login PA_BUDGET_LINES.LAST_UPDATE_LOGIN%TYPE := FND_GLOBAL.login_id;
814: l_sysdate DATE := SYSDATE;
815:
816: /* Tables for budget line Insert */
817: l_ins_ra_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 990: FROM pa_budget_lines bl

986: AND ra.resource_list_member_id = tmp4.txn_resource_list_member_id
987: AND ( ra.transaction_source_code IS NOT NULL
988: OR ( ra.transaction_source_code IS NULL
989: AND NOT EXISTS ( SELECT 1
990: FROM pa_budget_lines bl
991: WHERE bl.resource_assignment_id =
992: ra.resource_assignment_id
993: AND bl.start_date >= l_etc_start_date
994: AND rownum = 1 )))

Line 1068: FROM pa_budget_lines bl,

1064: l_init_pc_raw_cost_tab,
1065: l_init_txn_raw_cost_tab,
1066: l_init_pc_burd_cost_tab,
1067: l_init_txn_burd_cost_tab
1068: FROM pa_budget_lines bl,
1069: pa_res_list_map_tmp4 tmp4
1070: WHERE bl.resource_assignment_id = tmp4.txn_resource_assignment_id
1071: AND bl.start_date < l_etc_start_date
1072: GROUP BY tmp4.txn_resource_assignment_id,

Line 1271: FROM pa_budget_lines

1267: INTO l_upd_bl_id,
1268: l_quantity,
1269: l_txn_raw_cost,
1270: l_txn_burdened_cost
1271: FROM pa_budget_lines
1272: WHERE resource_assignment_id = l_curr_ra_id
1273: AND txn_currency_code = l_unspent_amt_currency
1274: AND start_date = DECODE(l_time_phase, 'N', start_date, l_start_date);
1275: EXCEPTION

Line 1309: INSERT INTO PA_BUDGET_LINES (

1305:
1306: IF l_ins_ra_id_tab.count > 0 THEN
1307:
1308: FORALL i IN 1..l_ins_ra_id_tab.count
1309: INSERT INTO PA_BUDGET_LINES (
1310: BUDGET_LINE_ID,
1311: BUDGET_VERSION_ID,
1312: RESOURCE_ASSIGNMENT_ID,
1313: START_DATE,

Line 1330: pa_budget_lines_s.nextval,

1326: LAST_UPDATE_LOGIN,
1327: PROJECT_CURRENCY_CODE,
1328: PROJFUNC_CURRENCY_CODE)
1329: VALUES (
1330: pa_budget_lines_s.nextval,
1331: p_budget_version_id,
1332: l_ins_ra_id_tab(i),
1333: NVL(l_start_date,l_ins_start_date_tab(i)),
1334: l_ins_txn_curr_code_tab(i),

Line 1392: UPDATE PA_BUDGET_LINES

1388: --dbms_output.put_line('l_upd_bl_id_tab.count = ' || l_upd_bl_id_tab.count);
1389:
1390: IF l_upd_bl_id_tab.count > 0 THEN
1391: FORALL i IN 1..l_upd_bl_id_tab.count
1392: UPDATE PA_BUDGET_LINES
1393: SET LAST_UPDATE_DATE = l_sysdate
1394: , LAST_UPDATED_BY = l_last_updated_by
1395: , LAST_UPDATE_LOGIN = l_last_update_login
1396: , QUANTITY = nvl(quantity,0) + nvl(l_upd_quantity_tab(i),0)

Line 1577: P_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,

1573: */
1574: PROCEDURE PRORATE_UNALIGNED_PERIOD_AMTS
1575: (P_SRC_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
1576: P_TARGET_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1577: P_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1578: P_CURRENCY_CODE_FLAG IN VARCHAR2,
1579: P_ACTUAL_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
1580: X_QUANTITY OUT NOCOPY PA_BUDGET_LINES.QUANTITY%TYPE,
1581: X_TXN_RAW_COST OUT NOCOPY PA_BUDGET_LINES.TXN_RAW_COST%TYPE,

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

1576: P_TARGET_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
1577: P_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1578: P_CURRENCY_CODE_FLAG IN VARCHAR2,
1579: P_ACTUAL_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
1580: X_QUANTITY OUT NOCOPY PA_BUDGET_LINES.QUANTITY%TYPE,
1581: X_TXN_RAW_COST OUT NOCOPY PA_BUDGET_LINES.TXN_RAW_COST%TYPE,
1582: X_TXN_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE,
1583: X_TXN_REVENUE OUT NOCOPY PA_BUDGET_LINES.TXN_REVENUE%TYPE,
1584: X_PROJ_RAW_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE,

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

1577: P_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
1578: P_CURRENCY_CODE_FLAG IN VARCHAR2,
1579: P_ACTUAL_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
1580: X_QUANTITY OUT NOCOPY PA_BUDGET_LINES.QUANTITY%TYPE,
1581: X_TXN_RAW_COST OUT NOCOPY PA_BUDGET_LINES.TXN_RAW_COST%TYPE,
1582: X_TXN_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE,
1583: X_TXN_REVENUE OUT NOCOPY PA_BUDGET_LINES.TXN_REVENUE%TYPE,
1584: X_PROJ_RAW_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE,
1585: X_PROJ_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE,

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

1578: P_CURRENCY_CODE_FLAG IN VARCHAR2,
1579: P_ACTUAL_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
1580: X_QUANTITY OUT NOCOPY PA_BUDGET_LINES.QUANTITY%TYPE,
1581: X_TXN_RAW_COST OUT NOCOPY PA_BUDGET_LINES.TXN_RAW_COST%TYPE,
1582: X_TXN_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE,
1583: X_TXN_REVENUE OUT NOCOPY PA_BUDGET_LINES.TXN_REVENUE%TYPE,
1584: X_PROJ_RAW_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE,
1585: X_PROJ_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE,
1586: X_PROJ_REVENUE OUT NOCOPY PA_BUDGET_LINES.PROJECT_REVENUE%TYPE,

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

1579: P_ACTUAL_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
1580: X_QUANTITY OUT NOCOPY PA_BUDGET_LINES.QUANTITY%TYPE,
1581: X_TXN_RAW_COST OUT NOCOPY PA_BUDGET_LINES.TXN_RAW_COST%TYPE,
1582: X_TXN_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE,
1583: X_TXN_REVENUE OUT NOCOPY PA_BUDGET_LINES.TXN_REVENUE%TYPE,
1584: X_PROJ_RAW_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE,
1585: X_PROJ_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE,
1586: X_PROJ_REVENUE OUT NOCOPY PA_BUDGET_LINES.PROJECT_REVENUE%TYPE,
1587: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

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

1580: X_QUANTITY OUT NOCOPY PA_BUDGET_LINES.QUANTITY%TYPE,
1581: X_TXN_RAW_COST OUT NOCOPY PA_BUDGET_LINES.TXN_RAW_COST%TYPE,
1582: X_TXN_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE,
1583: X_TXN_REVENUE OUT NOCOPY PA_BUDGET_LINES.TXN_REVENUE%TYPE,
1584: X_PROJ_RAW_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE,
1585: X_PROJ_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE,
1586: X_PROJ_REVENUE OUT NOCOPY PA_BUDGET_LINES.PROJECT_REVENUE%TYPE,
1587: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1588: X_MSG_COUNT OUT NOCOPY NUMBER,

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

1581: X_TXN_RAW_COST OUT NOCOPY PA_BUDGET_LINES.TXN_RAW_COST%TYPE,
1582: X_TXN_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE,
1583: X_TXN_REVENUE OUT NOCOPY PA_BUDGET_LINES.TXN_REVENUE%TYPE,
1584: X_PROJ_RAW_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE,
1585: X_PROJ_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE,
1586: X_PROJ_REVENUE OUT NOCOPY PA_BUDGET_LINES.PROJECT_REVENUE%TYPE,
1587: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1588: X_MSG_COUNT OUT NOCOPY NUMBER,
1589: X_MSG_DATA OUT NOCOPY VARCHAR2) IS

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

1582: X_TXN_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE,
1583: X_TXN_REVENUE OUT NOCOPY PA_BUDGET_LINES.TXN_REVENUE%TYPE,
1584: X_PROJ_RAW_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE,
1585: X_PROJ_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE,
1586: X_PROJ_REVENUE OUT NOCOPY PA_BUDGET_LINES.PROJECT_REVENUE%TYPE,
1587: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1588: X_MSG_COUNT OUT NOCOPY NUMBER,
1589: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1590:

Line 1595: l_target_period_name pa_budget_lines.period_name%TYPE;

1591: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
1592: l_org_id pa_projects_all.org_id%TYPE;
1593: l_target_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1594: l_target_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1595: l_target_period_name pa_budget_lines.period_name%TYPE;
1596: l_target_start_date pa_budget_lines.start_date%TYPE;
1597: l_target_end_date pa_budget_lines.end_date%TYPE;
1598: l_source_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1599: l_source_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;

Line 1596: l_target_start_date pa_budget_lines.start_date%TYPE;

1592: l_org_id pa_projects_all.org_id%TYPE;
1593: l_target_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1594: l_target_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1595: l_target_period_name pa_budget_lines.period_name%TYPE;
1596: l_target_start_date pa_budget_lines.start_date%TYPE;
1597: l_target_end_date pa_budget_lines.end_date%TYPE;
1598: l_source_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1599: l_source_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1600: l_source_period_name pa_budget_lines.period_name%TYPE;

Line 1597: l_target_end_date pa_budget_lines.end_date%TYPE;

1593: l_target_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1594: l_target_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1595: l_target_period_name pa_budget_lines.period_name%TYPE;
1596: l_target_start_date pa_budget_lines.start_date%TYPE;
1597: l_target_end_date pa_budget_lines.end_date%TYPE;
1598: l_source_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1599: l_source_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1600: l_source_period_name pa_budget_lines.period_name%TYPE;
1601: l_source_start_date pa_budget_lines.start_date%TYPE;

Line 1600: l_source_period_name pa_budget_lines.period_name%TYPE;

1596: l_target_start_date pa_budget_lines.start_date%TYPE;
1597: l_target_end_date pa_budget_lines.end_date%TYPE;
1598: l_source_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1599: l_source_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1600: l_source_period_name pa_budget_lines.period_name%TYPE;
1601: l_source_start_date pa_budget_lines.start_date%TYPE;
1602: l_source_end_date pa_budget_lines.end_date%TYPE;
1603:
1604: l_prorated_multiplier NUMBER;

Line 1601: l_source_start_date pa_budget_lines.start_date%TYPE;

1597: l_target_end_date pa_budget_lines.end_date%TYPE;
1598: l_source_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1599: l_source_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1600: l_source_period_name pa_budget_lines.period_name%TYPE;
1601: l_source_start_date pa_budget_lines.start_date%TYPE;
1602: l_source_end_date pa_budget_lines.end_date%TYPE;
1603:
1604: l_prorated_multiplier NUMBER;
1605: l_quantity NUMBER;

Line 1602: l_source_end_date pa_budget_lines.end_date%TYPE;

1598: l_source_ver_period_type pa_proj_fp_options.cost_time_phased_code%TYPE;
1599: l_source_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
1600: l_source_period_name pa_budget_lines.period_name%TYPE;
1601: l_source_start_date pa_budget_lines.start_date%TYPE;
1602: l_source_end_date pa_budget_lines.end_date%TYPE;
1603:
1604: l_prorated_multiplier NUMBER;
1605: l_quantity NUMBER;
1606: l_txn_raw_cost NUMBER;

Line 1633: l_source_bv_id pa_budget_lines.budget_version_id%TYPE;

1629: adjustment_period_flag = 'N' and
1630: c_amt_thru between start_date and end_date;
1631: gl_period_rec gl_period_csr%ROWTYPE;
1632:
1633: l_source_bv_id pa_budget_lines.budget_version_id%TYPE;
1634: BEGIN
1635:
1636: IF P_PA_DEBUG_MODE = 'Y' THEN
1637: pa_debug.set_curr_function( p_function => 'PRORATE_UNALIGNED_PERIOD_AMTS',

Line 1749: pa_budget_lines sbl

1745: l_txn_raw_cost,
1746: l_txn_burdened_cost,
1747: l_txn_revenue
1748: FROM pa_fp_gen_rate_tmp tmp,
1749: pa_budget_lines sbl
1750: WHERE tmp.target_res_asg_id = sbl.resource_assignment_id
1751: and sbl.budget_version_id = l_source_bv_id
1752: and sbl.period_name = l_source_period_name
1753: and sbl.txn_currency_code = decode(p_currency_code_flag,

Line 1816: pa_budget_lines bl

1812: CURSOR multi_bl_fixed_date_ra_cur IS
1813: SELECT DISTINCT(bl.resource_assignment_id)
1814: FROM pa_resource_assignments ra,
1815: pa_spread_curves_b sp,
1816: pa_budget_lines bl
1817: WHERE ra.budget_version_id = p_budget_version_id
1818: AND sp.spread_curve_id = ra.spread_curve_id
1819: AND sp.spread_curve_code = lc_FixedDate
1820: AND bl.resource_assignment_id = ra.resource_assignment_id

Line 1835: pa_budget_lines bl

1831: CURSOR one_bl_fixed_date_ra_cur IS
1832: SELECT DISTINCT(bl.resource_assignment_id)
1833: FROM pa_resource_assignments ra,
1834: pa_spread_curves_b sp,
1835: pa_budget_lines bl
1836: WHERE ra.budget_version_id = p_budget_version_id
1837: AND sp.spread_curve_id = ra.spread_curve_id
1838: AND sp.spread_curve_code = lc_FixedDate
1839: AND bl.resource_assignment_id = ra.resource_assignment_id