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_CALC_PLAN_PKG dependencies on PA_FP_ROLLUP_TMP

Line 66: budget_line_id pa_fp_rollup_tmp.budget_line_id%type

62: /* Billabliity and MRC Enhancements: Note declaring table of records cannot be used in Bulk updates / bulk inserts
63: * so 9.2.5.0 version donot support the builk-in-bind of table of records with indexes
64: * so commenting it out for time being
65: TYPE mrc_fpRec IS RECORD (
66: budget_line_id pa_fp_rollup_tmp.budget_line_id%type
67: ,resource_assignment_id pa_fp_rollup_tmp.resource_assignment_id%type
68: ,txn_currency_code pa_fp_rollup_tmp.txn_currency_code%type
69: ,start_date pa_fp_rollup_tmp.start_date%type
70: ,end_date pa_fp_rollup_tmp.start_date%type

Line 67: ,resource_assignment_id pa_fp_rollup_tmp.resource_assignment_id%type

63: * so 9.2.5.0 version donot support the builk-in-bind of table of records with indexes
64: * so commenting it out for time being
65: TYPE mrc_fpRec IS RECORD (
66: budget_line_id pa_fp_rollup_tmp.budget_line_id%type
67: ,resource_assignment_id pa_fp_rollup_tmp.resource_assignment_id%type
68: ,txn_currency_code pa_fp_rollup_tmp.txn_currency_code%type
69: ,start_date pa_fp_rollup_tmp.start_date%type
70: ,end_date pa_fp_rollup_tmp.start_date%type
71: ,period_name pa_fp_rollup_tmp.period_name%type

Line 68: ,txn_currency_code pa_fp_rollup_tmp.txn_currency_code%type

64: * so commenting it out for time being
65: TYPE mrc_fpRec IS RECORD (
66: budget_line_id pa_fp_rollup_tmp.budget_line_id%type
67: ,resource_assignment_id pa_fp_rollup_tmp.resource_assignment_id%type
68: ,txn_currency_code pa_fp_rollup_tmp.txn_currency_code%type
69: ,start_date pa_fp_rollup_tmp.start_date%type
70: ,end_date pa_fp_rollup_tmp.start_date%type
71: ,period_name pa_fp_rollup_tmp.period_name%type
72: ,quantity Number

Line 69: ,start_date pa_fp_rollup_tmp.start_date%type

65: TYPE mrc_fpRec IS RECORD (
66: budget_line_id pa_fp_rollup_tmp.budget_line_id%type
67: ,resource_assignment_id pa_fp_rollup_tmp.resource_assignment_id%type
68: ,txn_currency_code pa_fp_rollup_tmp.txn_currency_code%type
69: ,start_date pa_fp_rollup_tmp.start_date%type
70: ,end_date pa_fp_rollup_tmp.start_date%type
71: ,period_name pa_fp_rollup_tmp.period_name%type
72: ,quantity Number
73: ,txn_raw_cost Number

Line 70: ,end_date pa_fp_rollup_tmp.start_date%type

66: budget_line_id pa_fp_rollup_tmp.budget_line_id%type
67: ,resource_assignment_id pa_fp_rollup_tmp.resource_assignment_id%type
68: ,txn_currency_code pa_fp_rollup_tmp.txn_currency_code%type
69: ,start_date pa_fp_rollup_tmp.start_date%type
70: ,end_date pa_fp_rollup_tmp.start_date%type
71: ,period_name pa_fp_rollup_tmp.period_name%type
72: ,quantity Number
73: ,txn_raw_cost Number
74: ,txn_burdened_cost Number

Line 71: ,period_name pa_fp_rollup_tmp.period_name%type

67: ,resource_assignment_id pa_fp_rollup_tmp.resource_assignment_id%type
68: ,txn_currency_code pa_fp_rollup_tmp.txn_currency_code%type
69: ,start_date pa_fp_rollup_tmp.start_date%type
70: ,end_date pa_fp_rollup_tmp.start_date%type
71: ,period_name pa_fp_rollup_tmp.period_name%type
72: ,quantity Number
73: ,txn_raw_cost Number
74: ,txn_burdened_cost Number
75: ,txn_revenue Number

Line 76: ,project_currency_code pa_fp_rollup_tmp.txn_currency_code%type

72: ,quantity Number
73: ,txn_raw_cost Number
74: ,txn_burdened_cost Number
75: ,txn_revenue Number
76: ,project_currency_code pa_fp_rollup_tmp.txn_currency_code%type
77: ,project_raw_cost Number
78: ,project_burden_cost Number
79: ,project_revenue Number
80: ,projfunc_currency_code pa_fp_rollup_tmp.txn_currency_code%type

Line 80: ,projfunc_currency_code pa_fp_rollup_tmp.txn_currency_code%type

76: ,project_currency_code pa_fp_rollup_tmp.txn_currency_code%type
77: ,project_raw_cost Number
78: ,project_burden_cost Number
79: ,project_revenue Number
80: ,projfunc_currency_code pa_fp_rollup_tmp.txn_currency_code%type
81: ,projfunc_raw_cost Number
82: ,projfunc_burden_cost Number
83: ,projfunc_revenue Number
84: ,delete_flag pa_fp_rollup_tmp.delete_flag%type

Line 84: ,delete_flag pa_fp_rollup_tmp.delete_flag%type

80: ,projfunc_currency_code pa_fp_rollup_tmp.txn_currency_code%type
81: ,projfunc_raw_cost Number
82: ,projfunc_burden_cost Number
83: ,projfunc_revenue Number
84: ,delete_flag pa_fp_rollup_tmp.delete_flag%type
85: ,Billable_flag pa_fp_rollup_tmp.delete_flag%type
86: ,project_cost_rate_type pa_fp_rollup_tmp.project_cost_rate_type%type
87: ,project_cost_exchange_rate pa_fp_rollup_tmp.project_cost_exchange_rate%type
88: ,project_cost_rate_date_type pa_fp_rollup_tmp.project_cost_rate_date_type%type

Line 85: ,Billable_flag pa_fp_rollup_tmp.delete_flag%type

81: ,projfunc_raw_cost Number
82: ,projfunc_burden_cost Number
83: ,projfunc_revenue Number
84: ,delete_flag pa_fp_rollup_tmp.delete_flag%type
85: ,Billable_flag pa_fp_rollup_tmp.delete_flag%type
86: ,project_cost_rate_type pa_fp_rollup_tmp.project_cost_rate_type%type
87: ,project_cost_exchange_rate pa_fp_rollup_tmp.project_cost_exchange_rate%type
88: ,project_cost_rate_date_type pa_fp_rollup_tmp.project_cost_rate_date_type%type
89: ,project_cost_rate_date pa_fp_rollup_tmp.project_cost_rate_date%type

Line 86: ,project_cost_rate_type pa_fp_rollup_tmp.project_cost_rate_type%type

82: ,projfunc_burden_cost Number
83: ,projfunc_revenue Number
84: ,delete_flag pa_fp_rollup_tmp.delete_flag%type
85: ,Billable_flag pa_fp_rollup_tmp.delete_flag%type
86: ,project_cost_rate_type pa_fp_rollup_tmp.project_cost_rate_type%type
87: ,project_cost_exchange_rate pa_fp_rollup_tmp.project_cost_exchange_rate%type
88: ,project_cost_rate_date_type pa_fp_rollup_tmp.project_cost_rate_date_type%type
89: ,project_cost_rate_date pa_fp_rollup_tmp.project_cost_rate_date%type
90: ,project_rev_rate_type pa_fp_rollup_tmp.project_rev_rate_type%type

Line 87: ,project_cost_exchange_rate pa_fp_rollup_tmp.project_cost_exchange_rate%type

83: ,projfunc_revenue Number
84: ,delete_flag pa_fp_rollup_tmp.delete_flag%type
85: ,Billable_flag pa_fp_rollup_tmp.delete_flag%type
86: ,project_cost_rate_type pa_fp_rollup_tmp.project_cost_rate_type%type
87: ,project_cost_exchange_rate pa_fp_rollup_tmp.project_cost_exchange_rate%type
88: ,project_cost_rate_date_type pa_fp_rollup_tmp.project_cost_rate_date_type%type
89: ,project_cost_rate_date pa_fp_rollup_tmp.project_cost_rate_date%type
90: ,project_rev_rate_type pa_fp_rollup_tmp.project_rev_rate_type%type
91: ,project_rev_exchange_rate pa_fp_rollup_tmp.project_rev_exchange_rate%type

Line 88: ,project_cost_rate_date_type pa_fp_rollup_tmp.project_cost_rate_date_type%type

84: ,delete_flag pa_fp_rollup_tmp.delete_flag%type
85: ,Billable_flag pa_fp_rollup_tmp.delete_flag%type
86: ,project_cost_rate_type pa_fp_rollup_tmp.project_cost_rate_type%type
87: ,project_cost_exchange_rate pa_fp_rollup_tmp.project_cost_exchange_rate%type
88: ,project_cost_rate_date_type pa_fp_rollup_tmp.project_cost_rate_date_type%type
89: ,project_cost_rate_date pa_fp_rollup_tmp.project_cost_rate_date%type
90: ,project_rev_rate_type pa_fp_rollup_tmp.project_rev_rate_type%type
91: ,project_rev_exchange_rate pa_fp_rollup_tmp.project_rev_exchange_rate%type
92: ,project_rev_rate_date_type pa_fp_rollup_tmp.project_rev_rate_date_type%type

Line 89: ,project_cost_rate_date pa_fp_rollup_tmp.project_cost_rate_date%type

85: ,Billable_flag pa_fp_rollup_tmp.delete_flag%type
86: ,project_cost_rate_type pa_fp_rollup_tmp.project_cost_rate_type%type
87: ,project_cost_exchange_rate pa_fp_rollup_tmp.project_cost_exchange_rate%type
88: ,project_cost_rate_date_type pa_fp_rollup_tmp.project_cost_rate_date_type%type
89: ,project_cost_rate_date pa_fp_rollup_tmp.project_cost_rate_date%type
90: ,project_rev_rate_type pa_fp_rollup_tmp.project_rev_rate_type%type
91: ,project_rev_exchange_rate pa_fp_rollup_tmp.project_rev_exchange_rate%type
92: ,project_rev_rate_date_type pa_fp_rollup_tmp.project_rev_rate_date_type%type
93: ,project_rev_rate_date pa_fp_rollup_tmp.project_rev_rate_date%type

Line 90: ,project_rev_rate_type pa_fp_rollup_tmp.project_rev_rate_type%type

86: ,project_cost_rate_type pa_fp_rollup_tmp.project_cost_rate_type%type
87: ,project_cost_exchange_rate pa_fp_rollup_tmp.project_cost_exchange_rate%type
88: ,project_cost_rate_date_type pa_fp_rollup_tmp.project_cost_rate_date_type%type
89: ,project_cost_rate_date pa_fp_rollup_tmp.project_cost_rate_date%type
90: ,project_rev_rate_type pa_fp_rollup_tmp.project_rev_rate_type%type
91: ,project_rev_exchange_rate pa_fp_rollup_tmp.project_rev_exchange_rate%type
92: ,project_rev_rate_date_type pa_fp_rollup_tmp.project_rev_rate_date_type%type
93: ,project_rev_rate_date pa_fp_rollup_tmp.project_rev_rate_date%type
94: ,projfunc_cost_rate_type pa_fp_rollup_tmp.projfunc_cost_rate_type%type

Line 91: ,project_rev_exchange_rate pa_fp_rollup_tmp.project_rev_exchange_rate%type

87: ,project_cost_exchange_rate pa_fp_rollup_tmp.project_cost_exchange_rate%type
88: ,project_cost_rate_date_type pa_fp_rollup_tmp.project_cost_rate_date_type%type
89: ,project_cost_rate_date pa_fp_rollup_tmp.project_cost_rate_date%type
90: ,project_rev_rate_type pa_fp_rollup_tmp.project_rev_rate_type%type
91: ,project_rev_exchange_rate pa_fp_rollup_tmp.project_rev_exchange_rate%type
92: ,project_rev_rate_date_type pa_fp_rollup_tmp.project_rev_rate_date_type%type
93: ,project_rev_rate_date pa_fp_rollup_tmp.project_rev_rate_date%type
94: ,projfunc_cost_rate_type pa_fp_rollup_tmp.projfunc_cost_rate_type%type
95: ,projfunc_cost_exchange_rate pa_fp_rollup_tmp.projfunc_cost_exchange_rate%type

Line 92: ,project_rev_rate_date_type pa_fp_rollup_tmp.project_rev_rate_date_type%type

88: ,project_cost_rate_date_type pa_fp_rollup_tmp.project_cost_rate_date_type%type
89: ,project_cost_rate_date pa_fp_rollup_tmp.project_cost_rate_date%type
90: ,project_rev_rate_type pa_fp_rollup_tmp.project_rev_rate_type%type
91: ,project_rev_exchange_rate pa_fp_rollup_tmp.project_rev_exchange_rate%type
92: ,project_rev_rate_date_type pa_fp_rollup_tmp.project_rev_rate_date_type%type
93: ,project_rev_rate_date pa_fp_rollup_tmp.project_rev_rate_date%type
94: ,projfunc_cost_rate_type pa_fp_rollup_tmp.projfunc_cost_rate_type%type
95: ,projfunc_cost_exchange_rate pa_fp_rollup_tmp.projfunc_cost_exchange_rate%type
96: ,projfunc_cost_rate_date_type pa_fp_rollup_tmp.projfunc_cost_rate_date_type%type

Line 93: ,project_rev_rate_date pa_fp_rollup_tmp.project_rev_rate_date%type

89: ,project_cost_rate_date pa_fp_rollup_tmp.project_cost_rate_date%type
90: ,project_rev_rate_type pa_fp_rollup_tmp.project_rev_rate_type%type
91: ,project_rev_exchange_rate pa_fp_rollup_tmp.project_rev_exchange_rate%type
92: ,project_rev_rate_date_type pa_fp_rollup_tmp.project_rev_rate_date_type%type
93: ,project_rev_rate_date pa_fp_rollup_tmp.project_rev_rate_date%type
94: ,projfunc_cost_rate_type pa_fp_rollup_tmp.projfunc_cost_rate_type%type
95: ,projfunc_cost_exchange_rate pa_fp_rollup_tmp.projfunc_cost_exchange_rate%type
96: ,projfunc_cost_rate_date_type pa_fp_rollup_tmp.projfunc_cost_rate_date_type%type
97: ,projfunc_cost_rate_date pa_fp_rollup_tmp.projfunc_cost_rate_date%type

Line 94: ,projfunc_cost_rate_type pa_fp_rollup_tmp.projfunc_cost_rate_type%type

90: ,project_rev_rate_type pa_fp_rollup_tmp.project_rev_rate_type%type
91: ,project_rev_exchange_rate pa_fp_rollup_tmp.project_rev_exchange_rate%type
92: ,project_rev_rate_date_type pa_fp_rollup_tmp.project_rev_rate_date_type%type
93: ,project_rev_rate_date pa_fp_rollup_tmp.project_rev_rate_date%type
94: ,projfunc_cost_rate_type pa_fp_rollup_tmp.projfunc_cost_rate_type%type
95: ,projfunc_cost_exchange_rate pa_fp_rollup_tmp.projfunc_cost_exchange_rate%type
96: ,projfunc_cost_rate_date_type pa_fp_rollup_tmp.projfunc_cost_rate_date_type%type
97: ,projfunc_cost_rate_date pa_fp_rollup_tmp.projfunc_cost_rate_date%type
98: ,projfunc_rev_rate_type pa_fp_rollup_tmp.projfunc_rev_rate_type%type

Line 95: ,projfunc_cost_exchange_rate pa_fp_rollup_tmp.projfunc_cost_exchange_rate%type

91: ,project_rev_exchange_rate pa_fp_rollup_tmp.project_rev_exchange_rate%type
92: ,project_rev_rate_date_type pa_fp_rollup_tmp.project_rev_rate_date_type%type
93: ,project_rev_rate_date pa_fp_rollup_tmp.project_rev_rate_date%type
94: ,projfunc_cost_rate_type pa_fp_rollup_tmp.projfunc_cost_rate_type%type
95: ,projfunc_cost_exchange_rate pa_fp_rollup_tmp.projfunc_cost_exchange_rate%type
96: ,projfunc_cost_rate_date_type pa_fp_rollup_tmp.projfunc_cost_rate_date_type%type
97: ,projfunc_cost_rate_date pa_fp_rollup_tmp.projfunc_cost_rate_date%type
98: ,projfunc_rev_rate_type pa_fp_rollup_tmp.projfunc_rev_rate_type%type
99: ,projfunc_rev_exchange_rate pa_fp_rollup_tmp.projfunc_rev_exchange_rate%type

Line 96: ,projfunc_cost_rate_date_type pa_fp_rollup_tmp.projfunc_cost_rate_date_type%type

92: ,project_rev_rate_date_type pa_fp_rollup_tmp.project_rev_rate_date_type%type
93: ,project_rev_rate_date pa_fp_rollup_tmp.project_rev_rate_date%type
94: ,projfunc_cost_rate_type pa_fp_rollup_tmp.projfunc_cost_rate_type%type
95: ,projfunc_cost_exchange_rate pa_fp_rollup_tmp.projfunc_cost_exchange_rate%type
96: ,projfunc_cost_rate_date_type pa_fp_rollup_tmp.projfunc_cost_rate_date_type%type
97: ,projfunc_cost_rate_date pa_fp_rollup_tmp.projfunc_cost_rate_date%type
98: ,projfunc_rev_rate_type pa_fp_rollup_tmp.projfunc_rev_rate_type%type
99: ,projfunc_rev_exchange_rate pa_fp_rollup_tmp.projfunc_rev_exchange_rate%type
100: ,projfunc_rev_rate_date_type pa_fp_rollup_tmp.projfunc_rev_rate_date_type%type

Line 97: ,projfunc_cost_rate_date pa_fp_rollup_tmp.projfunc_cost_rate_date%type

93: ,project_rev_rate_date pa_fp_rollup_tmp.project_rev_rate_date%type
94: ,projfunc_cost_rate_type pa_fp_rollup_tmp.projfunc_cost_rate_type%type
95: ,projfunc_cost_exchange_rate pa_fp_rollup_tmp.projfunc_cost_exchange_rate%type
96: ,projfunc_cost_rate_date_type pa_fp_rollup_tmp.projfunc_cost_rate_date_type%type
97: ,projfunc_cost_rate_date pa_fp_rollup_tmp.projfunc_cost_rate_date%type
98: ,projfunc_rev_rate_type pa_fp_rollup_tmp.projfunc_rev_rate_type%type
99: ,projfunc_rev_exchange_rate pa_fp_rollup_tmp.projfunc_rev_exchange_rate%type
100: ,projfunc_rev_rate_date_type pa_fp_rollup_tmp.projfunc_rev_rate_date_type%type
101: ,projfunc_rev_rate_date pa_fp_rollup_tmp.projfunc_rev_rate_date%type

Line 98: ,projfunc_rev_rate_type pa_fp_rollup_tmp.projfunc_rev_rate_type%type

94: ,projfunc_cost_rate_type pa_fp_rollup_tmp.projfunc_cost_rate_type%type
95: ,projfunc_cost_exchange_rate pa_fp_rollup_tmp.projfunc_cost_exchange_rate%type
96: ,projfunc_cost_rate_date_type pa_fp_rollup_tmp.projfunc_cost_rate_date_type%type
97: ,projfunc_cost_rate_date pa_fp_rollup_tmp.projfunc_cost_rate_date%type
98: ,projfunc_rev_rate_type pa_fp_rollup_tmp.projfunc_rev_rate_type%type
99: ,projfunc_rev_exchange_rate pa_fp_rollup_tmp.projfunc_rev_exchange_rate%type
100: ,projfunc_rev_rate_date_type pa_fp_rollup_tmp.projfunc_rev_rate_date_type%type
101: ,projfunc_rev_rate_date pa_fp_rollup_tmp.projfunc_rev_rate_date%type
102: );

Line 99: ,projfunc_rev_exchange_rate pa_fp_rollup_tmp.projfunc_rev_exchange_rate%type

95: ,projfunc_cost_exchange_rate pa_fp_rollup_tmp.projfunc_cost_exchange_rate%type
96: ,projfunc_cost_rate_date_type pa_fp_rollup_tmp.projfunc_cost_rate_date_type%type
97: ,projfunc_cost_rate_date pa_fp_rollup_tmp.projfunc_cost_rate_date%type
98: ,projfunc_rev_rate_type pa_fp_rollup_tmp.projfunc_rev_rate_type%type
99: ,projfunc_rev_exchange_rate pa_fp_rollup_tmp.projfunc_rev_exchange_rate%type
100: ,projfunc_rev_rate_date_type pa_fp_rollup_tmp.projfunc_rev_rate_date_type%type
101: ,projfunc_rev_rate_date pa_fp_rollup_tmp.projfunc_rev_rate_date%type
102: );
103: TYPE mrc_fpTab IS TABLE OF mrc_fpRec INDEX BY BINARY_INTEGER;

Line 100: ,projfunc_rev_rate_date_type pa_fp_rollup_tmp.projfunc_rev_rate_date_type%type

96: ,projfunc_cost_rate_date_type pa_fp_rollup_tmp.projfunc_cost_rate_date_type%type
97: ,projfunc_cost_rate_date pa_fp_rollup_tmp.projfunc_cost_rate_date%type
98: ,projfunc_rev_rate_type pa_fp_rollup_tmp.projfunc_rev_rate_type%type
99: ,projfunc_rev_exchange_rate pa_fp_rollup_tmp.projfunc_rev_exchange_rate%type
100: ,projfunc_rev_rate_date_type pa_fp_rollup_tmp.projfunc_rev_rate_date_type%type
101: ,projfunc_rev_rate_date pa_fp_rollup_tmp.projfunc_rev_rate_date%type
102: );
103: TYPE mrc_fpTab IS TABLE OF mrc_fpRec INDEX BY BINARY_INTEGER;
104: G_FP_MRC_TAB mrc_fpTab;

Line 101: ,projfunc_rev_rate_date pa_fp_rollup_tmp.projfunc_rev_rate_date%type

97: ,projfunc_cost_rate_date pa_fp_rollup_tmp.projfunc_cost_rate_date%type
98: ,projfunc_rev_rate_type pa_fp_rollup_tmp.projfunc_rev_rate_type%type
99: ,projfunc_rev_exchange_rate pa_fp_rollup_tmp.projfunc_rev_exchange_rate%type
100: ,projfunc_rev_rate_date_type pa_fp_rollup_tmp.projfunc_rev_rate_date_type%type
101: ,projfunc_rev_rate_date pa_fp_rollup_tmp.projfunc_rev_rate_date%type
102: );
103: TYPE mrc_fpTab IS TABLE OF mrc_fpRec INDEX BY BINARY_INTEGER;
104: G_FP_MRC_TAB mrc_fpTab;
105: */

