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_VIEW_PLANS_UTIL dependencies on PA_FP_VIEW_PLANS_PUB

Line 23: select SUM(DECODE(pa_fp_view_plans_pub.G_FP_CALC_MARGIN_FROM,

19: l_revenue NUMBER := 0;
20: l_margin NUMBER := 0;
21: l_margin_percent NUMBER := 0;
22: begin
23: select SUM(DECODE(pa_fp_view_plans_pub.G_FP_CALC_MARGIN_FROM,
24: 'R', DECODE(amount_subtype,
25: 'RAW_COST', nvl(period_amount1, 0) + nvl(period_amount2, 0) +
26: nvl(period_amount3, 0) + nvl(period_amount4, 0) +
27: nvl(period_amount5, 0) + nvl(period_amount6, 0) +

Line 28: DECODE(pa_fp_view_plans_pub.Get_Prec_Pds_Flag,

24: 'R', DECODE(amount_subtype,
25: 'RAW_COST', nvl(period_amount1, 0) + nvl(period_amount2, 0) +
26: nvl(period_amount3, 0) + nvl(period_amount4, 0) +
27: nvl(period_amount5, 0) + nvl(period_amount6, 0) +
28: DECODE(pa_fp_view_plans_pub.Get_Prec_Pds_Flag,
29: 'Y', nvl(preceding_periods_amount,0),
30: 0) +
31: DECODE(pa_fp_view_plans_pub.Get_Succ_Pds_Flag,
32: 'Y', nvl(succeeding_periods_amount,0),

Line 31: DECODE(pa_fp_view_plans_pub.Get_Succ_Pds_Flag,

27: nvl(period_amount5, 0) + nvl(period_amount6, 0) +
28: DECODE(pa_fp_view_plans_pub.Get_Prec_Pds_Flag,
29: 'Y', nvl(preceding_periods_amount,0),
30: 0) +
31: DECODE(pa_fp_view_plans_pub.Get_Succ_Pds_Flag,
32: 'Y', nvl(succeeding_periods_amount,0),
33: 0),
34: 0),
35: DECODE(amount_subtype,

Line 39: DECODE(pa_fp_view_plans_pub.Get_Prec_Pds_Flag,

35: DECODE(amount_subtype,
36: 'BURDENED_COST', nvl(period_amount1, 0) + nvl(period_amount2, 0) +
37: nvl(period_amount3, 0) + nvl(period_amount4, 0) +
38: nvl(period_amount5, 0) + nvl(period_amount6, 0) +
39: DECODE(pa_fp_view_plans_pub.Get_Prec_Pds_Flag,
40: 'Y', nvl(preceding_periods_amount,0),
41: 0) +
42: DECODE(pa_fp_view_plans_pub.Get_Succ_Pds_Flag,
43: 'Y', nvl(succeeding_periods_amount,0),

Line 42: DECODE(pa_fp_view_plans_pub.Get_Succ_Pds_Flag,

38: nvl(period_amount5, 0) + nvl(period_amount6, 0) +
39: DECODE(pa_fp_view_plans_pub.Get_Prec_Pds_Flag,
40: 'Y', nvl(preceding_periods_amount,0),
41: 0) +
42: DECODE(pa_fp_view_plans_pub.Get_Succ_Pds_Flag,
43: 'Y', nvl(succeeding_periods_amount,0),
44: 0),
45: 0))),
46: SUM(DECODE(amount_subtype,

Line 50: DECODE(pa_fp_view_plans_pub.Get_Prec_Pds_Flag,

46: SUM(DECODE(amount_subtype,
47: 'REVENUE', nvl(period_amount1, 0) + nvl(period_amount2, 0) +
48: nvl(period_amount3, 0) + nvl(period_amount4, 0) +
49: nvl(period_amount5, 0) + nvl(period_amount6, 0) +
50: DECODE(pa_fp_view_plans_pub.Get_Prec_Pds_Flag,
51: 'Y', nvl(preceding_periods_amount,0),
52: 0) +
53: DECODE(pa_fp_view_plans_pub.Get_Succ_Pds_Flag,
54: 'Y', nvl(succeeding_periods_amount,0),

Line 53: DECODE(pa_fp_view_plans_pub.Get_Succ_Pds_Flag,

49: nvl(period_amount5, 0) + nvl(period_amount6, 0) +
50: DECODE(pa_fp_view_plans_pub.Get_Prec_Pds_Flag,
51: 'Y', nvl(preceding_periods_amount,0),
52: 0) +
53: DECODE(pa_fp_view_plans_pub.Get_Succ_Pds_Flag,
54: 'Y', nvl(succeeding_periods_amount,0),
55: 0),
56: 0))
57: into l_burdened_cost,

Line 93: select SUM(DECODE(pa_fp_view_plans_pub.G_FP_CALC_MARGIN_FROM,

89: l_margin_percent NUMBER := 0;
90: begin
91: -- bug fix 2746025: calculate margin from RAW_COST or BURDENED_COST based
92: -- on margin_derived_from_code
93: select SUM(DECODE(pa_fp_view_plans_pub.G_FP_CALC_MARGIN_FROM,
94: 'R', DECODE(amount_subtype,
95: 'RAW_COST', nvl(period_amount1, 0) + nvl(period_amount2, 0) +
96: nvl(period_amount3, 0) + nvl(period_amount4, 0) +
97: nvl(period_amount5, 0) + nvl(period_amount6, 0) +

Line 102: DECODE(pa_fp_view_plans_pub.Get_Prec_Pds_Flag,

98: nvl(period_amount7, 0) + nvl(period_amount8, 0) +
99: nvl(period_amount9, 0) + nvl(period_amount10, 0) +
100: nvl(period_amount11, 0) + nvl(period_amount12, 0) +
101: nvl(period_amount13, 0) +
102: DECODE(pa_fp_view_plans_pub.Get_Prec_Pds_Flag,
103: 'Y', nvl(preceding_periods_amount,0),
104: 0) +
105: DECODE(pa_fp_view_plans_pub.Get_Succ_Pds_Flag,
106: 'Y', nvl(succeeding_periods_amount,0),

Line 105: DECODE(pa_fp_view_plans_pub.Get_Succ_Pds_Flag,

101: nvl(period_amount13, 0) +
102: DECODE(pa_fp_view_plans_pub.Get_Prec_Pds_Flag,
103: 'Y', nvl(preceding_periods_amount,0),
104: 0) +
105: DECODE(pa_fp_view_plans_pub.Get_Succ_Pds_Flag,
106: 'Y', nvl(succeeding_periods_amount,0),
107: 0),
108: 0),
109: DECODE(amount_subtype,

Line 117: DECODE(pa_fp_view_plans_pub.Get_Prec_Pds_Flag,

113: nvl(period_amount7, 0) + nvl(period_amount8, 0) +
114: nvl(period_amount9, 0) + nvl(period_amount10, 0) +
115: nvl(period_amount11, 0) + nvl(period_amount12, 0) +
116: nvl(period_amount13, 0) +
117: DECODE(pa_fp_view_plans_pub.Get_Prec_Pds_Flag,
118: 'Y', nvl(preceding_periods_amount,0),
119: 0) +
120: DECODE(pa_fp_view_plans_pub.Get_Succ_Pds_Flag,
121: 'Y', nvl(succeeding_periods_amount,0),

Line 120: DECODE(pa_fp_view_plans_pub.Get_Succ_Pds_Flag,

116: nvl(period_amount13, 0) +
117: DECODE(pa_fp_view_plans_pub.Get_Prec_Pds_Flag,
118: 'Y', nvl(preceding_periods_amount,0),
119: 0) +
120: DECODE(pa_fp_view_plans_pub.Get_Succ_Pds_Flag,
121: 'Y', nvl(succeeding_periods_amount,0),
122: 0),
123: 0))),
124: SUM(DECODE(amount_subtype,

Line 132: DECODE(pa_fp_view_plans_pub.Get_Prec_Pds_Flag,

128: nvl(period_amount7, 0) + nvl(period_amount8, 0) +
129: nvl(period_amount9, 0) + nvl(period_amount10, 0) +
130: nvl(period_amount11, 0) + nvl(period_amount12, 0) +
131: nvl(period_amount13, 0) +
132: DECODE(pa_fp_view_plans_pub.Get_Prec_Pds_Flag,
133: 'Y', nvl(preceding_periods_amount,0),
134: 0) +
135: DECODE(pa_fp_view_plans_pub.Get_Succ_Pds_Flag,
136: 'Y', nvl(succeeding_periods_amount,0),

Line 135: DECODE(pa_fp_view_plans_pub.Get_Succ_Pds_Flag,

131: nvl(period_amount13, 0) +
132: DECODE(pa_fp_view_plans_pub.Get_Prec_Pds_Flag,
133: 'Y', nvl(preceding_periods_amount,0),
134: 0) +
135: DECODE(pa_fp_view_plans_pub.Get_Succ_Pds_Flag,
136: 'Y', nvl(succeeding_periods_amount,0),
137: 0),
138: 0))
139: into l_burdened_cost,

Line 224: if p_resource_list_member_id = pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id then

220: l_res_parent_member_id pa_resource_list_members.parent_member_id%TYPE;
221: BEGIN
222: l_return_value := -1;
223: -- NEED TO ACCOUNT FOR PROJECT AND TASK LEVEL ROWS THAT ARE USER-ENTERED
224: if p_resource_list_member_id = pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id then
225: if p_task_id = 0 then
226: -- this is a PROJECT row
227: l_return_value := 1;
228: else

Line 335: if p_resource_list_member_id = pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id then

331:
332: BEGIN
333: l_return_value := -1;
334: -- NEED TO ACCOUNT FOR PROJECT AND TASK LEVEL ROWS THAT ARE USER-ENTERED
335: if p_resource_list_member_id = pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id then
336: if p_task_id = 0 then
337: -- this is a PROJECT ROW
338: l_return_value := 'NONE';
339: else

Line 492: if p_resource_list_member_id = pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id then

488:
489: BEGIN
490: l_return_value := 'dummy element name';
491: -- NEED TO ACCOUNT FOR PROJECT AND TASK LEVEL ROWS THAT ARE USER-ENTERED
492: if p_resource_list_member_id = pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id then
493: if p_task_id = 0 then
494: -- retrieve PROJECT NAME
495: select name || ' (' || segment1 || ')'
496: into l_return_value

Line 580: if p_resource_list_member_id = pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id then

576: BEGIN
577: l_return_value := 'dummy element level';
578:
579: -- NEED TO ACCOUNT FOR PROJECT AND TASK LEVEL ROWS THAT ARE USER-ENTERED
580: if p_resource_list_member_id = pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id then
581: if p_task_id = 0 then
582: l_return_value := 'PROJECT';
583: else
584: l_return_value := 'TASK';

Line 796: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',

792: when others then
793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
794: x_msg_count := 1;
795: x_msg_data := SQLERRM;
796: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',
797: p_procedure_name => 'Assign_Default_Amount');
798: pa_debug.reset_err_stack;
799: return;
800: END assign_default_amount;

Line 818: --hr_utility.trace('date= ' || pa_fp_view_plans_pub.Get_Period_Start_Date1());

814: l_return_value NUMBER;
815:
816: begin
817: --hr_utility.trace('entering');
818: --hr_utility.trace('date= ' || pa_fp_view_plans_pub.Get_Period_Start_Date1());
819: -- *** PERFORMANCE ISSUE 2773408: get budget_version_id to use index
820: -- PA_PROJECT_PERIODS_DENORM_N1
821:
822: if p_period_number = 1 then

Line 823: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date1(),

819: -- *** PERFORMANCE ISSUE 2773408: get budget_version_id to use index
820: -- PA_PROJECT_PERIODS_DENORM_N1
821:
822: if p_period_number = 1 then
823: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date1(),
824: pppp.period1_start_Date, nvl(pppd.period_amount1,0),
825: pppp.period2_start_Date, nvl(pppd.period_amount2,0),
826: pppp.period3_start_Date, nvl(pppd.period_amount3,0),
827: pppp.period4_start_Date, nvl(pppd.period_amount4,0),

Line 890: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date2(),

886: (p_amount_type_id <> 215 and pppd.currency_type = p_project_currency_type));
887: --group by pppd.amount_subtype_id;
888:
889: elsif p_period_number = 2 then
890: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date2(),
891: pppp.period1_start_Date, nvl(pppd.period_amount1,0),
892: pppp.period2_start_Date, nvl(pppd.period_amount2,0),
893: pppp.period3_start_Date, nvl(pppd.period_amount3,0),
894: pppp.period4_start_Date, nvl(pppd.period_amount4,0),

Line 957: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date3(),

953: (p_amount_type_id <> 215 and pppd.currency_type = p_project_currency_type));
954: --group by pppd.amount_subtype_id;
955:
956: elsif p_period_number = 3 then
957: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date3(),
958: pppp.period1_start_Date, nvl(pppd.period_amount1,0),
959: pppp.period2_start_Date, nvl(pppd.period_amount2,0),
960: pppp.period3_start_Date, nvl(pppd.period_amount3,0),
961: pppp.period4_start_Date, nvl(pppd.period_amount4,0),

Line 1024: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date4(),

1020: (p_amount_type_id <> 215 and pppd.currency_type = p_project_currency_type));
1021: --group by pppd.amount_subtype_id;
1022:
1023: elsif p_period_number = 4 then
1024: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date4(),
1025: pppp.period1_start_Date, nvl(pppd.period_amount1,0),
1026: pppp.period2_start_Date, nvl(pppd.period_amount2,0),
1027: pppp.period3_start_Date, nvl(pppd.period_amount3,0),
1028: pppp.period4_start_Date, nvl(pppd.period_amount4,0),

Line 1091: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date5(),

1087: (p_amount_type_id <> 215 and pppd.currency_type = p_project_currency_type));
1088: --group by pppd.amount_subtype_id;
1089:
1090: elsif p_period_number = 5 then
1091: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date5(),
1092: pppp.period1_start_Date, nvl(pppd.period_amount1,0),
1093: pppp.period2_start_Date, nvl(pppd.period_amount2,0),
1094: pppp.period3_start_Date, nvl(pppd.period_amount3,0),
1095: pppp.period4_start_Date, nvl(pppd.period_amount4,0),

Line 1158: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date6(),

1154: (p_amount_type_id <> 215 and pppd.currency_type = p_project_currency_type));
1155: --group by pppd.amount_subtype_id;
1156:
1157: elsif p_period_number = 6 then
1158: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date6(),
1159: pppp.period1_start_Date, nvl(pppd.period_amount1,0),
1160: pppp.period2_start_Date, nvl(pppd.period_amount2,0),
1161: pppp.period3_start_Date, nvl(pppd.period_amount3,0),
1162: pppp.period4_start_Date, nvl(pppd.period_amount4,0),

Line 1225: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date7(),

1221: (p_amount_type_id <> 215 and pppd.currency_type = p_project_currency_type));
1222: --group by pppd.amount_subtype_id;
1223:
1224: elsif p_period_number = 7 then
1225: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date7(),
1226: pppp.period1_start_Date, nvl(pppd.period_amount1,0),
1227: pppp.period2_start_Date, nvl(pppd.period_amount2,0),
1228: pppp.period3_start_Date, nvl(pppd.period_amount3,0),
1229: pppp.period4_start_Date, nvl(pppd.period_amount4,0),

Line 1292: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date8(),

1288: (p_amount_type_id <> 215 and pppd.currency_type = p_project_currency_type));
1289: --group by pppd.amount_subtype_id;
1290:
1291: elsif p_period_number = 8 then
1292: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date8(),
1293: pppp.period1_start_Date, nvl(pppd.period_amount1,0),
1294: pppp.period2_start_Date, nvl(pppd.period_amount2,0),
1295: pppp.period3_start_Date, nvl(pppd.period_amount3,0),
1296: pppp.period4_start_Date, nvl(pppd.period_amount4,0),

Line 1359: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date9(),

1355: (p_amount_type_id <> 215 and pppd.currency_type = p_project_currency_type));
1356: --group by pppd.amount_subtype_id;
1357:
1358: elsif p_period_number = 9 then
1359: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date9(),
1360: pppp.period1_start_Date, nvl(pppd.period_amount1,0),
1361: pppp.period2_start_Date, nvl(pppd.period_amount2,0),
1362: pppp.period3_start_Date, nvl(pppd.period_amount3,0),
1363: pppp.period4_start_Date, nvl(pppd.period_amount4,0),

Line 1426: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date10(),

1422: (p_amount_type_id <> 215 and pppd.currency_type = p_project_currency_type));
1423: --group by pppd.amount_subtype_id;
1424:
1425: elsif p_period_number = 10 then
1426: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date10(),
1427: pppp.period1_start_Date, nvl(pppd.period_amount1,0),
1428: pppp.period2_start_Date, nvl(pppd.period_amount2,0),
1429: pppp.period3_start_Date, nvl(pppd.period_amount3,0),
1430: pppp.period4_start_Date, nvl(pppd.period_amount4,0),

Line 1493: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date11(),

1489: (p_amount_type_id <> 215 and pppd.currency_type = p_project_currency_type));
1490: --group by pppd.amount_subtype_id;
1491:
1492: elsif p_period_number = 11 then
1493: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date11(),
1494: pppp.period1_start_Date, nvl(pppd.period_amount1,0),
1495: pppp.period2_start_Date, nvl(pppd.period_amount2,0),
1496: pppp.period3_start_Date, nvl(pppd.period_amount3,0),
1497: pppp.period4_start_Date, nvl(pppd.period_amount4,0),

Line 1560: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date12(),

1556: (p_amount_type_id <> 215 and pppd.currency_type = p_project_currency_type));
1557: --group by pppd.amount_subtype_id;
1558:
1559: elsif p_period_number = 12 then
1560: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date12(),
1561: pppp.period1_start_Date, nvl(pppd.period_amount1,0),
1562: pppp.period2_start_Date, nvl(pppd.period_amount2,0),
1563: pppp.period3_start_Date, nvl(pppd.period_amount3,0),
1564: pppp.period4_start_Date, nvl(pppd.period_amount4,0),

Line 1627: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date13(),

1623: (p_amount_type_id <> 215 and pppd.currency_type = p_project_currency_type));
1624: --group by pppd.amount_subtype_id;
1625:
1626: elsif p_period_number = 13 then
1627: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date13(),
1628: pppp.period1_start_Date, nvl(pppd.period_amount1,0),
1629: pppp.period2_start_Date, nvl(pppd.period_amount2,0),
1630: pppp.period3_start_Date, nvl(pppd.period_amount3,0),
1631: pppp.period4_start_Date, nvl(pppd.period_amount4,0),

Line 1756: --hr_utility.trace('pa_fp_view_plans_pub.Get_Period_Start_Date1()= ' ||

1752: -- we use SUM(DECODE) because for COST or REVENUE amount type, there's
1753: -- one AMOUNT_SUBTYPE_ID which will require us to subtract instead of add
1754: -- COST: TP_COST_OUT (185)
1755: -- REVENUE: TP_REVENUE_OUT (120)
1756: --hr_utility.trace('pa_fp_view_plans_pub.Get_Period_Start_Date1()= ' ||
1757: to_char(pa_fp_view_plans_pub.Get_Period_Start_Date1()));
1758: if p_period_number = 1 then
1759: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date1(),
1760: pppp.period1_start_Date, DECODE(pppd.amount_subtype_id,

Line 1757: to_char(pa_fp_view_plans_pub.Get_Period_Start_Date1()));

1753: -- one AMOUNT_SUBTYPE_ID which will require us to subtract instead of add
1754: -- COST: TP_COST_OUT (185)
1755: -- REVENUE: TP_REVENUE_OUT (120)
1756: --hr_utility.trace('pa_fp_view_plans_pub.Get_Period_Start_Date1()= ' ||
1757: to_char(pa_fp_view_plans_pub.Get_Period_Start_Date1()));
1758: if p_period_number = 1 then
1759: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date1(),
1760: pppp.period1_start_Date, DECODE(pppd.amount_subtype_id,
1761: 185, -pppd.period_amount1,

Line 1759: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date1(),

1755: -- REVENUE: TP_REVENUE_OUT (120)
1756: --hr_utility.trace('pa_fp_view_plans_pub.Get_Period_Start_Date1()= ' ||
1757: to_char(pa_fp_view_plans_pub.Get_Period_Start_Date1()));
1758: if p_period_number = 1 then
1759: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date1(),
1760: pppp.period1_start_Date, DECODE(pppd.amount_subtype_id,
1761: 185, -pppd.period_amount1,
1762: 120, -pppd.period_amount1,
1763: pppd.period_amount1),

Line 1979: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date2(),

1975: pppd.currency_type = p_project_currency_type
1976: group by pppd.amount_type_id;
1977:
1978: elsif p_period_number = 2 then
1979: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date2(),
1980: pppp.period1_start_Date, DECODE(pppd.amount_subtype_id,
1981: 185, -pppd.period_amount1,
1982: 120, -pppd.period_amount1,
1983: pppd.period_amount1),

Line 2199: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date3(),

2195: pppd.currency_type = p_project_currency_type
2196: group by pppd.amount_type_id;
2197:
2198: elsif p_period_number = 3 then
2199: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date3(),
2200: pppp.period1_start_Date, DECODE(pppd.amount_subtype_id,
2201: 185, -pppd.period_amount1,
2202: 120, -pppd.period_amount1,
2203: pppd.period_amount1),

Line 2419: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date4(),

2415: pppd.currency_type = p_project_currency_type
2416: group by pppd.amount_type_id;
2417:
2418: elsif p_period_number = 4 then
2419: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date4(),
2420: pppp.period1_start_Date, DECODE(pppd.amount_subtype_id,
2421: 185, -pppd.period_amount1,
2422: 120, -pppd.period_amount1,
2423: pppd.period_amount1),

Line 2639: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date5(),

2635: pppd.currency_type = p_project_currency_type
2636: group by pppd.amount_type_id;
2637:
2638: elsif p_period_number = 5 then
2639: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date5(),
2640: pppp.period1_start_Date, DECODE(pppd.amount_subtype_id,
2641: 185, -pppd.period_amount1,
2642: 120, -pppd.period_amount1,
2643: pppd.period_amount1),

Line 2859: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date6(),

2855: pppd.currency_type = p_project_currency_type
2856: group by pppd.amount_type_id;
2857:
2858: elsif p_period_number = 6 then
2859: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date6(),
2860: pppp.period1_start_Date, DECODE(pppd.amount_subtype_id,
2861: 185, -pppd.period_amount1,
2862: 120, -pppd.period_amount1,
2863: pppd.period_amount1),

Line 3079: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date7(),

3075: pppd.currency_type = p_project_currency_type
3076: group by pppd.amount_type_id;
3077:
3078: elsif p_period_number = 7 then
3079: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date7(),
3080: pppp.period1_start_Date, DECODE(pppd.amount_subtype_id,
3081: 185, -pppd.period_amount1,
3082: 120, -pppd.period_amount1,
3083: pppd.period_amount1),

Line 3299: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date8(),

3295: pppd.currency_type = p_project_currency_type
3296: group by pppd.amount_type_id;
3297:
3298: elsif p_period_number = 8 then
3299: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date8(),
3300: pppp.period1_start_Date, DECODE(pppd.amount_subtype_id,
3301: 185, -pppd.period_amount1,
3302: 120, -pppd.period_amount1,
3303: pppd.period_amount1),

Line 3519: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date9(),

3515: pppd.currency_type = p_project_currency_type
3516: group by pppd.amount_type_id;
3517:
3518: elsif p_period_number = 9 then
3519: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date9(),
3520: pppp.period1_start_Date, DECODE(pppd.amount_subtype_id,
3521: 185, -pppd.period_amount1,
3522: 120, -pppd.period_amount1,
3523: pppd.period_amount1),

Line 3739: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date10(),

3735: pppd.currency_type = p_project_currency_type
3736: group by pppd.amount_type_id;
3737:
3738: elsif p_period_number = 10 then
3739: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date10(),
3740: pppp.period1_start_Date, DECODE(pppd.amount_subtype_id,
3741: 185, -pppd.period_amount1,
3742: 120, -pppd.period_amount1,
3743: pppd.period_amount1),

Line 3959: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date11(),

3955: pppd.currency_type = p_project_currency_type
3956: group by pppd.amount_type_id;
3957:
3958: elsif p_period_number = 11 then
3959: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date11(),
3960: pppp.period1_start_Date, DECODE(pppd.amount_subtype_id,
3961: 185, -pppd.period_amount1,
3962: 120, -pppd.period_amount1,
3963: pppd.period_amount1),

Line 4179: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date12(),

4175: pppd.currency_type = p_project_currency_type
4176: group by pppd.amount_type_id;
4177:
4178: elsif p_period_number = 12 then
4179: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date12(),
4180: pppp.period1_start_Date, DECODE(pppd.amount_subtype_id,
4181: 185, -pppd.period_amount1,
4182: 120, -pppd.period_amount1,
4183: pppd.period_amount1),

Line 4399: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date13(),

4395: pppd.currency_type = p_project_currency_type
4396: group by pppd.amount_type_id;
4397:
4398: elsif p_period_number = 13 then
4399: select SUM(DECODE(pa_fp_view_plans_pub.Get_Period_Start_Date13(),
4400: pppp.period1_start_Date, DECODE(pppd.amount_subtype_id,
4401: 185, -pppd.period_amount1,
4402: 120, -pppd.period_amount1,
4403: pppd.period_amount1),