APPS.PA_FP_MAINTAIN_ACTUAL_PUB dependencies on PA_BUDGET_LINES_S

Line 1246: PA_BUDGET_LINES_S.nextval,

1242: l_project_revenue_tab(j),
1243: l_pfc_raw_cost_tab(j),
1244: l_pfc_burdened_cost_tab(j),
1245: l_pfc_revenue_tab(j),
1246: PA_BUDGET_LINES_S.nextval,
1247: l_sysdate,
1248: l_last_updated_by,
1249: l_sysdate,
1250: l_last_updated_by,

Line 1324: PA_BUDGET_LINES_S.nextval,

1320: l_project_revenue_tab(j),
1321: l_pfc_raw_cost_tab(j),
1322: l_pfc_burdened_cost_tab(j),
1323: l_pfc_revenue_tab(j),
1324: PA_BUDGET_LINES_S.nextval,
1325: l_sysdate,
1326: l_last_updated_by,
1327: l_sysdate,
1328: l_last_updated_by,

Line 1403: PA_BUDGET_LINES_S.nextval,

1399: l_project_revenue_tab(j),
1400: l_pfc_raw_cost_tab(j),
1401: l_pfc_burdened_cost_tab(j),
1402: l_pfc_revenue_tab(j),
1403: PA_BUDGET_LINES_S.nextval,
1404: l_sysdate,
1405: l_last_updated_by,
1406: l_sysdate,
1407: l_last_updated_by,

Line 1471: PA_BUDGET_LINES_S.nextval,

1467: l_project_revenue_tab(j2),
1468: l_pfc_raw_cost_tab(j2),
1469: l_pfc_burdened_cost_tab(j2),
1470: l_pfc_revenue_tab(j2),
1471: PA_BUDGET_LINES_S.nextval,
1472: l_sysdate,
1473: l_last_updated_by,
1474: l_sysdate,
1475: l_last_updated_by,

Line 1726: UPDATE pa_budget_lines SET

1722: /* bug 4398799 start */
1723: IF l_version_type = 'COST' THEN
1724:
1725: FORALL m in 1..l_upd_period_name_tab.count
1726: UPDATE pa_budget_lines SET
1727: TXN_STANDARD_COST_RATE = decode (nvl(quantity,0), 0, NULL, txn_raw_cost / quantity),
1728: BURDEN_COST_RATE = decode (nvl(quantity,0), 0, NULL, txn_burdened_cost/quantity)
1729: WHERE budget_line_id = l_bdgt_line_id_tab(m);
1730:

Line 1734: UPDATE pa_budget_lines SET

1730:
1731: ELSIF l_version_type = 'REVENUE' THEN
1732:
1733: FORALL m in 1..l_upd_period_name_tab.count
1734: UPDATE pa_budget_lines SET
1735: TXN_STANDARD_BILL_RATE = decode (nvl(quantity,0), 0, NULL, txn_revenue/quantity)
1736: WHERE budget_line_id = l_bdgt_line_id_tab(m);
1737:
1738: ELSIF l_version_type = 'ALL' THEN

Line 1741: UPDATE pa_budget_lines SET

1737:
1738: ELSIF l_version_type = 'ALL' THEN
1739:
1740: FORALL m in 1..l_upd_period_name_tab.count
1741: UPDATE pa_budget_lines SET
1742: TXN_STANDARD_COST_RATE = decode (nvl(quantity,0), 0, NULL, txn_raw_cost / quantity),
1743: BURDEN_COST_RATE = decode (nvl(quantity,0), 0, NULL, txn_burdened_cost/quantity),
1744: TXN_STANDARD_BILL_RATE = decode (nvl(quantity,0), 0, NULL, txn_revenue/quantity)
1745: WHERE budget_line_id = l_bdgt_line_id_tab(m);

Line 2220: PA_BUDGET_LINES_S.nextval,

2216: l_ins_project_revenue_tab(n),
2217: l_ins_pfc_raw_cost_tab(n),
2218: l_ins_pfc_burdened_cost_tab(n),
2219: l_ins_pfc_revenue_tab(n),
2220: PA_BUDGET_LINES_S.nextval,
2221: l_sysdate,
2222: l_last_updated_by,
2223: l_sysdate,
2224: l_last_updated_by,

Line 2299: PA_BUDGET_LINES_S.nextval,

2295: l_ins_project_revenue_tab(n),
2296: l_ins_pfc_raw_cost_tab(n),
2297: l_ins_pfc_burdened_cost_tab(n),
2298: l_ins_pfc_revenue_tab(n),
2299: PA_BUDGET_LINES_S.nextval,
2300: l_sysdate,
2301: l_last_updated_by,
2302: l_sysdate,
2303: l_last_updated_by,

Line 2360: PA_BUDGET_LINES_S.nextval,

2356: l_ins_project_revenue_tab(n),
2357: l_ins_pfc_raw_cost_tab(n),
2358: l_ins_pfc_burdened_cost_tab(n),
2359: l_ins_pfc_revenue_tab(n),
2360: PA_BUDGET_LINES_S.nextval,
2361: l_sysdate,
2362: l_last_updated_by,
2363: l_sysdate,
2364: l_last_updated_by,

Line 2419: PA_BUDGET_LINES_S.nextval,

2415: l_ins_project_revenue_tab(n2),
2416: l_ins_pfc_raw_cost_tab(n2),
2417: l_ins_pfc_burdened_cost_tab(n2),
2418: l_ins_pfc_revenue_tab(n2),
2419: PA_BUDGET_LINES_S.nextval,
2420: l_sysdate,
2421: l_last_updated_by,
2422: l_sysdate,
2423: l_last_updated_by,