Line 667: FROM pa_fp_rollup_tmp tmp

663: ,tmp.burden_cost_rate_override
664: ,tmp.txn_revenue
665: ,tmp.bill_rate_override
666: ,tmp.budget_line_id
667: FROM pa_fp_rollup_tmp tmp
668: ORDER BY tmp.resource_assignment_id
669: ,tmp.txn_currency_code;
670:
671: CURSOR cur_calTmp IS

Line 783: AND EXISTS ( select /+ INDEX(RTMP PA_FP_ROLLUP_TMP_N1) / null

779: WHERE tmp.budget_version_id = p_budget_version_id
780: AND tmp.resource_assignment_id = rtx.resource_assignment_id
781: AND tmp.txn_currency_code = rtx.txn_currency_code
782: /* bug fix: If no budge Lines exists then donot delete the resource when refresh is done */
783: AND EXISTS ( select /*+ INDEX(RTMP PA_FP_ROLLUP_TMP_N1) */ null
784: from pa_fp_rollup_tmp rtmp
785: where rtmp.resource_assignment_id = tmp.resource_assignment_id
786: and rtmp.txn_currency_code = tmp.txn_currency_code
787: );

Line 784: from pa_fp_rollup_tmp rtmp

780: AND tmp.resource_assignment_id = rtx.resource_assignment_id
781: AND tmp.txn_currency_code = rtx.txn_currency_code
782: /* bug fix: If no budge Lines exists then donot delete the resource when refresh is done */
783: AND EXISTS ( select /*+ INDEX(RTMP PA_FP_ROLLUP_TMP_N1) */ null
784: from pa_fp_rollup_tmp rtmp
785: where rtmp.resource_assignment_id = tmp.resource_assignment_id
786: and rtmp.txn_currency_code = tmp.txn_currency_code
787: );
788: l_rowCount1 := sql%Rowcount;

Line 805: from pa_fp_rollup_tmp rtmp

801: where tmp.resource_assignment_id = rtx.resource_assignment_id
802: and tmp.txn_currency_code = rtx.txn_currency_code
803: )
804: AND NOT EXISTS ( select null
805: from pa_fp_rollup_tmp rtmp
806: where rtmp.resource_assignment_id = rtx.resource_assignment_id
807: and rtmp.txn_currency_code = rtx.txn_currency_code
808: );
809: --print_msg('Number of records updated directly with null['||sql%rowcount||']');

