[Home] [Help]
1: package body GMS_BUDGET_PUB as
2: /* $Header: gmsmbupb.pls 120.10.12010000.2 2008/08/25 09:22:44 mumohan ship $ */
3:
4: /* package global to be used during updates */
5:
13:
14: function G_PA_MISS_NUM return number
15: is
16: begin
17: return GMS_BUDGET_PUB.G_MISS_NUM;
18: end;
19:
20: function G_PA_MISS_CHAR return varchar2
21: is
19:
20: function G_PA_MISS_CHAR return varchar2
21: is
22: begin
23: return GMS_BUDGET_PUB.G_MISS_CHAR;
24: end;
25:
26: function G_PA_MISS_DATE return date
27: is
25:
26: function G_PA_MISS_DATE return date
27: is
28: begin
29: return GMS_BUDGET_PUB.G_MISS_DATE;
30: end;
31:
32: function G_GMS_FALSE return varchar2
33: is
31:
32: function G_GMS_FALSE return varchar2
33: is
34: begin
35: return GMS_BUDGET_PUB.G_FALSE;
36: end;
37:
38: function G_GMS_TRUE return varchar2
39: is
37:
38: function G_GMS_TRUE return varchar2
39: is
40: begin
41: return GMS_BUDGET_PUB.G_TRUE;
42: end;
43:
44: -----------------------------------------------------------------------------------
45:
43:
44: -----------------------------------------------------------------------------------
45:
46: PROCEDURE convert_projnum_to_id
47: (p_project_number_in IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
48: ,p_project_id_in IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
49: ,p_project_id_out OUT NOCOPY NUMBER
50: ,x_err_code IN OUT NOCOPY NUMBER
51: ,x_err_stage IN OUT NOCOPY VARCHAR2
44: -----------------------------------------------------------------------------------
45:
46: PROCEDURE convert_projnum_to_id
47: (p_project_number_in IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
48: ,p_project_id_in IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
49: ,p_project_id_out OUT NOCOPY NUMBER
50: ,x_err_code IN OUT NOCOPY NUMBER
51: ,x_err_stage IN OUT NOCOPY VARCHAR2
52: ,x_err_stack IN OUT NOCOPY VARCHAR2)
73: x_err_code := 0;
74: l_old_stack := x_err_stack;
75: x_err_stack := x_err_stack ||'-> convert_projnum_to_id';
76:
77: IF p_project_id_in <> GMS_BUDGET_PUB.G_PA_MISS_NUM
78: AND p_project_id_in IS NOT NULL
79: THEN
80:
81: --check validity of this ID
94:
95: CLOSE l_project_id_csr;
96: p_project_id_out := p_project_id_in;
97:
98: ELSIF p_project_number_in <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
99: AND p_project_number_in IS NOT NULL
100: THEN
101: OPEN l_project_number_csr(p_project_number_in);
102: FETCH l_project_number_csr INTO p_project_id_out;
139: END convert_projnum_to_id;
140: -------------------------------------------------------------------------
141: PROCEDURE convert_tasknum_to_id
142: (p_project_id_in IN NUMBER
143: ,p_task_id_in IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
144: ,p_task_number_in IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
145: ,p_task_id_out OUT NOCOPY NUMBER
146: ,x_err_code IN OUT NOCOPY NUMBER
147: ,x_err_stage IN OUT NOCOPY VARCHAR2
140: -------------------------------------------------------------------------
141: PROCEDURE convert_tasknum_to_id
142: (p_project_id_in IN NUMBER
143: ,p_task_id_in IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
144: ,p_task_number_in IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
145: ,p_task_id_out OUT NOCOPY NUMBER
146: ,x_err_code IN OUT NOCOPY NUMBER
147: ,x_err_stage IN OUT NOCOPY VARCHAR2
148: ,x_err_stack IN OUT NOCOPY VARCHAR2)
173: x_err_code := 0;
174: l_old_stack := x_err_stack;
175: x_err_stack := x_err_stack ||'-> convert_tasknum_to_id';
176:
177: IF p_task_id_in <> GMS_BUDGET_PUB.G_PA_MISS_NUM
178: AND p_task_id_in IS NOT NULL
179: THEN
180:
181: --check validity of this ID
194:
195: CLOSE l_task_id_csr;
196: p_task_id_out := p_task_id_in;
197:
198: ELSIF p_task_number_in <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
199: AND p_task_number_in IS NOT NULL
200: THEN
201: OPEN l_task_number_csr(p_project_id_in, p_task_number_in);
202: FETCH l_task_number_csr INTO p_task_id_out;
241:
242: -------------------------------------------------------------------------
243:
244: PROCEDURE convert_awardnum_to_id
245: (p_award_number_in IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
246: ,p_award_id_in IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
247: ,p_award_id_out OUT NOCOPY NUMBER
248: ,x_err_code IN OUT NOCOPY NUMBER
249: ,x_err_stage IN OUT NOCOPY VARCHAR2
242: -------------------------------------------------------------------------
243:
244: PROCEDURE convert_awardnum_to_id
245: (p_award_number_in IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
246: ,p_award_id_in IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
247: ,p_award_id_out OUT NOCOPY NUMBER
248: ,x_err_code IN OUT NOCOPY NUMBER
249: ,x_err_stage IN OUT NOCOPY VARCHAR2
250: ,x_err_stack IN OUT NOCOPY VARCHAR2)
271: x_err_code := 0;
272: l_old_stack := x_err_stack;
273: x_err_stack := x_err_stack ||'-> convert_awardnum_to_id';
274:
275: IF p_award_id_in <> GMS_BUDGET_PUB.G_PA_MISS_NUM
276: AND p_award_id_in IS NOT NULL
277: THEN
278:
279: --check validity of this ID
292:
293: CLOSE l_award_id_csr;
294: p_award_id_out := p_award_id_in;
295:
296: ELSIF p_award_number_in <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
297: AND p_award_number_in IS NOT NULL
298: THEN
299: OPEN l_award_number_csr(p_award_number_in);
300: FETCH l_award_number_csr INTO p_award_id_out;
336:
337: END convert_awardnum_to_id;
338: ----------------------------------------------------------------------
339: PROCEDURE convert_reslistname_to_id
340: (p_resource_list_name_in IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
341: ,p_resource_list_id_in IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
342: ,p_resource_list_id_out OUT NOCOPY NUMBER
343: ,x_err_code IN OUT NOCOPY NUMBER
344: ,x_err_stage IN OUT NOCOPY VARCHAR2
337: END convert_awardnum_to_id;
338: ----------------------------------------------------------------------
339: PROCEDURE convert_reslistname_to_id
340: (p_resource_list_name_in IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
341: ,p_resource_list_id_in IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
342: ,p_resource_list_id_out OUT NOCOPY NUMBER
343: ,x_err_code IN OUT NOCOPY NUMBER
344: ,x_err_stage IN OUT NOCOPY VARCHAR2
345: ,x_err_stack IN OUT NOCOPY VARCHAR2)
367: x_err_code := 0;
368: l_old_stack := x_err_stack;
369: x_err_stack := x_err_stack ||'-> convert_reslistname_to_id';
370:
371: IF p_resource_list_id_in <> GMS_BUDGET_PUB.G_PA_MISS_NUM
372: AND p_resource_list_id_in IS NOT NULL
373: THEN
374:
375: --check validity of this ID
388:
389: CLOSE l_resource_list_id_csr;
390: p_resource_list_id_out := p_resource_list_id_in;
391:
392: ELSIF p_resource_list_name_in <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
393: AND p_resource_list_name_in IS NOT NULL
394: THEN
395: OPEN l_resource_list_name_csr(p_resource_list_name_in);
396: FETCH l_resource_list_name_csr INTO p_resource_list_id_out;
434: -------------------------------------------------------------------------------
435:
436: PROCEDURE convert_listmem_alias_to_id
437: (p_resource_list_id_in IN NUMBER
438: ,p_reslist_member_alias_in IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
439: ,p_resource_list_member_id_in IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
440: ,p_resource_list_member_id_out OUT NOCOPY NUMBER
441: ,x_err_code IN OUT NOCOPY NUMBER
442: ,x_err_stage IN OUT NOCOPY VARCHAR2
435:
436: PROCEDURE convert_listmem_alias_to_id
437: (p_resource_list_id_in IN NUMBER
438: ,p_reslist_member_alias_in IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
439: ,p_resource_list_member_id_in IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
440: ,p_resource_list_member_id_out OUT NOCOPY NUMBER
441: ,x_err_code IN OUT NOCOPY NUMBER
442: ,x_err_stage IN OUT NOCOPY VARCHAR2
443: ,x_err_stack IN OUT NOCOPY VARCHAR2)
467: x_err_code := 0;
468: l_old_stack := x_err_stack;
469: x_err_stack := x_err_stack ||'-> convert_listmem_alias_to_id';
470:
471: IF p_resource_list_member_id_in <> GMS_BUDGET_PUB.G_PA_MISS_NUM
472: AND p_resource_list_member_id_in IS NOT NULL
473: THEN
474:
475: --check validity of this ID
488:
489: CLOSE l_resource_list_member_id_csr;
490: p_resource_list_member_id_out := p_resource_list_member_id_in;
491:
492: ELSIF p_reslist_member_alias_in <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
493: AND p_reslist_member_alias_in IS NOT NULL
494: THEN
495: OPEN l_reslist_member_alias_csr(p_resource_list_id_in, p_reslist_member_alias_in);
496: FETCH l_reslist_member_alias_csr INTO p_resource_list_member_id_out;
796: l_old_stack varchar2(630);
797: begin
798:
799: IF L_DEBUG = 'Y' THEN
800: gms_error_pkg.gms_debug('*** Start of GMS_BUDGET_PUB.SUMMERIZE_PROJECT_TOTALS ***','C');
801: END IF;
802:
803: x_err_code := 0;
804: l_old_stack := x_err_stack;
839:
840: x_err_stack := l_old_stack;
841:
842: IF L_DEBUG = 'Y' THEN
843: gms_error_pkg.gms_debug('*** End of GMS_BUDGET_PUB.SUMMERIZE_PROJECT_TOTALS ***','C');
844: END IF;
845:
846: exception
847: when others then
846: exception
847: when others then
848: -- Modified for bug 2587078
849: --x_err_code := SQLCODE;
850: x_err_stage := 'GMS_BUDGET_PUB.SUMMERIZE_PROJECT_TOTALS - In when others exception';
851: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_SUMM_BUDG_LINES_FAIL',
852: x_err_code => x_err_code,
853: x_err_buff => x_err_stage);
854: fnd_msg_pub.add;
1505: ----------------------------------------------------------------------------
1506: -- Everytime the Budget Entry Method or Resource List is changed they should be
1507: -- validated against each other.
1508:
1509: if p_budget_entry_method_code = GMS_BUDGET_PUB.G_MISS_CHAR then
1510:
1511: open entry_method_csr(p_project_id => p_project_id,
1512: p_award_id => p_award_id);
1513:
1517: l_budget_entry_method_code := p_budget_entry_method_code;
1518:
1519: end if;
1520:
1521: if p_resource_list_id = GMS_BUDGET_PUB.G_MISS_NUM then
1522:
1523: open resource_list_csr (p_project_id => p_project_id,
1524: p_award_id => p_award_id);
1525:
1568: ( p_api_version_number IN NUMBER
1569: ,x_err_code IN OUT NOCOPY NUMBER
1570: ,x_err_stage IN OUT NOCOPY VARCHAR2
1571: ,x_err_stack IN OUT NOCOPY VARCHAR2
1572: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
1573: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
1574: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1575: ,p_pm_budget_reference IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1576: , p_budget_version_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1569: ,x_err_code IN OUT NOCOPY NUMBER
1570: ,x_err_stage IN OUT NOCOPY VARCHAR2
1571: ,x_err_stack IN OUT NOCOPY VARCHAR2
1572: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
1573: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
1574: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1575: ,p_pm_budget_reference IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1576: , p_budget_version_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1577: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1570: ,x_err_stage IN OUT NOCOPY VARCHAR2
1571: ,x_err_stack IN OUT NOCOPY VARCHAR2
1572: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
1573: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
1574: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1575: ,p_pm_budget_reference IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1576: , p_budget_version_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1577: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1578: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1571: ,x_err_stack IN OUT NOCOPY VARCHAR2
1572: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
1573: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
1574: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1575: ,p_pm_budget_reference IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1576: , p_budget_version_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1577: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1578: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1579: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1572: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
1573: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
1574: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1575: ,p_pm_budget_reference IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1576: , p_budget_version_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1577: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1578: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1579: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1580: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1573: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
1574: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1575: ,p_pm_budget_reference IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1576: , p_budget_version_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1577: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1578: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1579: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1580: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1581: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1574: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1575: ,p_pm_budget_reference IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1576: , p_budget_version_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1577: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1578: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1579: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1580: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1581: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1582: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1575: ,p_pm_budget_reference IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1576: , p_budget_version_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1577: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1578: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1579: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1580: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1581: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1582: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1583: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1576: , p_budget_version_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1577: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1578: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1579: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1580: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1581: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1582: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1583: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1584: ,p_entry_method_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1577: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1578: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1579: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1580: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1581: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1582: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1583: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1584: ,p_entry_method_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1585: ,p_resource_list_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1578: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1579: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1580: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1581: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1582: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1583: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1584: ,p_entry_method_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1585: ,p_resource_list_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1586: ,p_resource_list_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1579: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1580: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1581: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1582: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1583: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1584: ,p_entry_method_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1585: ,p_resource_list_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1586: ,p_resource_list_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1587: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1580: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1581: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1582: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1583: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1584: ,p_entry_method_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1585: ,p_resource_list_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1586: ,p_resource_list_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1587: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1588: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1581: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1582: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1583: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1584: ,p_entry_method_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1585: ,p_resource_list_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1586: ,p_resource_list_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1587: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1588: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1589: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1582: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1583: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1584: ,p_entry_method_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1585: ,p_resource_list_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1586: ,p_resource_list_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1587: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1588: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1589: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1590: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1583: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1584: ,p_entry_method_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1585: ,p_resource_list_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1586: ,p_resource_list_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1587: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1588: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1589: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1590: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1591: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1584: ,p_entry_method_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1585: ,p_resource_list_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1586: ,p_resource_list_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1587: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1588: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1589: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1590: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1591: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1592: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1585: ,p_resource_list_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1586: ,p_resource_list_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1587: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1588: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1589: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1590: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1591: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1592: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1593: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1586: ,p_resource_list_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
1587: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1588: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1589: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1590: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1591: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1592: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1593: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1594: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1587: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1588: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1589: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1590: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1591: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1592: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1593: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1594: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1595: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1588: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1589: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1590: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1591: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1592: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1593: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1594: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1595: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1596: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1589: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1590: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1591: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1592: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1593: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1594: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1595: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1596: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1597: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1590: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1591: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1592: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1593: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1594: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1595: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1596: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1597: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1598: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1591: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1592: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1593: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1594: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1595: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1596: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1597: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1598: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1599: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1592: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1593: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1594: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1595: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1596: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1597: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1598: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1599: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1600: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1593: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1594: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1595: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1596: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1597: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1598: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1599: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1600: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1601: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1594: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1595: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1596: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1597: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1598: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1599: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1600: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1601: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1602: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1595: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1596: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1597: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1598: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1599: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1600: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1601: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1602: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1603: ,p_first_budget_period IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR -- Bug 3104308
1596: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1597: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1598: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1599: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1600: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1601: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1602: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1603: ,p_first_budget_period IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR -- Bug 3104308
1604: )
1597: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1598: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1599: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1600: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1601: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1602: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1603: ,p_first_budget_period IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR -- Bug 3104308
1604: )
1605: IS
1598: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1599: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1600: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1601: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1602: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1603: ,p_first_budget_period IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR -- Bug 3104308
1604: )
1605: IS
1606:
1599: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1600: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1601: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1602: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
1603: ,p_first_budget_period IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR -- Bug 3104308
1604: )
1605: IS
1606:
1607: CURSOR l_budget_entry_method_csr
1752:
1753:
1754: -- product_code is mandatory
1755:
1756: IF p_pm_product_code = GMS_BUDGET_PUB.G_PA_MISS_CHAR
1757: OR p_pm_product_code IS NULL
1758: THEN
1759: gms_error_pkg.gms_message(x_err_name => 'GMS_PRODUCT_CODE_IS_MISSING',
1760: x_err_code => x_err_code,
1768: -- If award_id is passed in then use it otherwise use the award_number
1769: -- that is passed in to fetch value of award_id from gms_awards table
1770: -- If both are missing then raise an error.
1771:
1772: IF (p_award_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
1773: AND p_award_number IS NOT NULL)
1774: OR (p_award_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
1775: AND p_award_id IS NOT NULL)
1776: THEN
1770: -- If both are missing then raise an error.
1771:
1772: IF (p_award_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
1773: AND p_award_number IS NOT NULL)
1774: OR (p_award_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
1775: AND p_award_id IS NOT NULL)
1776: THEN
1777:
1778: convert_awardnum_to_id(p_award_number_in => p_award_number
1822: -- If project_id is passed in then use it otherwise use the project_number
1823: -- (segment1) that is passed in to fetch value of project_id from pa_projects
1824: -- table. If both are missing then raise an error.
1825:
1826: IF (p_project_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
1827: AND p_project_number IS NOT NULL)
1828: OR (p_project_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
1829: AND p_project_id IS NOT NULL)
1830: THEN
1824: -- table. If both are missing then raise an error.
1825:
1826: IF (p_project_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
1827: AND p_project_number IS NOT NULL)
1828: OR (p_project_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
1829: AND p_project_id IS NOT NULL)
1830: THEN
1831: convert_projnum_to_id(p_project_number_in => p_project_number
1832: ,p_project_id_in => p_project_id
1887:
1888: -- budget type code is mandatory
1889:
1890: IF p_budget_type_code IS NULL
1891: OR p_budget_type_code = GMS_BUDGET_PUB.G_PA_MISS_CHAR
1892: THEN
1893:
1894: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_MISSING',
1895: x_err_code => x_err_code,
1919:
1920: -- entry method code is mandatory
1921:
1922: IF p_entry_method_code IS NULL
1923: OR p_entry_method_code = GMS_BUDGET_PUB.G_PA_MISS_CHAR
1924: THEN
1925: gms_error_pkg.gms_message(x_err_name => 'GMS_ENTRY_METHOD_IS_MISSING',
1926: x_err_code => x_err_code,
1927: x_err_buff => x_err_stage);
1975: -- If resource_list_id is passed in then use it otherwise use the resource_list
1976: -- name (NAME) that is passed in to fetch value of resource_list_id from
1977: -- pa_resource_lists table. If both are missing then raise an error.
1978:
1979: IF (p_resource_list_name <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
1980: AND p_resource_list_name IS NOT NULL)
1981: OR (p_resource_list_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
1982: AND p_resource_list_id IS NOT NULL)
1983: THEN
1977: -- pa_resource_lists table. If both are missing then raise an error.
1978:
1979: IF (p_resource_list_name <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
1980: AND p_resource_list_name IS NOT NULL)
1981: OR (p_resource_list_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
1982: AND p_resource_list_id IS NOT NULL)
1983: THEN
1984: convert_reslistname_to_id(p_resource_list_name_in => p_resource_list_name
1985: ,p_resource_list_id_in => p_resource_list_id
2005: APP_EXCEPTION.RAISE_EXCEPTION;
2006: END IF;
2007: ------------------------------------------------------------------------------
2008: /*
2009: IF (p_resource_list_name <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
2010: AND p_resource_list_name IS NOT NULL)
2011: OR (p_resource_list_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
2012: AND p_resource_list_id IS NOT NULL) THEN
2013:
2007: ------------------------------------------------------------------------------
2008: /*
2009: IF (p_resource_list_name <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
2010: AND p_resource_list_name IS NOT NULL)
2011: OR (p_resource_list_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
2012: AND p_resource_list_id IS NOT NULL) THEN
2013:
2014: -- convert resource_list_name to resource_list_id
2015:
2039:
2040: -- check validity of the budget change reason code, passing NULL is OK
2041:
2042: IF (p_change_reason_code IS NOT NULL AND
2043: p_change_reason_code <> GMS_BUDGET_PUB.G_PA_MISS_CHAR) THEN
2044: OPEN l_budget_change_reason_csr( p_change_reason_code );
2045: FETCH l_budget_change_reason_csr INTO l_dummy;
2046:
2047: IF l_budget_change_reason_csr%NOTFOUND THEN
2060: END IF;
2061:
2062: --When description is not passed, set value to NULL
2063:
2064: IF p_description = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2065: THEN
2066: l_description := NULL;
2067: ELSE
2068: l_description := p_description;
2070:
2071: -- dbms_output.put_line('Before setting flex fields to NULL, when not passed');
2072:
2073: --When descriptive flex fields are not passed set them to NULL
2074: IF p_attribute_category = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2075: THEN
2076: l_attribute_category := NULL;
2077: ELSE
2078: l_attribute_category := p_attribute_category;
2076: l_attribute_category := NULL;
2077: ELSE
2078: l_attribute_category := p_attribute_category;
2079: END IF;
2080: IF p_attribute1 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2081: THEN
2082: l_attribute1 := NULL;
2083: ELSE
2084: l_attribute1 := p_attribute1;
2082: l_attribute1 := NULL;
2083: ELSE
2084: l_attribute1 := p_attribute1;
2085: END IF;
2086: IF p_attribute2 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2087: THEN
2088: l_attribute2 := NULL;
2089: ELSE
2090: l_attribute2 := p_attribute2;
2088: l_attribute2 := NULL;
2089: ELSE
2090: l_attribute2 := p_attribute2;
2091: END IF;
2092: IF p_attribute3 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2093: THEN
2094: l_attribute3 := NULL;
2095: ELSE
2096: l_attribute3 := p_attribute3;
2094: l_attribute3 := NULL;
2095: ELSE
2096: l_attribute3 := p_attribute3;
2097: END IF;
2098: IF p_attribute4 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2099: THEN
2100: l_attribute4 := NULL;
2101: ELSE
2102: l_attribute4 := p_attribute4;
2101: ELSE
2102: l_attribute4 := p_attribute4;
2103: END IF;
2104:
2105: IF p_attribute5 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2106: THEN
2107: l_attribute5 := NULL;
2108: ELSE
2109: l_attribute5 := p_attribute5;
2108: ELSE
2109: l_attribute5 := p_attribute5;
2110: END IF;
2111:
2112: IF p_attribute6 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2113: THEN
2114: l_attribute6 := NULL;
2115: ELSE
2116: l_attribute6 := p_attribute6;
2115: ELSE
2116: l_attribute6 := p_attribute6;
2117: END IF;
2118:
2119: IF p_attribute7 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2120: THEN
2121: l_attribute7 := NULL;
2122: ELSE
2123: l_attribute7 := p_attribute7;
2122: ELSE
2123: l_attribute7 := p_attribute7;
2124: END IF;
2125:
2126: IF p_attribute8 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2127: THEN
2128: l_attribute8 := NULL;
2129: ELSE
2130: l_attribute8 := p_attribute8;
2128: l_attribute8 := NULL;
2129: ELSE
2130: l_attribute8 := p_attribute8;
2131: END IF;
2132: IF p_attribute9 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2133: THEN
2134: l_attribute9 := NULL;
2135: ELSE
2136: l_attribute9 := p_attribute9;
2134: l_attribute9 := NULL;
2135: ELSE
2136: l_attribute9 := p_attribute9;
2137: END IF;
2138: IF p_attribute10 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2139: THEN
2140: l_attribute10 := NULL;
2141: ELSE
2142: l_attribute10 := p_attribute10;
2140: l_attribute10 := NULL;
2141: ELSE
2142: l_attribute10 := p_attribute10;
2143: END IF;
2144: IF p_attribute11 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2145: THEN
2146: l_attribute11 := NULL;
2147: ELSE
2148: l_attribute11 := p_attribute11;
2146: l_attribute11 := NULL;
2147: ELSE
2148: l_attribute11 := p_attribute11;
2149: END IF;
2150: IF p_attribute12 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2151: THEN
2152: l_attribute12 := NULL;
2153: ELSE
2154: l_attribute12 := p_attribute12;
2152: l_attribute12 := NULL;
2153: ELSE
2154: l_attribute12 := p_attribute12;
2155: END IF;
2156: IF p_attribute13 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2157: THEN
2158: l_attribute13 := NULL;
2159: ELSE
2160: l_attribute13 := p_attribute13;
2158: l_attribute13 := NULL;
2159: ELSE
2160: l_attribute13 := p_attribute13;
2161: END IF;
2162: IF p_attribute14 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2163: THEN
2164: l_attribute14:= NULL;
2165: ELSE
2166: l_attribute14:= p_attribute14;
2165: ELSE
2166: l_attribute14:= p_attribute14;
2167: END IF;
2168:
2169: IF p_attribute15 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2170: THEN
2171: l_attribute15 := NULL;
2172: ELSE
2173: l_attribute15 := p_attribute15;
2191:
2192: APP_EXCEPTION.RAISE_EXCEPTION;
2193: END IF;
2194:
2195: IF p_pm_budget_reference = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2196: THEN
2197: l_pm_budget_reference := NULL;
2198: ELSE
2199: l_pm_budget_reference := p_pm_budget_reference;
2198: ELSE
2199: l_pm_budget_reference := p_pm_budget_reference;
2200: END IF;
2201:
2202: IF p_budget_version_name = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2203: THEN
2204: l_budget_version_name := NULL;
2205: ELSE
2206: l_budget_version_name := p_budget_version_name;
2208:
2209: -- Bug 3104308 : Validation for p_first_budget_period .This will be fired only for
2210: -- GL/PA budget periods.
2211:
2212: IF p_first_budget_period = GMS_BUDGET_PUB.G_PA_MISS_CHAR THEN -- Bug 3104308
2213: l_first_budget_period := NULL;
2214: ELSIF (p_first_budget_period IS NOT NULL AND l_budget_entry_method_rec.time_phased_type_code IN ('G','P')) THEN
2215:
2216: OPEN l_budget_periods_csr(p_first_budget_period,l_budget_entry_method_rec.time_phased_type_code);
2282:
2283: -- if draft exist, delete it
2284: if (x_err_code = 0) then
2285:
2286: gms_budget_pub.delete_draft_budget
2287: ( p_api_version_number => 1.0
2288: ,p_pm_product_code => 'GMS'
2289: ,p_project_id => l_project_id
2290: ,p_award_id => l_award_id
2485: -- and this is used as a concurrent process. It will be called
2486: -- by the Award Budgets form (GMSBUEBU)
2487: --
2488: --
2489: -- Called subprograms: gms_budget_pub.baseline_budget
2490: --
2491: --
2492: --
2493: --
2496:
2497: PROCEDURE submit_baseline_budget
2498: ( ERRBUFF IN OUT NOCOPY VARCHAR2
2499: ,RETCODE IN OUT NOCOPY VARCHAR2
2500: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
2501: ,p_award_number IN VARCHAR2 /*bug 3651888 := GMS_BUDGET_PUB.G_PA_MISS_NUM*/
2502: ,p_mark_as_original IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR)
2503:
2504: IS
2497: PROCEDURE submit_baseline_budget
2498: ( ERRBUFF IN OUT NOCOPY VARCHAR2
2499: ,RETCODE IN OUT NOCOPY VARCHAR2
2500: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
2501: ,p_award_number IN VARCHAR2 /*bug 3651888 := GMS_BUDGET_PUB.G_PA_MISS_NUM*/
2502: ,p_mark_as_original IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR)
2503:
2504: IS
2505:
2498: ( ERRBUFF IN OUT NOCOPY VARCHAR2
2499: ,RETCODE IN OUT NOCOPY VARCHAR2
2500: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
2501: ,p_award_number IN VARCHAR2 /*bug 3651888 := GMS_BUDGET_PUB.G_PA_MISS_NUM*/
2502: ,p_mark_as_original IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR)
2503:
2504: IS
2505:
2506: l_err_code number;
2511:
2512: begin
2513:
2514: IF L_DEBUG = 'Y' THEN
2515: gms_error_pkg.gms_debug('*** Start of GMS_BUDGET_PUB.SUBMIT_BASELINE_BUDGET ***','C');
2516: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.SUBMIT_BASELINE_BUDGET - Calling gms_budget_pub.baseline_budget','C');
2517: END IF;
2518:
2519: /* Bug 3651888 */
2512: begin
2513:
2514: IF L_DEBUG = 'Y' THEN
2515: gms_error_pkg.gms_debug('*** Start of GMS_BUDGET_PUB.SUBMIT_BASELINE_BUDGET ***','C');
2516: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.SUBMIT_BASELINE_BUDGET - Calling gms_budget_pub.baseline_budget','C');
2517: END IF;
2518:
2519: /* Bug 3651888 */
2520: Select award_id
2521: into l_award_id
2522: from gms_awards_all
2523: where award_number = p_award_number;
2524:
2525: gms_budget_pub.baseline_budget( p_api_version_number => 1.0,
2526: x_err_code => l_err_code,
2527: x_err_stage => l_err_stage,
2528: x_err_stack => l_err_stack,
2529: p_commit => 'T',
2535: p_budget_type_code => 'AC',
2536: p_mark_as_original => p_mark_as_original);
2537:
2538: IF L_DEBUG = 'Y' THEN
2539: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.SUBMIT_BASELINE_BUDGET - Call to gms_budget_pub.baseline_budget returned l_err_code : '||l_err_code,'C');
2540: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.SUBMIT_BASELINE_BUDGET - Call to gms_budget_pub.baseline_budget returned l_err_stage : '||l_err_stage,'C');
2541: END IF;
2542:
2543: -- Bug 3022766 : Introduced error code = 3 to represent fundscheck failure status.
2536: p_mark_as_original => p_mark_as_original);
2537:
2538: IF L_DEBUG = 'Y' THEN
2539: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.SUBMIT_BASELINE_BUDGET - Call to gms_budget_pub.baseline_budget returned l_err_code : '||l_err_code,'C');
2540: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.SUBMIT_BASELINE_BUDGET - Call to gms_budget_pub.baseline_budget returned l_err_stage : '||l_err_stage,'C');
2541: END IF;
2542:
2543: -- Bug 3022766 : Introduced error code = 3 to represent fundscheck failure status.
2544: -- Baseline_budget procedure returns following statuses
2565:
2566: end if;
2567:
2568: IF L_DEBUG = 'Y' THEN
2569: gms_error_pkg.gms_debug('*** End of GMS_BUDGET_PUB.SUBMIT_BASELINE_BUDGET ***','C');
2570: END IF;
2571:
2572: exception
2573: when OTHERS then
2573: when OTHERS then
2574: RETCODE := 2;
2575: ERRBUFF := SQLCODE ||'-'||SQLERRM;
2576: IF L_DEBUG = 'Y' THEN
2577: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.SUBMIT_BASELINE_BUDGET - Exception :'||ERRBUFF,'C');
2578: END IF;
2579:
2580: end;
2581:
2599: ( p_api_version_number IN NUMBER
2600: ,x_err_code IN OUT NOCOPY NUMBER
2601: ,x_err_stage IN OUT NOCOPY VARCHAR2
2602: ,x_err_stack IN OUT NOCOPY VARCHAR2
2603: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
2604: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
2605: ,p_workflow_started OUT NOCOPY VARCHAR2
2606: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2607: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
2600: ,x_err_code IN OUT NOCOPY NUMBER
2601: ,x_err_stage IN OUT NOCOPY VARCHAR2
2602: ,x_err_stack IN OUT NOCOPY VARCHAR2
2603: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
2604: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
2605: ,p_workflow_started OUT NOCOPY VARCHAR2
2606: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2607: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
2608: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2602: ,x_err_stack IN OUT NOCOPY VARCHAR2
2603: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
2604: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
2605: ,p_workflow_started OUT NOCOPY VARCHAR2
2606: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2607: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
2608: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2609: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
2610: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2603: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
2604: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
2605: ,p_workflow_started OUT NOCOPY VARCHAR2
2606: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2607: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
2608: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2609: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
2610: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2611: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2604: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
2605: ,p_workflow_started OUT NOCOPY VARCHAR2
2606: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2607: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
2608: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2609: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
2610: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2611: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2612: ,p_mark_as_original IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR )
2605: ,p_workflow_started OUT NOCOPY VARCHAR2
2606: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2607: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
2608: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2609: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
2610: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2611: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2612: ,p_mark_as_original IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR )
2613:
2606: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2607: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
2608: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2609: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
2610: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2611: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2612: ,p_mark_as_original IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR )
2613:
2614: IS
2607: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
2608: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2609: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
2610: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2611: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2612: ,p_mark_as_original IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR )
2613:
2614: IS
2615:
2608: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2609: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
2610: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2611: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
2612: ,p_mark_as_original IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR )
2613:
2614: IS
2615:
2616: CURSOR l_budget_types_csr
2787:
2788: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024
2789:
2790: IF L_DEBUG = 'Y' THEN
2791: gms_error_pkg.gms_debug('*** Start of GMS_BUDGET_PUB.BASELINE_BUDGET ***','C');
2792: END IF;
2793:
2794: x_err_code := 0;
2795: x_err_stage := NULL; -- Bug 2587078
2815: p_api_version_number ,
2816: l_api_name ,
2817: G_PKG_NAME )
2818: THEN
2819: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Error occured in FND_API.Compatible_API_Call';
2820: gms_error_pkg.gms_message(x_err_name => 'GMS_INCOMPATIBLE_API_CALL',
2821: x_err_code => x_err_code,
2822: x_err_buff => x_err_stage);
2823: fnd_msg_pub.add; -- Bug 2587078
2828: END IF;
2829:
2830: --product_code is mandatory
2831:
2832: IF p_pm_product_code = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2833: OR p_pm_product_code IS NULL
2834: THEN
2835: x_err_stage := 'Error occured while validating product_code';
2836: gms_error_pkg.gms_message(x_err_name => 'GMS_PRODUCT_CODE_IS_MISSING',
2845: -- If award_id is passed in then use it otherwise use the award_number
2846: -- that is passed in to fetch value of award_id from gms_awards table
2847: -- If both are missing then raise an error.
2848:
2849: IF (p_award_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
2850: AND p_award_number IS NOT NULL)
2851: OR (p_award_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
2852: AND p_award_id IS NOT NULL)
2853: THEN
2847: -- If both are missing then raise an error.
2848:
2849: IF (p_award_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
2850: AND p_award_number IS NOT NULL)
2851: OR (p_award_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
2852: AND p_award_id IS NOT NULL)
2853: THEN
2854:
2855: IF L_DEBUG = 'Y' THEN
2852: AND p_award_id IS NOT NULL)
2853: THEN
2854:
2855: IF L_DEBUG = 'Y' THEN
2856: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Calling convert_awardnum_to_id','C');
2857: END IF;
2858:
2859: convert_awardnum_to_id(p_award_number_in => p_award_number
2860: ,p_award_id_in => p_award_id
2865:
2866: IF x_err_code <> 0
2867: THEN
2868: IF L_DEBUG = 'Y' THEN
2869: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Call to convert_awardnum_to_id returned x_err_code : '||x_err_code ||' x_err_stage :'||x_err_stage,'C');
2870: END IF;
2871: return;
2872: END IF;
2873: ELSE
2870: END IF;
2871: return;
2872: END IF;
2873: ELSE
2874: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Error occured while validating Award information';
2875: gms_error_pkg.gms_message(x_err_name => 'GMS_AWARD_NUM_ID_MISSING',
2876: x_err_code => x_err_code,
2877: x_err_buff => x_err_stage);
2878: fnd_msg_pub.add; -- Bug 2587078
2897: -- If a user does not have privileges to update the award, then
2898: -- cannot baseline the budget
2899:
2900: IF L_DEBUG = 'Y' THEN
2901: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Calling gms_security.initialize','C');
2902: END IF;
2903:
2904: gms_security.initialize (X_user_id => l_user_id,
2905: X_calling_module => l_module_name);
2919: -- If project_id is passed in then use it otherwise use the project_number
2920: -- (segment1) that is passed in to fetch value of project_id from pa_projects
2921: -- table. If both are missing then raise an error.
2922:
2923: IF (p_project_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
2924: AND p_project_number IS NOT NULL)
2925: OR (p_project_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
2926: AND p_project_id IS NOT NULL)
2927: THEN
2921: -- table. If both are missing then raise an error.
2922:
2923: IF (p_project_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
2924: AND p_project_number IS NOT NULL)
2925: OR (p_project_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
2926: AND p_project_id IS NOT NULL)
2927: THEN
2928: IF L_DEBUG = 'Y' THEN
2929: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Calling convert_projnum_to_id','C');
2925: OR (p_project_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
2926: AND p_project_id IS NOT NULL)
2927: THEN
2928: IF L_DEBUG = 'Y' THEN
2929: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Calling convert_projnum_to_id','C');
2930: END IF;
2931: convert_projnum_to_id(p_project_number_in => p_project_number
2932: ,p_project_id_in => p_project_id
2933: ,p_project_id_out => l_project_id
2937:
2938: IF x_err_code <> 0
2939: THEN
2940: IF L_DEBUG = 'Y' THEN
2941: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Call to convert_projnum_to_id returned x_err_code : '||x_err_code ||' x_err_stage :'||x_err_stage,'C');
2942: END IF;
2943: return;
2944: END IF;
2945:
2943: return;
2944: END IF;
2945:
2946: ELSE
2947: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Error occured while validating Project information';
2948: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJECT_IS_MISSING', -- 'GMS_PROJ_NUM_ID_MISSING', Bug 2587078
2949: x_err_code => x_err_code,
2950: x_err_buff => x_err_stage);
2951: fnd_msg_pub.add; -- Bug 2587078
2962: close l_project_csr;
2963:
2964: IF l_project_id IS NULL --never happens because previous procedure checks this.
2965: THEN
2966: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Error occured while validating Project information';
2967: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJ_REF_AND_ID_MISSING', --'GMS_INVALID_PROJ_NUMBER', bug 2587078
2968: x_err_code => x_err_code,
2969: x_err_buff => x_err_stage);
2970: fnd_msg_pub.add; -- Bug 2587078
2973:
2974: -- budget type code is mandatory
2975:
2976: IF p_budget_type_code IS NULL
2977: OR p_budget_type_code = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2978: THEN
2979: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Error occured while validating Budget type information';
2980: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_MISSING',
2981: x_err_code => x_err_code,
2975:
2976: IF p_budget_type_code IS NULL
2977: OR p_budget_type_code = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2978: THEN
2979: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Error occured while validating Budget type information';
2980: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_MISSING',
2981: x_err_code => x_err_code,
2982: x_err_buff => x_err_stage);
2983: fnd_msg_pub.add; -- Bug 2587078
2992: IF l_budget_types_csr%NOTFOUND
2993: THEN
2994:
2995: CLOSE l_budget_types_csr;
2996: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Error occured while validating Budget type information';
2997: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_INVALID',
2998: x_err_code => x_err_code,
2999: x_err_buff => x_err_stage);
3000: fnd_msg_pub.add; -- Bug 2587078
3009: -- mark_as_original defaults to YES ('Y') when this is the first time this budget is baselined
3010: -- otherwise it will default to NO ('N')
3011:
3012: IF p_mark_as_original IS NULL
3013: OR p_mark_as_original = GMS_BUDGET_PUB.G_PA_MISS_CHAR
3014: OR UPPER(p_mark_as_original) NOT IN ('N','Y')
3015: THEN
3016:
3017: OPEN l_baselined_csr( l_project_id
3034:
3035: END IF;
3036:
3037: IF L_DEBUG = 'Y' THEN
3038: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - l_mark_as_original : '||l_mark_as_original,'C');
3039: END IF;
3040:
3041: -- get the budget version ID associated with this project / budget_type_code combination
3042:
3049:
3050: IF l_budget_versions_csr%NOTFOUND
3051: THEN
3052: CLOSE l_budget_versions_csr;
3053: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Error occured while validating Budget version information';
3054: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_BUDGET_VERSION',
3055: x_err_code => x_err_code,
3056: x_err_buff => x_err_stage);
3057: fnd_msg_pub.add; -- Bug 2587078
3070:
3071: IF l_resource_assignments_csr%NOTFOUND
3072: THEN
3073: CLOSE l_resource_assignments_csr;
3074: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Error occured while validating Budget lines information';
3075: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_BUDGET_LINES',
3076: x_err_code => x_err_code,
3077: x_err_buff => x_err_stage);
3078: fnd_msg_pub.add; -- Bug 2587078
3087:
3088: IF l_time_phased_type_csr%NOTFOUND
3089: THEN
3090: CLOSE l_time_phased_type_csr;
3091: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Error occured while validating Time phase information';
3092: gms_error_pkg.gms_message(x_err_name => 'GMS_TIME_PHASED_TYPE_CODE_MISS',
3093: x_err_code => x_err_code,
3094: x_err_buff => x_err_stage);
3095: fnd_msg_pub.add; -- Bug 2587078
3098:
3099: -- Dummy call !
3100:
3101: IF L_DEBUG = 'Y' THEN
3102: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Calling gms_budget_core.verify', 'C');
3103: END IF;
3104:
3105: gms_budget_core.verify( x_budget_version_id => l_budget_version_id
3106: ,x_err_code => x_err_code
3108: ,x_err_stack => x_err_stack );
3109:
3110: IF x_err_code <> 0
3111: THEN
3112: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Error occured in gms_budget_core.verify';
3113: gms_error_pkg.gms_message(x_err_name => 'GMS_VERIFY_FAILED',
3114: x_err_code => x_err_code,
3115: x_err_buff => x_err_stage);
3116: fnd_msg_pub.add; -- Bug 2587078
3133: IF ( l_budget_rules_csr%NOTFOUND)
3134: THEN
3135:
3136: CLOSE l_budget_rules_csr;
3137: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Error occured while validating Budget rules information';
3138: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_BUDGET_RULES_ATTR',
3139: x_err_code => x_err_code,
3140: x_err_buff => x_err_stage);
3141: fnd_msg_pub.add; -- Bug 2587078
3171: if is_fc_required (p_project_id => l_project_id,
3172: p_award_id => l_award_id)
3173: then
3174: IF L_DEBUG = 'Y' THEN
3175: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Call to is_fc_required returned TRUE ', 'C');
3176: END IF;
3177:
3178: UPDATE gms_budget_versions
3179: SET fc_required_flag = 'Y'
3182: AND budget_type_code = p_budget_type_code
3183: AND budget_status_code in ('W','S');
3184: else
3185: IF L_DEBUG = 'Y' THEN
3186: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Call to is_fc_required returned FALSE ', 'C');
3187: END IF;
3188:
3189: UPDATE gms_budget_versions
3190: SET fc_required_flag = 'N'
3198: IF l_budget_status_code = 'W'
3199: THEN
3200:
3201: IF L_DEBUG = 'Y' THEN
3202: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Start of Submit process', 'C');
3203: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Calling GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES - Submit mode', 'C');
3204: END IF;
3205:
3206: -- this is also a dummy call ...
3199: THEN
3200:
3201: IF L_DEBUG = 'Y' THEN
3202: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Start of Submit process', 'C');
3203: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Calling GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES - Submit mode', 'C');
3204: END IF;
3205:
3206: -- this is also a dummy call ...
3207: GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES
3231: IF (x_err_code <> 0)
3232: THEN
3233: IF (l_warnings_only_flag <> 'Y')
3234: THEN
3235: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Error occured in GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES - Submit';
3236: gms_error_pkg.gms_message(x_err_name => 'GMS_VERIFY_BUDGET_FAIL_S',
3237: x_err_code => x_err_code,
3238: x_err_buff => x_err_stage);
3239: fnd_msg_pub.add; -- Bug 25870708
3243:
3244:
3245: -- LOCK DRAFT BUDGET VERSION Since Primary Verification Finished
3246: IF L_DEBUG = 'Y' THEN
3247: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Locking the budget', 'C');
3248: END IF;
3249:
3250: OPEN l_lock_budget_csr(l_budget_version_id);
3251: CLOSE l_lock_budget_csr;
3252:
3253: -- BASELINE RULES -------------------------------------------------------------
3254:
3255: IF L_DEBUG = 'Y' THEN
3256: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Calling GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES - Baseline mode', 'C');
3257: END IF;
3258:
3259: GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES
3260: (p_draft_version_id => l_budget_version_id
3283: IF (x_err_code <> 0)
3284: THEN
3285: IF (l_warnings_only_flag <> 'Y')
3286: THEN
3287: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Error occured in GMS_BUDGET_UTILS.VERIFY_BUDGET_RULES - Baseline ';
3288: gms_error_pkg.gms_message(x_err_name => 'GMS_VERIFY_BUDGET_FAIL_B',
3289: x_err_code => x_err_code,
3290: x_err_buff => x_err_stage);
3291: fnd_msg_pub.add; -- Bug 2587078
3296:
3297: -- CHECKING IF WORKFLOW IS ENABLED FOR THIS AWARD
3298:
3299: IF L_DEBUG = 'Y' THEN
3300: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Calling gms_wf_pkg.is_budget_wf_used', 'C');
3301: END IF;
3302:
3303: GMS_WF_PKG.Is_Budget_Wf_Used
3304: ( p_project_id => l_project_id
3312: );
3313:
3314: IF (x_err_code <> 0)
3315: THEN
3316: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Error occured in gms_wf_pkg.is_budget_wf_used';
3317: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDG_WF_CHECK_FAIL',
3318: x_err_code => x_err_code,
3319: x_err_buff => x_err_stage);
3320: fnd_msg_pub.add; -- Bug 2587078
3321: APP_EXCEPTION.RAISE_EXCEPTION;
3322: END IF;
3323:
3324: IF L_DEBUG = 'Y' THEN
3325: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - l_workflow_is_used : '||l_workflow_is_used, 'C');
3326: END IF;
3327:
3328: IF (l_workflow_is_used = 'T' ) THEN -- WORKFLOW IS ENABLED FOR THIS AWARD
3329:
3337: conc_request_id = l_conc_request_id
3338: WHERE budget_version_id = l_budget_version_id;
3339:
3340: IF L_DEBUG = 'Y' THEN
3341: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Calling gms_wf_pkg.start_budget_wf', 'C');
3342: END IF;
3343:
3344: GMS_WF_PKG.Start_Budget_Wf
3345: ( p_draft_version_id => l_budget_version_id
3353: );
3354:
3355: IF (x_err_code <> 0)
3356: THEN
3357: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Error occured in gms_wf_pkg.start_budget_wf';
3358: gms_error_pkg.gms_message(x_err_name => 'GMS_START_BUDG_WF_FAIL',
3359: x_err_code => x_err_code,
3360: x_err_buff => x_err_stage);
3361: fnd_msg_pub.add; -- Bug 2587078
3372: THEN
3373: COMMIT;
3374: END IF;
3375:
3376: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Budget workflow started ';
3377: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_WF_STARTED',
3378: x_token_name1 => 'AWARD_NUMBER',
3379: x_token_val1 => l_award_number,
3380: x_token_name2 => 'PROJECT_NUMBER',
3390:
3391: ELSE -- WORKFLOW IS NOT ENABLED FOR THIS AWARD
3392:
3393: IF L_DEBUG = 'Y' THEN
3394: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - l_funds_check_at_submit : '||l_funds_check_at_submit,'C');
3395: END IF;
3396:
3397: IF l_funds_check_at_submit = 'Y' THEN --Bug 2290959 : Perform fundscheck only if the profile 'GMS : Enable funds check for budget Submission' is set to Yes.
3398:
3396:
3397: IF l_funds_check_at_submit = 'Y' THEN --Bug 2290959 : Perform fundscheck only if the profile 'GMS : Enable funds check for budget Submission' is set to Yes.
3398:
3399: -- CALLING THE FUNDSCHECK PROCESS ...
3400: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - In gms_budget_balance.update_gms_balance';
3401: gms_budget_balance.update_gms_balance( x_project_id => l_project_id
3402: , x_award_id => l_award_id
3403: , x_mode => 'S'
3404: , ERRBUF => x_err_stage
3409:
3410: SAVEPOINT baseline_budget_pub;
3411:
3412: IF L_DEBUG = 'Y' THEN
3413: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - l_fc_return_code : '||l_fc_return_code, 'C');
3414: END IF;
3415:
3416:
3417: END IF; --Bug 2290959
3418:
3419: IF ((l_fc_return_code = 'S' AND l_funds_check_at_submit = 'Y') OR l_funds_check_at_submit = 'N' )THEN --Bug 2290959
3420:
3421: IF L_DEBUG = 'Y' THEN
3422: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Updating Budget to Submitted status', 'C');
3423: END IF;
3424:
3425: UPDATE gms_budget_versions
3426: SET budget_status_code = 'S',
3464: gms_error_pkg.gms_output(x_output => x_err_stage);
3465: rollback to baseline_budget_pub;
3466:
3467: IF L_DEBUG = 'Y' THEN
3468: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - End of Submit process', 'C');
3469: END IF;
3470: return;
3471: END IF;
3472:
3471: END IF;
3472:
3473: END IF; -- (l_workflow_is_used = 'T' )
3474: IF L_DEBUG = 'Y' THEN
3475: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - End of Submit process', 'C');
3476: END IF;
3477: ---------------------------------------------------------------------------------------
3478: ELSE -- Budget status is 'S', so Baseline the budget
3479:
3477: ---------------------------------------------------------------------------------------
3478: ELSE -- Budget status is 'S', so Baseline the budget
3479:
3480: IF L_DEBUG = 'Y' THEN
3481: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Start of Baseline process', 'C');
3482: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Calling gms_budget_core.baseline', 'C');
3483: END IF;
3484: gms_budget_core.baseline ( x_draft_version_id => l_budget_version_id
3485: ,x_mark_as_original => l_mark_as_original
3478: ELSE -- Budget status is 'S', so Baseline the budget
3479:
3480: IF L_DEBUG = 'Y' THEN
3481: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Start of Baseline process', 'C');
3482: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Calling gms_budget_core.baseline', 'C');
3483: END IF;
3484: gms_budget_core.baseline ( x_draft_version_id => l_budget_version_id
3485: ,x_mark_as_original => l_mark_as_original
3486: ,x_verify_budget_rules => 'N'
3489: ,x_err_stack => x_err_stack );
3490:
3491: IF x_err_code <> 0
3492: THEN
3493: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Error occured in gms_budget_core.baseline';
3494: gms_error_pkg.gms_message(x_err_name => 'GMS_BASELINE_FAILED',
3495: x_err_code => x_err_code,
3496: x_err_buff => x_err_stage);
3497: fnd_msg_pub.add; -- Bug 2587078
3506: -- First get the budget_version_id of the previously baselined budget. In case there is an error we need to set the current_flag
3507: -- for this line to Y
3508:
3509: IF L_DEBUG = 'Y' THEN
3510: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Fetching previous budget_version_id', 'C');
3511: END IF;
3512:
3513:
3514: select bv.budget_version_id,
3524: and bv.current_flag = 'R'
3525: and bv.budget_entry_method_code = bem.budget_entry_method_code;
3526:
3527: IF L_DEBUG = 'Y' THEN
3528: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Fetched previous budget_version_id '||l_prev_baselined_version_id, 'C');
3529: END IF;
3530:
3531:
3532: exception
3534: -- this means that there did not exist any baselined budget earlier
3535: l_prev_baselined_version_id := null;
3536: l_prev_entry_level_code := null;
3537: IF L_DEBUG = 'Y' THEN
3538: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - There exists no baselined budget earlier', 'C');
3539: END IF;
3540:
3541: when OTHERS then
3542: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - While fetching previous version id, when others exception ';
3538: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - There exists no baselined budget earlier', 'C');
3539: END IF;
3540:
3541: when OTHERS then
3542: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - While fetching previous version id, when others exception ';
3543: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
3544: x_token_name1 => 'SQLCODE',
3545: x_token_val1 => sqlcode,
3546: x_token_name2 => 'SQLERRM',
3557:
3558: -- Bug 5162777 : The budgetary control records are created before invoking fundscheck process.
3559: ----------------------- START OF BC RECORD CREATION -------------------------
3560:
3561: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Calling gms_budg_cont_setup.bud_ctrl_create', 'C');
3562: gms_budg_cont_setup.bud_ctrl_create(p_project_id => l_project_id
3563: ,p_award_id => l_award_id
3564: ,p_prev_entry_level_code => l_prev_entry_level_code
3565: ,p_entry_level_code => l_entry_level_code
3569: ,x_err_stage => x_err_stage);
3570:
3571: if x_err_code <> 0
3572: then
3573: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Error occurred in gms_budg_cont_setup.bud_ctrl_create';
3574: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDG_CONTROL_SETUP_FAIL',
3575: x_err_code => x_err_code,
3576: x_err_buff => x_err_stage);
3577:
3583: ----------------------- END OF BC RECORD CREATION -------------------------
3584:
3585: -- CALLING THE FUNDSCHECK PROCESS ...
3586: IF L_DEBUG = 'Y' THEN
3587: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Calling gms_budget_balance.update_gms_balance','C');
3588: END IF;
3589:
3590: gms_budget_balance.update_gms_balance( x_project_id => l_project_id
3591: , x_award_id => l_award_id
3598:
3599: SAVEPOINT baseline_budget_pub;
3600:
3601: IF L_DEBUG = 'Y' THEN
3602: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - l_fc_return_code : '||l_fc_return_code, 'C');
3603: END IF;
3604:
3605: IF l_fc_return_code = 'S'
3606: THEN -- Funds check passed
3608: -- after calling BASELINE, set the budget_status_code back to 'W' (Working)
3609: -- the concept of submitting budget is not available in the public API's!
3610:
3611: IF L_DEBUG = 'Y' THEN
3612: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Updating Budget to Working status', 'C');
3613: END IF;
3614:
3615: UPDATE gms_budget_versions
3616: SET budget_status_code = 'W', conc_request_id = l_conc_request_id
3628:
3629: -- 1. set the current_flag = 'N' for the previously baselined budget (whose current_flag was set to 'R' earlier)
3630:
3631: IF L_DEBUG = 'Y' THEN
3632: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Updating current flag to N on previous baselined budget version', 'C');
3633: END IF;
3634:
3635: update gms_budget_versions
3636: set current_flag = 'N'
3644:
3645: -- Corrected the query for Bug:2542827
3646:
3647: IF L_DEBUG = 'Y' THEN
3648: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Updating current flag to Y on newly created budget version', 'C');
3649: END IF;
3650:
3651: update gms_budget_versions
3652: set current_flag = 'Y'
3672: and budget_status_code = 'B'
3673: and current_flag = 'Y';
3674:
3675: IF L_DEBUG = 'Y' THEN
3676: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - l_baselined_version_id '||l_baselined_version_id, 'C');
3677: END IF;
3678:
3679: exception
3680: when OTHERS
3678:
3679: exception
3680: when OTHERS
3681: then
3682: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - While fetching baselined version id, when others exception ';
3683: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
3684: x_token_name1 => 'SQLCODE',
3685: x_token_val1 => sqlcode,
3686: x_token_name2 => 'SQLERRM',
3699:
3700: -- 4. call gms_sweeper - added for Bug: 1666853
3701:
3702: IF L_DEBUG = 'Y' THEN
3703: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Calling gms_sweeper.upd_act_enc_bal', 'C');
3704: END IF;
3705:
3706:
3707: -- get the packet id for the budget and pass it on to the sweeper process.
3730: x_project_id => l_project_id,
3731: x_award_id => l_award_id);
3732:
3733: if x_err_code <> 0 then -- Changed from 'S' to 0 (zero) for Bug:2464800
3734: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Error occurred in gms_sweeper.upd_act_enc_bal';
3735: gms_error_pkg.gms_message(x_err_name => 'GMS_BU_SWEEP_FAILED',
3736: x_err_code => x_err_code,
3737: x_err_buff => x_err_stage);
3738:
3736: x_err_code => x_err_code,
3737: x_err_buff => x_err_stage);
3738:
3739: IF L_DEBUG = 'Y' THEN
3740: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Updating current flag to Y on previous baselined budget version', 'C');
3741: END IF;
3742:
3743: -- Bug 2386041
3744: update gms_budget_versions
3745: set current_flag = 'Y'
3746: where budget_version_id = l_prev_baselined_version_id;
3747:
3748: IF L_DEBUG = 'Y' THEN
3749: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Updating current flag to N on newly baselined budget version id', 'C');
3750: END IF;
3751:
3752: update gms_budget_versions
3753: set current_flag = 'N'
3753: set current_flag = 'N'
3754: where budget_version_id = l_baselined_version_id;
3755:
3756: IF L_DEBUG = 'Y' THEN
3757: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Updating budget to submitted status', 'C');
3758: END IF;
3759:
3760: UPDATE gms_budget_versions
3761: SET budget_status_code = 'S'
3777:
3778: -- 5. Summarize the Project Budget.
3779:
3780: IF L_DEBUG = 'Y' THEN
3781: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Start of Project Budget Summarization ', 'C');
3782: END IF;
3783:
3784: -- Bug 2386041
3785: l_user_profile_value1 := fnd_profile.value_specific('PA_SUPER_PROJECT', fnd_global.user_id, fnd_global.resp_id, fnd_global.resp_appl_id);
3838: end if;
3839:
3840:
3841: IF L_DEBUG = 'Y' THEN
3842: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Calling gms_summarize_budgets.summarize_baselined_versions', 'C');
3843: END IF;
3844:
3845: -- Bug 2386041
3846: gms_summarize_budgets.summarize_baselined_versions( x_project_id => l_project_id
3861: -- Fix for bug : 5511910. We retrun stasus values as 'P' if summarization does not happen.
3862: --IF l_return_status <> 'S'
3863: IF l_return_status NOT in ( 'S','X') THEN
3864:
3865: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Error occured in gms_summarize_budgets.summarize_baselined_versions';
3866: gms_error_pkg.gms_message(x_err_name => 'GMS_SUMMARIZE_PA_BUDG_FAIL',
3867: x_err_code => x_err_code,
3868: x_err_buff => x_err_stage);
3869:
3867: x_err_code => x_err_code,
3868: x_err_buff => x_err_stage);
3869:
3870: IF L_DEBUG = 'Y' THEN
3871: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Updating current flag to Y on previous baselined budget version', 'C');
3872: END IF;
3873:
3874: -- Bug 2386041
3875: update gms_budget_versions
3876: set current_flag = 'Y'
3877: where budget_version_id = l_prev_baselined_version_id;
3878:
3879: IF L_DEBUG = 'Y' THEN
3880: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Updating current flag to N on newly baselined budget version id', 'C');
3881: END IF;
3882:
3883: update gms_budget_versions
3884: set current_flag = 'N'
3884: set current_flag = 'N'
3885: where budget_version_id = l_baselined_version_id;
3886:
3887: IF L_DEBUG = 'Y' THEN
3888: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Updating budget to submitted status', 'C');
3889: END IF;
3890:
3891: UPDATE gms_budget_versions
3892: SET budget_status_code = 'S'
3902:
3903: -- 6. call Workflow process to send notification
3904:
3905: IF L_DEBUG = 'Y' THEN
3906: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET -Sending workflow notifictaion', 'C');
3907: END IF;
3908:
3909: open l_wf_notif_role_csr (p_award_id => l_award_id);
3910: fetch l_wf_notif_role_csr into l_row_found;
3916:
3917: if l_wf_notif_role_csr%FOUND AND l_wf_enabled_flag = 'Y' then --One more condition added for bug 5620089
3918:
3919: IF L_DEBUG = 'Y' THEN
3920: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Calling gms_wf_pkg.start_budget_wf_ntfy_only', 'C');
3921: END IF;
3922:
3923: GMS_WF_PKG.Start_Budget_Wf_Ntfy_Only
3924: ( p_draft_version_id => l_budget_version_id
3930: , p_err_stage => x_err_stage
3931: , p_err_stack => x_err_stack);
3932:
3933: if (x_err_code <> 0) then
3934: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Error occurred in gms_wf_pkg.start_budget_wf_ntfy_only' ;
3935: gms_error_pkg.gms_message(x_err_name => 'GMS_BU_WF_NTFY_FAIL', -- 'GMS_NTFY_BUDG_WF_FAIL', Bug 2587078
3936: x_err_code => x_err_code,
3937: x_err_buff => x_err_stage,
3938: x_exec_type => 'C');
3953: --------------------------------------------- ----------------------------------------------------------------------------------
3954: -- GMS enhancement for R12 : 5583170
3955: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - l_return_status IS ==== : '|| l_return_status,'C');
3956: If l_return_status = 'S' then
3957: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Baselining successful ' ;
3958: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_BASELINED',
3959: x_token_name1 => 'PROJECT_NUMBER',
3960: x_token_val1 => l_project_number,
3961: x_exec_type => 'C', -- for concurrent process
3985:
3986: -- since Funds check failed the previously baselined budget (whose current_flag was set to 'R' earlier) has to be restored
3987:
3988: IF L_DEBUG = 'Y' THEN
3989: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Updating current_flag to Y on previously baselined budget', 'C');
3990: END IF;
3991:
3992: update gms_budget_versions
3993: set current_flag = 'Y'
4003:
4004: -- Redefining the savepoint since the above commit will clear all previously defined savepoints
4005:
4006: SAVEPOINT baseline_budget_pub;
4007: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET - Fundscheck failed' ;
4008: gms_error_pkg.gms_message(x_err_name => 'GMS_FC_FAIL_BASELINE',
4009: x_token_name1 => 'AWARD_NUMBER',
4010: x_token_val1 => l_award_number,
4011: x_token_name2 => 'PROJECT_NUMBER',
4029:
4030: ELSE -- l_fc_return_code = 'H' or 'L' - Unexpected Error Occured
4031:
4032: IF L_DEBUG = 'Y' THEN
4033: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - Updating current_flag to Y on previously baselined budget', 'C');
4034: END IF;
4035:
4036: -- since Funds check failed the previously baselined budget (whose current_flag was set to 'R' earlier) has to be restored
4037:
4049:
4050: -- Redefining the savepoint since the above commit will clear all previously defined savepoints
4051:
4052: SAVEPOINT baseline_budget_pub;
4053: x_err_stage := 'GMS_BUDGET_PUB.BASELINE_BUDGET -Unexpected error' ;
4054: gms_error_pkg.gms_message(x_err_name => 'GMS_UNEXPECTED_ERROR',
4055: x_token_name1 => 'SQLCODE',
4056: x_token_val1 => sqlcode,
4057: x_token_name2 => 'SQLERRM',
4067:
4068: END IF;
4069:
4070: IF L_DEBUG = 'Y' THEN
4071: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - End of Baseline process', 'C');
4072: END IF;
4073:
4074: END IF; --
4075:
4073:
4074: END IF; --
4075:
4076: IF L_DEBUG = 'Y' THEN
4077: gms_error_pkg.gms_debug('*** End of GMS_BUDGET_PUB.BASELINE_BUDGET ***','C');
4078: END IF;
4079:
4080: EXCEPTION
4081: WHEN OTHERS
4079:
4080: EXCEPTION
4081: WHEN OTHERS
4082: THEN
4083: x_err_stage :='GMS_BUDGET_PUB.BASELINE_BUDGET - In when others exception';
4084:
4085: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_FAILED', -- Bug 2587078
4086: x_err_code => x_err_code,
4087: x_err_buff => x_err_stage);
4098: -- existing WORKING budget.
4099: --
4100: --Called subprograms:
4101: -- gms_budget_utils.check_overlapping_dates()
4102: -- gms_budget_pub.summerize_project_totals()
4103: --
4104: --
4105: --
4106: --History:
4110: ( p_api_version_number IN NUMBER
4111: ,x_err_code IN OUT NOCOPY NUMBER
4112: ,x_err_stage IN OUT NOCOPY VARCHAR2
4113: ,x_err_stack IN OUT NOCOPY VARCHAR2
4114: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
4115: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
4116: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4117: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4118: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4111: ,x_err_code IN OUT NOCOPY NUMBER
4112: ,x_err_stage IN OUT NOCOPY VARCHAR2
4113: ,x_err_stack IN OUT NOCOPY VARCHAR2
4114: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
4115: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
4116: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4117: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4118: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4119: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4112: ,x_err_stage IN OUT NOCOPY VARCHAR2
4113: ,x_err_stack IN OUT NOCOPY VARCHAR2
4114: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
4115: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
4116: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4117: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4118: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4119: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4120: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4113: ,x_err_stack IN OUT NOCOPY VARCHAR2
4114: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
4115: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
4116: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4117: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4118: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4119: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4120: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4121: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4114: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
4115: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
4116: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4117: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4118: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4119: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4120: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4121: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4122: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4115: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
4116: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4117: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4118: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4119: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4120: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4121: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4122: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4123: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4116: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4117: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4118: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4119: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4120: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4121: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4122: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4123: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4124: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4117: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4118: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4119: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4120: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4121: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4122: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4123: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4124: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4125: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4118: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4119: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4120: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4121: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4122: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4123: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4124: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4125: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4126: ,p_budget_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
4119: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4120: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4121: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4122: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4123: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4124: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4125: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4126: ,p_budget_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
4127: ,p_budget_end_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
4120: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4121: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4122: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4123: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4124: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4125: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4126: ,p_budget_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
4127: ,p_budget_end_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
4128: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4121: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4122: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4123: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4124: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4125: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4126: ,p_budget_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
4127: ,p_budget_end_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
4128: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4129: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4122: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4123: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4124: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4125: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4126: ,p_budget_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
4127: ,p_budget_end_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
4128: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4129: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4130: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4123: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4124: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4125: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4126: ,p_budget_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
4127: ,p_budget_end_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
4128: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4129: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4130: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4131: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4124: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4125: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4126: ,p_budget_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
4127: ,p_budget_end_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
4128: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4129: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4130: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4131: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4132: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4125: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4126: ,p_budget_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
4127: ,p_budget_end_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
4128: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4129: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4130: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4131: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4132: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4133: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4126: ,p_budget_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
4127: ,p_budget_end_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
4128: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4129: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4130: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4131: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4132: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4133: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4134: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4127: ,p_budget_end_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
4128: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4129: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4130: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4131: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4132: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4133: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4134: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4135: ,p_track_as_labor_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4128: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4129: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4130: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4131: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4132: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4133: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4134: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4135: ,p_track_as_labor_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4136: ,p_pm_budget_line_reference IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4129: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4130: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4131: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4132: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4133: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4134: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4135: ,p_track_as_labor_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4136: ,p_pm_budget_line_reference IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4137: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4130: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4131: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4132: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4133: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4134: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4135: ,p_track_as_labor_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4136: ,p_pm_budget_line_reference IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4137: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4138: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4131: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4132: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4133: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4134: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4135: ,p_track_as_labor_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4136: ,p_pm_budget_line_reference IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4137: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4138: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4139: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4132: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4133: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4134: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4135: ,p_track_as_labor_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4136: ,p_pm_budget_line_reference IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4137: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4138: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4139: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4140: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4133: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
4134: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4135: ,p_track_as_labor_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4136: ,p_pm_budget_line_reference IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4137: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4138: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4139: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4140: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4141: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4134: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4135: ,p_track_as_labor_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4136: ,p_pm_budget_line_reference IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4137: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4138: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4139: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4140: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4141: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4142: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4135: ,p_track_as_labor_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4136: ,p_pm_budget_line_reference IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4137: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4138: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4139: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4140: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4141: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4142: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4143: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4136: ,p_pm_budget_line_reference IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4137: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4138: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4139: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4140: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4141: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4142: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4143: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4144: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4137: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4138: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4139: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4140: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4141: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4142: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4143: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4144: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4145: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4138: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4139: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4140: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4141: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4142: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4143: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4144: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4145: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4146: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4139: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4140: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4141: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4142: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4143: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4144: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4145: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4146: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4147: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4140: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4141: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4142: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4143: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4144: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4145: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4146: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4147: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4148: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4141: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4142: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4143: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4144: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4145: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4146: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4147: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4148: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4149: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4142: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4143: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4144: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4145: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4146: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4147: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4148: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4149: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4150: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4143: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4144: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4145: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4146: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4147: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4148: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4149: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4150: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4151: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4144: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4145: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4146: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4147: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4148: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4149: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4150: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4151: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4152: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4145: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4146: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4147: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4148: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4149: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4150: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4151: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4152: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4153: ,p_raw_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4146: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4147: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4148: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4149: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4150: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4151: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4152: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4153: ,p_raw_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4154: ,p_burdened_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4147: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4148: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4149: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4150: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4151: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4152: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4153: ,p_raw_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4154: ,p_burdened_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4155: ,p_quantity_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4148: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4149: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4150: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4151: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4152: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4153: ,p_raw_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4154: ,p_burdened_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4155: ,p_quantity_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4156: )
4149: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4150: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4151: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4152: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4153: ,p_raw_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4154: ,p_burdened_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4155: ,p_quantity_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4156: )
4157: IS
4150: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4151: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4152: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4153: ,p_raw_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4154: ,p_burdened_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4155: ,p_quantity_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4156: )
4157: IS
4158:
4151: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4152: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4153: ,p_raw_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4154: ,p_burdened_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4155: ,p_quantity_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
4156: )
4157: IS
4158:
4159:
4241: l_old_stack VARCHAR2(630);
4242:
4243: BEGIN
4244:
4245: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - start');
4246:
4247: x_err_code := 0;
4248: l_old_stack := x_err_stack;
4249: x_err_stack := x_err_stack ||'-> Add_Budget_Line';
4296: --CHECK FOR MANDATORY FIELDS and CONVERT VALUES to ID's
4297:
4298: --product_code is mandatory
4299:
4300: IF p_pm_product_code = GMS_BUDGET_PUB.G_PA_MISS_CHAR
4301: OR p_pm_product_code IS NULL
4302: THEN
4303: gms_error_pkg.gms_message(x_err_name => 'GMS_PRODUCT_CODE_MISSING',
4304: x_err_code => x_err_code,
4310: -- If award_id is passed in then use it otherwise use the award_number
4311: -- that is passed in to fetch value of award_id from gms_awards table
4312: -- If both are missing then raise an error.
4313:
4314: IF (p_award_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
4315: AND p_award_number IS NOT NULL)
4316: OR (p_award_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
4317: AND p_award_id IS NOT NULL)
4318: THEN
4312: -- If both are missing then raise an error.
4313:
4314: IF (p_award_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
4315: AND p_award_number IS NOT NULL)
4316: OR (p_award_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
4317: AND p_award_id IS NOT NULL)
4318: THEN
4319: convert_awardnum_to_id(p_award_number_in => p_award_number
4320: ,p_award_id_in => p_award_id
4334:
4335: APP_EXCEPTION.RAISE_EXCEPTION;
4336: END IF;
4337: --------------------------------------------------------------------------------
4338: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after award info validation');
4339:
4340: -- If project_id is passed in then use it otherwise use the project_number
4341: -- (segment1) that is passed in to fetch value of project_id from pa_projects
4342: -- table. If both are missing then raise an error.
4340: -- If project_id is passed in then use it otherwise use the project_number
4341: -- (segment1) that is passed in to fetch value of project_id from pa_projects
4342: -- table. If both are missing then raise an error.
4343:
4344: IF (p_project_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
4345: AND p_project_number IS NOT NULL)
4346: OR (p_project_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
4347: AND p_project_id IS NOT NULL)
4348: THEN
4342: -- table. If both are missing then raise an error.
4343:
4344: IF (p_project_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
4345: AND p_project_number IS NOT NULL)
4346: OR (p_project_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
4347: AND p_project_id IS NOT NULL)
4348: THEN
4349: convert_projnum_to_id(p_project_number_in => p_project_number
4350: ,p_project_id_in => p_project_id
4366: APP_EXCEPTION.RAISE_EXCEPTION;
4367: END IF;
4368:
4369: -------------------------------------------------------------------------------
4370: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after project info validation');
4371:
4372: IF l_project_id IS NULL
4373: THEN
4374: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJECT_IS_MISSING',
4408: APP_EXCEPTION.RAISE_EXCEPTION;
4409: END IF;
4410: END IF;
4411:
4412: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after award security validation');
4413:
4414: -- budget type code is mandatory
4415:
4416: IF p_budget_type_code IS NULL
4439: CLOSE l_budget_amount_code_csr;
4440:
4441: END IF;
4442:
4443: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after budget_amount_code_csr');
4444:
4445: -- Get the budget_version, budget_entry_method_code and resource_list_id from table gms_budget_versions
4446:
4447: OPEN l_budget_version_csr(l_project_id, l_award_id, p_budget_type_code);
4461: END IF;
4462:
4463: CLOSE l_budget_version_csr;
4464:
4465: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after budget_version_csr');
4466:
4467: -- entry method code is mandatory (and a nullible field in table gms_budget_versions)
4468:
4469: IF l_budget_entry_method_code IS NULL
4491: END IF;
4492:
4493: CLOSE l_budget_entry_method_csr;
4494:
4495: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after budget_entry_method_csr');
4496:
4497: -- if both task id and reference are NULL or not passed, we will assume that budgetting is
4498: -- done at the project level and that requires l_task_id to be '0'
4499: -- if budgeting at the project level,then ignore all tasks
4497: -- if both task id and reference are NULL or not passed, we will assume that budgetting is
4498: -- done at the project level and that requires l_task_id to be '0'
4499: -- if budgeting at the project level,then ignore all tasks
4500:
4501: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - entry_lvl_code = '||l_budget_entry_method_rec.entry_level_code);
4502:
4503: IF l_budget_entry_method_rec.entry_level_code = 'P' THEN
4504: l_task_id := 0;
4505: END IF;
4503: IF l_budget_entry_method_rec.entry_level_code = 'P' THEN
4504: l_task_id := 0;
4505: END IF;
4506:
4507: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - before convert_tasknum_to_id = '||to_char(l_project_id));
4508: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - before convert_tasknum_to_id = '||to_char(p_task_id));
4509:
4510: IF l_budget_entry_method_rec.entry_level_code in ('T','L','M')
4511: THEN
4504: l_task_id := 0;
4505: END IF;
4506:
4507: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - before convert_tasknum_to_id = '||to_char(l_project_id));
4508: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - before convert_tasknum_to_id = '||to_char(p_task_id));
4509:
4510: IF l_budget_entry_method_rec.entry_level_code in ('T','L','M')
4511: THEN
4512: convert_tasknum_to_id ( p_project_id_in => l_project_id
4516: ,x_err_code => x_err_code
4517: ,x_err_stage => x_err_stage
4518: ,x_err_stack => x_err_stack);
4519:
4520: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after convert_tasknum_to_id = '||to_char(l_task_id));
4521:
4522: IF x_err_code <> 0
4523: THEN
4524: gms_error_pkg.gms_message(x_err_name => 'GMS_INVALID_TASK_NUMBER',
4592:
4593: APP_EXCEPTION.RAISE_EXCEPTION;
4594: END IF;
4595:
4596: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after gms_budget_utils.get_valid_period_dates');
4597:
4598: -- every budget line need to be checked for it's amount values.
4599:
4600: gms_budget_utils.check_entry_method_flags
4614:
4615: APP_EXCEPTION.RAISE_EXCEPTION;
4616: END IF;
4617:
4618: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after gms_budget_utils.check_entry_method_flags');
4619:
4620: /*
4621: We don't have to validate/convert resource_list info
4622: since we fetch it using cursor ...
4621: We don't have to validate/convert resource_list info
4622: since we fetch it using cursor ...
4623:
4624: -- convert resource_list name to id
4625: IF (p_resource_list_name <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
4626: AND p_resource_list_name IS NOT NULL)
4627: OR (p_resource_list_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
4628: AND p_resource_list_id IS NOT NULL)
4629: THEN
4623:
4624: -- convert resource_list name to id
4625: IF (p_resource_list_name <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
4626: AND p_resource_list_name IS NOT NULL)
4627: OR (p_resource_list_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
4628: AND p_resource_list_id IS NOT NULL)
4629: THEN
4630: convert_reslist_name_to_id
4631: (p_resource_list_name_in => p_resource_list_name
4650: -- and resource member is (passed and not NULL)
4651: -- then we convert the alias to the id
4652: -- else we default to the uncategorized resource member
4653:
4654: IF (p_resource_alias <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
4655: AND p_resource_alias IS NOT NULL)
4656:
4657: OR (p_resource_list_member_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
4658: AND p_resource_list_member_id IS NOT NULL)
4653:
4654: IF (p_resource_alias <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
4655: AND p_resource_alias IS NOT NULL)
4656:
4657: OR (p_resource_list_member_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
4658: AND p_resource_list_member_id IS NOT NULL)
4659: THEN
4660: convert_listmem_alias_to_id
4661: (p_resource_list_id_in => l_resource_list_id -- IN
4681:
4682:
4683: --When budget line description is not passed, set value to NULL
4684:
4685: IF p_description = GMS_BUDGET_PUB.G_PA_MISS_CHAR
4686: THEN
4687: l_description := NULL;
4688: ELSE
4689: l_description := p_description;
4688: ELSE
4689: l_description := p_description;
4690: END IF;
4691:
4692: IF p_period_name = GMS_BUDGET_PUB.G_PA_MISS_CHAR
4693: THEN
4694: l_period_name := NULL;
4695: ELSE
4696: l_period_name := p_period_name;
4696: l_period_name := p_period_name;
4697: END IF;
4698:
4699: --When descriptive flex fields are not passed set them to NULL
4700: IF p_attribute_category = GMS_BUDGET_PUB.G_PA_MISS_CHAR
4701: THEN
4702: l_attribute_category := NULL;
4703: ELSE
4704: l_attribute_category := p_attribute_category;
4702: l_attribute_category := NULL;
4703: ELSE
4704: l_attribute_category := p_attribute_category;
4705: END IF;
4706: IF p_attribute1 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
4707: THEN
4708: l_attribute1 := NULL;
4709: ELSE
4710: l_attribute1 := p_attribute1;
4708: l_attribute1 := NULL;
4709: ELSE
4710: l_attribute1 := p_attribute1;
4711: END IF;
4712: IF p_attribute2 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
4713: THEN
4714: l_attribute2 := NULL;
4715: ELSE
4716: l_attribute2 := p_attribute2;
4714: l_attribute2 := NULL;
4715: ELSE
4716: l_attribute2 := p_attribute2;
4717: END IF;
4718: IF p_attribute3 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
4719: THEN
4720: l_attribute3 := NULL;
4721: ELSE
4722: l_attribute3 := p_attribute3;
4720: l_attribute3 := NULL;
4721: ELSE
4722: l_attribute3 := p_attribute3;
4723: END IF;
4724: IF p_attribute4 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
4725: THEN
4726: l_attribute4 := NULL;
4727: ELSE
4728: l_attribute4 := p_attribute4;
4727: ELSE
4728: l_attribute4 := p_attribute4;
4729: END IF;
4730:
4731: IF p_attribute5 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
4732: THEN
4733: l_attribute5 := NULL;
4734: ELSE
4735: l_attribute5 := p_attribute5;
4734: ELSE
4735: l_attribute5 := p_attribute5;
4736: END IF;
4737:
4738: IF p_attribute6 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
4739: THEN
4740: l_attribute6 := NULL;
4741: ELSE
4742: l_attribute6 := p_attribute6;
4741: ELSE
4742: l_attribute6 := p_attribute6;
4743: END IF;
4744:
4745: IF p_attribute7 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
4746: THEN
4747: l_attribute7 := NULL;
4748: ELSE
4749: l_attribute7 := p_attribute7;
4748: ELSE
4749: l_attribute7 := p_attribute7;
4750: END IF;
4751:
4752: IF p_attribute8 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
4753: THEN
4754: l_attribute8 := NULL;
4755: ELSE
4756: l_attribute8 := p_attribute8;
4754: l_attribute8 := NULL;
4755: ELSE
4756: l_attribute8 := p_attribute8;
4757: END IF;
4758: IF p_attribute9 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
4759: THEN
4760: l_attribute9 := NULL;
4761: ELSE
4762: l_attribute9 := p_attribute9;
4760: l_attribute9 := NULL;
4761: ELSE
4762: l_attribute9 := p_attribute9;
4763: END IF;
4764: IF p_attribute10 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
4765: THEN
4766: l_attribute10 := NULL;
4767: ELSE
4768: l_attribute10 := p_attribute10;
4766: l_attribute10 := NULL;
4767: ELSE
4768: l_attribute10 := p_attribute10;
4769: END IF;
4770: IF p_attribute11 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
4771: THEN
4772: l_attribute11 := NULL;
4773: ELSE
4774: l_attribute11 := p_attribute11;
4772: l_attribute11 := NULL;
4773: ELSE
4774: l_attribute11 := p_attribute11;
4775: END IF;
4776: IF p_attribute12 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
4777: THEN
4778: l_attribute12 := NULL;
4779: ELSE
4780: l_attribute12 := p_attribute12;
4778: l_attribute12 := NULL;
4779: ELSE
4780: l_attribute12 := p_attribute12;
4781: END IF;
4782: IF p_attribute13 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
4783: THEN
4784: l_attribute13 := NULL;
4785: ELSE
4786: l_attribute13 := p_attribute13;
4784: l_attribute13 := NULL;
4785: ELSE
4786: l_attribute13 := p_attribute13;
4787: END IF;
4788: IF p_attribute14 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
4789: THEN
4790: l_attribute14:= NULL;
4791: ELSE
4792: l_attribute14:= p_attribute14;
4791: ELSE
4792: l_attribute14:= p_attribute14;
4793: END IF;
4794:
4795: IF p_attribute15 = GMS_BUDGET_PUB.G_PA_MISS_CHAR
4796: THEN
4797: l_attribute15 := NULL;
4798: ELSE
4799: l_attribute15 := p_attribute15;
4798: ELSE
4799: l_attribute15 := p_attribute15;
4800: END IF;
4801:
4802: IF p_unit_of_measure = GMS_BUDGET_PUB.G_PA_MISS_CHAR
4803: THEN
4804: l_unit_of_measure := NULL;
4805: ELSE
4806: l_unit_of_measure := p_unit_of_measure;
4805: ELSE
4806: l_unit_of_measure := p_unit_of_measure;
4807: END IF;
4808:
4809: IF p_track_as_labor_flag = GMS_BUDGET_PUB.G_PA_MISS_CHAR
4810: THEN
4811: l_track_as_labor_flag := NULL;
4812: ELSE
4813: l_track_as_labor_flag := p_track_as_labor_flag;
4815:
4816: --Remove big numbers in case parameters were not passed, default to NULL; Assign Valid
4817: -- Values to local variables.
4818:
4819: IF p_quantity = GMS_BUDGET_PUB.G_PA_MISS_NUM
4820: THEN
4821: l_quantity := null;
4822: ELSE
4823: l_quantity := p_quantity;
4822: ELSE
4823: l_quantity := p_quantity;
4824: END IF;
4825:
4826: IF p_raw_cost = GMS_BUDGET_PUB.G_PA_MISS_NUM
4827: THEN
4828: l_raw_cost := null;
4829: ELSE
4830: l_raw_cost := p_raw_cost;
4829: ELSE
4830: l_raw_cost := p_raw_cost;
4831: END IF;
4832:
4833: IF p_burdened_cost = GMS_BUDGET_PUB.G_PA_MISS_NUM
4834: THEN
4835: l_burdened_cost := null;
4836: ELSE
4837: l_burdened_cost := p_burdened_cost;
4864: select gms_resource_assignments_s.nextval
4865: into l_resource_assignment_id
4866: from sys.dual;
4867:
4868: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after selecting from sequence');
4869:
4870: -- create a new resource assignment
4871: insert into gms_resource_assignments
4872: (resource_assignment_id,
4906:
4907: APP_EXCEPTION.RAISE_EXCEPTION;
4908: end ;
4909:
4910: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after insert into gms_resource_assignments');
4911:
4912: -- Copy raw cost into burdened cost if budrened cost is null.
4913: -- If the resource UOM is currency and raw cost is null then
4914: -- copy value of quantity amt into raw cost and also set quantity
4930: end if;
4931:
4932: end if;
4933:
4934: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - before insert into gms_budget_lines');
4935:
4936: insert into gms_budget_lines
4937: (resource_assignment_id,
4938: start_date,
5008: p_raw_cost_source,
5009: p_burdened_cost_source
5010: );
5011:
5012: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after insert into gms_budget_lines');
5013:
5014: end if;
5015:
5016: -------------------------------------------------------------------------------------------
5036: end if; -- Time Phased type code
5037:
5038: -- summarizing the totals in the table gms_budget_versions
5039:
5040: GMS_BUDGET_PUB.summerize_project_totals( x_budget_version_id => l_budget_version_id
5041: , x_err_code => x_err_code
5042: , x_err_stage => x_err_stage
5043: , x_err_stack => x_err_stack );
5044:
5127: ( p_api_version_number IN NUMBER
5128: ,x_err_code IN OUT NOCOPY NUMBER
5129: ,x_err_stage IN OUT NOCOPY VARCHAR2
5130: ,x_err_stack IN OUT NOCOPY VARCHAR2
5131: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
5132: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
5133: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5134: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5135: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5128: ,x_err_code IN OUT NOCOPY NUMBER
5129: ,x_err_stage IN OUT NOCOPY VARCHAR2
5130: ,x_err_stack IN OUT NOCOPY VARCHAR2
5131: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
5132: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
5133: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5134: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5135: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5136: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5129: ,x_err_stage IN OUT NOCOPY VARCHAR2
5130: ,x_err_stack IN OUT NOCOPY VARCHAR2
5131: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
5132: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
5133: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5134: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5135: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5136: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5137: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5130: ,x_err_stack IN OUT NOCOPY VARCHAR2
5131: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
5132: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
5133: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5134: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5135: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5136: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5137: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5138: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR )
5131: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
5132: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
5133: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5134: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5135: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5136: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5137: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5138: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR )
5139:
5132: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
5133: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5134: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5135: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5136: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5137: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5138: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR )
5139:
5140: IS
5133: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5134: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5135: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5136: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5137: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5138: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR )
5139:
5140: IS
5141:
5134: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5135: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5136: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5137: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5138: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR )
5139:
5140: IS
5141:
5142: CURSOR l_budget_version_csr
5217: END IF;
5218:
5219: -- product_code is mandatory
5220:
5221: IF p_pm_product_code = GMS_BUDGET_PUB.G_PA_MISS_CHAR
5222: OR p_pm_product_code IS NULL
5223: THEN
5224: gms_error_pkg.gms_message(x_err_name => 'GMS_PRODUCT_CODE_IS_MISSING',
5225: x_err_code => x_err_code,
5232: -- If award_id is passed in then use it otherwise use the award_number
5233: -- that is passed in to fetch value of award_id from gms_awards table
5234: -- If both are missing then raise an error.
5235:
5236: IF (p_award_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
5237: AND p_award_number IS NOT NULL)
5238: OR (p_award_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
5239: AND p_award_id IS NOT NULL)
5240: THEN
5234: -- If both are missing then raise an error.
5235:
5236: IF (p_award_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
5237: AND p_award_number IS NOT NULL)
5238: OR (p_award_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
5239: AND p_award_id IS NOT NULL)
5240: THEN
5241:
5242: convert_awardnum_to_id(p_award_number_in => p_award_number
5282: -- If project_id is passed in then use it otherwise use the project_number
5283: -- (segment1) that is passed in to fetch value of project_id from pa_projects
5284: -- table. If both are missing then raise an error.
5285:
5286: IF (p_project_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
5287: AND p_project_number IS NOT NULL)
5288: OR (p_project_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
5289: AND p_project_id IS NOT NULL)
5290: THEN
5284: -- table. If both are missing then raise an error.
5285:
5286: IF (p_project_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
5287: AND p_project_number IS NOT NULL)
5288: OR (p_project_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
5289: AND p_project_id IS NOT NULL)
5290: THEN
5291: convert_projnum_to_id(p_project_number_in => p_project_number
5292: ,p_project_id_in => p_project_id
5344:
5345: -- budget code is mandatory
5346:
5347: IF p_budget_type_code IS NULL
5348: OR p_budget_type_code = GMS_BUDGET_PUB.G_PA_MISS_CHAR
5349: THEN
5350: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_MISSING',
5351: x_err_code => x_err_code,
5352: x_err_buff => x_err_stage);
5421: and gra.budget_version_id = l_budget_version_id )
5422:
5423: loop
5424:
5425: gms_budget_pub.delete_budget_line
5426: ( p_api_version_number => 1.0
5427: ,p_pm_product_code => 'GMS'
5428: ,p_project_id => l_project_id
5429: ,p_award_id => l_award_id
5500: ( p_api_version_number IN NUMBER
5501: ,x_err_code IN OUT NOCOPY NUMBER
5502: ,x_err_stage IN OUT NOCOPY VARCHAR2
5503: ,x_err_stack IN OUT NOCOPY VARCHAR2
5504: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
5505: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
5506: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5507: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5508: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5501: ,x_err_code IN OUT NOCOPY NUMBER
5502: ,x_err_stage IN OUT NOCOPY VARCHAR2
5503: ,x_err_stack IN OUT NOCOPY VARCHAR2
5504: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
5505: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
5506: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5507: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5508: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5509: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5502: ,x_err_stage IN OUT NOCOPY VARCHAR2
5503: ,x_err_stack IN OUT NOCOPY VARCHAR2
5504: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
5505: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
5506: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5507: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5508: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5509: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5510: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5503: ,x_err_stack IN OUT NOCOPY VARCHAR2
5504: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
5505: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
5506: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5507: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5508: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5509: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5510: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5511: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5504: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
5505: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
5506: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5507: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5508: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5509: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5510: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5511: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5512: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5505: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
5506: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5507: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5508: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5509: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5510: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5511: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5512: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5513: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5506: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5507: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5508: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5509: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5510: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5511: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5512: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5513: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5514: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5507: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5508: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5509: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5510: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5511: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5512: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5513: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5514: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5515: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5508: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5509: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5510: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5511: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5512: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5513: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5514: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5515: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5516: ,p_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
5509: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5510: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5511: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5512: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5513: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5514: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5515: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5516: ,p_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
5517: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR )
5510: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5511: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5512: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5513: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5514: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5515: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5516: ,p_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
5517: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR )
5518:
5511: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5512: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5513: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5514: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5515: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5516: ,p_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
5517: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR )
5518:
5519: IS
5512: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5513: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5514: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5515: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5516: ,p_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
5517: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR )
5518:
5519: IS
5520:
5513: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5514: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
5515: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
5516: ,p_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
5517: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR )
5518:
5519: IS
5520:
5521: CURSOR l_budget_version_csr
5676: END IF;
5677:
5678: -- product_code is mandatory
5679:
5680: IF p_pm_product_code = GMS_BUDGET_PUB.G_PA_MISS_CHAR
5681: OR p_pm_product_code IS NULL
5682: THEN
5683: gms_error_pkg.gms_message(x_err_name => 'GMS_PRODUCT_CODE_IS_MISSING',
5684: x_err_code => x_err_code,
5691: -- If award_id is passed in then use it otherwise use the award_number
5692: -- that is passed in to fetch value of award_id from gms_awards table
5693: -- If both are missing then raise an error.
5694:
5695: IF (p_award_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
5696: AND p_award_number IS NOT NULL)
5697: OR (p_award_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
5698: AND p_award_id IS NOT NULL)
5699: THEN
5693: -- If both are missing then raise an error.
5694:
5695: IF (p_award_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
5696: AND p_award_number IS NOT NULL)
5697: OR (p_award_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
5698: AND p_award_id IS NOT NULL)
5699: THEN
5700: convert_awardnum_to_id(p_award_number_in => p_award_number
5701: ,p_award_id_in => p_award_id
5736: -- If project_id is passed in then use it otherwise use the project_number
5737: -- (segment1) that is passed in to fetch value of project_id from pa_projects
5738: -- table. If both are missing then raise an error.
5739:
5740: IF (p_project_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
5741: AND p_project_number IS NOT NULL)
5742: OR (p_project_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
5743: AND p_project_id IS NOT NULL)
5744: THEN
5738: -- table. If both are missing then raise an error.
5739:
5740: IF (p_project_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
5741: AND p_project_number IS NOT NULL)
5742: OR (p_project_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
5743: AND p_project_id IS NOT NULL)
5744: THEN
5745: convert_projnum_to_id(p_project_number_in => p_project_number
5746: ,p_project_id_in => p_project_id
5798:
5799: -- budget code is mandatory
5800:
5801: IF p_budget_type_code IS NULL
5802: OR p_budget_type_code = GMS_BUDGET_PUB.G_PA_MISS_CHAR
5803: THEN
5804: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_MISSING',
5805: x_err_code => x_err_code,
5806: x_err_buff => x_err_stage);
5849: -- convert pm_task_reference to pa_task_id
5850: -- if both task_id and task_reference are not passed or NULL, then we will default to 0, because this
5851: -- is the value of task_id when budgetting is done at the project level.
5852:
5853: IF (p_task_id = GMS_BUDGET_PUB.G_PA_MISS_NUM
5854: OR p_task_id IS NULL OR p_task_id = 0)
5855: AND (p_task_number = GMS_BUDGET_PUB.G_PA_MISS_CHAR
5856: OR p_task_number IS NULL )
5857:
5851: -- is the value of task_id when budgetting is done at the project level.
5852:
5853: IF (p_task_id = GMS_BUDGET_PUB.G_PA_MISS_NUM
5854: OR p_task_id IS NULL OR p_task_id = 0)
5855: AND (p_task_number = GMS_BUDGET_PUB.G_PA_MISS_CHAR
5856: OR p_task_number IS NULL )
5857:
5858: THEN
5859:
5886: -- and resource member is (passed and not NULL)
5887: -- then we convert the alias to the id
5888: -- else we default to the uncategorized resource member
5889:
5890: IF (p_resource_alias <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
5891: AND p_resource_alias IS NOT NULL)
5892: OR (p_resource_list_member_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
5893: AND p_resource_list_member_id IS NOT NULL)
5894: THEN
5888: -- else we default to the uncategorized resource member
5889:
5890: IF (p_resource_alias <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
5891: AND p_resource_alias IS NOT NULL)
5892: OR (p_resource_list_member_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
5893: AND p_resource_list_member_id IS NOT NULL)
5894: THEN
5895: convert_listmem_alias_to_id
5896: (p_resource_list_id_in => l_resource_list_id -- IN
5943: CLOSE l_budget_entry_method_csr;
5944:
5945:
5946: IF p_period_name IS NOT NULL
5947: AND p_period_name <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
5948: THEN
5949:
5950:
5951: OPEN l_budget_periods_csr( p_period_name => p_period_name
5964: END IF;
5965: CLOSE l_budget_periods_csr;
5966:
5967: ELSIF p_start_date IS NOT NULL
5968: AND p_start_date <> GMS_BUDGET_PUB.G_PA_MISS_DATE
5969: THEN
5970:
5971: -- Condition for 'G' or 'P' time-phased-type code as only
5972: -- required for period phased budgets.
6111:
6112:
6113: --summarizing the totals in the table gms_budget_versions
6114:
6115: GMS_BUDGET_PUB.summerize_project_totals( x_budget_version_id => l_budget_version_id
6116: , x_err_code => x_err_code
6117: , x_err_stage => x_err_stage
6118: , x_err_stack => x_err_stack );
6119:
6190: ( p_api_version_number IN NUMBER
6191: ,x_err_code IN OUT NOCOPY NUMBER
6192: ,x_err_stage IN OUT NOCOPY VARCHAR2
6193: ,x_err_stack IN OUT NOCOPY VARCHAR2
6194: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
6195: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
6196: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6197: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6198: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6191: ,x_err_code IN OUT NOCOPY NUMBER
6192: ,x_err_stage IN OUT NOCOPY VARCHAR2
6193: ,x_err_stack IN OUT NOCOPY VARCHAR2
6194: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
6195: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
6196: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6197: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6198: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6199: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6192: ,x_err_stage IN OUT NOCOPY VARCHAR2
6193: ,x_err_stack IN OUT NOCOPY VARCHAR2
6194: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
6195: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
6196: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6197: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6198: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6199: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6200: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6193: ,x_err_stack IN OUT NOCOPY VARCHAR2
6194: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
6195: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
6196: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6197: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6198: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6199: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6200: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6201: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6194: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
6195: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
6196: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6197: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6198: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6199: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6200: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6201: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6202: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6195: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
6196: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6197: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6198: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6199: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6200: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6201: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6202: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6203: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6196: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6197: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6198: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6199: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6200: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6201: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6202: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6203: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6204: ,p_budget_status_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6197: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6198: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6199: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6200: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6201: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6202: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6203: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6204: ,p_budget_status_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6205: ,p_version_number IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6198: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6199: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6200: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6201: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6202: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6203: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6204: ,p_budget_status_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6205: ,p_version_number IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6206: ,p_current_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6199: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6200: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6201: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6202: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6203: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6204: ,p_budget_status_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6205: ,p_version_number IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6206: ,p_current_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6207: ,p_original_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6200: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6201: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6202: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6203: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6204: ,p_budget_status_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6205: ,p_version_number IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6206: ,p_current_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6207: ,p_original_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6208: ,p_current_original_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6201: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6202: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6203: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6204: ,p_budget_status_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6205: ,p_version_number IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6206: ,p_current_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6207: ,p_original_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6208: ,p_current_original_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6209: ,p_resource_accumulated_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6202: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6203: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6204: ,p_budget_status_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6205: ,p_version_number IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6206: ,p_current_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6207: ,p_original_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6208: ,p_current_original_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6209: ,p_resource_accumulated_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6210: ,p_resource_list_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6203: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6204: ,p_budget_status_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6205: ,p_version_number IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6206: ,p_current_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6207: ,p_original_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6208: ,p_current_original_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6209: ,p_resource_accumulated_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6210: ,p_resource_list_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6211: ,p_version_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6204: ,p_budget_status_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6205: ,p_version_number IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6206: ,p_current_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6207: ,p_original_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6208: ,p_current_original_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6209: ,p_resource_accumulated_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6210: ,p_resource_list_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6211: ,p_version_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6212: ,p_budget_entry_method_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6205: ,p_version_number IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6206: ,p_current_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6207: ,p_original_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6208: ,p_current_original_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6209: ,p_resource_accumulated_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6210: ,p_resource_list_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6211: ,p_version_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6212: ,p_budget_entry_method_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6213: ,p_baselined_by_person_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6206: ,p_current_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6207: ,p_original_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6208: ,p_current_original_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6209: ,p_resource_accumulated_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6210: ,p_resource_list_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6211: ,p_version_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6212: ,p_budget_entry_method_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6213: ,p_baselined_by_person_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6214: ,p_baselined_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6207: ,p_original_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6208: ,p_current_original_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6209: ,p_resource_accumulated_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6210: ,p_resource_list_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6211: ,p_version_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6212: ,p_budget_entry_method_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6213: ,p_baselined_by_person_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6214: ,p_baselined_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6215: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6208: ,p_current_original_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6209: ,p_resource_accumulated_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6210: ,p_resource_list_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6211: ,p_version_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6212: ,p_budget_entry_method_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6213: ,p_baselined_by_person_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6214: ,p_baselined_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6215: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6216: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6209: ,p_resource_accumulated_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6210: ,p_resource_list_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6211: ,p_version_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6212: ,p_budget_entry_method_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6213: ,p_baselined_by_person_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6214: ,p_baselined_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6215: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6216: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6217: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6210: ,p_resource_list_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6211: ,p_version_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6212: ,p_budget_entry_method_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6213: ,p_baselined_by_person_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6214: ,p_baselined_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6215: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6216: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6217: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6218: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6211: ,p_version_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6212: ,p_budget_entry_method_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6213: ,p_baselined_by_person_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6214: ,p_baselined_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6215: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6216: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6217: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6218: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6219: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6212: ,p_budget_entry_method_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6213: ,p_baselined_by_person_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6214: ,p_baselined_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6215: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6216: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6217: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6218: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6219: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6220: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6213: ,p_baselined_by_person_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6214: ,p_baselined_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6215: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6216: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6217: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6218: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6219: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6220: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6221: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6214: ,p_baselined_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6215: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6216: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6217: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6218: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6219: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6220: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6221: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6222: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6215: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6216: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6217: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6218: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6219: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6220: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6221: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6222: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6223: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6216: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6217: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6218: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6219: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6220: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6221: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6222: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6223: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6224: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6217: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6218: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6219: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6220: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6221: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6222: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6223: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6224: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6225: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6218: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6219: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6220: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6221: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6222: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6223: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6224: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6225: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6226: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6219: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6220: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6221: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6222: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6223: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6224: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6225: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6226: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6227: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6220: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6221: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6222: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6223: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6224: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6225: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6226: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6227: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6228: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6221: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6222: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6223: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6224: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6225: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6226: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6227: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6228: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6229: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6222: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6223: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6224: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6225: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6226: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6227: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6228: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6229: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6230: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6223: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6224: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6225: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6226: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6227: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6228: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6229: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6230: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6231: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6224: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6225: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6226: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6227: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6228: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6229: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6230: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6231: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6232: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6225: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6226: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6227: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6228: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6229: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6230: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6231: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6232: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6233: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6226: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6227: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6228: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6229: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6230: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6231: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6232: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6233: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6234: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6227: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6228: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6229: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6230: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6231: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6232: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6233: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6234: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6235: ,p_first_budget_period IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6228: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6229: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6230: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6231: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6232: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6233: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6234: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6235: ,p_first_budget_period IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6236: ,p_wf_status_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR)
6229: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6230: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6231: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6232: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6233: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6234: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6235: ,p_first_budget_period IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6236: ,p_wf_status_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR)
6237:
6230: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6231: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6232: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6233: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6234: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6235: ,p_first_budget_period IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6236: ,p_wf_status_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR)
6237:
6238: IS
6231: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6232: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6233: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6234: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6235: ,p_first_budget_period IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6236: ,p_wf_status_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR)
6237:
6238: IS
6239:
6232: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6233: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6234: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6235: ,p_first_budget_period IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6236: ,p_wf_status_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR)
6237:
6238: IS
6239:
6240:
6357: l_budget_entry_method_code VARCHAR2(30);
6358: l_change_reason_code VARCHAR2(30);
6359: l_description VARCHAR2(255);
6360: l_budget_line_index NUMBER;
6361: -- l_budget_line_in_rec gms_budget_pub.budget_line_in_rec_type;
6362: l_time_phased_type_code VARCHAR2(30);
6363: l_resource_assignment_id NUMBER;
6364: l_budget_start_date DATE;
6365: l_resource_list_id NUMBER;
6417: -- p_multiple_task_msg VARCHAR2(1) := 'T';
6418:
6419: BEGIN
6420:
6421: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET - start');
6422:
6423: x_err_code := 0;
6424: l_old_stack := x_err_stack;
6425: x_err_stack := x_err_stack ||'-> Update_budget';
6452: END IF;
6453:
6454: --product_code is mandatory
6455:
6456: IF p_pm_product_code = GMS_BUDGET_PUB.G_PA_MISS_CHAR
6457: OR p_pm_product_code IS NULL
6458: THEN
6459: gms_error_pkg.gms_message(x_err_name => 'GMS_PRODUCT_CODE_IS_MISSING',
6460: x_err_code => x_err_code,
6467: -- If award_id is passed in then use it otherwise use the award_number
6468: -- that is passed in to fetch value of award_id from gms_awards table
6469: -- If both are missing then raise an error.
6470:
6471: IF (p_award_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
6472: AND p_award_number IS NOT NULL)
6473: OR (p_award_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
6474: AND p_award_id IS NOT NULL)
6475: THEN
6469: -- If both are missing then raise an error.
6470:
6471: IF (p_award_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
6472: AND p_award_number IS NOT NULL)
6473: OR (p_award_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
6474: AND p_award_id IS NOT NULL)
6475: THEN
6476: convert_awardnum_to_id(p_award_number_in => p_award_number
6477: ,p_award_id_in => p_award_id
6491:
6492: APP_EXCEPTION.RAISE_EXCEPTION;
6493: END IF;
6494: --------------------------------------------------------------------------------
6495: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET - after award info validation');
6496:
6497: l_resp_id := FND_GLOBAL.Resp_id;
6498: l_user_id := FND_GLOBAL.User_id;
6499: l_login_id := FND_GLOBAL.Login_id;
6519: -- If project_id is passed in then use it otherwise use the project_number
6520: -- (segment1) that is passed in to fetch value of project_id from pa_projects
6521: -- table. If both are missing then raise an error.
6522:
6523: IF (p_project_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
6524: AND p_project_number IS NOT NULL)
6525: OR (p_project_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
6526: AND p_project_id IS NOT NULL)
6527: THEN
6521: -- table. If both are missing then raise an error.
6522:
6523: IF (p_project_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
6524: AND p_project_number IS NOT NULL)
6525: OR (p_project_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
6526: AND p_project_id IS NOT NULL)
6527: THEN
6528: convert_projnum_to_id(p_project_number_in => p_project_number
6529: ,p_project_id_in => p_project_id
6544:
6545: APP_EXCEPTION.RAISE_EXCEPTION;
6546: END IF;
6547: -------------------------------------------------------------------------------
6548: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET - after project info validation');
6549:
6550: -- Now verify whether award security allows the user to update
6551: -- award
6552: -- If a user does not have privileges to update the award, then
6582:
6583: -- budget type code is mandatory
6584:
6585: IF p_budget_type_code IS NULL
6586: OR p_budget_type_code = GMS_BUDGET_PUB.G_PA_MISS_CHAR
6587: THEN
6588: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_MISSING',
6589: x_err_code => x_err_code,
6590: x_err_buff => x_err_stage);
6642: l_entry_level_code,
6643: l_categorization_code;
6644: CLOSE l_budget_entry_method_csr;
6645:
6646: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET - after locking budget');
6647: -----------------------------------------------------------------------------------------
6648: -- Start of change for Bug:2830539
6649:
6650: -- Validate the Change Reason Code passed in as a parameter
6648: -- Start of change for Bug:2830539
6649:
6650: -- Validate the Change Reason Code passed in as a parameter
6651:
6652: IF (p_change_reason_code <> GMS_BUDGET_PUB.G_PA_MISS_CHAR) THEN
6653:
6654: OPEN l_budget_change_reason_csr (p_change_reason_code);
6655: FETCH l_budget_change_reason_csr INTO l_dummy;
6656:
6670: -- Validate the Budget Entry Method and Resource List passed in as a parameter.
6671: -- Even if either Budget Entry Method or Resource List is passed in then we
6672: -- have to validate against each other.
6673:
6674: IF ((p_budget_entry_method_code <> GMS_BUDGET_PUB.G_PA_MISS_CHAR) or (p_resource_list_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM)) THEN
6675:
6676: validate_bem_resource_list(p_project_id => l_project_id,
6677: p_award_id => l_award_id,
6678: p_budget_entry_method_code => p_budget_entry_method_code,
6685:
6686: -- Bug 3104308 : Validation for p_first_budget_period .This will be fired only for
6687: -- GL/PA budget periods.
6688:
6689: IF (p_first_budget_period <> GMS_BUDGET_PUB.G_PA_MISS_CHAR AND p_first_budget_period IS NOT NULL
6690: AND l_time_phased_type_code IN ('G','P')) THEN
6691:
6692: OPEN l_budget_periods_csr(p_first_budget_period,l_time_phased_type_code);
6693: FETCH l_budget_periods_csr into l_first_budget_period;
6704: OPEN l_lock_budget_csr( l_budget_version_id );
6705:
6706: UPDATE GMS_BUDGET_VERSIONS
6707: SET change_reason_code = decode(p_change_reason_code,
6708: GMS_BUDGET_PUB.G_MISS_CHAR,
6709: change_reason_code,
6710: p_change_reason_code),
6711: budget_entry_method_code = decode(p_budget_entry_method_code,
6712: GMS_BUDGET_PUB.G_MISS_CHAR,
6708: GMS_BUDGET_PUB.G_MISS_CHAR,
6709: change_reason_code,
6710: p_change_reason_code),
6711: budget_entry_method_code = decode(p_budget_entry_method_code,
6712: GMS_BUDGET_PUB.G_MISS_CHAR,
6713: budget_entry_method_code,
6714: p_budget_entry_method_code),
6715: resource_list_id = decode(p_resource_list_id,
6716: GMS_BUDGET_PUB.G_MISS_NUM,
6712: GMS_BUDGET_PUB.G_MISS_CHAR,
6713: budget_entry_method_code,
6714: p_budget_entry_method_code),
6715: resource_list_id = decode(p_resource_list_id,
6716: GMS_BUDGET_PUB.G_MISS_NUM,
6717: resource_list_id,
6718: p_resource_list_id),
6719: current_original_flag = decode(p_current_original_flag,
6720: GMS_BUDGET_PUB.G_MISS_CHAR,
6716: GMS_BUDGET_PUB.G_MISS_NUM,
6717: resource_list_id,
6718: p_resource_list_id),
6719: current_original_flag = decode(p_current_original_flag,
6720: GMS_BUDGET_PUB.G_MISS_CHAR,
6721: current_original_flag,
6722: p_current_original_flag),
6723: budget_status_code = decode(p_budget_status_code,
6724: GMS_BUDGET_PUB.G_MISS_CHAR,
6720: GMS_BUDGET_PUB.G_MISS_CHAR,
6721: current_original_flag,
6722: p_current_original_flag),
6723: budget_status_code = decode(p_budget_status_code,
6724: GMS_BUDGET_PUB.G_MISS_CHAR,
6725: budget_status_code,
6726: p_budget_status_code),
6727: version_name = decode(p_version_name,
6728: GMS_BUDGET_PUB.G_MISS_CHAR,
6724: GMS_BUDGET_PUB.G_MISS_CHAR,
6725: budget_status_code,
6726: p_budget_status_code),
6727: version_name = decode(p_version_name,
6728: GMS_BUDGET_PUB.G_MISS_CHAR,
6729: version_name,
6730: p_version_name),
6731: description = decode(p_description,
6732: GMS_BUDGET_PUB.G_MISS_CHAR,
6728: GMS_BUDGET_PUB.G_MISS_CHAR,
6729: version_name,
6730: p_version_name),
6731: description = decode(p_description,
6732: GMS_BUDGET_PUB.G_MISS_CHAR,
6733: description,
6734: p_description),
6735: attribute_category = decode(p_attribute_category,
6736: GMS_BUDGET_PUB.G_MISS_CHAR,
6732: GMS_BUDGET_PUB.G_MISS_CHAR,
6733: description,
6734: p_description),
6735: attribute_category = decode(p_attribute_category,
6736: GMS_BUDGET_PUB.G_MISS_CHAR,
6737: attribute_category,
6738: p_attribute_category),
6739: attribute1 = decode(p_attribute1,
6740: GMS_BUDGET_PUB.G_MISS_CHAR,
6736: GMS_BUDGET_PUB.G_MISS_CHAR,
6737: attribute_category,
6738: p_attribute_category),
6739: attribute1 = decode(p_attribute1,
6740: GMS_BUDGET_PUB.G_MISS_CHAR,
6741: attribute1,
6742: p_attribute1),
6743: attribute2 = decode(p_attribute2,
6744: GMS_BUDGET_PUB.G_MISS_CHAR,
6740: GMS_BUDGET_PUB.G_MISS_CHAR,
6741: attribute1,
6742: p_attribute1),
6743: attribute2 = decode(p_attribute2,
6744: GMS_BUDGET_PUB.G_MISS_CHAR,
6745: attribute2,
6746: p_attribute2),
6747: attribute3 = decode(p_attribute3,
6748: GMS_BUDGET_PUB.G_MISS_CHAR,
6744: GMS_BUDGET_PUB.G_MISS_CHAR,
6745: attribute2,
6746: p_attribute2),
6747: attribute3 = decode(p_attribute3,
6748: GMS_BUDGET_PUB.G_MISS_CHAR,
6749: attribute3,
6750: p_attribute3),
6751: attribute4 = decode(p_attribute4,
6752: GMS_BUDGET_PUB.G_MISS_CHAR,
6748: GMS_BUDGET_PUB.G_MISS_CHAR,
6749: attribute3,
6750: p_attribute3),
6751: attribute4 = decode(p_attribute4,
6752: GMS_BUDGET_PUB.G_MISS_CHAR,
6753: attribute4,
6754: p_attribute4),
6755: attribute5 = decode(p_attribute5,
6756: GMS_BUDGET_PUB.G_MISS_CHAR,
6752: GMS_BUDGET_PUB.G_MISS_CHAR,
6753: attribute4,
6754: p_attribute4),
6755: attribute5 = decode(p_attribute5,
6756: GMS_BUDGET_PUB.G_MISS_CHAR,
6757: attribute5,
6758: p_attribute5),
6759: attribute6 = decode(p_attribute6,
6760: GMS_BUDGET_PUB.G_MISS_CHAR,
6756: GMS_BUDGET_PUB.G_MISS_CHAR,
6757: attribute5,
6758: p_attribute5),
6759: attribute6 = decode(p_attribute6,
6760: GMS_BUDGET_PUB.G_MISS_CHAR,
6761: attribute6,
6762: p_attribute6),
6763: attribute7 = decode(p_attribute7,
6764: GMS_BUDGET_PUB.G_MISS_CHAR,
6760: GMS_BUDGET_PUB.G_MISS_CHAR,
6761: attribute6,
6762: p_attribute6),
6763: attribute7 = decode(p_attribute7,
6764: GMS_BUDGET_PUB.G_MISS_CHAR,
6765: attribute7,
6766: p_attribute7),
6767: attribute8 = decode(p_attribute8,
6768: GMS_BUDGET_PUB.G_MISS_CHAR,
6764: GMS_BUDGET_PUB.G_MISS_CHAR,
6765: attribute7,
6766: p_attribute7),
6767: attribute8 = decode(p_attribute8,
6768: GMS_BUDGET_PUB.G_MISS_CHAR,
6769: attribute8,
6770: p_attribute8),
6771: attribute9 = decode(p_attribute9,
6772: GMS_BUDGET_PUB.G_MISS_CHAR,
6768: GMS_BUDGET_PUB.G_MISS_CHAR,
6769: attribute8,
6770: p_attribute8),
6771: attribute9 = decode(p_attribute9,
6772: GMS_BUDGET_PUB.G_MISS_CHAR,
6773: attribute9,
6774: p_attribute9),
6775: attribute10 = decode(p_attribute10,
6776: GMS_BUDGET_PUB.G_MISS_CHAR,
6772: GMS_BUDGET_PUB.G_MISS_CHAR,
6773: attribute9,
6774: p_attribute9),
6775: attribute10 = decode(p_attribute10,
6776: GMS_BUDGET_PUB.G_MISS_CHAR,
6777: attribute10,
6778: p_attribute10),
6779: attribute11 = decode(p_attribute11,
6780: GMS_BUDGET_PUB.G_MISS_CHAR,
6776: GMS_BUDGET_PUB.G_MISS_CHAR,
6777: attribute10,
6778: p_attribute10),
6779: attribute11 = decode(p_attribute11,
6780: GMS_BUDGET_PUB.G_MISS_CHAR,
6781: attribute11),
6782: attribute12 = decode(p_attribute12,
6783: GMS_BUDGET_PUB.G_MISS_CHAR,
6784: attribute12,
6779: attribute11 = decode(p_attribute11,
6780: GMS_BUDGET_PUB.G_MISS_CHAR,
6781: attribute11),
6782: attribute12 = decode(p_attribute12,
6783: GMS_BUDGET_PUB.G_MISS_CHAR,
6784: attribute12,
6785: p_attribute12),
6786: attribute13 = decode(p_attribute13,
6787: GMS_BUDGET_PUB.G_MISS_CHAR,
6783: GMS_BUDGET_PUB.G_MISS_CHAR,
6784: attribute12,
6785: p_attribute12),
6786: attribute13 = decode(p_attribute13,
6787: GMS_BUDGET_PUB.G_MISS_CHAR,
6788: attribute13,
6789: p_attribute13),
6790: attribute14 = decode(p_attribute14,
6791: GMS_BUDGET_PUB.G_MISS_CHAR,
6787: GMS_BUDGET_PUB.G_MISS_CHAR,
6788: attribute13,
6789: p_attribute13),
6790: attribute14 = decode(p_attribute14,
6791: GMS_BUDGET_PUB.G_MISS_CHAR,
6792: attribute14,
6793: p_attribute14),
6794: attribute15 = decode(p_attribute15,
6795: GMS_BUDGET_PUB.G_MISS_CHAR,
6791: GMS_BUDGET_PUB.G_MISS_CHAR,
6792: attribute14,
6793: p_attribute14),
6794: attribute15 = decode(p_attribute15,
6795: GMS_BUDGET_PUB.G_MISS_CHAR,
6796: attribute15,
6797: p_attribute15),
6798: last_update_date = SYSDATE,
6799: last_updated_by = G_USER_ID,
6798: last_update_date = SYSDATE,
6799: last_updated_by = G_USER_ID,
6800: last_update_login = G_LOGIN_ID,
6801: first_budget_period = decode(p_first_budget_period,
6802: GMS_BUDGET_PUB.G_MISS_CHAR,
6803: first_budget_period,
6804: p_first_budget_period ) --Bug 3104308 : Added first_budget_period column in update
6805: WHERE budget_version_id = l_budget_version_id;
6806:
6830: end if; -- l_time_phased_type_code
6831:
6832: --summarizing the totals in the table gms_budget_versions
6833:
6834: gms_budget_pub.summerize_project_totals( x_budget_version_id => l_budget_version_id
6835: , x_err_code => x_err_code
6836: , x_err_stage => x_err_stage
6837: , x_err_stack => x_err_stack );
6838:
6881: ( p_api_version_number IN NUMBER
6882: ,x_err_code IN OUT NOCOPY NUMBER
6883: ,x_err_stage IN OUT NOCOPY VARCHAR2
6884: ,x_err_stack IN OUT NOCOPY VARCHAR2
6885: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
6886: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
6887: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6888: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6889: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6882: ,x_err_code IN OUT NOCOPY NUMBER
6883: ,x_err_stage IN OUT NOCOPY VARCHAR2
6884: ,x_err_stack IN OUT NOCOPY VARCHAR2
6885: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
6886: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
6887: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6888: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6889: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6890: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6883: ,x_err_stage IN OUT NOCOPY VARCHAR2
6884: ,x_err_stack IN OUT NOCOPY VARCHAR2
6885: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
6886: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
6887: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6888: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6889: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6890: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6891: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6884: ,x_err_stack IN OUT NOCOPY VARCHAR2
6885: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
6886: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
6887: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6888: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6889: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6890: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6891: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6892: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6885: ,p_commit IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
6886: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
6887: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6888: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6889: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6890: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6891: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6892: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6893: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6886: ,p_init_msg_list IN VARCHAR2 := GMS_BUDGET_PUB.G_GMS_FALSE
6887: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6888: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6889: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6890: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6891: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6892: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6893: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6894: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6887: ,p_pm_product_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6888: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6889: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6890: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6891: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6892: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6893: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6894: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6895: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6888: ,p_project_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6889: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6890: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6891: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6892: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6893: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6894: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6895: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6896: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6889: ,p_project_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6890: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6891: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6892: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6893: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6894: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6895: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6896: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6897: ,p_budget_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6890: ,p_budget_type_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6891: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6892: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6893: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6894: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6895: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6896: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6897: ,p_budget_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6898: ,p_budget_end_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6891: ,p_task_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6892: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6893: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6894: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6895: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6896: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6897: ,p_budget_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6898: ,p_budget_end_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6899: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6892: ,p_task_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6893: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6894: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6895: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6896: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6897: ,p_budget_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6898: ,p_budget_end_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6899: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6900: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6893: ,p_award_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6894: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6895: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6896: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6897: ,p_budget_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6898: ,p_budget_end_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6899: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6900: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6901: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6894: ,p_award_number IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6895: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6896: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6897: ,p_budget_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6898: ,p_budget_end_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6899: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6900: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6901: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6902: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6895: ,p_resource_alias IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6896: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6897: ,p_budget_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6898: ,p_budget_end_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6899: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6900: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6901: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6902: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6903: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6896: ,p_resource_list_member_id IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6897: ,p_budget_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6898: ,p_budget_end_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6899: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6900: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6901: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6902: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6903: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6904: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6897: ,p_budget_start_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6898: ,p_budget_end_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6899: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6900: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6901: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6902: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6903: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6904: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6905: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6898: ,p_budget_end_date IN DATE := GMS_BUDGET_PUB.G_PA_MISS_DATE
6899: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6900: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6901: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6902: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6903: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6904: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6905: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6906: ,p_track_as_labor_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6899: ,p_period_name IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6900: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6901: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6902: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6903: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6904: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6905: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6906: ,p_track_as_labor_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6907: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6900: ,p_description IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6901: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6902: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6903: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6904: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6905: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6906: ,p_track_as_labor_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6907: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6908: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6901: ,p_change_reason_code IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6902: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6903: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6904: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6905: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6906: ,p_track_as_labor_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6907: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6908: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6909: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6902: ,p_raw_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6903: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6904: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6905: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6906: ,p_track_as_labor_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6907: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6908: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6909: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6910: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6903: ,p_burdened_cost IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6904: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6905: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6906: ,p_track_as_labor_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6907: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6908: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6909: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6910: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6911: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6904: ,p_quantity IN NUMBER := GMS_BUDGET_PUB.G_PA_MISS_NUM
6905: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6906: ,p_track_as_labor_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6907: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6908: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6909: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6910: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6911: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6912: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6905: ,p_unit_of_measure IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6906: ,p_track_as_labor_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6907: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6908: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6909: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6910: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6911: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6912: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6913: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6906: ,p_track_as_labor_flag IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6907: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6908: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6909: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6910: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6911: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6912: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6913: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6914: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6907: ,p_attribute_category IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6908: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6909: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6910: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6911: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6912: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6913: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6914: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6915: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6908: ,p_attribute1 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6909: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6910: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6911: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6912: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6913: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6914: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6915: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6916: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6909: ,p_attribute2 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6910: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6911: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6912: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6913: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6914: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6915: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6916: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6917: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6910: ,p_attribute3 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6911: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6912: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6913: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6914: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6915: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6916: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6917: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6918: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6911: ,p_attribute4 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6912: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6913: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6914: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6915: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6916: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6917: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6918: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6919: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6912: ,p_attribute5 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6913: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6914: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6915: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6916: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6917: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6918: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6919: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6920: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6913: ,p_attribute6 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6914: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6915: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6916: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6917: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6918: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6919: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6920: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6921: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6914: ,p_attribute7 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6915: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6916: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6917: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6918: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6919: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6920: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6921: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6922: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6915: ,p_attribute8 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6916: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6917: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6918: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6919: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6920: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6921: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6922: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6923: ,p_raw_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6916: ,p_attribute9 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6917: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6918: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6919: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6920: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6921: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6922: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6923: ,p_raw_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6924: ,p_burdened_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6917: ,p_attribute10 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6918: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6919: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6920: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6921: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6922: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6923: ,p_raw_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6924: ,p_burdened_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6925: ,p_quantity_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6918: ,p_attribute11 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6919: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6920: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6921: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6922: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6923: ,p_raw_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6924: ,p_burdened_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6925: ,p_quantity_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6926: )
6919: ,p_attribute12 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6920: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6921: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6922: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6923: ,p_raw_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6924: ,p_burdened_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6925: ,p_quantity_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6926: )
6927: IS
6920: ,p_attribute13 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6921: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6922: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6923: ,p_raw_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6924: ,p_burdened_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6925: ,p_quantity_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6926: )
6927: IS
6928:
6921: ,p_attribute14 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6922: ,p_attribute15 IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6923: ,p_raw_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6924: ,p_burdened_cost_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6925: ,p_quantity_source IN VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
6926: )
6927: IS
6928:
6929:
7102: l_old_stack VARCHAR2(630);
7103:
7104: BEGIN -- update_budget_line
7105:
7106: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET_LINE - start');
7107:
7108: x_err_code := 0;
7109: l_old_stack := x_err_stack;
7110: x_err_stack := x_err_stack ||'-> Update_Budget_Line';
7138: END IF;
7139:
7140: --product_code is mandatory
7141:
7142: IF p_pm_product_code = GMS_BUDGET_PUB.G_PA_MISS_CHAR
7143: OR p_pm_product_code IS NULL
7144: THEN
7145: gms_error_pkg.gms_message(x_err_name => 'GMS_PRODUCT_CODE_MISSING',
7146: x_err_code => x_err_code,
7153: -- If award_id is passed in then use it otherwise use the award_number
7154: -- that is passed in to fetch value of award_id from gms_awards table
7155: -- If both are missing then raise an error.
7156:
7157: IF (p_award_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
7158: AND p_award_number IS NOT NULL)
7159: OR (p_award_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
7160: AND p_award_id IS NOT NULL)
7161: THEN
7155: -- If both are missing then raise an error.
7156:
7157: IF (p_award_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
7158: AND p_award_number IS NOT NULL)
7159: OR (p_award_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
7160: AND p_award_id IS NOT NULL)
7161: THEN
7162: convert_awardnum_to_id(p_award_number_in => p_award_number
7163: ,p_award_id_in => p_award_id
7178: APP_EXCEPTION.RAISE_EXCEPTION;
7179: END IF;
7180: --------------------------------------------------------------------------------
7181:
7182: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET_LINE - after award info validation');
7183:
7184: l_resp_id := FND_GLOBAL.Resp_id;
7185: l_user_id := FND_GLOBAL.User_id;
7186: l_login_id := FND_GLOBAL.login_id;
7201: -- If project_id is passed in then use it otherwise use the project_number
7202: -- (segment1) that is passed in to fetch value of project_id from pa_projects
7203: -- table. If both are missing then raise an error.
7204:
7205: IF (p_project_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
7206: AND p_project_number IS NOT NULL)
7207: OR (p_project_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
7208: AND p_project_id IS NOT NULL)
7209: THEN
7203: -- table. If both are missing then raise an error.
7204:
7205: IF (p_project_number <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
7206: AND p_project_number IS NOT NULL)
7207: OR (p_project_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
7208: AND p_project_id IS NOT NULL)
7209: THEN
7210: convert_projnum_to_id(p_project_number_in => p_project_number
7211: ,p_project_id_in => p_project_id
7227: APP_EXCEPTION.RAISE_EXCEPTION;
7228: END IF;
7229: -------------------------------------------------------------------------------
7230:
7231: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET_LINE - after project info validation');
7232:
7233: IF l_project_id IS NULL
7234: THEN
7235: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJECT_MISSING',
7275: -- budget type code is mandatory
7276: -- dbms_output.put_line('Checking budget type code');
7277:
7278: IF p_budget_type_code IS NULL
7279: OR p_budget_type_code = GMS_BUDGET_PUB.G_PA_MISS_CHAR
7280: THEN
7281: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_MISSING',
7282: x_err_code => x_err_code,
7283: x_err_buff => x_err_stage);
7353: END IF;
7354:
7355: CLOSE l_budget_entry_method_csr;
7356:
7357: IF p_period_name <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
7358: AND p_period_name IS NOT NULL
7359: THEN
7360:
7361: OPEN l_budget_periods_csr( p_period_name
7373: END IF;
7374:
7375: CLOSE l_budget_periods_csr;
7376:
7377: ELSIF p_budget_start_date <> GMS_BUDGET_PUB.G_PA_MISS_DATE
7378: AND p_budget_start_date IS NOT NULL
7379: THEN
7380:
7381: l_budget_start_date := trunc(p_budget_start_date);
7381: l_budget_start_date := trunc(p_budget_start_date);
7382:
7383: -- if a valid p_budget_end_date is passed in then use it to update the table
7384:
7385: IF p_budget_end_date <> GMS_BUDGET_PUB.G_PA_MISS_DATE AND p_budget_end_date IS NOT NULL
7386: THEN
7387: l_budget_end_date := trunc(p_budget_end_date);
7388: END IF;
7389: ELSE
7399: -- if both task id and number are not passed or NULL, we will assume that budgetting is
7400: -- done at the project level and that requires l_task_id to be '0'
7401:
7402:
7403: IF (p_task_id = GMS_BUDGET_PUB.G_PA_MISS_NUM
7404: OR p_task_id IS NULL OR p_task_id = 0 )
7405: AND (p_task_number = GMS_BUDGET_PUB.G_PA_MISS_CHAR
7406: OR p_task_number IS NULL )
7407: THEN
7401:
7402:
7403: IF (p_task_id = GMS_BUDGET_PUB.G_PA_MISS_NUM
7404: OR p_task_id IS NULL OR p_task_id = 0 )
7405: AND (p_task_number = GMS_BUDGET_PUB.G_PA_MISS_CHAR
7406: OR p_task_number IS NULL )
7407: THEN
7408:
7409: l_task_id := 0;
7433: -- and resource member is (passed and not NULL)
7434: -- then we convert the alias to the id
7435: -- else we default to the uncategorized resource member
7436:
7437: IF (p_resource_alias <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
7438: AND p_resource_alias IS NOT NULL)
7439:
7440: OR (p_resource_list_member_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
7441: AND p_resource_list_member_id IS NOT NULL)
7436:
7437: IF (p_resource_alias <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
7438: AND p_resource_alias IS NOT NULL)
7439:
7440: OR (p_resource_list_member_id <> GMS_BUDGET_PUB.G_PA_MISS_NUM
7441: AND p_resource_list_member_id IS NOT NULL)
7442: THEN
7443: convert_listmem_alias_to_id
7444: (p_resource_list_id_in => l_resource_list_id -- IN
7502: END IF;
7503:
7504: CLOSE l_resource_csr;
7505:
7506: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET_LINE - after resource info validation');
7507:
7508: --get the resource assignment id
7509:
7510: OPEN l_resource_assignment_csr( l_budget_version_id
7524: END IF;
7525:
7526: CLOSE l_resource_assignment_csr;
7527:
7528: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET_LINE - after checking existence of resource assignment');
7529:
7530: -- dbms_output.put_line('Checking existence of budget line');
7531: OPEN l_budget_line_csr( l_resource_assignment_id
7532: ,l_budget_start_date );
7548: CLOSE l_budget_line_csr;
7549: ------------------------------------------------------------------------------------------------------
7550: -- Start of changes for Bug:2830539
7551:
7552: IF p_change_reason_code <> GMS_BUDGET_PUB.G_PA_MISS_CHAR THEN
7553:
7554: OPEN l_budget_change_reason_csr (p_change_reason_code);
7555: FETCH l_budget_change_reason_csr INTO l_dummy;
7556:
7567: CLOSE l_budget_change_reason_csr;
7568:
7569: END IF;
7570:
7571: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET_LINE - after checking existence of budget line');
7572:
7573: -- Once the above validations have passed update the GMS_BUDGET_LINES table
7574: -- with the appropriate values.
7575:
7576: OPEN l_lock_budget_line_csr( l_budget_line_rowid );
7577:
7578: UPDATE GMS_BUDGET_LINES
7579: SET change_reason_code = decode(p_change_reason_code,
7580: GMS_BUDGET_PUB.G_MISS_CHAR,
7581: change_reason_code,
7582: p_change_reason_code),
7583: burdened_cost = decode(p_burdened_cost,
7584: GMS_BUDGET_PUB.G_MISS_NUM,
7580: GMS_BUDGET_PUB.G_MISS_CHAR,
7581: change_reason_code,
7582: p_change_reason_code),
7583: burdened_cost = decode(p_burdened_cost,
7584: GMS_BUDGET_PUB.G_MISS_NUM,
7585: burdened_cost,
7586: p_burdened_cost),
7587: description = decode(p_description,
7588: GMS_BUDGET_PUB.G_MISS_CHAR,
7584: GMS_BUDGET_PUB.G_MISS_NUM,
7585: burdened_cost,
7586: p_burdened_cost),
7587: description = decode(p_description,
7588: GMS_BUDGET_PUB.G_MISS_CHAR,
7589: description,
7590: p_description),
7591: attribute_category = decode(p_attribute_category,
7592: GMS_BUDGET_PUB.G_MISS_CHAR,
7588: GMS_BUDGET_PUB.G_MISS_CHAR,
7589: description,
7590: p_description),
7591: attribute_category = decode(p_attribute_category,
7592: GMS_BUDGET_PUB.G_MISS_CHAR,
7593: attribute_category,
7594: p_attribute_category),
7595: attribute1 = decode(p_attribute1,
7596: GMS_BUDGET_PUB.G_MISS_CHAR,
7592: GMS_BUDGET_PUB.G_MISS_CHAR,
7593: attribute_category,
7594: p_attribute_category),
7595: attribute1 = decode(p_attribute1,
7596: GMS_BUDGET_PUB.G_MISS_CHAR,
7597: attribute1,
7598: p_attribute1),
7599: attribute2 = decode(p_attribute2,
7600: GMS_BUDGET_PUB.G_MISS_CHAR,
7596: GMS_BUDGET_PUB.G_MISS_CHAR,
7597: attribute1,
7598: p_attribute1),
7599: attribute2 = decode(p_attribute2,
7600: GMS_BUDGET_PUB.G_MISS_CHAR,
7601: attribute2,
7602: p_attribute2),
7603: attribute3 = decode(p_attribute3,
7604: GMS_BUDGET_PUB.G_MISS_CHAR,
7600: GMS_BUDGET_PUB.G_MISS_CHAR,
7601: attribute2,
7602: p_attribute2),
7603: attribute3 = decode(p_attribute3,
7604: GMS_BUDGET_PUB.G_MISS_CHAR,
7605: attribute3,
7606: p_attribute3),
7607: attribute4 = decode(p_attribute4,
7608: GMS_BUDGET_PUB.G_MISS_CHAR,
7604: GMS_BUDGET_PUB.G_MISS_CHAR,
7605: attribute3,
7606: p_attribute3),
7607: attribute4 = decode(p_attribute4,
7608: GMS_BUDGET_PUB.G_MISS_CHAR,
7609: attribute4,
7610: p_attribute4),
7611: attribute5 = decode(p_attribute5,
7612: GMS_BUDGET_PUB.G_MISS_CHAR,
7608: GMS_BUDGET_PUB.G_MISS_CHAR,
7609: attribute4,
7610: p_attribute4),
7611: attribute5 = decode(p_attribute5,
7612: GMS_BUDGET_PUB.G_MISS_CHAR,
7613: attribute5,
7614: p_attribute5),
7615: attribute6 = decode(p_attribute6,
7616: GMS_BUDGET_PUB.G_MISS_CHAR,
7612: GMS_BUDGET_PUB.G_MISS_CHAR,
7613: attribute5,
7614: p_attribute5),
7615: attribute6 = decode(p_attribute6,
7616: GMS_BUDGET_PUB.G_MISS_CHAR,
7617: attribute6,
7618: p_attribute6),
7619: attribute7 = decode(p_attribute7,
7620: GMS_BUDGET_PUB.G_MISS_CHAR,
7616: GMS_BUDGET_PUB.G_MISS_CHAR,
7617: attribute6,
7618: p_attribute6),
7619: attribute7 = decode(p_attribute7,
7620: GMS_BUDGET_PUB.G_MISS_CHAR,
7621: attribute7,
7622: p_attribute7),
7623: attribute8 = decode(p_attribute8,
7624: GMS_BUDGET_PUB.G_MISS_CHAR,
7620: GMS_BUDGET_PUB.G_MISS_CHAR,
7621: attribute7,
7622: p_attribute7),
7623: attribute8 = decode(p_attribute8,
7624: GMS_BUDGET_PUB.G_MISS_CHAR,
7625: attribute8,
7626: p_attribute8),
7627: attribute9 = decode(p_attribute9,
7628: GMS_BUDGET_PUB.G_MISS_CHAR,
7624: GMS_BUDGET_PUB.G_MISS_CHAR,
7625: attribute8,
7626: p_attribute8),
7627: attribute9 = decode(p_attribute9,
7628: GMS_BUDGET_PUB.G_MISS_CHAR,
7629: attribute9,
7630: p_attribute9),
7631: attribute10 = decode(p_attribute10,
7632: GMS_BUDGET_PUB.G_MISS_CHAR,
7628: GMS_BUDGET_PUB.G_MISS_CHAR,
7629: attribute9,
7630: p_attribute9),
7631: attribute10 = decode(p_attribute10,
7632: GMS_BUDGET_PUB.G_MISS_CHAR,
7633: attribute10,
7634: p_attribute10),
7635: attribute11 = decode(p_attribute11,
7636: GMS_BUDGET_PUB.G_MISS_CHAR,
7632: GMS_BUDGET_PUB.G_MISS_CHAR,
7633: attribute10,
7634: p_attribute10),
7635: attribute11 = decode(p_attribute11,
7636: GMS_BUDGET_PUB.G_MISS_CHAR,
7637: attribute11),
7638: attribute12 = decode(p_attribute12,
7639: GMS_BUDGET_PUB.G_MISS_CHAR,
7640: attribute12,
7635: attribute11 = decode(p_attribute11,
7636: GMS_BUDGET_PUB.G_MISS_CHAR,
7637: attribute11),
7638: attribute12 = decode(p_attribute12,
7639: GMS_BUDGET_PUB.G_MISS_CHAR,
7640: attribute12,
7641: p_attribute12),
7642: attribute13 = decode(p_attribute13,
7643: GMS_BUDGET_PUB.G_MISS_CHAR,
7639: GMS_BUDGET_PUB.G_MISS_CHAR,
7640: attribute12,
7641: p_attribute12),
7642: attribute13 = decode(p_attribute13,
7643: GMS_BUDGET_PUB.G_MISS_CHAR,
7644: attribute13,
7645: p_attribute13),
7646: attribute14 = decode(p_attribute14,
7647: GMS_BUDGET_PUB.G_MISS_CHAR,
7643: GMS_BUDGET_PUB.G_MISS_CHAR,
7644: attribute13,
7645: p_attribute13),
7646: attribute14 = decode(p_attribute14,
7647: GMS_BUDGET_PUB.G_MISS_CHAR,
7648: attribute14,
7649: p_attribute14),
7650: attribute15 = decode(p_attribute15,
7651: GMS_BUDGET_PUB.G_MISS_CHAR,
7647: GMS_BUDGET_PUB.G_MISS_CHAR,
7648: attribute14,
7649: p_attribute14),
7650: attribute15 = decode(p_attribute15,
7651: GMS_BUDGET_PUB.G_MISS_CHAR,
7652: attribute15,
7653: p_attribute15),
7654: last_update_date = SYSDATE,
7655: last_updated_by = G_USER_ID,
7664: ----------------------------------------------------------------------------------
7665:
7666: --We don't have to check for overlapping dates because begin and and date can not be changed.
7667:
7668: GMS_BUDGET_PUB.summerize_project_totals( x_budget_version_id => l_budget_version_id
7669: , x_err_code => x_err_code
7670: , x_err_stage => x_err_stage
7671: , x_err_stack => x_err_stack );
7672:
7728:
7729: END update_budget_line;
7730: ----------------------------------------------------------------------------------------
7731:
7732: end GMS_BUDGET_PUB;