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