Line 952: FROM pa_fp_rollup_tmp tmp

948: SELECT 1 ra_txn_id
949: ,p_budget_version_id
950: ,tmp.resource_assignment_id
951: ,tmp.txn_currency_code
952: FROM pa_fp_rollup_tmp tmp
953: WHERE tmp.budget_version_id = p_budget_version_id
954: GROUP BY p_budget_version_id
955: ,tmp.resource_assignment_id
956: ,tmp.txn_currency_code,1;

Line 1027: FROM pa_fp_rollup_tmp

1023: l_burden_cost_rate_override,
1024: l_bill_rate_override,
1025: l_ra_id,
1026: l_txn_currency_code
1027: FROM pa_fp_rollup_tmp
1028: WHERE rowid=gl_cl_roll_up_tmp_rowid_tab(zz);
1029:
1030: UPDATE pa_resource_asgn_curr_tmp
1031: SET txn_raw_cost_rate_override = NVL(l_rw_cost_rate_override,txn_raw_cost_rate_override),

Line 1169: UPDATE pa_fp_rollup_tmp tmp

1165: x_return_status := 'S';
1166: IF p_pa_debug_mode = 'Y' Then
1167: print_rlTmp_Values;
1168: End If;
1169: UPDATE pa_fp_rollup_tmp tmp
1170: SET (tmp.rw_cost_rate_override
1171: ,tmp.burden_cost_rate_override
1172: ,tmp.bill_rate_override ) =
1173: (SELECT /*+ INDEX(RAX PA_RESOURCE_ASGN_CURR_U2) */

Line 1551: DELETE FROM pa_fp_rollup_tmp;

1547: BEGIN
1548:
1549: --INITIALIZATION--
1550: DELETE FROM pa_fp_res_assignments_tmp;
1551: DELETE FROM pa_fp_rollup_tmp;
1552: DELETE FROM pa_fp_spread_calc_tmp;
1553: DELETE FROM pa_resource_asgn_curr_tmp;
1554:
1555: --Bug 4309290.using the new introuced parameter p_del_spread_calc_tmp1_flg to determine delete on pa_fp_spread_calc_tmp1

Line 1748: from pa_fp_rollup_tmp tmp

1744: CURSOR cur_retSts IS
1745: SELECT 'E'
1746: FROM DUAL
1747: WHERE EXISTS (select null
1748: from pa_fp_rollup_tmp tmp
1749: where ( tmp.cost_rejection_code in ('PA_FP_PROJ_NO_TXNCONVRATE'
1750: ,'PA_FP_PRJFUNC_CURR_NULL'
1751: ,'PA_FP_PRJ_CURR_NULL'
1752: ,'PA_FP_ERROR_FROM_RATE_API_CALL' )

Line 1875: /* This API inserts mrc plsql table of records into pa_fp_rollup_tmp when mrc conv is required */

1871: x_msg_data := sqlcode||sqlerrm;
1872: RAISE;
1873: END Populate_MRC_plsqlTabs;
1874:
1875: /* This API inserts mrc plsql table of records into pa_fp_rollup_tmp when mrc conv is required */
1876: PROCEDURE Populate_rollup_WithMrcRecs
1877: (p_budget_version_id IN Number
1878: ,x_msg_data OUT NOCOPY Varchar2
1879: ,x_return_status OUT NOCOPY Varchar2

Line 1893: INSERT INTO PA_FP_ROLLUP_TMP tmp

1889: * BULK In-BIND table of records
1890: */
1891: --print_msg('Number of records inserting into rollupTmp for MRC processing['||g_mrc_budget_line_id_tab.COUNT||']');
1892: FORALL i IN g_mrc_budget_line_id_tab.FIRST .. g_mrc_budget_line_id_tab.LAST
1893: INSERT INTO PA_FP_ROLLUP_TMP tmp
1894: (budget_version_id
1895: ,budget_line_id
1896: ,resource_assignment_id
1897: ,txn_currency_code

Line 1969: FROM PA_FP_ROLLUP_TMP RLTMP1

1965: ,g_mrc_projfunc_rev_rt_dt_tab(i)
1966: ,g_mrc_delete_flag_tab(i)
1967: FROM DUAL
1968: WHERE NOT EXISTS (SELECT NULL
1969: FROM PA_FP_ROLLUP_TMP RLTMP1
1970: WHERE rltmp1.budget_line_id = g_mrc_budget_line_id_tab(i)
1971: );
1972: END If;
1973: END IF;

Line 2280: FROM pa_fp_rollup_tmp tmp

2276: ,to_number(NULL) diff_projfunc_burden_cost
2277: ,to_number(NULL) diff_projfunc_revenue
2278: ,project_currency_code
2279: ,projfunc_currency_code
2280: FROM pa_fp_rollup_tmp tmp
2281: WHERE tmp.budget_version_id = p_budget_version_id
2282: AND nvl(quantity,0) <> 0
2283: AND ( tmp.txn_currency_code <> tmp.project_currency_code
2284: OR

Line 2450: UPDATE pa_fp_rollup_tmp tmp

2446:
2447: --print_msg('Updating rollup tmp last line with the rounding difference amount');
2448: g_stage := 'Update_PCPFC_rounding_diff:102';
2449: FORALL i IN l_resource_assignment_tab.FIRST .. l_resource_assignment_tab.LAST
2450: UPDATE pa_fp_rollup_tmp tmp
2451: SET tmp.attribute14 = decode(tmp.txn_currency_code,tmp.project_currency_code,NULL,'PCPFCRoundingDiscrepancyLine')
2452: /*---Project columns ---*/
2453: ,tmp.project_raw_cost = decode(p_budget_version_type,'COST',
2454: decode(tmp.txn_currency_code,tmp.project_currency_code,tmp.project_raw_cost

Line 2518: from pa_fp_rollup_tmp tmp2

2514: OR NVL(l_diff_pjfc_rev_tab(i),0) <> 0 );
2515: /** Bug fix: 4208217 Performance fix: This is additional condition may not be necessary so commenting out
2516: -- added this to ensure that only one budget line in rollup tmp gets updated even if there is duplicate lines
2517: AND tmp.rowid in (select max(rowid)
2518: from pa_fp_rollup_tmp tmp2
2519: where tmp2.resource_assignment_id = tmp.resource_assignment_id
2520: and tmp2.txn_currency_code = tmp.txn_currency_code
2521: and tmp2.start_date = tmp.start_date
2522: );

Line 2599: FROM pa_fp_rollup_tmp tmp

2595: **/
2596: ,to_number(NULL) diff_raw_cost
2597: ,to_number(NULL) diff_burden_cost
2598: ,to_number(NULL) diff_revenue
2599: FROM pa_fp_rollup_tmp tmp
2600: WHERE tmp.budget_version_id = p_budget_version_id
2601: AND nvl(quantity,0) <> 0
2602: GROUP BY resource_assignment_id
2603: ,txn_currency_code ;

Line 2719: UPDATE /+ INDEX(TMP PA_FP_ROLLUP_TMP_N1) / pa_fp_rollup_tmp tmp

2715: END IF;
2716: g_stage := 'Update_rounding_diff:102';
2717: --print_msg('Updating rollup tmp last line with the rounding difference amount');
2718: FORALL i IN l_resource_assignment_tab.FIRST .. l_resource_assignment_tab.LAST
2719: UPDATE /*+ INDEX(TMP PA_FP_ROLLUP_TMP_N1) */ pa_fp_rollup_tmp tmp
2720: SET tmp.txn_raw_cost = decode(p_budget_version_type,'COST'
2721: ,DECODE((nvl(tmp.txn_raw_cost,0)+NVL(l_diff_raw_cost_tab(i),0)),0,NULL
2722: ,(nvl(tmp.txn_raw_cost,0)+NVL(l_diff_raw_cost_tab(i),0)))
2723: ,'ALL',DECODE((nvl(tmp.txn_raw_cost,0)+NVL(l_diff_raw_cost_tab(i),0)),0,NULL

Line 2747: from pa_fp_rollup_tmp tmp2

2743: ;
2744: /** Bug fix: 4208217 Performance fix: This is additional condition may not be necessary so commenting out
2745: -- added this to ensure that only one budget line in rollup tmp gets updated even if there is duplicate lines
2746: AND tmp.rowid in (select max(rowid)
2747: from pa_fp_rollup_tmp tmp2
2748: where tmp2.resource_assignment_id = tmp.resource_assignment_id
2749: and tmp2.txn_currency_code = tmp.txn_currency_code
2750: and tmp2.start_date = tmp.start_date
2751: );

Line 4777: FROM pa_fp_rollup_tmp tmp

4773: * If bill rate override is passed, then do not calculate markup
4774: */
4775: ,decode(p_generation_context,'REVENUE_MARKUP',
4776: decode(fptmp.revenue_bill_rate,NULL,'Y','N'),'Y') markup_calculation_flag
4777: FROM pa_fp_rollup_tmp tmp
4778: ,pa_fp_gen_rate_tmp fptmp
4779: ,pa_resource_assignments ra
4780: ,pa_fp_spread_calc_tmp caltmp
4781: WHERE caltmp.budget_version_id = p_budget_version_id

Line 4813: FROM pa_fp_rollup_tmp tmp

4809: ,fptmp.burdened_cost_rate burden_rate_override
4810: ,fptmp.revenue_bill_rate bill_rate_override
4811: ,decode(p_generation_context,'REVENUE_MARKUP',
4812: decode(fptmp.revenue_bill_rate,NULL,'Y','N'),'Y') markup_calculation_flag
4813: FROM pa_fp_rollup_tmp tmp
4814: ,pa_fp_gen_rate_tmp fptmp
4815: ,pa_resource_assignments ra
4816: ,pa_fp_spread_calc_tmp caltmp
4817: WHERE caltmp.budget_version_id = p_budget_version_id

Line 4877: UPDATE pa_fp_rollup_tmp tmp

4873:
4874: If perdRec.time_phase_code in ('G','P') Then
4875: g_stage :='Update_rollupTmp_OvrRates:101';
4876: --print_msg('Update rollup tmp period name where it is null');
4877: UPDATE pa_fp_rollup_tmp tmp
4878: SET tmp.period_name = (select gp.period_name
4879: from gl_periods gp
4880: where gp.period_set_name = perdRec.period_set_name
4881: and gp.adjustment_period_flag = 'N'

Line 4895: UPDATE pa_fp_rollup_tmp tmp

4891: --print_msg('Number of rows updated['||sql%rowcount||']');
4892: Else
4893: g_stage :='Update_rollupTmp_OvrRates:102';
4894: /* Non-Timephased budgets period name must be null */
4895: UPDATE pa_fp_rollup_tmp tmp
4896: SET tmp.period_name = NULL
4897: WHERE tmp.period_name is NOT NULL
4898: AND NVL(tmp.system_reference5,'N') = 'N'
4899: AND tmp.budget_version_id = p_budget_version_id;

Line 4977: UPDATE pa_fp_rollup_tmp tmp

4973: */
4974: g_stage :='Update_rollupTmp_OvrRates:104';
4975: --print_msg(g_stage||'Number of rows fetched['||l_rowid_tab.COUNT||']');
4976: FORALL i IN l_rowid_tab.FIRST .. l_rowid_tab.LAST
4977: UPDATE pa_fp_rollup_tmp tmp
4978: SET tmp.rw_cost_rate_override = l_cost_rate_override_tab(i)
4979: ,tmp.burden_cost_rate_override = l_burden_rate_override_tab(i)
4980: ,tmp.bill_rate_override = l_bill_rate_override_tab(i)
4981: ,tmp.PROJECT_COST_RATE_TYPE = nvl(l_PROJECT_COST_RATE_TYPE_tab(i),tmp.PROJECT_COST_RATE_TYPE)

Line 5782: INSERT INTO pa_fp_rollup_tmp (

5778: end loop;
5779: END IF;
5780: */
5781:
5782: INSERT INTO pa_fp_rollup_tmp (
5783: budget_version_id
5784: ,resource_assignment_id
5785: ,start_date
5786: ,end_date

Line 5854: In the following code we are storing the pa_budget_lines attributes in pa_fp_rollup_tmp

5850: /* Bug Fix 4332086
5851: When ever currency is overridden in the workplan flow the exchange rates of old currency
5852: are used to derive the PFC amounts.
5853: This is happening due to the following piece of code.
5854: In the following code we are storing the pa_budget_lines attributes in pa_fp_rollup_tmp
5855: and then we are using the same in the later part of the code.
5856: This is resulting in the bug.
5857:
5858: As a fix now we added another decode condition to see if the currency is iverridden.

Line 6162: UPDATE /+ INDEX(TMP PA_FP_ROLLUP_TMP_N1) / pa_fp_rollup_tmp tmp

6158: AND NVL(g_mass_adjust_flag,'N') = 'N'
6159: AND NVL(g_refresh_conv_rates_flag,'N') = 'N'
6160: AND g_applyProg_RaId_tab.COUNT = 0 ) Then
6161: g_stage := 'populate_rollup_tmp:102';
6162: UPDATE /*+ INDEX(TMP PA_FP_ROLLUP_TMP_N1) */ pa_fp_rollup_tmp tmp
6163: SET (tmp.rw_cost_rate_override
6164: ,tmp.burden_cost_rate_override
6165: ,tmp.bill_rate_override) =
6166: (SELECT decode(caltmp.txn_curr_code_override,NULL,decode(caltmp.mfc_cost_change_flag,'Y',caltmp.cost_rate_override

Line 6209: UPDATE /+ INDEX(TMP PA_FP_ROLLUP_TMP_N1) / pa_fp_rollup_tmp tmp

6205: If P_PA_DEBUG_MODE = 'Y' Then
6206: print_msg('Updating rollup with rate overrides ');
6207: End If;
6208: FORALL i IN g_rtChanged_RaId_tab.FIRST .. g_rtChanged_RaId_tab.LAST
6209: UPDATE /*+ INDEX(TMP PA_FP_ROLLUP_TMP_N1) */ pa_fp_rollup_tmp tmp
6210: SET (tmp.rw_cost_rate_override
6211: ,tmp.burden_cost_rate_override
6212: ,tmp.bill_rate_override ) =
6213: (SELECT decode(NVL(g_rtChanged_cstMisNumFlg_tab(i),'N'),'Y',NULL

Line 6255: FROM pa_fp_rollup_tmp ;

6251: If P_PA_DEBUG_MODE = 'Y' Then
6252: l_stage := 2019;
6253: SELECT count(*)
6254: INTO l_count
6255: FROM pa_fp_rollup_tmp ;
6256: g_stage := 'populate_rollup_tmp:104';
6257: print_msg('Num of rows inserted into rollup Temp['||l_count||']');
6258: print_rlTmp_Values;
6259: End If;

Line 6356: FROM pa_fp_rollup_tmp tmp

6352: ,decode(g_wp_version_flag,'Y',0
6353: ,decode(NVL(tmp.rate_based_flag,'N'),'Y',0
6354: ,(sum(nvl(tmp.txn_revenue,0) - nvl(tmp.txn_init_revenue,0))))) RndRevenue
6355: ,to_number(null) RevenueDiff
6356: FROM pa_fp_rollup_tmp tmp
6357: ,pa_fp_spread_calc_tmp caltmp
6358: WHERE caltmp.budget_version_id = p_budget_version_id
6359: AND caltmp.resource_assignment_id = tmp.resource_assignment_id
6360: AND tmp.txn_currency_code = caltmp.txn_currency_code

Line 6391: UPDATE /+ INDEX(TMP PA_FP_ROLLUP_TMP_N1) / pa_fp_rollup_tmp tmp

6387: l_revenue_adj_pct := Round(l_revenue_adj_pct,2);
6388:
6389: If g_wp_version_flag = 'Y' Then --{
6390: g_stage := 'mass_adjust:101';
6391: UPDATE /*+ INDEX(TMP PA_FP_ROLLUP_TMP_N1) */ pa_fp_rollup_tmp tmp
6392: SET tmp.old_quantity = decode(l_quantity_adj_pct,NULL,to_number(NULL),tmp.quantity)
6393: ,tmp.quantity = decode(l_quantity_adj_pct,NULL,tmp.quantity
6394: ,decode(NVL(tmp.rate_based_flag,'N'),'N'
6395: ,(NVL(tmp.init_quantity,0)+ pa_currency.round_trans_currency_amt1 (

Line 6434: UPDATE /+ INDEX(TMP PA_FP_ROLLUP_TMP_N1) / pa_fp_rollup_tmp tmp

6430: OR l_cost_rate_adj_pct is NOT NULL
6431: or l_burdened_rate_adj_pct is NOT NULL
6432: or l_bill_rate_adj_pct is NOT NULL Then --{
6433: g_stage := 'mass_adjust:103';
6434: UPDATE /*+ INDEX(TMP PA_FP_ROLLUP_TMP_N1) */ pa_fp_rollup_tmp tmp
6435: SET tmp.old_quantity = decode(NVL(tmp.rate_based_flag,'N'),'N',tmp.quantity
6436: ,decode(l_quantity_adj_pct,NULL,to_number(NULL),tmp.quantity))
6437: ,tmp.quantity = decode(NVL(tmp.rate_based_flag,'N'),'N',tmp.quantity
6438: ,decode(l_quantity_adj_pct,NULL,tmp.quantity

Line 6493: UPDATE /+ INDEX(TMP PA_FP_ROLLUP_TMP_N1) / pa_fp_rollup_tmp tmp

6489: );
6490: g_stage := 'mass_adjust:104: Number of rows Updated['||sql%rowcount||']';
6491:
6492: ELSIF l_raw_cost_adj_pct is NOT NULL OR l_burden_cost_adj_pct is NOT NULL OR l_revenue_adj_pct is NOT NULL Then
6493: UPDATE /*+ INDEX(TMP PA_FP_ROLLUP_TMP_N1) */ pa_fp_rollup_tmp tmp
6494: SET tmp.old_txn_raw_cost =
6495: decode(l_raw_cost_adj_pct,NULL,to_number(null),tmp.txn_raw_cost)
6496: ,tmp.old_txn_revenue =
6497: decode(l_revenue_adj_pct,NULL,to_number(null),tmp.txn_revenue)

Line 6630: UPDATE pa_fp_rollup_tmp tmp

6626: End If;
6627: END LOOP;
6628: g_stage := 'mass_adjust:106';
6629: FORALL i IN l_blId_tab.FIRST .. l_blId_tab.LAST
6630: UPDATE pa_fp_rollup_tmp tmp
6631: SET tmp.quantity = tmp.quantity + nvl(l_quantity_diff_tab(i),0)
6632: WHERE tmp.budget_line_id = l_blId_tab(i)
6633: AND NVL(l_quantity_diff_tab(i),0) <> 0;
6634:

Line 6651: UPDATE pa_fp_rollup_tmp tmp

6647: End If;
6648: END LOOP;
6649: g_stage := 'mass_adjust:106';
6650: FORALL i IN l_blId_tab.FIRST .. l_blId_tab.LAST
6651: UPDATE pa_fp_rollup_tmp tmp
6652: SET tmp.quantity = decode(g_fp_budget_version_type,'REVENUE', tmp.quantity
6653: ,'COST', (tmp.txn_raw_cost + nvl(l_rawcost_diff_tab(i),0))
6654: ,'ALL',decode(tmp.rw_cost_rate_override,0,tmp.quantity,NULL,tmp.quantity
6655: ,(tmp.txn_raw_cost + nvl(l_rawcost_diff_tab(i),0))))

Line 6680: UPDATE pa_fp_rollup_tmp tmp

6676: End If;
6677: END LOOP;
6678: g_stage := 'mass_adjust:106';
6679: FORALL i IN l_blId_tab.FIRST .. l_blId_tab.LAST
6680: UPDATE pa_fp_rollup_tmp tmp
6681: SET tmp.quantity = decode(g_fp_budget_version_type,'COST', tmp.quantity
6682: ,'REVENUE', (tmp.txn_revenue + nvl(l_revenue_diff_tab(i),0))
6683: ,'ALL',decode(nvl(tmp.rw_cost_rate_override,0),0
6684: ,(tmp.txn_revenue + nvl(l_revenue_diff_tab(i),0)),tmp.quantity))

Line 7246: ,p_txn_raw_cost IN pa_fp_rollup_tmp.txn_raw_cost%TYPE

7242: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
7243: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
7244: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
7245: ,p_budget_line_id IN pa_budget_lines.budget_line_id%TYPE
7246: ,p_txn_raw_cost IN pa_fp_rollup_tmp.txn_raw_cost%TYPE
7247: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.txn_burdened_cost%TYPE
7248: ,p_txn_revenue IN pa_fp_rollup_tmp.txn_revenue%TYPE
7249: ,x_projfunc_currency_code OUT NOCOPY pa_fp_rollup_tmp.projfunc_currency_code%TYPE
7250: ,x_projfunc_raw_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_raw_cost%TYPE

Line 7247: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.txn_burdened_cost%TYPE

7243: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
7244: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
7245: ,p_budget_line_id IN pa_budget_lines.budget_line_id%TYPE
7246: ,p_txn_raw_cost IN pa_fp_rollup_tmp.txn_raw_cost%TYPE
7247: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.txn_burdened_cost%TYPE
7248: ,p_txn_revenue IN pa_fp_rollup_tmp.txn_revenue%TYPE
7249: ,x_projfunc_currency_code OUT NOCOPY pa_fp_rollup_tmp.projfunc_currency_code%TYPE
7250: ,x_projfunc_raw_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_raw_cost%TYPE
7251: ,x_projfunc_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_burdened_cost%TYPE

Line 7248: ,p_txn_revenue IN pa_fp_rollup_tmp.txn_revenue%TYPE

7244: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
7245: ,p_budget_line_id IN pa_budget_lines.budget_line_id%TYPE
7246: ,p_txn_raw_cost IN pa_fp_rollup_tmp.txn_raw_cost%TYPE
7247: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.txn_burdened_cost%TYPE
7248: ,p_txn_revenue IN pa_fp_rollup_tmp.txn_revenue%TYPE
7249: ,x_projfunc_currency_code OUT NOCOPY pa_fp_rollup_tmp.projfunc_currency_code%TYPE
7250: ,x_projfunc_raw_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_raw_cost%TYPE
7251: ,x_projfunc_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_burdened_cost%TYPE
7252: ,x_projfunc_revenue OUT NOCOPY pa_fp_rollup_tmp.projfunc_revenue%TYPE

Line 7249: ,x_projfunc_currency_code OUT NOCOPY pa_fp_rollup_tmp.projfunc_currency_code%TYPE

7245: ,p_budget_line_id IN pa_budget_lines.budget_line_id%TYPE
7246: ,p_txn_raw_cost IN pa_fp_rollup_tmp.txn_raw_cost%TYPE
7247: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.txn_burdened_cost%TYPE
7248: ,p_txn_revenue IN pa_fp_rollup_tmp.txn_revenue%TYPE
7249: ,x_projfunc_currency_code OUT NOCOPY pa_fp_rollup_tmp.projfunc_currency_code%TYPE
7250: ,x_projfunc_raw_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_raw_cost%TYPE
7251: ,x_projfunc_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_burdened_cost%TYPE
7252: ,x_projfunc_revenue OUT NOCOPY pa_fp_rollup_tmp.projfunc_revenue%TYPE
7253: ,x_projfunc_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pfc_cur_conv_rejection_code%TYPE

Line 7250: ,x_projfunc_raw_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_raw_cost%TYPE

7246: ,p_txn_raw_cost IN pa_fp_rollup_tmp.txn_raw_cost%TYPE
7247: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.txn_burdened_cost%TYPE
7248: ,p_txn_revenue IN pa_fp_rollup_tmp.txn_revenue%TYPE
7249: ,x_projfunc_currency_code OUT NOCOPY pa_fp_rollup_tmp.projfunc_currency_code%TYPE
7250: ,x_projfunc_raw_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_raw_cost%TYPE
7251: ,x_projfunc_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_burdened_cost%TYPE
7252: ,x_projfunc_revenue OUT NOCOPY pa_fp_rollup_tmp.projfunc_revenue%TYPE
7253: ,x_projfunc_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pfc_cur_conv_rejection_code%TYPE
7254: ,x_project_currency_code OUT NOCOPY pa_fp_rollup_tmp.project_currency_code%TYPE

Line 7251: ,x_projfunc_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_burdened_cost%TYPE

7247: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.txn_burdened_cost%TYPE
7248: ,p_txn_revenue IN pa_fp_rollup_tmp.txn_revenue%TYPE
7249: ,x_projfunc_currency_code OUT NOCOPY pa_fp_rollup_tmp.projfunc_currency_code%TYPE
7250: ,x_projfunc_raw_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_raw_cost%TYPE
7251: ,x_projfunc_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_burdened_cost%TYPE
7252: ,x_projfunc_revenue OUT NOCOPY pa_fp_rollup_tmp.projfunc_revenue%TYPE
7253: ,x_projfunc_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pfc_cur_conv_rejection_code%TYPE
7254: ,x_project_currency_code OUT NOCOPY pa_fp_rollup_tmp.project_currency_code%TYPE
7255: ,x_project_raw_cost OUT NOCOPY pa_fp_rollup_tmp.project_raw_cost%TYPE

Line 7252: ,x_projfunc_revenue OUT NOCOPY pa_fp_rollup_tmp.projfunc_revenue%TYPE

7248: ,p_txn_revenue IN pa_fp_rollup_tmp.txn_revenue%TYPE
7249: ,x_projfunc_currency_code OUT NOCOPY pa_fp_rollup_tmp.projfunc_currency_code%TYPE
7250: ,x_projfunc_raw_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_raw_cost%TYPE
7251: ,x_projfunc_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_burdened_cost%TYPE
7252: ,x_projfunc_revenue OUT NOCOPY pa_fp_rollup_tmp.projfunc_revenue%TYPE
7253: ,x_projfunc_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pfc_cur_conv_rejection_code%TYPE
7254: ,x_project_currency_code OUT NOCOPY pa_fp_rollup_tmp.project_currency_code%TYPE
7255: ,x_project_raw_cost OUT NOCOPY pa_fp_rollup_tmp.project_raw_cost%TYPE
7256: ,x_project_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.project_burdened_cost%TYPE

Line 7253: ,x_projfunc_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pfc_cur_conv_rejection_code%TYPE

7249: ,x_projfunc_currency_code OUT NOCOPY pa_fp_rollup_tmp.projfunc_currency_code%TYPE
7250: ,x_projfunc_raw_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_raw_cost%TYPE
7251: ,x_projfunc_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_burdened_cost%TYPE
7252: ,x_projfunc_revenue OUT NOCOPY pa_fp_rollup_tmp.projfunc_revenue%TYPE
7253: ,x_projfunc_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pfc_cur_conv_rejection_code%TYPE
7254: ,x_project_currency_code OUT NOCOPY pa_fp_rollup_tmp.project_currency_code%TYPE
7255: ,x_project_raw_cost OUT NOCOPY pa_fp_rollup_tmp.project_raw_cost%TYPE
7256: ,x_project_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.project_burdened_cost%TYPE
7257: ,x_project_revenue OUT NOCOPY pa_fp_rollup_tmp.project_revenue%TYPE

Line 7254: ,x_project_currency_code OUT NOCOPY pa_fp_rollup_tmp.project_currency_code%TYPE

7250: ,x_projfunc_raw_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_raw_cost%TYPE
7251: ,x_projfunc_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_burdened_cost%TYPE
7252: ,x_projfunc_revenue OUT NOCOPY pa_fp_rollup_tmp.projfunc_revenue%TYPE
7253: ,x_projfunc_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pfc_cur_conv_rejection_code%TYPE
7254: ,x_project_currency_code OUT NOCOPY pa_fp_rollup_tmp.project_currency_code%TYPE
7255: ,x_project_raw_cost OUT NOCOPY pa_fp_rollup_tmp.project_raw_cost%TYPE
7256: ,x_project_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.project_burdened_cost%TYPE
7257: ,x_project_revenue OUT NOCOPY pa_fp_rollup_tmp.project_revenue%TYPE
7258: ,x_project_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pc_cur_conv_rejection_code%TYPE

Line 7255: ,x_project_raw_cost OUT NOCOPY pa_fp_rollup_tmp.project_raw_cost%TYPE

7251: ,x_projfunc_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.projfunc_burdened_cost%TYPE
7252: ,x_projfunc_revenue OUT NOCOPY pa_fp_rollup_tmp.projfunc_revenue%TYPE
7253: ,x_projfunc_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pfc_cur_conv_rejection_code%TYPE
7254: ,x_project_currency_code OUT NOCOPY pa_fp_rollup_tmp.project_currency_code%TYPE
7255: ,x_project_raw_cost OUT NOCOPY pa_fp_rollup_tmp.project_raw_cost%TYPE
7256: ,x_project_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.project_burdened_cost%TYPE
7257: ,x_project_revenue OUT NOCOPY pa_fp_rollup_tmp.project_revenue%TYPE
7258: ,x_project_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pc_cur_conv_rejection_code%TYPE
7259: ,x_return_status OUT NOCOPY VARCHAR2

Line 7256: ,x_project_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.project_burdened_cost%TYPE

7252: ,x_projfunc_revenue OUT NOCOPY pa_fp_rollup_tmp.projfunc_revenue%TYPE
7253: ,x_projfunc_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pfc_cur_conv_rejection_code%TYPE
7254: ,x_project_currency_code OUT NOCOPY pa_fp_rollup_tmp.project_currency_code%TYPE
7255: ,x_project_raw_cost OUT NOCOPY pa_fp_rollup_tmp.project_raw_cost%TYPE
7256: ,x_project_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.project_burdened_cost%TYPE
7257: ,x_project_revenue OUT NOCOPY pa_fp_rollup_tmp.project_revenue%TYPE
7258: ,x_project_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pc_cur_conv_rejection_code%TYPE
7259: ,x_return_status OUT NOCOPY VARCHAR2
7260: ,x_msg_count OUT NOCOPY NUMBER

Line 7257: ,x_project_revenue OUT NOCOPY pa_fp_rollup_tmp.project_revenue%TYPE

7253: ,x_projfunc_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pfc_cur_conv_rejection_code%TYPE
7254: ,x_project_currency_code OUT NOCOPY pa_fp_rollup_tmp.project_currency_code%TYPE
7255: ,x_project_raw_cost OUT NOCOPY pa_fp_rollup_tmp.project_raw_cost%TYPE
7256: ,x_project_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.project_burdened_cost%TYPE
7257: ,x_project_revenue OUT NOCOPY pa_fp_rollup_tmp.project_revenue%TYPE
7258: ,x_project_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pc_cur_conv_rejection_code%TYPE
7259: ,x_return_status OUT NOCOPY VARCHAR2
7260: ,x_msg_count OUT NOCOPY NUMBER
7261: ,x_msg_data OUT NOCOPY VARCHAR2) IS

Line 7258: ,x_project_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pc_cur_conv_rejection_code%TYPE

7254: ,x_project_currency_code OUT NOCOPY pa_fp_rollup_tmp.project_currency_code%TYPE
7255: ,x_project_raw_cost OUT NOCOPY pa_fp_rollup_tmp.project_raw_cost%TYPE
7256: ,x_project_burdened_cost OUT NOCOPY pa_fp_rollup_tmp.project_burdened_cost%TYPE
7257: ,x_project_revenue OUT NOCOPY pa_fp_rollup_tmp.project_revenue%TYPE
7258: ,x_project_rejection_code OUT NOCOPY pa_fp_rollup_tmp.pc_cur_conv_rejection_code%TYPE
7259: ,x_return_status OUT NOCOPY VARCHAR2
7260: ,x_msg_count OUT NOCOPY NUMBER
7261: ,x_msg_data OUT NOCOPY VARCHAR2) IS
7262:

Line 7393: from pa_fp_rollup_tmp r

7389: 'START_DATE',r.start_date,
7390: 'END_DATE' ,r.end_date,
7391: nvl(r.project_rev_rate_date,pa_fp_multi_currency_pkg.g_proj_rev_rate_date))
7392: project_rev_rate_date
7393: from pa_fp_rollup_tmp r
7394: where nvl(r.delete_flag,'N') = 'N'
7395: and r.budget_line_id = p_budget_line_id
7396: order by r.resource_assignment_id,
7397: r.start_date,

Line 8077: from pa_fp_rollup_tmp

8073:
8074: CURSOR get_total_amounts_res_asn (p_resource_asg_id IN NUMBER) IS
8075: select sum(txn_burdened_cost) l_txn_burdened_cost_total_bl,
8076: sum(txn_raw_cost) l_txn_raw_cost_total_bl
8077: from pa_fp_rollup_tmp
8078: where budget_version_id = p_budget_version_id
8079: and resource_assignment_id = p_resource_asg_id;
8080:
8081: CURSOR get_p_res_asn_curr_code IS

Line 8179: FROM pa_fp_rollup_tmp tmp

8175: ,tmp.txn_init_raw_cost
8176: ,tmp.txn_init_burdened_cost
8177: ,tmp.txn_init_revenue
8178: -- End for 6781055
8179: FROM pa_fp_rollup_tmp tmp
8180: ,pa_budget_versions bv
8181: ,pa_resource_assignments ra
8182: ,pa_resource_list_members rl
8183: WHERE bv.budget_version_id = p_budget_version_id

Line 10538: /*Bug 4224464. This API would be called to insert into pa_fp_rollup_tmp all those budget lines which are not already present in

10534:
10535: END IF; --}
10536:
10537:
10538: /*Bug 4224464. This API would be called to insert into pa_fp_rollup_tmp all those budget lines which are not already present in
10539: pa_fp_rollup_tmp. These lines would be the ones with no changes to qty/amnt and rate columns. The lines with changes to
10540: qty/amnt and rate columns would not be processed by this API as earlier call to copy_blattributes would have handled these
10541: lines Also using the same signature for this API as used for copy_blattributes above.*/
10542: /* This call to update_dffcols is required for non AMG flows too but currently doing for AMG flow only

Line 10539: pa_fp_rollup_tmp. These lines would be the ones with no changes to qty/amnt and rate columns. The lines with changes to

10535: END IF; --}
10536:
10537:
10538: /*Bug 4224464. This API would be called to insert into pa_fp_rollup_tmp all those budget lines which are not already present in
10539: pa_fp_rollup_tmp. These lines would be the ones with no changes to qty/amnt and rate columns. The lines with changes to
10540: qty/amnt and rate columns would not be processed by this API as earlier call to copy_blattributes would have handled these
10541: lines Also using the same signature for this API as used for copy_blattributes above.*/
10542: /* This call to update_dffcols is required for non AMG flows too but currently doing for AMG flow only
10543: *.as the fix is done for AMG rollup. Will ask Ranga to evaluate this for non-AMG flows and remove the if condition.

Line 10866: /*print_msg(' AFTER client extn Values UPDATE pa_fp_rollup_tmp');

10862: End If;
10863: End If;
10864: End If; -- end of version type
10865:
10866: /*print_msg(' AFTER client extn Values UPDATE pa_fp_rollup_tmp');
10867: print_msg(' txn_raw_cost => ' || to_char(l_txn_raw_cost));
10868: print_msg(' txn_burdened_cost => ' || to_char(l_txn_burdened_cost));
10869: print_msg(' txn_revenue => ' || to_char(l_txn_revenue));
10870: */

Line 10891: UPDATE pa_fp_rollup_tmp tmp

10887:
10888: END LOOP;
10889: IF l_cl_budget_line_id_tab.COUNT > 0 then
10890: FORALL i IN l_cl_budget_line_id_tab.FIRST .. l_cl_budget_line_id_tab.LAST
10891: UPDATE pa_fp_rollup_tmp tmp
10892: SET tmp.quantity = l_cl_txn_plan_quantity_tab(i)
10893: ,tmp.txn_raw_cost = l_cl_txn_raw_cost_tab(i)
10894: ,tmp.txn_burdened_cost = l_cl_txn_burdened_cost_tab(i)
10895: ,tmp.txn_revenue = l_cl_txn_revenue_tab(i)

Line 10953: update pa_fp_rollup_tmp

10949: OPEN get_total_amounts_res_asn(l_resource_assignment_tab(j));
10950: FETCH get_total_amounts_res_asn INTO l_txn_burdened_cost_total_bl, l_txn_raw_cost_total_bl;
10951: CLOSE get_total_amounts_res_asn;
10952:
10953: update pa_fp_rollup_tmp
10954: set txn_burdened_cost = (nvl(txn_burdened_cost,0) + nvl(l_txn_burdened_cost_total,0)-nvl(l_txn_burdened_cost_total_bl,0)),
10955: txn_raw_cost = (nvl(txn_raw_cost,0) + nvl(l_txn_raw_cost_total,0)-nvl(l_txn_raw_cost_total_bl,0))
10956: where budget_version_id = p_budget_version_id and resource_assignment_id = l_resource_assignment_tab(j)
10957: and start_date = (select max(start_date) from pa_fp_rollup_tmp where budget_version_id = p_budget_version_id

Line 10957: and start_date = (select max(start_date) from pa_fp_rollup_tmp where budget_version_id = p_budget_version_id

10953: update pa_fp_rollup_tmp
10954: set txn_burdened_cost = (nvl(txn_burdened_cost,0) + nvl(l_txn_burdened_cost_total,0)-nvl(l_txn_burdened_cost_total_bl,0)),
10955: txn_raw_cost = (nvl(txn_raw_cost,0) + nvl(l_txn_raw_cost_total,0)-nvl(l_txn_raw_cost_total_bl,0))
10956: where budget_version_id = p_budget_version_id and resource_assignment_id = l_resource_assignment_tab(j)
10957: and start_date = (select max(start_date) from pa_fp_rollup_tmp where budget_version_id = p_budget_version_id
10958: and resource_assignment_id = l_resource_assignment_tab(j));
10959:
10960: END LOOP;
10961: END IF;

Line 11023: *Now the global temporary table pa_fp_rollup_tmp is completely populated and the

11019: END IF;
11020: END IF;
11021:
11022: /*
11023: *Now the global temporary table pa_fp_rollup_tmp is completely populated and the
11024: *table pa_budget_lines is ready to be updated with the values stored in pa_fp_rollup_tmp
11025: *It will update pa_budget_lines with ALL rows stored in pa_fp_rollup_tmp
11026: */
11027: l_stage := 1100;

Line 11024: *table pa_budget_lines is ready to be updated with the values stored in pa_fp_rollup_tmp

11020: END IF;
11021:
11022: /*
11023: *Now the global temporary table pa_fp_rollup_tmp is completely populated and the
11024: *table pa_budget_lines is ready to be updated with the values stored in pa_fp_rollup_tmp
11025: *It will update pa_budget_lines with ALL rows stored in pa_fp_rollup_tmp
11026: */
11027: l_stage := 1100;
11028: /* Bug fix: 4184159 moved to bulk update pa_fp_calc_plan_pkg.update_budget_lines */

Line 11025: *It will update pa_budget_lines with ALL rows stored in pa_fp_rollup_tmp

11021:
11022: /*
11023: *Now the global temporary table pa_fp_rollup_tmp is completely populated and the
11024: *table pa_budget_lines is ready to be updated with the values stored in pa_fp_rollup_tmp
11025: *It will update pa_budget_lines with ALL rows stored in pa_fp_rollup_tmp
11026: */
11027: l_stage := 1100;
11028: /* Bug fix: 4184159 moved to bulk update pa_fp_calc_plan_pkg.update_budget_lines */
11029: l_pls_start_time := dbms_utility.get_time;

Line 11728: * Note: Before calling this API, pa_fp_rollup_tmp should be populated

11724:
11725:
11726: /* This API calls the main wrapper RATE api and converts the amounts from txn to txn currency if
11727: * cost rate and revenue rate currencies are different
11728: * Note: Before calling this API, pa_fp_rollup_tmp should be populated
11729: */
11730: PROCEDURE Get_Res_RATEs
11731: (p_calling_module IN Varchar2
11732: ,p_activity_code IN Varchar2

Line 11784: SELECT /+LEADING(TMP) INDEX(TMP PA_FP_ROLLUP_TMP_N1)/ ra.resource_assignment_id -- bug 4873834

11780: ,p_txn_currency_code Varchar2
11781: ,p_txn_curr_code_Ovr Varchar2
11782: ,p_line_start_date Date
11783: ,p_line_end_date Date ) IS
11784: SELECT /*+LEADING(TMP) INDEX(TMP PA_FP_ROLLUP_TMP_N1)*/ ra.resource_assignment_id -- bug 4873834
11785: ,tmp.txn_currency_code
11786: ,tmp.quantity
11787: ,tmp.start_date
11788: ,tmp.budget_line_id

Line 11844: ,pa_fp_rollup_tmp tmp

11840: /* Bug fix:4294287 */
11841: ,tmp.bill_markup_percentage
11842: ,NVL(tmp.system_reference6,'Y') markup_calculation_flag
11843: FROM pa_resource_assignments ra
11844: ,pa_fp_rollup_tmp tmp
11845: ,pa_resource_list_members rl
11846: WHERE tmp.resource_assignment_id = p_resource_assignment_id
11847: AND ra.resource_assignment_id = tmp.resource_assignment_id
11848: AND rl.resource_list_member_id = ra.resource_list_member_id

Line 12229: print_msg(to_char(l_stage)||' Rate API req parameters from pa_fp_rollup_tmp');

12225: l_return_status := 'S';
12226: x_msg_data := NULL;
12227:
12228: If P_PA_DEBUG_MODE = 'Y' Then
12229: print_msg(to_char(l_stage)||' Rate API req parameters from pa_fp_rollup_tmp');
12230: print_msg(' l_txn_currency_code := '||l_txn_currency_code);
12231: print_msg(' l_Final_txn_currency_code := '||l_Final_txn_currency_code);
12232: print_msg(' l_txn_plan_quantity := '||l_txn_plan_quantity);
12233: print_msg(' l_budget_lines_start_date := '||z.start_date);

Line 12386: print_msg(to_char(l_stage)||' Rate API req parameters from pa_fp_rollup_tmp after rate_based_flag = N check');

12382:
12383:
12384: l_stage := 610;
12385: /*
12386: print_msg(to_char(l_stage)||' Rate API req parameters from pa_fp_rollup_tmp after rate_based_flag = N check');
12387: print_msg(' l_txn_currency_code := '||l_txn_currency_code);
12388: print_msg(' l_txn_plan_quantity := '||l_txn_plan_quantity);
12389: print_msg(' l_budget_lines_start_date := '||l_budget_lines_start_date);
12390: print_msg(' l_budget_line_id := '||l_budget_line_id);

Line 14298: UPDATE PA_FP_ROLLUP_TMP RL

14294: If NVL(l_return_status,'S') = 'S' Then
14295: **/
14296: IF l_rlt_budget_line_id_tab.COUNT > 0 Then
14297: FORALL i IN l_rlt_budget_line_id_tab.FIRST .. l_rlt_budget_line_id_tab.LAST
14298: UPDATE PA_FP_ROLLUP_TMP RL
14299: SET RL.QUANTITY = l_rlt_quantity_tab(i)
14300: ,RL.BILL_RATE = l_rlt_bill_rate_tab(i)
14301: ,RL.BILL_RATE_OVERRIDE = l_rlt_bill_rate_ovr_tab(i)
14302: ,RL.COST_RATE = l_rlt_cost_rate_tab(i)

Line 15802: INSERT INTO pa_fp_rollup_tmp (

15798:
15799:
15800: g_stage := 'Process_skipped_records : populate_rollup_tmp';
15801:
15802: INSERT INTO pa_fp_rollup_tmp (
15803: budget_version_id
15804: ,resource_assignment_id
15805: ,start_date
15806: ,end_date

Line 15922: ,pa_fp_rollup_tmp rlp --Bug 5203868

15918: ,tmp.billable_flag
15919: FROM pa_budget_lines bl
15920: ,pa_resource_assignments ra
15921: ,pa_fp_spread_calc_tmp tmp
15922: ,pa_fp_rollup_tmp rlp --Bug 5203868
15923: WHERE tmp.budget_version_id = p_budget_version_id
15924: AND tmp.resource_assignment_id = ra.resource_assignment_id
15925: AND bl.resource_assignment_id = tmp.resource_assignment_id
15926: AND bl.txn_currency_code = tmp.txn_currency_code

Line 15945: from pa_fp_rollup_tmp rl1

15941: AND rlp.rowid IS NULL
15942: /* Commenting below code for bug 5203868
15943: AND NOT EXISTS
15944: (select null
15945: from pa_fp_rollup_tmp rl1
15946: Where rl1.resource_assignment_id = tmp.resource_assignment_id
15947: and rl1.txn_currency_code = tmp.txn_currency_code
15948: )
15949: */