eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_BUDGET_VERSIONS_PKG dependencies on PA_BUDGET_VERSIONS

Line 27: (px_budget_version_id IN OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895

23: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PA_FP_BUDGET_VERSIONS_PKG';
24: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pafpbvtb.pls';
25:
26: PROCEDURE Insert_Row
27: (px_budget_version_id IN OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
28: ,p_project_id IN pa_budget_versions.project_id%TYPE
29: := FND_API.G_MISS_NUM
30: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
31: := FND_API.G_MISS_CHAR

Line 28: ,p_project_id IN pa_budget_versions.project_id%TYPE

24: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pafpbvtb.pls';
25:
26: PROCEDURE Insert_Row
27: (px_budget_version_id IN OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
28: ,p_project_id IN pa_budget_versions.project_id%TYPE
29: := FND_API.G_MISS_NUM
30: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
31: := FND_API.G_MISS_CHAR
32: ,p_version_number IN pa_budget_versions.version_number%TYPE

Line 30: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE

26: PROCEDURE Insert_Row
27: (px_budget_version_id IN OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
28: ,p_project_id IN pa_budget_versions.project_id%TYPE
29: := FND_API.G_MISS_NUM
30: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
31: := FND_API.G_MISS_CHAR
32: ,p_version_number IN pa_budget_versions.version_number%TYPE
33: := FND_API.G_MISS_NUM
34: ,p_budget_status_code IN pa_budget_versions.budget_status_code%TYPE

Line 32: ,p_version_number IN pa_budget_versions.version_number%TYPE

28: ,p_project_id IN pa_budget_versions.project_id%TYPE
29: := FND_API.G_MISS_NUM
30: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
31: := FND_API.G_MISS_CHAR
32: ,p_version_number IN pa_budget_versions.version_number%TYPE
33: := FND_API.G_MISS_NUM
34: ,p_budget_status_code IN pa_budget_versions.budget_status_code%TYPE
35: := FND_API.G_MISS_CHAR
36: ,p_current_flag IN pa_budget_versions.current_flag%TYPE

Line 34: ,p_budget_status_code IN pa_budget_versions.budget_status_code%TYPE

30: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
31: := FND_API.G_MISS_CHAR
32: ,p_version_number IN pa_budget_versions.version_number%TYPE
33: := FND_API.G_MISS_NUM
34: ,p_budget_status_code IN pa_budget_versions.budget_status_code%TYPE
35: := FND_API.G_MISS_CHAR
36: ,p_current_flag IN pa_budget_versions.current_flag%TYPE
37: := FND_API.G_MISS_CHAR
38: ,p_original_flag IN pa_budget_versions.original_flag%TYPE

Line 36: ,p_current_flag IN pa_budget_versions.current_flag%TYPE

32: ,p_version_number IN pa_budget_versions.version_number%TYPE
33: := FND_API.G_MISS_NUM
34: ,p_budget_status_code IN pa_budget_versions.budget_status_code%TYPE
35: := FND_API.G_MISS_CHAR
36: ,p_current_flag IN pa_budget_versions.current_flag%TYPE
37: := FND_API.G_MISS_CHAR
38: ,p_original_flag IN pa_budget_versions.original_flag%TYPE
39: := FND_API.G_MISS_CHAR
40: ,p_current_original_flag IN pa_budget_versions.current_original_flag%TYPE

Line 38: ,p_original_flag IN pa_budget_versions.original_flag%TYPE

34: ,p_budget_status_code IN pa_budget_versions.budget_status_code%TYPE
35: := FND_API.G_MISS_CHAR
36: ,p_current_flag IN pa_budget_versions.current_flag%TYPE
37: := FND_API.G_MISS_CHAR
38: ,p_original_flag IN pa_budget_versions.original_flag%TYPE
39: := FND_API.G_MISS_CHAR
40: ,p_current_original_flag IN pa_budget_versions.current_original_flag%TYPE
41: := FND_API.G_MISS_CHAR
42: ,p_resource_accumulated_flag IN pa_budget_versions.resource_accumulated_flag%TYPE

Line 40: ,p_current_original_flag IN pa_budget_versions.current_original_flag%TYPE

36: ,p_current_flag IN pa_budget_versions.current_flag%TYPE
37: := FND_API.G_MISS_CHAR
38: ,p_original_flag IN pa_budget_versions.original_flag%TYPE
39: := FND_API.G_MISS_CHAR
40: ,p_current_original_flag IN pa_budget_versions.current_original_flag%TYPE
41: := FND_API.G_MISS_CHAR
42: ,p_resource_accumulated_flag IN pa_budget_versions.resource_accumulated_flag%TYPE
43: := FND_API.G_MISS_CHAR
44: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE

Line 42: ,p_resource_accumulated_flag IN pa_budget_versions.resource_accumulated_flag%TYPE

38: ,p_original_flag IN pa_budget_versions.original_flag%TYPE
39: := FND_API.G_MISS_CHAR
40: ,p_current_original_flag IN pa_budget_versions.current_original_flag%TYPE
41: := FND_API.G_MISS_CHAR
42: ,p_resource_accumulated_flag IN pa_budget_versions.resource_accumulated_flag%TYPE
43: := FND_API.G_MISS_CHAR
44: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
45: := FND_API.G_MISS_NUM
46: ,p_version_name IN pa_budget_versions.version_name%TYPE

Line 44: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE

40: ,p_current_original_flag IN pa_budget_versions.current_original_flag%TYPE
41: := FND_API.G_MISS_CHAR
42: ,p_resource_accumulated_flag IN pa_budget_versions.resource_accumulated_flag%TYPE
43: := FND_API.G_MISS_CHAR
44: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
45: := FND_API.G_MISS_NUM
46: ,p_version_name IN pa_budget_versions.version_name%TYPE
47: := FND_API.G_MISS_CHAR
48: ,p_budget_entry_method_code IN pa_budget_versions.budget_entry_method_code%TYPE

Line 46: ,p_version_name IN pa_budget_versions.version_name%TYPE

42: ,p_resource_accumulated_flag IN pa_budget_versions.resource_accumulated_flag%TYPE
43: := FND_API.G_MISS_CHAR
44: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
45: := FND_API.G_MISS_NUM
46: ,p_version_name IN pa_budget_versions.version_name%TYPE
47: := FND_API.G_MISS_CHAR
48: ,p_budget_entry_method_code IN pa_budget_versions.budget_entry_method_code%TYPE
49: := FND_API.G_MISS_CHAR
50: ,p_baselined_by_person_id IN pa_budget_versions.baselined_by_person_id%TYPE

Line 48: ,p_budget_entry_method_code IN pa_budget_versions.budget_entry_method_code%TYPE

44: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
45: := FND_API.G_MISS_NUM
46: ,p_version_name IN pa_budget_versions.version_name%TYPE
47: := FND_API.G_MISS_CHAR
48: ,p_budget_entry_method_code IN pa_budget_versions.budget_entry_method_code%TYPE
49: := FND_API.G_MISS_CHAR
50: ,p_baselined_by_person_id IN pa_budget_versions.baselined_by_person_id%TYPE
51: := FND_API.G_MISS_NUM
52: ,p_baselined_date IN pa_budget_versions.baselined_date%TYPE

Line 50: ,p_baselined_by_person_id IN pa_budget_versions.baselined_by_person_id%TYPE

46: ,p_version_name IN pa_budget_versions.version_name%TYPE
47: := FND_API.G_MISS_CHAR
48: ,p_budget_entry_method_code IN pa_budget_versions.budget_entry_method_code%TYPE
49: := FND_API.G_MISS_CHAR
50: ,p_baselined_by_person_id IN pa_budget_versions.baselined_by_person_id%TYPE
51: := FND_API.G_MISS_NUM
52: ,p_baselined_date IN pa_budget_versions.baselined_date%TYPE
53: := FND_API.G_MISS_DATE
54: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE

Line 52: ,p_baselined_date IN pa_budget_versions.baselined_date%TYPE

48: ,p_budget_entry_method_code IN pa_budget_versions.budget_entry_method_code%TYPE
49: := FND_API.G_MISS_CHAR
50: ,p_baselined_by_person_id IN pa_budget_versions.baselined_by_person_id%TYPE
51: := FND_API.G_MISS_NUM
52: ,p_baselined_date IN pa_budget_versions.baselined_date%TYPE
53: := FND_API.G_MISS_DATE
54: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
55: := FND_API.G_MISS_CHAR
56: ,p_labor_quantity IN pa_budget_versions.labor_quantity%TYPE

Line 54: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE

50: ,p_baselined_by_person_id IN pa_budget_versions.baselined_by_person_id%TYPE
51: := FND_API.G_MISS_NUM
52: ,p_baselined_date IN pa_budget_versions.baselined_date%TYPE
53: := FND_API.G_MISS_DATE
54: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
55: := FND_API.G_MISS_CHAR
56: ,p_labor_quantity IN pa_budget_versions.labor_quantity%TYPE
57: := FND_API.G_MISS_NUM
58: ,p_labor_unit_of_measure IN pa_budget_versions.labor_unit_of_measure%TYPE

Line 56: ,p_labor_quantity IN pa_budget_versions.labor_quantity%TYPE

52: ,p_baselined_date IN pa_budget_versions.baselined_date%TYPE
53: := FND_API.G_MISS_DATE
54: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
55: := FND_API.G_MISS_CHAR
56: ,p_labor_quantity IN pa_budget_versions.labor_quantity%TYPE
57: := FND_API.G_MISS_NUM
58: ,p_labor_unit_of_measure IN pa_budget_versions.labor_unit_of_measure%TYPE
59: := FND_API.G_MISS_CHAR
60: ,p_raw_cost IN pa_budget_versions.raw_cost%TYPE

Line 58: ,p_labor_unit_of_measure IN pa_budget_versions.labor_unit_of_measure%TYPE

54: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
55: := FND_API.G_MISS_CHAR
56: ,p_labor_quantity IN pa_budget_versions.labor_quantity%TYPE
57: := FND_API.G_MISS_NUM
58: ,p_labor_unit_of_measure IN pa_budget_versions.labor_unit_of_measure%TYPE
59: := FND_API.G_MISS_CHAR
60: ,p_raw_cost IN pa_budget_versions.raw_cost%TYPE
61: := FND_API.G_MISS_NUM
62: ,p_burdened_cost IN pa_budget_versions.burdened_cost%TYPE

Line 60: ,p_raw_cost IN pa_budget_versions.raw_cost%TYPE

56: ,p_labor_quantity IN pa_budget_versions.labor_quantity%TYPE
57: := FND_API.G_MISS_NUM
58: ,p_labor_unit_of_measure IN pa_budget_versions.labor_unit_of_measure%TYPE
59: := FND_API.G_MISS_CHAR
60: ,p_raw_cost IN pa_budget_versions.raw_cost%TYPE
61: := FND_API.G_MISS_NUM
62: ,p_burdened_cost IN pa_budget_versions.burdened_cost%TYPE
63: := FND_API.G_MISS_NUM
64: ,p_revenue IN pa_budget_versions.revenue%TYPE

Line 62: ,p_burdened_cost IN pa_budget_versions.burdened_cost%TYPE

58: ,p_labor_unit_of_measure IN pa_budget_versions.labor_unit_of_measure%TYPE
59: := FND_API.G_MISS_CHAR
60: ,p_raw_cost IN pa_budget_versions.raw_cost%TYPE
61: := FND_API.G_MISS_NUM
62: ,p_burdened_cost IN pa_budget_versions.burdened_cost%TYPE
63: := FND_API.G_MISS_NUM
64: ,p_revenue IN pa_budget_versions.revenue%TYPE
65: := FND_API.G_MISS_NUM
66: ,p_description IN pa_budget_versions.description%TYPE

Line 64: ,p_revenue IN pa_budget_versions.revenue%TYPE

60: ,p_raw_cost IN pa_budget_versions.raw_cost%TYPE
61: := FND_API.G_MISS_NUM
62: ,p_burdened_cost IN pa_budget_versions.burdened_cost%TYPE
63: := FND_API.G_MISS_NUM
64: ,p_revenue IN pa_budget_versions.revenue%TYPE
65: := FND_API.G_MISS_NUM
66: ,p_description IN pa_budget_versions.description%TYPE
67: := FND_API.G_MISS_CHAR
68: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE

Line 66: ,p_description IN pa_budget_versions.description%TYPE

62: ,p_burdened_cost IN pa_budget_versions.burdened_cost%TYPE
63: := FND_API.G_MISS_NUM
64: ,p_revenue IN pa_budget_versions.revenue%TYPE
65: := FND_API.G_MISS_NUM
66: ,p_description IN pa_budget_versions.description%TYPE
67: := FND_API.G_MISS_CHAR
68: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
69: := FND_API.G_MISS_CHAR
70: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE

Line 68: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE

64: ,p_revenue IN pa_budget_versions.revenue%TYPE
65: := FND_API.G_MISS_NUM
66: ,p_description IN pa_budget_versions.description%TYPE
67: := FND_API.G_MISS_CHAR
68: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
69: := FND_API.G_MISS_CHAR
70: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
71: := FND_API.G_MISS_CHAR
72: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE

Line 70: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE

66: ,p_description IN pa_budget_versions.description%TYPE
67: := FND_API.G_MISS_CHAR
68: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
69: := FND_API.G_MISS_CHAR
70: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
71: := FND_API.G_MISS_CHAR
72: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
73: := FND_API.G_MISS_CHAR
74: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE

Line 72: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE

68: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
69: := FND_API.G_MISS_CHAR
70: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
71: := FND_API.G_MISS_CHAR
72: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
73: := FND_API.G_MISS_CHAR
74: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
75: := FND_API.G_MISS_CHAR
76: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE

Line 74: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE

70: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
71: := FND_API.G_MISS_CHAR
72: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
73: := FND_API.G_MISS_CHAR
74: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
75: := FND_API.G_MISS_CHAR
76: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
77: := FND_API.G_MISS_CHAR
78: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE

Line 76: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE

72: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
73: := FND_API.G_MISS_CHAR
74: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
75: := FND_API.G_MISS_CHAR
76: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
77: := FND_API.G_MISS_CHAR
78: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
79: := FND_API.G_MISS_CHAR
80: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE

Line 78: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE

74: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
75: := FND_API.G_MISS_CHAR
76: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
77: := FND_API.G_MISS_CHAR
78: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
79: := FND_API.G_MISS_CHAR
80: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
81: := FND_API.G_MISS_CHAR
82: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE

Line 80: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE

76: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
77: := FND_API.G_MISS_CHAR
78: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
79: := FND_API.G_MISS_CHAR
80: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
81: := FND_API.G_MISS_CHAR
82: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
83: := FND_API.G_MISS_CHAR
84: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE

Line 82: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE

78: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
79: := FND_API.G_MISS_CHAR
80: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
81: := FND_API.G_MISS_CHAR
82: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
83: := FND_API.G_MISS_CHAR
84: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
85: := FND_API.G_MISS_CHAR
86: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE

Line 84: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE

80: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
81: := FND_API.G_MISS_CHAR
82: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
83: := FND_API.G_MISS_CHAR
84: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
85: := FND_API.G_MISS_CHAR
86: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
87: := FND_API.G_MISS_CHAR
88: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE

Line 86: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE

82: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
83: := FND_API.G_MISS_CHAR
84: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
85: := FND_API.G_MISS_CHAR
86: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
87: := FND_API.G_MISS_CHAR
88: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
89: := FND_API.G_MISS_CHAR
90: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE

Line 88: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE

84: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
85: := FND_API.G_MISS_CHAR
86: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
87: := FND_API.G_MISS_CHAR
88: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
89: := FND_API.G_MISS_CHAR
90: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
91: := FND_API.G_MISS_CHAR
92: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE

Line 90: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE

86: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
87: := FND_API.G_MISS_CHAR
88: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
89: := FND_API.G_MISS_CHAR
90: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
91: := FND_API.G_MISS_CHAR
92: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
93: := FND_API.G_MISS_CHAR
94: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE

Line 92: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE

88: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
89: := FND_API.G_MISS_CHAR
90: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
91: := FND_API.G_MISS_CHAR
92: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
93: := FND_API.G_MISS_CHAR
94: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
95: := FND_API.G_MISS_CHAR
96: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE

Line 94: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE

90: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
91: := FND_API.G_MISS_CHAR
92: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
93: := FND_API.G_MISS_CHAR
94: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
95: := FND_API.G_MISS_CHAR
96: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
97: := FND_API.G_MISS_CHAR
98: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE

Line 96: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE

92: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
93: := FND_API.G_MISS_CHAR
94: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
95: := FND_API.G_MISS_CHAR
96: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
97: := FND_API.G_MISS_CHAR
98: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
99: := FND_API.G_MISS_CHAR
100: ,p_first_budget_period IN pa_budget_versions.first_budget_period%TYPE

Line 98: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE

94: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
95: := FND_API.G_MISS_CHAR
96: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
97: := FND_API.G_MISS_CHAR
98: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
99: := FND_API.G_MISS_CHAR
100: ,p_first_budget_period IN pa_budget_versions.first_budget_period%TYPE
101: := FND_API.G_MISS_CHAR
102: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE

Line 100: ,p_first_budget_period IN pa_budget_versions.first_budget_period%TYPE

96: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
97: := FND_API.G_MISS_CHAR
98: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
99: := FND_API.G_MISS_CHAR
100: ,p_first_budget_period IN pa_budget_versions.first_budget_period%TYPE
101: := FND_API.G_MISS_CHAR
102: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
103: := FND_API.G_MISS_CHAR
104: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE

Line 102: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE

98: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
99: := FND_API.G_MISS_CHAR
100: ,p_first_budget_period IN pa_budget_versions.first_budget_period%TYPE
101: := FND_API.G_MISS_CHAR
102: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
103: := FND_API.G_MISS_CHAR
104: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
105: := FND_API.G_MISS_CHAR
106: ,p_wf_status_code IN pa_budget_versions.wf_status_code%TYPE

Line 104: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE

100: ,p_first_budget_period IN pa_budget_versions.first_budget_period%TYPE
101: := FND_API.G_MISS_CHAR
102: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
103: := FND_API.G_MISS_CHAR
104: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
105: := FND_API.G_MISS_CHAR
106: ,p_wf_status_code IN pa_budget_versions.wf_status_code%TYPE
107: := FND_API.G_MISS_CHAR
108: ,p_adw_notify_flag IN pa_budget_versions.adw_notify_flag%TYPE

Line 106: ,p_wf_status_code IN pa_budget_versions.wf_status_code%TYPE

102: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
103: := FND_API.G_MISS_CHAR
104: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
105: := FND_API.G_MISS_CHAR
106: ,p_wf_status_code IN pa_budget_versions.wf_status_code%TYPE
107: := FND_API.G_MISS_CHAR
108: ,p_adw_notify_flag IN pa_budget_versions.adw_notify_flag%TYPE
109: := FND_API.G_MISS_CHAR
110: ,p_prc_generated_flag IN pa_budget_versions.prc_generated_flag%TYPE

Line 108: ,p_adw_notify_flag IN pa_budget_versions.adw_notify_flag%TYPE

104: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
105: := FND_API.G_MISS_CHAR
106: ,p_wf_status_code IN pa_budget_versions.wf_status_code%TYPE
107: := FND_API.G_MISS_CHAR
108: ,p_adw_notify_flag IN pa_budget_versions.adw_notify_flag%TYPE
109: := FND_API.G_MISS_CHAR
110: ,p_prc_generated_flag IN pa_budget_versions.prc_generated_flag%TYPE
111: := FND_API.G_MISS_CHAR
112: ,p_plan_run_date IN pa_budget_versions.plan_run_date%TYPE

Line 110: ,p_prc_generated_flag IN pa_budget_versions.prc_generated_flag%TYPE

106: ,p_wf_status_code IN pa_budget_versions.wf_status_code%TYPE
107: := FND_API.G_MISS_CHAR
108: ,p_adw_notify_flag IN pa_budget_versions.adw_notify_flag%TYPE
109: := FND_API.G_MISS_CHAR
110: ,p_prc_generated_flag IN pa_budget_versions.prc_generated_flag%TYPE
111: := FND_API.G_MISS_CHAR
112: ,p_plan_run_date IN pa_budget_versions.plan_run_date%TYPE
113: := FND_API.G_MISS_DATE
114: ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE

Line 112: ,p_plan_run_date IN pa_budget_versions.plan_run_date%TYPE

108: ,p_adw_notify_flag IN pa_budget_versions.adw_notify_flag%TYPE
109: := FND_API.G_MISS_CHAR
110: ,p_prc_generated_flag IN pa_budget_versions.prc_generated_flag%TYPE
111: := FND_API.G_MISS_CHAR
112: ,p_plan_run_date IN pa_budget_versions.plan_run_date%TYPE
113: := FND_API.G_MISS_DATE
114: ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE
115: := FND_API.G_MISS_CHAR
116: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE

Line 114: ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE

110: ,p_prc_generated_flag IN pa_budget_versions.prc_generated_flag%TYPE
111: := FND_API.G_MISS_CHAR
112: ,p_plan_run_date IN pa_budget_versions.plan_run_date%TYPE
113: := FND_API.G_MISS_DATE
114: ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE
115: := FND_API.G_MISS_CHAR
116: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
117: := FND_API.G_MISS_NUM
118: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE

Line 116: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE

112: ,p_plan_run_date IN pa_budget_versions.plan_run_date%TYPE
113: := FND_API.G_MISS_DATE
114: ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE
115: := FND_API.G_MISS_CHAR
116: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
117: := FND_API.G_MISS_NUM
118: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
119: := FND_API.G_MISS_NUM
120: ,p_parent_plan_version_id IN pa_budget_versions.parent_plan_version_id%TYPE

Line 118: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE

114: ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE
115: := FND_API.G_MISS_CHAR
116: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
117: := FND_API.G_MISS_NUM
118: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
119: := FND_API.G_MISS_NUM
120: ,p_parent_plan_version_id IN pa_budget_versions.parent_plan_version_id%TYPE
121: := FND_API.G_MISS_NUM
122: ,p_project_structure_version_id IN pa_budget_versions.project_structure_version_id%TYPE

Line 120: ,p_parent_plan_version_id IN pa_budget_versions.parent_plan_version_id%TYPE

116: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
117: := FND_API.G_MISS_NUM
118: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
119: := FND_API.G_MISS_NUM
120: ,p_parent_plan_version_id IN pa_budget_versions.parent_plan_version_id%TYPE
121: := FND_API.G_MISS_NUM
122: ,p_project_structure_version_id IN pa_budget_versions.project_structure_version_id%TYPE
123: := FND_API.G_MISS_NUM
124: ,p_current_working_flag IN pa_budget_versions.current_working_flag%TYPE

Line 122: ,p_project_structure_version_id IN pa_budget_versions.project_structure_version_id%TYPE

118: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
119: := FND_API.G_MISS_NUM
120: ,p_parent_plan_version_id IN pa_budget_versions.parent_plan_version_id%TYPE
121: := FND_API.G_MISS_NUM
122: ,p_project_structure_version_id IN pa_budget_versions.project_structure_version_id%TYPE
123: := FND_API.G_MISS_NUM
124: ,p_current_working_flag IN pa_budget_versions.current_working_flag%TYPE
125: := FND_API.G_MISS_CHAR
126: ,p_total_borrowed_revenue IN pa_budget_versions.total_borrowed_revenue%TYPE

Line 124: ,p_current_working_flag IN pa_budget_versions.current_working_flag%TYPE

120: ,p_parent_plan_version_id IN pa_budget_versions.parent_plan_version_id%TYPE
121: := FND_API.G_MISS_NUM
122: ,p_project_structure_version_id IN pa_budget_versions.project_structure_version_id%TYPE
123: := FND_API.G_MISS_NUM
124: ,p_current_working_flag IN pa_budget_versions.current_working_flag%TYPE
125: := FND_API.G_MISS_CHAR
126: ,p_total_borrowed_revenue IN pa_budget_versions.total_borrowed_revenue%TYPE
127: := FND_API.G_MISS_NUM
128: ,p_total_tp_revenue_in IN pa_budget_versions.total_tp_revenue_in%TYPE

Line 126: ,p_total_borrowed_revenue IN pa_budget_versions.total_borrowed_revenue%TYPE

122: ,p_project_structure_version_id IN pa_budget_versions.project_structure_version_id%TYPE
123: := FND_API.G_MISS_NUM
124: ,p_current_working_flag IN pa_budget_versions.current_working_flag%TYPE
125: := FND_API.G_MISS_CHAR
126: ,p_total_borrowed_revenue IN pa_budget_versions.total_borrowed_revenue%TYPE
127: := FND_API.G_MISS_NUM
128: ,p_total_tp_revenue_in IN pa_budget_versions.total_tp_revenue_in%TYPE
129: := FND_API.G_MISS_NUM
130: ,p_total_tp_revenue_out IN pa_budget_versions.total_tp_revenue_out%TYPE

Line 128: ,p_total_tp_revenue_in IN pa_budget_versions.total_tp_revenue_in%TYPE

124: ,p_current_working_flag IN pa_budget_versions.current_working_flag%TYPE
125: := FND_API.G_MISS_CHAR
126: ,p_total_borrowed_revenue IN pa_budget_versions.total_borrowed_revenue%TYPE
127: := FND_API.G_MISS_NUM
128: ,p_total_tp_revenue_in IN pa_budget_versions.total_tp_revenue_in%TYPE
129: := FND_API.G_MISS_NUM
130: ,p_total_tp_revenue_out IN pa_budget_versions.total_tp_revenue_out%TYPE
131: := FND_API.G_MISS_NUM
132: ,p_total_revenue_adj IN pa_budget_versions.total_revenue_adj%TYPE

Line 130: ,p_total_tp_revenue_out IN pa_budget_versions.total_tp_revenue_out%TYPE

126: ,p_total_borrowed_revenue IN pa_budget_versions.total_borrowed_revenue%TYPE
127: := FND_API.G_MISS_NUM
128: ,p_total_tp_revenue_in IN pa_budget_versions.total_tp_revenue_in%TYPE
129: := FND_API.G_MISS_NUM
130: ,p_total_tp_revenue_out IN pa_budget_versions.total_tp_revenue_out%TYPE
131: := FND_API.G_MISS_NUM
132: ,p_total_revenue_adj IN pa_budget_versions.total_revenue_adj%TYPE
133: := FND_API.G_MISS_NUM
134: ,p_total_lent_resource_cost IN pa_budget_versions.total_lent_resource_cost%TYPE

Line 132: ,p_total_revenue_adj IN pa_budget_versions.total_revenue_adj%TYPE

128: ,p_total_tp_revenue_in IN pa_budget_versions.total_tp_revenue_in%TYPE
129: := FND_API.G_MISS_NUM
130: ,p_total_tp_revenue_out IN pa_budget_versions.total_tp_revenue_out%TYPE
131: := FND_API.G_MISS_NUM
132: ,p_total_revenue_adj IN pa_budget_versions.total_revenue_adj%TYPE
133: := FND_API.G_MISS_NUM
134: ,p_total_lent_resource_cost IN pa_budget_versions.total_lent_resource_cost%TYPE
135: := FND_API.G_MISS_NUM
136: ,p_total_tp_cost_in IN pa_budget_versions.total_tp_cost_in%TYPE

Line 134: ,p_total_lent_resource_cost IN pa_budget_versions.total_lent_resource_cost%TYPE

130: ,p_total_tp_revenue_out IN pa_budget_versions.total_tp_revenue_out%TYPE
131: := FND_API.G_MISS_NUM
132: ,p_total_revenue_adj IN pa_budget_versions.total_revenue_adj%TYPE
133: := FND_API.G_MISS_NUM
134: ,p_total_lent_resource_cost IN pa_budget_versions.total_lent_resource_cost%TYPE
135: := FND_API.G_MISS_NUM
136: ,p_total_tp_cost_in IN pa_budget_versions.total_tp_cost_in%TYPE
137: := FND_API.G_MISS_NUM
138: ,p_total_tp_cost_out IN pa_budget_versions.total_tp_cost_out%TYPE

Line 136: ,p_total_tp_cost_in IN pa_budget_versions.total_tp_cost_in%TYPE

132: ,p_total_revenue_adj IN pa_budget_versions.total_revenue_adj%TYPE
133: := FND_API.G_MISS_NUM
134: ,p_total_lent_resource_cost IN pa_budget_versions.total_lent_resource_cost%TYPE
135: := FND_API.G_MISS_NUM
136: ,p_total_tp_cost_in IN pa_budget_versions.total_tp_cost_in%TYPE
137: := FND_API.G_MISS_NUM
138: ,p_total_tp_cost_out IN pa_budget_versions.total_tp_cost_out%TYPE
139: := FND_API.G_MISS_NUM
140: ,p_total_cost_adj IN pa_budget_versions.total_cost_adj%TYPE

Line 138: ,p_total_tp_cost_out IN pa_budget_versions.total_tp_cost_out%TYPE

134: ,p_total_lent_resource_cost IN pa_budget_versions.total_lent_resource_cost%TYPE
135: := FND_API.G_MISS_NUM
136: ,p_total_tp_cost_in IN pa_budget_versions.total_tp_cost_in%TYPE
137: := FND_API.G_MISS_NUM
138: ,p_total_tp_cost_out IN pa_budget_versions.total_tp_cost_out%TYPE
139: := FND_API.G_MISS_NUM
140: ,p_total_cost_adj IN pa_budget_versions.total_cost_adj%TYPE
141: := FND_API.G_MISS_NUM
142: ,p_total_unassigned_time_cost IN pa_budget_versions.total_unassigned_time_cost%TYPE

Line 140: ,p_total_cost_adj IN pa_budget_versions.total_cost_adj%TYPE

136: ,p_total_tp_cost_in IN pa_budget_versions.total_tp_cost_in%TYPE
137: := FND_API.G_MISS_NUM
138: ,p_total_tp_cost_out IN pa_budget_versions.total_tp_cost_out%TYPE
139: := FND_API.G_MISS_NUM
140: ,p_total_cost_adj IN pa_budget_versions.total_cost_adj%TYPE
141: := FND_API.G_MISS_NUM
142: ,p_total_unassigned_time_cost IN pa_budget_versions.total_unassigned_time_cost%TYPE
143: := FND_API.G_MISS_NUM
144: ,p_total_utilization_percent IN pa_budget_versions.total_utilization_percent%TYPE

Line 142: ,p_total_unassigned_time_cost IN pa_budget_versions.total_unassigned_time_cost%TYPE

138: ,p_total_tp_cost_out IN pa_budget_versions.total_tp_cost_out%TYPE
139: := FND_API.G_MISS_NUM
140: ,p_total_cost_adj IN pa_budget_versions.total_cost_adj%TYPE
141: := FND_API.G_MISS_NUM
142: ,p_total_unassigned_time_cost IN pa_budget_versions.total_unassigned_time_cost%TYPE
143: := FND_API.G_MISS_NUM
144: ,p_total_utilization_percent IN pa_budget_versions.total_utilization_percent%TYPE
145: := FND_API.G_MISS_NUM
146: ,p_total_utilization_hours IN pa_budget_versions.total_utilization_hours%TYPE

Line 144: ,p_total_utilization_percent IN pa_budget_versions.total_utilization_percent%TYPE

140: ,p_total_cost_adj IN pa_budget_versions.total_cost_adj%TYPE
141: := FND_API.G_MISS_NUM
142: ,p_total_unassigned_time_cost IN pa_budget_versions.total_unassigned_time_cost%TYPE
143: := FND_API.G_MISS_NUM
144: ,p_total_utilization_percent IN pa_budget_versions.total_utilization_percent%TYPE
145: := FND_API.G_MISS_NUM
146: ,p_total_utilization_hours IN pa_budget_versions.total_utilization_hours%TYPE
147: := FND_API.G_MISS_NUM
148: ,p_total_utilization_adj IN pa_budget_versions.total_utilization_adj%TYPE

Line 146: ,p_total_utilization_hours IN pa_budget_versions.total_utilization_hours%TYPE

142: ,p_total_unassigned_time_cost IN pa_budget_versions.total_unassigned_time_cost%TYPE
143: := FND_API.G_MISS_NUM
144: ,p_total_utilization_percent IN pa_budget_versions.total_utilization_percent%TYPE
145: := FND_API.G_MISS_NUM
146: ,p_total_utilization_hours IN pa_budget_versions.total_utilization_hours%TYPE
147: := FND_API.G_MISS_NUM
148: ,p_total_utilization_adj IN pa_budget_versions.total_utilization_adj%TYPE
149: := FND_API.G_MISS_NUM
150: ,p_total_capacity IN pa_budget_versions.total_capacity%TYPE

Line 148: ,p_total_utilization_adj IN pa_budget_versions.total_utilization_adj%TYPE

144: ,p_total_utilization_percent IN pa_budget_versions.total_utilization_percent%TYPE
145: := FND_API.G_MISS_NUM
146: ,p_total_utilization_hours IN pa_budget_versions.total_utilization_hours%TYPE
147: := FND_API.G_MISS_NUM
148: ,p_total_utilization_adj IN pa_budget_versions.total_utilization_adj%TYPE
149: := FND_API.G_MISS_NUM
150: ,p_total_capacity IN pa_budget_versions.total_capacity%TYPE
151: := FND_API.G_MISS_NUM
152: ,p_total_head_count IN pa_budget_versions.total_head_count%TYPE

Line 150: ,p_total_capacity IN pa_budget_versions.total_capacity%TYPE

146: ,p_total_utilization_hours IN pa_budget_versions.total_utilization_hours%TYPE
147: := FND_API.G_MISS_NUM
148: ,p_total_utilization_adj IN pa_budget_versions.total_utilization_adj%TYPE
149: := FND_API.G_MISS_NUM
150: ,p_total_capacity IN pa_budget_versions.total_capacity%TYPE
151: := FND_API.G_MISS_NUM
152: ,p_total_head_count IN pa_budget_versions.total_head_count%TYPE
153: := FND_API.G_MISS_NUM
154: ,p_total_head_count_adj IN pa_budget_versions.total_head_count_adj%TYPE

Line 152: ,p_total_head_count IN pa_budget_versions.total_head_count%TYPE

148: ,p_total_utilization_adj IN pa_budget_versions.total_utilization_adj%TYPE
149: := FND_API.G_MISS_NUM
150: ,p_total_capacity IN pa_budget_versions.total_capacity%TYPE
151: := FND_API.G_MISS_NUM
152: ,p_total_head_count IN pa_budget_versions.total_head_count%TYPE
153: := FND_API.G_MISS_NUM
154: ,p_total_head_count_adj IN pa_budget_versions.total_head_count_adj%TYPE
155: := FND_API.G_MISS_NUM
156: ,p_version_type IN pa_budget_versions.version_type%TYPE

Line 154: ,p_total_head_count_adj IN pa_budget_versions.total_head_count_adj%TYPE

150: ,p_total_capacity IN pa_budget_versions.total_capacity%TYPE
151: := FND_API.G_MISS_NUM
152: ,p_total_head_count IN pa_budget_versions.total_head_count%TYPE
153: := FND_API.G_MISS_NUM
154: ,p_total_head_count_adj IN pa_budget_versions.total_head_count_adj%TYPE
155: := FND_API.G_MISS_NUM
156: ,p_version_type IN pa_budget_versions.version_type%TYPE
157: := FND_API.G_MISS_CHAR
158: ,p_request_id IN pa_budget_versions.request_id%TYPE

Line 156: ,p_version_type IN pa_budget_versions.version_type%TYPE

152: ,p_total_head_count IN pa_budget_versions.total_head_count%TYPE
153: := FND_API.G_MISS_NUM
154: ,p_total_head_count_adj IN pa_budget_versions.total_head_count_adj%TYPE
155: := FND_API.G_MISS_NUM
156: ,p_version_type IN pa_budget_versions.version_type%TYPE
157: := FND_API.G_MISS_CHAR
158: ,p_request_id IN pa_budget_versions.request_id%TYPE
159: := FND_API.G_MISS_NUM
160: ,p_total_project_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE

Line 158: ,p_request_id IN pa_budget_versions.request_id%TYPE

154: ,p_total_head_count_adj IN pa_budget_versions.total_head_count_adj%TYPE
155: := FND_API.G_MISS_NUM
156: ,p_version_type IN pa_budget_versions.version_type%TYPE
157: := FND_API.G_MISS_CHAR
158: ,p_request_id IN pa_budget_versions.request_id%TYPE
159: := FND_API.G_MISS_NUM
160: ,p_total_project_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE
161: := FND_API.G_MISS_NUM
162: ,p_total_project_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE

Line 160: ,p_total_project_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE

156: ,p_version_type IN pa_budget_versions.version_type%TYPE
157: := FND_API.G_MISS_CHAR
158: ,p_request_id IN pa_budget_versions.request_id%TYPE
159: := FND_API.G_MISS_NUM
160: ,p_total_project_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE
161: := FND_API.G_MISS_NUM
162: ,p_total_project_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE
163: := FND_API.G_MISS_NUM
164: ,p_total_project_revenue IN pa_budget_versions.total_project_revenue%TYPE

Line 162: ,p_total_project_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE

158: ,p_request_id IN pa_budget_versions.request_id%TYPE
159: := FND_API.G_MISS_NUM
160: ,p_total_project_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE
161: := FND_API.G_MISS_NUM
162: ,p_total_project_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE
163: := FND_API.G_MISS_NUM
164: ,p_total_project_revenue IN pa_budget_versions.total_project_revenue%TYPE
165: := FND_API.G_MISS_NUM
166: ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE

Line 164: ,p_total_project_revenue IN pa_budget_versions.total_project_revenue%TYPE

160: ,p_total_project_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE
161: := FND_API.G_MISS_NUM
162: ,p_total_project_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE
163: := FND_API.G_MISS_NUM
164: ,p_total_project_revenue IN pa_budget_versions.total_project_revenue%TYPE
165: := FND_API.G_MISS_NUM
166: ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE
167: := FND_API.G_MISS_NUM
168: ,p_approved_cost_plan_type_flag IN pa_budget_versions.approved_cost_plan_type_flag%TYPE

Line 166: ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE

162: ,p_total_project_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE
163: := FND_API.G_MISS_NUM
164: ,p_total_project_revenue IN pa_budget_versions.total_project_revenue%TYPE
165: := FND_API.G_MISS_NUM
166: ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE
167: := FND_API.G_MISS_NUM
168: ,p_approved_cost_plan_type_flag IN pa_budget_versions.approved_cost_plan_type_flag%TYPE
169: := FND_API.G_MISS_CHAR
170: ,p_approved_rev_plan_type_flag IN pa_budget_versions.approved_rev_plan_type_flag%TYPE

Line 168: ,p_approved_cost_plan_type_flag IN pa_budget_versions.approved_cost_plan_type_flag%TYPE

164: ,p_total_project_revenue IN pa_budget_versions.total_project_revenue%TYPE
165: := FND_API.G_MISS_NUM
166: ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE
167: := FND_API.G_MISS_NUM
168: ,p_approved_cost_plan_type_flag IN pa_budget_versions.approved_cost_plan_type_flag%TYPE
169: := FND_API.G_MISS_CHAR
170: ,p_approved_rev_plan_type_flag IN pa_budget_versions.approved_rev_plan_type_flag%TYPE
171: := FND_API.G_MISS_CHAR
172: -- start of changes of Bug:- 2634900

Line 170: ,p_approved_rev_plan_type_flag IN pa_budget_versions.approved_rev_plan_type_flag%TYPE

166: ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE
167: := FND_API.G_MISS_NUM
168: ,p_approved_cost_plan_type_flag IN pa_budget_versions.approved_cost_plan_type_flag%TYPE
169: := FND_API.G_MISS_CHAR
170: ,p_approved_rev_plan_type_flag IN pa_budget_versions.approved_rev_plan_type_flag%TYPE
171: := FND_API.G_MISS_CHAR
172: -- start of changes of Bug:- 2634900
173: ,p_est_project_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE
174: := FND_API.G_MISS_NUM

Line 173: ,p_est_project_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE

169: := FND_API.G_MISS_CHAR
170: ,p_approved_rev_plan_type_flag IN pa_budget_versions.approved_rev_plan_type_flag%TYPE
171: := FND_API.G_MISS_CHAR
172: -- start of changes of Bug:- 2634900
173: ,p_est_project_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE
174: := FND_API.G_MISS_NUM
175: ,p_est_project_burdened_cost IN pa_budget_versions.est_project_burdened_cost%TYPE
176: := FND_API.G_MISS_NUM
177: ,p_est_project_revenue IN pa_budget_versions.est_project_revenue%TYPE

Line 175: ,p_est_project_burdened_cost IN pa_budget_versions.est_project_burdened_cost%TYPE

171: := FND_API.G_MISS_CHAR
172: -- start of changes of Bug:- 2634900
173: ,p_est_project_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE
174: := FND_API.G_MISS_NUM
175: ,p_est_project_burdened_cost IN pa_budget_versions.est_project_burdened_cost%TYPE
176: := FND_API.G_MISS_NUM
177: ,p_est_project_revenue IN pa_budget_versions.est_project_revenue%TYPE
178: := FND_API.G_MISS_NUM
179: ,p_est_quantity IN pa_budget_versions.est_quantity%TYPE

Line 177: ,p_est_project_revenue IN pa_budget_versions.est_project_revenue%TYPE

173: ,p_est_project_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE
174: := FND_API.G_MISS_NUM
175: ,p_est_project_burdened_cost IN pa_budget_versions.est_project_burdened_cost%TYPE
176: := FND_API.G_MISS_NUM
177: ,p_est_project_revenue IN pa_budget_versions.est_project_revenue%TYPE
178: := FND_API.G_MISS_NUM
179: ,p_est_quantity IN pa_budget_versions.est_quantity%TYPE
180: := FND_API.G_MISS_NUM
181: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE

Line 179: ,p_est_quantity IN pa_budget_versions.est_quantity%TYPE

175: ,p_est_project_burdened_cost IN pa_budget_versions.est_project_burdened_cost%TYPE
176: := FND_API.G_MISS_NUM
177: ,p_est_project_revenue IN pa_budget_versions.est_project_revenue%TYPE
178: := FND_API.G_MISS_NUM
179: ,p_est_quantity IN pa_budget_versions.est_quantity%TYPE
180: := FND_API.G_MISS_NUM
181: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE
182: := FND_API.G_MISS_NUM
183: ,p_est_projfunc_raw_cost IN pa_budget_versions.est_projfunc_raw_cost%TYPE

Line 181: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE

177: ,p_est_project_revenue IN pa_budget_versions.est_project_revenue%TYPE
178: := FND_API.G_MISS_NUM
179: ,p_est_quantity IN pa_budget_versions.est_quantity%TYPE
180: := FND_API.G_MISS_NUM
181: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE
182: := FND_API.G_MISS_NUM
183: ,p_est_projfunc_raw_cost IN pa_budget_versions.est_projfunc_raw_cost%TYPE
184: := FND_API.G_MISS_NUM
185: ,p_est_projfunc_burdened_cost IN pa_budget_versions.est_projfunc_burdened_cost%TYPE

Line 183: ,p_est_projfunc_raw_cost IN pa_budget_versions.est_projfunc_raw_cost%TYPE

179: ,p_est_quantity IN pa_budget_versions.est_quantity%TYPE
180: := FND_API.G_MISS_NUM
181: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE
182: := FND_API.G_MISS_NUM
183: ,p_est_projfunc_raw_cost IN pa_budget_versions.est_projfunc_raw_cost%TYPE
184: := FND_API.G_MISS_NUM
185: ,p_est_projfunc_burdened_cost IN pa_budget_versions.est_projfunc_burdened_cost%TYPE
186: := FND_API.G_MISS_NUM
187: ,p_est_projfunc_revenue IN pa_budget_versions.est_projfunc_revenue%TYPE

Line 185: ,p_est_projfunc_burdened_cost IN pa_budget_versions.est_projfunc_burdened_cost%TYPE

181: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE
182: := FND_API.G_MISS_NUM
183: ,p_est_projfunc_raw_cost IN pa_budget_versions.est_projfunc_raw_cost%TYPE
184: := FND_API.G_MISS_NUM
185: ,p_est_projfunc_burdened_cost IN pa_budget_versions.est_projfunc_burdened_cost%TYPE
186: := FND_API.G_MISS_NUM
187: ,p_est_projfunc_revenue IN pa_budget_versions.est_projfunc_revenue%TYPE
188: := FND_API.G_MISS_NUM
189: ,p_ci_id IN pa_budget_versions.ci_id%TYPE

Line 187: ,p_est_projfunc_revenue IN pa_budget_versions.est_projfunc_revenue%TYPE

183: ,p_est_projfunc_raw_cost IN pa_budget_versions.est_projfunc_raw_cost%TYPE
184: := FND_API.G_MISS_NUM
185: ,p_est_projfunc_burdened_cost IN pa_budget_versions.est_projfunc_burdened_cost%TYPE
186: := FND_API.G_MISS_NUM
187: ,p_est_projfunc_revenue IN pa_budget_versions.est_projfunc_revenue%TYPE
188: := FND_API.G_MISS_NUM
189: ,p_ci_id IN pa_budget_versions.ci_id%TYPE
190: := FND_API.G_MISS_NUM
191: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE

Line 189: ,p_ci_id IN pa_budget_versions.ci_id%TYPE

185: ,p_est_projfunc_burdened_cost IN pa_budget_versions.est_projfunc_burdened_cost%TYPE
186: := FND_API.G_MISS_NUM
187: ,p_est_projfunc_revenue IN pa_budget_versions.est_projfunc_revenue%TYPE
188: := FND_API.G_MISS_NUM
189: ,p_ci_id IN pa_budget_versions.ci_id%TYPE
190: := FND_API.G_MISS_NUM
191: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE
192: := FND_API.G_MISS_NUM
193: ,p_refresh_required_flag IN pa_budget_versions.PROCESS_UPDATE_WBS_FLAG%TYPE

Line 191: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE

187: ,p_est_projfunc_revenue IN pa_budget_versions.est_projfunc_revenue%TYPE
188: := FND_API.G_MISS_NUM
189: ,p_ci_id IN pa_budget_versions.ci_id%TYPE
190: := FND_API.G_MISS_NUM
191: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE
192: := FND_API.G_MISS_NUM
193: ,p_refresh_required_flag IN pa_budget_versions.PROCESS_UPDATE_WBS_FLAG%TYPE
194: := FND_API.G_MISS_CHAR
195: -- end of changes of Bug:- 2634900

Line 193: ,p_refresh_required_flag IN pa_budget_versions.PROCESS_UPDATE_WBS_FLAG%TYPE

189: ,p_ci_id IN pa_budget_versions.ci_id%TYPE
190: := FND_API.G_MISS_NUM
191: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE
192: := FND_API.G_MISS_NUM
193: ,p_refresh_required_flag IN pa_budget_versions.PROCESS_UPDATE_WBS_FLAG%TYPE
194: := FND_API.G_MISS_CHAR
195: -- end of changes of Bug:- 2634900
196: -- Bug 3354518: start of new columns for FP-M
197: ,p_object_type_code IN pa_budget_versions.object_type_code%TYPE

Line 197: ,p_object_type_code IN pa_budget_versions.object_type_code%TYPE

193: ,p_refresh_required_flag IN pa_budget_versions.PROCESS_UPDATE_WBS_FLAG%TYPE
194: := FND_API.G_MISS_CHAR
195: -- end of changes of Bug:- 2634900
196: -- Bug 3354518: start of new columns for FP-M
197: ,p_object_type_code IN pa_budget_versions.object_type_code%TYPE
198: := FND_API.G_MISS_CHAR
199: ,p_object_id IN pa_budget_versions.object_id%TYPE
200: := FND_API.G_MISS_NUM
201: ,p_primary_cost_forecast_flag IN pa_budget_versions.primary_cost_forecast_flag%TYPE

Line 199: ,p_object_id IN pa_budget_versions.object_id%TYPE

195: -- end of changes of Bug:- 2634900
196: -- Bug 3354518: start of new columns for FP-M
197: ,p_object_type_code IN pa_budget_versions.object_type_code%TYPE
198: := FND_API.G_MISS_CHAR
199: ,p_object_id IN pa_budget_versions.object_id%TYPE
200: := FND_API.G_MISS_NUM
201: ,p_primary_cost_forecast_flag IN pa_budget_versions.primary_cost_forecast_flag%TYPE
202: := FND_API.G_MISS_CHAR
203: ,p_primary_rev_forecast_flag IN pa_budget_versions.primary_rev_forecast_flag%TYPE

Line 201: ,p_primary_cost_forecast_flag IN pa_budget_versions.primary_cost_forecast_flag%TYPE

197: ,p_object_type_code IN pa_budget_versions.object_type_code%TYPE
198: := FND_API.G_MISS_CHAR
199: ,p_object_id IN pa_budget_versions.object_id%TYPE
200: := FND_API.G_MISS_NUM
201: ,p_primary_cost_forecast_flag IN pa_budget_versions.primary_cost_forecast_flag%TYPE
202: := FND_API.G_MISS_CHAR
203: ,p_primary_rev_forecast_flag IN pa_budget_versions.primary_rev_forecast_flag%TYPE
204: := FND_API.G_MISS_CHAR
205: ,p_rev_partially_impl_flag IN pa_budget_versions.rev_partially_impl_flag%TYPE

Line 203: ,p_primary_rev_forecast_flag IN pa_budget_versions.primary_rev_forecast_flag%TYPE

199: ,p_object_id IN pa_budget_versions.object_id%TYPE
200: := FND_API.G_MISS_NUM
201: ,p_primary_cost_forecast_flag IN pa_budget_versions.primary_cost_forecast_flag%TYPE
202: := FND_API.G_MISS_CHAR
203: ,p_primary_rev_forecast_flag IN pa_budget_versions.primary_rev_forecast_flag%TYPE
204: := FND_API.G_MISS_CHAR
205: ,p_rev_partially_impl_flag IN pa_budget_versions.rev_partially_impl_flag%TYPE
206: := FND_API.G_MISS_CHAR
207: ,p_equipment_quantity IN pa_budget_versions.equipment_quantity%TYPE

Line 205: ,p_rev_partially_impl_flag IN pa_budget_versions.rev_partially_impl_flag%TYPE

201: ,p_primary_cost_forecast_flag IN pa_budget_versions.primary_cost_forecast_flag%TYPE
202: := FND_API.G_MISS_CHAR
203: ,p_primary_rev_forecast_flag IN pa_budget_versions.primary_rev_forecast_flag%TYPE
204: := FND_API.G_MISS_CHAR
205: ,p_rev_partially_impl_flag IN pa_budget_versions.rev_partially_impl_flag%TYPE
206: := FND_API.G_MISS_CHAR
207: ,p_equipment_quantity IN pa_budget_versions.equipment_quantity%TYPE
208: := FND_API.G_MISS_NUM
209: ,p_pji_summarized_flag IN pa_budget_versions.pji_summarized_flag%TYPE

Line 207: ,p_equipment_quantity IN pa_budget_versions.equipment_quantity%TYPE

203: ,p_primary_rev_forecast_flag IN pa_budget_versions.primary_rev_forecast_flag%TYPE
204: := FND_API.G_MISS_CHAR
205: ,p_rev_partially_impl_flag IN pa_budget_versions.rev_partially_impl_flag%TYPE
206: := FND_API.G_MISS_CHAR
207: ,p_equipment_quantity IN pa_budget_versions.equipment_quantity%TYPE
208: := FND_API.G_MISS_NUM
209: ,p_pji_summarized_flag IN pa_budget_versions.pji_summarized_flag%TYPE
210: := FND_API.G_MISS_CHAR
211: ,p_wp_version_flag IN pa_budget_versions.wp_version_flag%TYPE

Line 209: ,p_pji_summarized_flag IN pa_budget_versions.pji_summarized_flag%TYPE

205: ,p_rev_partially_impl_flag IN pa_budget_versions.rev_partially_impl_flag%TYPE
206: := FND_API.G_MISS_CHAR
207: ,p_equipment_quantity IN pa_budget_versions.equipment_quantity%TYPE
208: := FND_API.G_MISS_NUM
209: ,p_pji_summarized_flag IN pa_budget_versions.pji_summarized_flag%TYPE
210: := FND_API.G_MISS_CHAR
211: ,p_wp_version_flag IN pa_budget_versions.wp_version_flag%TYPE
212: := FND_API.G_MISS_CHAR
213: ,p_current_planning_period IN pa_budget_versions.current_planning_period%TYPE

Line 211: ,p_wp_version_flag IN pa_budget_versions.wp_version_flag%TYPE

207: ,p_equipment_quantity IN pa_budget_versions.equipment_quantity%TYPE
208: := FND_API.G_MISS_NUM
209: ,p_pji_summarized_flag IN pa_budget_versions.pji_summarized_flag%TYPE
210: := FND_API.G_MISS_CHAR
211: ,p_wp_version_flag IN pa_budget_versions.wp_version_flag%TYPE
212: := FND_API.G_MISS_CHAR
213: ,p_current_planning_period IN pa_budget_versions.current_planning_period%TYPE
214: := FND_API.G_MISS_CHAR
215: ,p_period_mask_id IN pa_budget_versions.period_mask_id%TYPE

Line 213: ,p_current_planning_period IN pa_budget_versions.current_planning_period%TYPE

209: ,p_pji_summarized_flag IN pa_budget_versions.pji_summarized_flag%TYPE
210: := FND_API.G_MISS_CHAR
211: ,p_wp_version_flag IN pa_budget_versions.wp_version_flag%TYPE
212: := FND_API.G_MISS_CHAR
213: ,p_current_planning_period IN pa_budget_versions.current_planning_period%TYPE
214: := FND_API.G_MISS_CHAR
215: ,p_period_mask_id IN pa_budget_versions.period_mask_id%TYPE
216: := FND_API.G_MISS_NUM
217: ,p_last_amt_gen_date IN pa_budget_versions.last_amt_gen_date%TYPE

Line 215: ,p_period_mask_id IN pa_budget_versions.period_mask_id%TYPE

211: ,p_wp_version_flag IN pa_budget_versions.wp_version_flag%TYPE
212: := FND_API.G_MISS_CHAR
213: ,p_current_planning_period IN pa_budget_versions.current_planning_period%TYPE
214: := FND_API.G_MISS_CHAR
215: ,p_period_mask_id IN pa_budget_versions.period_mask_id%TYPE
216: := FND_API.G_MISS_NUM
217: ,p_last_amt_gen_date IN pa_budget_versions.last_amt_gen_date%TYPE
218: := FND_API.G_MISS_DATE
219: ,p_actual_amts_thru_period IN pa_budget_versions.actual_amts_thru_period%TYPE

Line 217: ,p_last_amt_gen_date IN pa_budget_versions.last_amt_gen_date%TYPE

213: ,p_current_planning_period IN pa_budget_versions.current_planning_period%TYPE
214: := FND_API.G_MISS_CHAR
215: ,p_period_mask_id IN pa_budget_versions.period_mask_id%TYPE
216: := FND_API.G_MISS_NUM
217: ,p_last_amt_gen_date IN pa_budget_versions.last_amt_gen_date%TYPE
218: := FND_API.G_MISS_DATE
219: ,p_actual_amts_thru_period IN pa_budget_versions.actual_amts_thru_period%TYPE
220: := FND_API.G_MISS_CHAR
221: -- Bug 3354518: end of new columns for FP-M

Line 219: ,p_actual_amts_thru_period IN pa_budget_versions.actual_amts_thru_period%TYPE

215: ,p_period_mask_id IN pa_budget_versions.period_mask_id%TYPE
216: := FND_API.G_MISS_NUM
217: ,p_last_amt_gen_date IN pa_budget_versions.last_amt_gen_date%TYPE
218: := FND_API.G_MISS_DATE
219: ,p_actual_amts_thru_period IN pa_budget_versions.actual_amts_thru_period%TYPE
220: := FND_API.G_MISS_CHAR
221: -- Bug 3354518: end of new columns for FP-M
222: ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
223: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 226: CURSOR C2 IS select pa_budget_versions_s.nextval FROM sys.dual;

222: ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
223: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
224:
225: IS
226: CURSOR C2 IS select pa_budget_versions_s.nextval FROM sys.dual;
227:
228: BEGIN
229:
230: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 239: INSERT INTO pa_budget_versions(

235: FETCH C2 INTO px_budget_version_id;
236: CLOSE C2;
237: END IF;
238:
239: INSERT INTO pa_budget_versions(
240: budget_version_id
241: ,record_version_number
242: ,project_id
243: ,budget_type_code

Line 502: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

498: RAISE;
499: END Insert_Row;
500:
501: PROCEDURE Update_Row
502: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
503: ,p_record_version_number IN NUMBER
504: := NULL
505: ,p_project_id IN pa_budget_versions.project_id%TYPE
506: := FND_API.G_MISS_NUM

Line 505: ,p_project_id IN pa_budget_versions.project_id%TYPE

501: PROCEDURE Update_Row
502: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
503: ,p_record_version_number IN NUMBER
504: := NULL
505: ,p_project_id IN pa_budget_versions.project_id%TYPE
506: := FND_API.G_MISS_NUM
507: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
508: := FND_API.G_MISS_CHAR
509: ,p_version_number IN pa_budget_versions.version_number%TYPE

Line 507: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE

503: ,p_record_version_number IN NUMBER
504: := NULL
505: ,p_project_id IN pa_budget_versions.project_id%TYPE
506: := FND_API.G_MISS_NUM
507: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
508: := FND_API.G_MISS_CHAR
509: ,p_version_number IN pa_budget_versions.version_number%TYPE
510: := FND_API.G_MISS_NUM
511: ,p_budget_status_code IN pa_budget_versions.budget_status_code%TYPE

Line 509: ,p_version_number IN pa_budget_versions.version_number%TYPE

505: ,p_project_id IN pa_budget_versions.project_id%TYPE
506: := FND_API.G_MISS_NUM
507: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
508: := FND_API.G_MISS_CHAR
509: ,p_version_number IN pa_budget_versions.version_number%TYPE
510: := FND_API.G_MISS_NUM
511: ,p_budget_status_code IN pa_budget_versions.budget_status_code%TYPE
512: := FND_API.G_MISS_CHAR
513: ,p_current_flag IN pa_budget_versions.current_flag%TYPE

Line 511: ,p_budget_status_code IN pa_budget_versions.budget_status_code%TYPE

507: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
508: := FND_API.G_MISS_CHAR
509: ,p_version_number IN pa_budget_versions.version_number%TYPE
510: := FND_API.G_MISS_NUM
511: ,p_budget_status_code IN pa_budget_versions.budget_status_code%TYPE
512: := FND_API.G_MISS_CHAR
513: ,p_current_flag IN pa_budget_versions.current_flag%TYPE
514: := FND_API.G_MISS_CHAR
515: ,p_original_flag IN pa_budget_versions.original_flag%TYPE

Line 513: ,p_current_flag IN pa_budget_versions.current_flag%TYPE

509: ,p_version_number IN pa_budget_versions.version_number%TYPE
510: := FND_API.G_MISS_NUM
511: ,p_budget_status_code IN pa_budget_versions.budget_status_code%TYPE
512: := FND_API.G_MISS_CHAR
513: ,p_current_flag IN pa_budget_versions.current_flag%TYPE
514: := FND_API.G_MISS_CHAR
515: ,p_original_flag IN pa_budget_versions.original_flag%TYPE
516: := FND_API.G_MISS_CHAR
517: ,p_current_original_flag IN pa_budget_versions.current_original_flag%TYPE

Line 515: ,p_original_flag IN pa_budget_versions.original_flag%TYPE

511: ,p_budget_status_code IN pa_budget_versions.budget_status_code%TYPE
512: := FND_API.G_MISS_CHAR
513: ,p_current_flag IN pa_budget_versions.current_flag%TYPE
514: := FND_API.G_MISS_CHAR
515: ,p_original_flag IN pa_budget_versions.original_flag%TYPE
516: := FND_API.G_MISS_CHAR
517: ,p_current_original_flag IN pa_budget_versions.current_original_flag%TYPE
518: := FND_API.G_MISS_CHAR
519: ,p_resource_accumulated_flag IN pa_budget_versions.resource_accumulated_flag%TYPE

Line 517: ,p_current_original_flag IN pa_budget_versions.current_original_flag%TYPE

513: ,p_current_flag IN pa_budget_versions.current_flag%TYPE
514: := FND_API.G_MISS_CHAR
515: ,p_original_flag IN pa_budget_versions.original_flag%TYPE
516: := FND_API.G_MISS_CHAR
517: ,p_current_original_flag IN pa_budget_versions.current_original_flag%TYPE
518: := FND_API.G_MISS_CHAR
519: ,p_resource_accumulated_flag IN pa_budget_versions.resource_accumulated_flag%TYPE
520: := FND_API.G_MISS_CHAR
521: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE

Line 519: ,p_resource_accumulated_flag IN pa_budget_versions.resource_accumulated_flag%TYPE

515: ,p_original_flag IN pa_budget_versions.original_flag%TYPE
516: := FND_API.G_MISS_CHAR
517: ,p_current_original_flag IN pa_budget_versions.current_original_flag%TYPE
518: := FND_API.G_MISS_CHAR
519: ,p_resource_accumulated_flag IN pa_budget_versions.resource_accumulated_flag%TYPE
520: := FND_API.G_MISS_CHAR
521: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
522: := FND_API.G_MISS_NUM
523: ,p_version_name IN pa_budget_versions.version_name%TYPE

Line 521: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE

517: ,p_current_original_flag IN pa_budget_versions.current_original_flag%TYPE
518: := FND_API.G_MISS_CHAR
519: ,p_resource_accumulated_flag IN pa_budget_versions.resource_accumulated_flag%TYPE
520: := FND_API.G_MISS_CHAR
521: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
522: := FND_API.G_MISS_NUM
523: ,p_version_name IN pa_budget_versions.version_name%TYPE
524: := FND_API.G_MISS_CHAR
525: ,p_budget_entry_method_code IN pa_budget_versions.budget_entry_method_code%TYPE

Line 523: ,p_version_name IN pa_budget_versions.version_name%TYPE

519: ,p_resource_accumulated_flag IN pa_budget_versions.resource_accumulated_flag%TYPE
520: := FND_API.G_MISS_CHAR
521: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
522: := FND_API.G_MISS_NUM
523: ,p_version_name IN pa_budget_versions.version_name%TYPE
524: := FND_API.G_MISS_CHAR
525: ,p_budget_entry_method_code IN pa_budget_versions.budget_entry_method_code%TYPE
526: := FND_API.G_MISS_CHAR
527: ,p_baselined_by_person_id IN pa_budget_versions.baselined_by_person_id%TYPE

Line 525: ,p_budget_entry_method_code IN pa_budget_versions.budget_entry_method_code%TYPE

521: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
522: := FND_API.G_MISS_NUM
523: ,p_version_name IN pa_budget_versions.version_name%TYPE
524: := FND_API.G_MISS_CHAR
525: ,p_budget_entry_method_code IN pa_budget_versions.budget_entry_method_code%TYPE
526: := FND_API.G_MISS_CHAR
527: ,p_baselined_by_person_id IN pa_budget_versions.baselined_by_person_id%TYPE
528: := FND_API.G_MISS_NUM
529: ,p_baselined_date IN pa_budget_versions.baselined_date%TYPE

Line 527: ,p_baselined_by_person_id IN pa_budget_versions.baselined_by_person_id%TYPE

523: ,p_version_name IN pa_budget_versions.version_name%TYPE
524: := FND_API.G_MISS_CHAR
525: ,p_budget_entry_method_code IN pa_budget_versions.budget_entry_method_code%TYPE
526: := FND_API.G_MISS_CHAR
527: ,p_baselined_by_person_id IN pa_budget_versions.baselined_by_person_id%TYPE
528: := FND_API.G_MISS_NUM
529: ,p_baselined_date IN pa_budget_versions.baselined_date%TYPE
530: := FND_API.G_MISS_DATE
531: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE

Line 529: ,p_baselined_date IN pa_budget_versions.baselined_date%TYPE

525: ,p_budget_entry_method_code IN pa_budget_versions.budget_entry_method_code%TYPE
526: := FND_API.G_MISS_CHAR
527: ,p_baselined_by_person_id IN pa_budget_versions.baselined_by_person_id%TYPE
528: := FND_API.G_MISS_NUM
529: ,p_baselined_date IN pa_budget_versions.baselined_date%TYPE
530: := FND_API.G_MISS_DATE
531: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
532: := FND_API.G_MISS_CHAR
533: ,p_labor_quantity IN pa_budget_versions.labor_quantity%TYPE

Line 531: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE

527: ,p_baselined_by_person_id IN pa_budget_versions.baselined_by_person_id%TYPE
528: := FND_API.G_MISS_NUM
529: ,p_baselined_date IN pa_budget_versions.baselined_date%TYPE
530: := FND_API.G_MISS_DATE
531: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
532: := FND_API.G_MISS_CHAR
533: ,p_labor_quantity IN pa_budget_versions.labor_quantity%TYPE
534: := FND_API.G_MISS_NUM
535: ,p_labor_unit_of_measure IN pa_budget_versions.labor_unit_of_measure%TYPE

Line 533: ,p_labor_quantity IN pa_budget_versions.labor_quantity%TYPE

529: ,p_baselined_date IN pa_budget_versions.baselined_date%TYPE
530: := FND_API.G_MISS_DATE
531: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
532: := FND_API.G_MISS_CHAR
533: ,p_labor_quantity IN pa_budget_versions.labor_quantity%TYPE
534: := FND_API.G_MISS_NUM
535: ,p_labor_unit_of_measure IN pa_budget_versions.labor_unit_of_measure%TYPE
536: := FND_API.G_MISS_CHAR
537: ,p_raw_cost IN pa_budget_versions.raw_cost%TYPE

Line 535: ,p_labor_unit_of_measure IN pa_budget_versions.labor_unit_of_measure%TYPE

531: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
532: := FND_API.G_MISS_CHAR
533: ,p_labor_quantity IN pa_budget_versions.labor_quantity%TYPE
534: := FND_API.G_MISS_NUM
535: ,p_labor_unit_of_measure IN pa_budget_versions.labor_unit_of_measure%TYPE
536: := FND_API.G_MISS_CHAR
537: ,p_raw_cost IN pa_budget_versions.raw_cost%TYPE
538: := FND_API.G_MISS_NUM
539: ,p_burdened_cost IN pa_budget_versions.burdened_cost%TYPE

Line 537: ,p_raw_cost IN pa_budget_versions.raw_cost%TYPE

533: ,p_labor_quantity IN pa_budget_versions.labor_quantity%TYPE
534: := FND_API.G_MISS_NUM
535: ,p_labor_unit_of_measure IN pa_budget_versions.labor_unit_of_measure%TYPE
536: := FND_API.G_MISS_CHAR
537: ,p_raw_cost IN pa_budget_versions.raw_cost%TYPE
538: := FND_API.G_MISS_NUM
539: ,p_burdened_cost IN pa_budget_versions.burdened_cost%TYPE
540: := FND_API.G_MISS_NUM
541: ,p_revenue IN pa_budget_versions.revenue%TYPE

Line 539: ,p_burdened_cost IN pa_budget_versions.burdened_cost%TYPE

535: ,p_labor_unit_of_measure IN pa_budget_versions.labor_unit_of_measure%TYPE
536: := FND_API.G_MISS_CHAR
537: ,p_raw_cost IN pa_budget_versions.raw_cost%TYPE
538: := FND_API.G_MISS_NUM
539: ,p_burdened_cost IN pa_budget_versions.burdened_cost%TYPE
540: := FND_API.G_MISS_NUM
541: ,p_revenue IN pa_budget_versions.revenue%TYPE
542: := FND_API.G_MISS_NUM
543: ,p_description IN pa_budget_versions.description%TYPE

Line 541: ,p_revenue IN pa_budget_versions.revenue%TYPE

537: ,p_raw_cost IN pa_budget_versions.raw_cost%TYPE
538: := FND_API.G_MISS_NUM
539: ,p_burdened_cost IN pa_budget_versions.burdened_cost%TYPE
540: := FND_API.G_MISS_NUM
541: ,p_revenue IN pa_budget_versions.revenue%TYPE
542: := FND_API.G_MISS_NUM
543: ,p_description IN pa_budget_versions.description%TYPE
544: := FND_API.G_MISS_CHAR
545: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE

Line 543: ,p_description IN pa_budget_versions.description%TYPE

539: ,p_burdened_cost IN pa_budget_versions.burdened_cost%TYPE
540: := FND_API.G_MISS_NUM
541: ,p_revenue IN pa_budget_versions.revenue%TYPE
542: := FND_API.G_MISS_NUM
543: ,p_description IN pa_budget_versions.description%TYPE
544: := FND_API.G_MISS_CHAR
545: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
546: := FND_API.G_MISS_CHAR
547: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE

Line 545: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE

541: ,p_revenue IN pa_budget_versions.revenue%TYPE
542: := FND_API.G_MISS_NUM
543: ,p_description IN pa_budget_versions.description%TYPE
544: := FND_API.G_MISS_CHAR
545: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
546: := FND_API.G_MISS_CHAR
547: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
548: := FND_API.G_MISS_CHAR
549: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE

Line 547: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE

543: ,p_description IN pa_budget_versions.description%TYPE
544: := FND_API.G_MISS_CHAR
545: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
546: := FND_API.G_MISS_CHAR
547: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
548: := FND_API.G_MISS_CHAR
549: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
550: := FND_API.G_MISS_CHAR
551: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE

Line 549: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE

545: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
546: := FND_API.G_MISS_CHAR
547: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
548: := FND_API.G_MISS_CHAR
549: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
550: := FND_API.G_MISS_CHAR
551: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
552: := FND_API.G_MISS_CHAR
553: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE

Line 551: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE

547: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
548: := FND_API.G_MISS_CHAR
549: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
550: := FND_API.G_MISS_CHAR
551: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
552: := FND_API.G_MISS_CHAR
553: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
554: := FND_API.G_MISS_CHAR
555: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE

Line 553: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE

549: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
550: := FND_API.G_MISS_CHAR
551: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
552: := FND_API.G_MISS_CHAR
553: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
554: := FND_API.G_MISS_CHAR
555: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
556: := FND_API.G_MISS_CHAR
557: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE

Line 555: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE

551: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
552: := FND_API.G_MISS_CHAR
553: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
554: := FND_API.G_MISS_CHAR
555: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
556: := FND_API.G_MISS_CHAR
557: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
558: := FND_API.G_MISS_CHAR
559: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE

Line 557: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE

553: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
554: := FND_API.G_MISS_CHAR
555: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
556: := FND_API.G_MISS_CHAR
557: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
558: := FND_API.G_MISS_CHAR
559: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
560: := FND_API.G_MISS_CHAR
561: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE

Line 559: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE

555: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
556: := FND_API.G_MISS_CHAR
557: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
558: := FND_API.G_MISS_CHAR
559: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
560: := FND_API.G_MISS_CHAR
561: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
562: := FND_API.G_MISS_CHAR
563: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE

Line 561: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE

557: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
558: := FND_API.G_MISS_CHAR
559: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
560: := FND_API.G_MISS_CHAR
561: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
562: := FND_API.G_MISS_CHAR
563: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
564: := FND_API.G_MISS_CHAR
565: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE

Line 563: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE

559: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
560: := FND_API.G_MISS_CHAR
561: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
562: := FND_API.G_MISS_CHAR
563: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
564: := FND_API.G_MISS_CHAR
565: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
566: := FND_API.G_MISS_CHAR
567: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE

Line 565: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE

561: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
562: := FND_API.G_MISS_CHAR
563: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
564: := FND_API.G_MISS_CHAR
565: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
566: := FND_API.G_MISS_CHAR
567: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
568: := FND_API.G_MISS_CHAR
569: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE

Line 567: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE

563: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
564: := FND_API.G_MISS_CHAR
565: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
566: := FND_API.G_MISS_CHAR
567: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
568: := FND_API.G_MISS_CHAR
569: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
570: := FND_API.G_MISS_CHAR
571: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE

Line 569: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE

565: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
566: := FND_API.G_MISS_CHAR
567: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
568: := FND_API.G_MISS_CHAR
569: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
570: := FND_API.G_MISS_CHAR
571: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
572: := FND_API.G_MISS_CHAR
573: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE

Line 571: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE

567: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
568: := FND_API.G_MISS_CHAR
569: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
570: := FND_API.G_MISS_CHAR
571: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
572: := FND_API.G_MISS_CHAR
573: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
574: := FND_API.G_MISS_CHAR
575: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE

Line 573: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE

569: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
570: := FND_API.G_MISS_CHAR
571: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
572: := FND_API.G_MISS_CHAR
573: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
574: := FND_API.G_MISS_CHAR
575: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
576: := FND_API.G_MISS_CHAR
577: ,p_first_budget_period IN pa_budget_versions.first_budget_period%TYPE

Line 575: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE

571: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
572: := FND_API.G_MISS_CHAR
573: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
574: := FND_API.G_MISS_CHAR
575: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
576: := FND_API.G_MISS_CHAR
577: ,p_first_budget_period IN pa_budget_versions.first_budget_period%TYPE
578: := FND_API.G_MISS_CHAR
579: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE

Line 577: ,p_first_budget_period IN pa_budget_versions.first_budget_period%TYPE

573: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
574: := FND_API.G_MISS_CHAR
575: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
576: := FND_API.G_MISS_CHAR
577: ,p_first_budget_period IN pa_budget_versions.first_budget_period%TYPE
578: := FND_API.G_MISS_CHAR
579: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
580: := FND_API.G_MISS_CHAR
581: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE

Line 579: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE

575: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
576: := FND_API.G_MISS_CHAR
577: ,p_first_budget_period IN pa_budget_versions.first_budget_period%TYPE
578: := FND_API.G_MISS_CHAR
579: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
580: := FND_API.G_MISS_CHAR
581: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
582: := FND_API.G_MISS_CHAR
583: ,p_wf_status_code IN pa_budget_versions.wf_status_code%TYPE

Line 581: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE

577: ,p_first_budget_period IN pa_budget_versions.first_budget_period%TYPE
578: := FND_API.G_MISS_CHAR
579: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
580: := FND_API.G_MISS_CHAR
581: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
582: := FND_API.G_MISS_CHAR
583: ,p_wf_status_code IN pa_budget_versions.wf_status_code%TYPE
584: := FND_API.G_MISS_CHAR
585: ,p_adw_notify_flag IN pa_budget_versions.adw_notify_flag%TYPE

Line 583: ,p_wf_status_code IN pa_budget_versions.wf_status_code%TYPE

579: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
580: := FND_API.G_MISS_CHAR
581: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
582: := FND_API.G_MISS_CHAR
583: ,p_wf_status_code IN pa_budget_versions.wf_status_code%TYPE
584: := FND_API.G_MISS_CHAR
585: ,p_adw_notify_flag IN pa_budget_versions.adw_notify_flag%TYPE
586: := FND_API.G_MISS_CHAR
587: ,p_prc_generated_flag IN pa_budget_versions.prc_generated_flag%TYPE

Line 585: ,p_adw_notify_flag IN pa_budget_versions.adw_notify_flag%TYPE

581: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
582: := FND_API.G_MISS_CHAR
583: ,p_wf_status_code IN pa_budget_versions.wf_status_code%TYPE
584: := FND_API.G_MISS_CHAR
585: ,p_adw_notify_flag IN pa_budget_versions.adw_notify_flag%TYPE
586: := FND_API.G_MISS_CHAR
587: ,p_prc_generated_flag IN pa_budget_versions.prc_generated_flag%TYPE
588: := FND_API.G_MISS_CHAR
589: ,p_plan_run_date IN pa_budget_versions.plan_run_date%TYPE

Line 587: ,p_prc_generated_flag IN pa_budget_versions.prc_generated_flag%TYPE

583: ,p_wf_status_code IN pa_budget_versions.wf_status_code%TYPE
584: := FND_API.G_MISS_CHAR
585: ,p_adw_notify_flag IN pa_budget_versions.adw_notify_flag%TYPE
586: := FND_API.G_MISS_CHAR
587: ,p_prc_generated_flag IN pa_budget_versions.prc_generated_flag%TYPE
588: := FND_API.G_MISS_CHAR
589: ,p_plan_run_date IN pa_budget_versions.plan_run_date%TYPE
590: := FND_API.G_MISS_DATE
591: ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE

Line 589: ,p_plan_run_date IN pa_budget_versions.plan_run_date%TYPE

585: ,p_adw_notify_flag IN pa_budget_versions.adw_notify_flag%TYPE
586: := FND_API.G_MISS_CHAR
587: ,p_prc_generated_flag IN pa_budget_versions.prc_generated_flag%TYPE
588: := FND_API.G_MISS_CHAR
589: ,p_plan_run_date IN pa_budget_versions.plan_run_date%TYPE
590: := FND_API.G_MISS_DATE
591: ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE
592: := FND_API.G_MISS_CHAR
593: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE

Line 591: ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE

587: ,p_prc_generated_flag IN pa_budget_versions.prc_generated_flag%TYPE
588: := FND_API.G_MISS_CHAR
589: ,p_plan_run_date IN pa_budget_versions.plan_run_date%TYPE
590: := FND_API.G_MISS_DATE
591: ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE
592: := FND_API.G_MISS_CHAR
593: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
594: := FND_API.G_MISS_NUM
595: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE

Line 593: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE

589: ,p_plan_run_date IN pa_budget_versions.plan_run_date%TYPE
590: := FND_API.G_MISS_DATE
591: ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE
592: := FND_API.G_MISS_CHAR
593: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
594: := FND_API.G_MISS_NUM
595: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
596: := FND_API.G_MISS_NUM
597: ,p_parent_plan_version_id IN pa_budget_versions.parent_plan_version_id%TYPE

Line 595: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE

591: ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE
592: := FND_API.G_MISS_CHAR
593: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
594: := FND_API.G_MISS_NUM
595: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
596: := FND_API.G_MISS_NUM
597: ,p_parent_plan_version_id IN pa_budget_versions.parent_plan_version_id%TYPE
598: := FND_API.G_MISS_NUM
599: ,p_project_structure_version_id IN pa_budget_versions.project_structure_version_id%TYPE

Line 597: ,p_parent_plan_version_id IN pa_budget_versions.parent_plan_version_id%TYPE

593: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
594: := FND_API.G_MISS_NUM
595: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
596: := FND_API.G_MISS_NUM
597: ,p_parent_plan_version_id IN pa_budget_versions.parent_plan_version_id%TYPE
598: := FND_API.G_MISS_NUM
599: ,p_project_structure_version_id IN pa_budget_versions.project_structure_version_id%TYPE
600: := FND_API.G_MISS_NUM
601: ,p_current_working_flag IN pa_budget_versions.current_working_flag%TYPE

Line 599: ,p_project_structure_version_id IN pa_budget_versions.project_structure_version_id%TYPE

595: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
596: := FND_API.G_MISS_NUM
597: ,p_parent_plan_version_id IN pa_budget_versions.parent_plan_version_id%TYPE
598: := FND_API.G_MISS_NUM
599: ,p_project_structure_version_id IN pa_budget_versions.project_structure_version_id%TYPE
600: := FND_API.G_MISS_NUM
601: ,p_current_working_flag IN pa_budget_versions.current_working_flag%TYPE
602: := FND_API.G_MISS_CHAR
603: ,p_total_borrowed_revenue IN pa_budget_versions.total_borrowed_revenue%TYPE

Line 601: ,p_current_working_flag IN pa_budget_versions.current_working_flag%TYPE

597: ,p_parent_plan_version_id IN pa_budget_versions.parent_plan_version_id%TYPE
598: := FND_API.G_MISS_NUM
599: ,p_project_structure_version_id IN pa_budget_versions.project_structure_version_id%TYPE
600: := FND_API.G_MISS_NUM
601: ,p_current_working_flag IN pa_budget_versions.current_working_flag%TYPE
602: := FND_API.G_MISS_CHAR
603: ,p_total_borrowed_revenue IN pa_budget_versions.total_borrowed_revenue%TYPE
604: := FND_API.G_MISS_NUM
605: ,p_total_tp_revenue_in IN pa_budget_versions.total_tp_revenue_in%TYPE

Line 603: ,p_total_borrowed_revenue IN pa_budget_versions.total_borrowed_revenue%TYPE

599: ,p_project_structure_version_id IN pa_budget_versions.project_structure_version_id%TYPE
600: := FND_API.G_MISS_NUM
601: ,p_current_working_flag IN pa_budget_versions.current_working_flag%TYPE
602: := FND_API.G_MISS_CHAR
603: ,p_total_borrowed_revenue IN pa_budget_versions.total_borrowed_revenue%TYPE
604: := FND_API.G_MISS_NUM
605: ,p_total_tp_revenue_in IN pa_budget_versions.total_tp_revenue_in%TYPE
606: := FND_API.G_MISS_NUM
607: ,p_total_tp_revenue_out IN pa_budget_versions.total_tp_revenue_out%TYPE

Line 605: ,p_total_tp_revenue_in IN pa_budget_versions.total_tp_revenue_in%TYPE

601: ,p_current_working_flag IN pa_budget_versions.current_working_flag%TYPE
602: := FND_API.G_MISS_CHAR
603: ,p_total_borrowed_revenue IN pa_budget_versions.total_borrowed_revenue%TYPE
604: := FND_API.G_MISS_NUM
605: ,p_total_tp_revenue_in IN pa_budget_versions.total_tp_revenue_in%TYPE
606: := FND_API.G_MISS_NUM
607: ,p_total_tp_revenue_out IN pa_budget_versions.total_tp_revenue_out%TYPE
608: := FND_API.G_MISS_NUM
609: ,p_total_revenue_adj IN pa_budget_versions.total_revenue_adj%TYPE

Line 607: ,p_total_tp_revenue_out IN pa_budget_versions.total_tp_revenue_out%TYPE

603: ,p_total_borrowed_revenue IN pa_budget_versions.total_borrowed_revenue%TYPE
604: := FND_API.G_MISS_NUM
605: ,p_total_tp_revenue_in IN pa_budget_versions.total_tp_revenue_in%TYPE
606: := FND_API.G_MISS_NUM
607: ,p_total_tp_revenue_out IN pa_budget_versions.total_tp_revenue_out%TYPE
608: := FND_API.G_MISS_NUM
609: ,p_total_revenue_adj IN pa_budget_versions.total_revenue_adj%TYPE
610: := FND_API.G_MISS_NUM
611: ,p_total_lent_resource_cost IN pa_budget_versions.total_lent_resource_cost%TYPE

Line 609: ,p_total_revenue_adj IN pa_budget_versions.total_revenue_adj%TYPE

605: ,p_total_tp_revenue_in IN pa_budget_versions.total_tp_revenue_in%TYPE
606: := FND_API.G_MISS_NUM
607: ,p_total_tp_revenue_out IN pa_budget_versions.total_tp_revenue_out%TYPE
608: := FND_API.G_MISS_NUM
609: ,p_total_revenue_adj IN pa_budget_versions.total_revenue_adj%TYPE
610: := FND_API.G_MISS_NUM
611: ,p_total_lent_resource_cost IN pa_budget_versions.total_lent_resource_cost%TYPE
612: := FND_API.G_MISS_NUM
613: ,p_total_tp_cost_in IN pa_budget_versions.total_tp_cost_in%TYPE

Line 611: ,p_total_lent_resource_cost IN pa_budget_versions.total_lent_resource_cost%TYPE

607: ,p_total_tp_revenue_out IN pa_budget_versions.total_tp_revenue_out%TYPE
608: := FND_API.G_MISS_NUM
609: ,p_total_revenue_adj IN pa_budget_versions.total_revenue_adj%TYPE
610: := FND_API.G_MISS_NUM
611: ,p_total_lent_resource_cost IN pa_budget_versions.total_lent_resource_cost%TYPE
612: := FND_API.G_MISS_NUM
613: ,p_total_tp_cost_in IN pa_budget_versions.total_tp_cost_in%TYPE
614: := FND_API.G_MISS_NUM
615: ,p_total_tp_cost_out IN pa_budget_versions.total_tp_cost_out%TYPE

Line 613: ,p_total_tp_cost_in IN pa_budget_versions.total_tp_cost_in%TYPE

609: ,p_total_revenue_adj IN pa_budget_versions.total_revenue_adj%TYPE
610: := FND_API.G_MISS_NUM
611: ,p_total_lent_resource_cost IN pa_budget_versions.total_lent_resource_cost%TYPE
612: := FND_API.G_MISS_NUM
613: ,p_total_tp_cost_in IN pa_budget_versions.total_tp_cost_in%TYPE
614: := FND_API.G_MISS_NUM
615: ,p_total_tp_cost_out IN pa_budget_versions.total_tp_cost_out%TYPE
616: := FND_API.G_MISS_NUM
617: ,p_total_cost_adj IN pa_budget_versions.total_cost_adj%TYPE

Line 615: ,p_total_tp_cost_out IN pa_budget_versions.total_tp_cost_out%TYPE

611: ,p_total_lent_resource_cost IN pa_budget_versions.total_lent_resource_cost%TYPE
612: := FND_API.G_MISS_NUM
613: ,p_total_tp_cost_in IN pa_budget_versions.total_tp_cost_in%TYPE
614: := FND_API.G_MISS_NUM
615: ,p_total_tp_cost_out IN pa_budget_versions.total_tp_cost_out%TYPE
616: := FND_API.G_MISS_NUM
617: ,p_total_cost_adj IN pa_budget_versions.total_cost_adj%TYPE
618: := FND_API.G_MISS_NUM
619: ,p_total_unassigned_time_cost IN pa_budget_versions.total_unassigned_time_cost%TYPE

Line 617: ,p_total_cost_adj IN pa_budget_versions.total_cost_adj%TYPE

613: ,p_total_tp_cost_in IN pa_budget_versions.total_tp_cost_in%TYPE
614: := FND_API.G_MISS_NUM
615: ,p_total_tp_cost_out IN pa_budget_versions.total_tp_cost_out%TYPE
616: := FND_API.G_MISS_NUM
617: ,p_total_cost_adj IN pa_budget_versions.total_cost_adj%TYPE
618: := FND_API.G_MISS_NUM
619: ,p_total_unassigned_time_cost IN pa_budget_versions.total_unassigned_time_cost%TYPE
620: := FND_API.G_MISS_NUM
621: ,p_total_utilization_percent IN pa_budget_versions.total_utilization_percent%TYPE

Line 619: ,p_total_unassigned_time_cost IN pa_budget_versions.total_unassigned_time_cost%TYPE

615: ,p_total_tp_cost_out IN pa_budget_versions.total_tp_cost_out%TYPE
616: := FND_API.G_MISS_NUM
617: ,p_total_cost_adj IN pa_budget_versions.total_cost_adj%TYPE
618: := FND_API.G_MISS_NUM
619: ,p_total_unassigned_time_cost IN pa_budget_versions.total_unassigned_time_cost%TYPE
620: := FND_API.G_MISS_NUM
621: ,p_total_utilization_percent IN pa_budget_versions.total_utilization_percent%TYPE
622: := FND_API.G_MISS_NUM
623: ,p_total_utilization_hours IN pa_budget_versions.total_utilization_hours%TYPE

Line 621: ,p_total_utilization_percent IN pa_budget_versions.total_utilization_percent%TYPE

617: ,p_total_cost_adj IN pa_budget_versions.total_cost_adj%TYPE
618: := FND_API.G_MISS_NUM
619: ,p_total_unassigned_time_cost IN pa_budget_versions.total_unassigned_time_cost%TYPE
620: := FND_API.G_MISS_NUM
621: ,p_total_utilization_percent IN pa_budget_versions.total_utilization_percent%TYPE
622: := FND_API.G_MISS_NUM
623: ,p_total_utilization_hours IN pa_budget_versions.total_utilization_hours%TYPE
624: := FND_API.G_MISS_NUM
625: ,p_total_utilization_adj IN pa_budget_versions.total_utilization_adj%TYPE

Line 623: ,p_total_utilization_hours IN pa_budget_versions.total_utilization_hours%TYPE

619: ,p_total_unassigned_time_cost IN pa_budget_versions.total_unassigned_time_cost%TYPE
620: := FND_API.G_MISS_NUM
621: ,p_total_utilization_percent IN pa_budget_versions.total_utilization_percent%TYPE
622: := FND_API.G_MISS_NUM
623: ,p_total_utilization_hours IN pa_budget_versions.total_utilization_hours%TYPE
624: := FND_API.G_MISS_NUM
625: ,p_total_utilization_adj IN pa_budget_versions.total_utilization_adj%TYPE
626: := FND_API.G_MISS_NUM
627: ,p_total_capacity IN pa_budget_versions.total_capacity%TYPE

Line 625: ,p_total_utilization_adj IN pa_budget_versions.total_utilization_adj%TYPE

621: ,p_total_utilization_percent IN pa_budget_versions.total_utilization_percent%TYPE
622: := FND_API.G_MISS_NUM
623: ,p_total_utilization_hours IN pa_budget_versions.total_utilization_hours%TYPE
624: := FND_API.G_MISS_NUM
625: ,p_total_utilization_adj IN pa_budget_versions.total_utilization_adj%TYPE
626: := FND_API.G_MISS_NUM
627: ,p_total_capacity IN pa_budget_versions.total_capacity%TYPE
628: := FND_API.G_MISS_NUM
629: ,p_total_head_count IN pa_budget_versions.total_head_count%TYPE

Line 627: ,p_total_capacity IN pa_budget_versions.total_capacity%TYPE

623: ,p_total_utilization_hours IN pa_budget_versions.total_utilization_hours%TYPE
624: := FND_API.G_MISS_NUM
625: ,p_total_utilization_adj IN pa_budget_versions.total_utilization_adj%TYPE
626: := FND_API.G_MISS_NUM
627: ,p_total_capacity IN pa_budget_versions.total_capacity%TYPE
628: := FND_API.G_MISS_NUM
629: ,p_total_head_count IN pa_budget_versions.total_head_count%TYPE
630: := FND_API.G_MISS_NUM
631: ,p_total_head_count_adj IN pa_budget_versions.total_head_count_adj%TYPE

Line 629: ,p_total_head_count IN pa_budget_versions.total_head_count%TYPE

625: ,p_total_utilization_adj IN pa_budget_versions.total_utilization_adj%TYPE
626: := FND_API.G_MISS_NUM
627: ,p_total_capacity IN pa_budget_versions.total_capacity%TYPE
628: := FND_API.G_MISS_NUM
629: ,p_total_head_count IN pa_budget_versions.total_head_count%TYPE
630: := FND_API.G_MISS_NUM
631: ,p_total_head_count_adj IN pa_budget_versions.total_head_count_adj%TYPE
632: := FND_API.G_MISS_NUM
633: ,p_version_type IN pa_budget_versions.version_type%TYPE

Line 631: ,p_total_head_count_adj IN pa_budget_versions.total_head_count_adj%TYPE

627: ,p_total_capacity IN pa_budget_versions.total_capacity%TYPE
628: := FND_API.G_MISS_NUM
629: ,p_total_head_count IN pa_budget_versions.total_head_count%TYPE
630: := FND_API.G_MISS_NUM
631: ,p_total_head_count_adj IN pa_budget_versions.total_head_count_adj%TYPE
632: := FND_API.G_MISS_NUM
633: ,p_version_type IN pa_budget_versions.version_type%TYPE
634: := FND_API.G_MISS_CHAR
635: ,p_request_id IN pa_budget_versions.request_id%TYPE

Line 633: ,p_version_type IN pa_budget_versions.version_type%TYPE

629: ,p_total_head_count IN pa_budget_versions.total_head_count%TYPE
630: := FND_API.G_MISS_NUM
631: ,p_total_head_count_adj IN pa_budget_versions.total_head_count_adj%TYPE
632: := FND_API.G_MISS_NUM
633: ,p_version_type IN pa_budget_versions.version_type%TYPE
634: := FND_API.G_MISS_CHAR
635: ,p_request_id IN pa_budget_versions.request_id%TYPE
636: := FND_API.G_MISS_NUM
637: ,p_total_project_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE

Line 635: ,p_request_id IN pa_budget_versions.request_id%TYPE

631: ,p_total_head_count_adj IN pa_budget_versions.total_head_count_adj%TYPE
632: := FND_API.G_MISS_NUM
633: ,p_version_type IN pa_budget_versions.version_type%TYPE
634: := FND_API.G_MISS_CHAR
635: ,p_request_id IN pa_budget_versions.request_id%TYPE
636: := FND_API.G_MISS_NUM
637: ,p_total_project_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE
638: := FND_API.G_MISS_NUM
639: ,p_total_project_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE

Line 637: ,p_total_project_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE

633: ,p_version_type IN pa_budget_versions.version_type%TYPE
634: := FND_API.G_MISS_CHAR
635: ,p_request_id IN pa_budget_versions.request_id%TYPE
636: := FND_API.G_MISS_NUM
637: ,p_total_project_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE
638: := FND_API.G_MISS_NUM
639: ,p_total_project_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE
640: := FND_API.G_MISS_NUM
641: ,p_total_project_revenue IN pa_budget_versions.total_project_revenue%TYPE

Line 639: ,p_total_project_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE

635: ,p_request_id IN pa_budget_versions.request_id%TYPE
636: := FND_API.G_MISS_NUM
637: ,p_total_project_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE
638: := FND_API.G_MISS_NUM
639: ,p_total_project_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE
640: := FND_API.G_MISS_NUM
641: ,p_total_project_revenue IN pa_budget_versions.total_project_revenue%TYPE
642: := FND_API.G_MISS_NUM
643: ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE

Line 641: ,p_total_project_revenue IN pa_budget_versions.total_project_revenue%TYPE

637: ,p_total_project_raw_cost IN pa_budget_versions.total_project_raw_cost%TYPE
638: := FND_API.G_MISS_NUM
639: ,p_total_project_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE
640: := FND_API.G_MISS_NUM
641: ,p_total_project_revenue IN pa_budget_versions.total_project_revenue%TYPE
642: := FND_API.G_MISS_NUM
643: ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE
644: := FND_API.G_MISS_NUM
645: ,p_approved_cost_plan_type_flag IN pa_budget_versions.approved_cost_plan_type_flag%TYPE

Line 643: ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE

639: ,p_total_project_burdened_cost IN pa_budget_versions.total_project_burdened_cost%TYPE
640: := FND_API.G_MISS_NUM
641: ,p_total_project_revenue IN pa_budget_versions.total_project_revenue%TYPE
642: := FND_API.G_MISS_NUM
643: ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE
644: := FND_API.G_MISS_NUM
645: ,p_approved_cost_plan_type_flag IN pa_budget_versions.approved_cost_plan_type_flag%TYPE
646: := FND_API.G_MISS_CHAR
647: ,p_approved_rev_plan_type_flag IN pa_budget_versions.approved_rev_plan_type_flag%TYPE

Line 645: ,p_approved_cost_plan_type_flag IN pa_budget_versions.approved_cost_plan_type_flag%TYPE

641: ,p_total_project_revenue IN pa_budget_versions.total_project_revenue%TYPE
642: := FND_API.G_MISS_NUM
643: ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE
644: := FND_API.G_MISS_NUM
645: ,p_approved_cost_plan_type_flag IN pa_budget_versions.approved_cost_plan_type_flag%TYPE
646: := FND_API.G_MISS_CHAR
647: ,p_approved_rev_plan_type_flag IN pa_budget_versions.approved_rev_plan_type_flag%TYPE
648: := FND_API.G_MISS_CHAR
649: -- start of changes of Bug:- 2634900

Line 647: ,p_approved_rev_plan_type_flag IN pa_budget_versions.approved_rev_plan_type_flag%TYPE

643: ,p_locked_by_person_id IN pa_budget_versions.locked_by_person_id%TYPE
644: := FND_API.G_MISS_NUM
645: ,p_approved_cost_plan_type_flag IN pa_budget_versions.approved_cost_plan_type_flag%TYPE
646: := FND_API.G_MISS_CHAR
647: ,p_approved_rev_plan_type_flag IN pa_budget_versions.approved_rev_plan_type_flag%TYPE
648: := FND_API.G_MISS_CHAR
649: -- start of changes of Bug:- 2634900
650: ,p_est_project_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE
651: := FND_API.G_MISS_NUM

Line 650: ,p_est_project_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE

646: := FND_API.G_MISS_CHAR
647: ,p_approved_rev_plan_type_flag IN pa_budget_versions.approved_rev_plan_type_flag%TYPE
648: := FND_API.G_MISS_CHAR
649: -- start of changes of Bug:- 2634900
650: ,p_est_project_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE
651: := FND_API.G_MISS_NUM
652: ,p_est_project_burdened_cost IN pa_budget_versions.est_project_burdened_cost%TYPE
653: := FND_API.G_MISS_NUM
654: ,p_est_project_revenue IN pa_budget_versions.est_project_revenue%TYPE

Line 652: ,p_est_project_burdened_cost IN pa_budget_versions.est_project_burdened_cost%TYPE

648: := FND_API.G_MISS_CHAR
649: -- start of changes of Bug:- 2634900
650: ,p_est_project_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE
651: := FND_API.G_MISS_NUM
652: ,p_est_project_burdened_cost IN pa_budget_versions.est_project_burdened_cost%TYPE
653: := FND_API.G_MISS_NUM
654: ,p_est_project_revenue IN pa_budget_versions.est_project_revenue%TYPE
655: := FND_API.G_MISS_NUM
656: ,p_est_quantity IN pa_budget_versions.est_quantity%TYPE

Line 654: ,p_est_project_revenue IN pa_budget_versions.est_project_revenue%TYPE

650: ,p_est_project_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE
651: := FND_API.G_MISS_NUM
652: ,p_est_project_burdened_cost IN pa_budget_versions.est_project_burdened_cost%TYPE
653: := FND_API.G_MISS_NUM
654: ,p_est_project_revenue IN pa_budget_versions.est_project_revenue%TYPE
655: := FND_API.G_MISS_NUM
656: ,p_est_quantity IN pa_budget_versions.est_quantity%TYPE
657: := FND_API.G_MISS_NUM
658: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE

Line 656: ,p_est_quantity IN pa_budget_versions.est_quantity%TYPE

652: ,p_est_project_burdened_cost IN pa_budget_versions.est_project_burdened_cost%TYPE
653: := FND_API.G_MISS_NUM
654: ,p_est_project_revenue IN pa_budget_versions.est_project_revenue%TYPE
655: := FND_API.G_MISS_NUM
656: ,p_est_quantity IN pa_budget_versions.est_quantity%TYPE
657: := FND_API.G_MISS_NUM
658: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE
659: := FND_API.G_MISS_NUM
660: ,p_est_projfunc_raw_cost IN pa_budget_versions.est_projfunc_raw_cost%TYPE

Line 658: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE

654: ,p_est_project_revenue IN pa_budget_versions.est_project_revenue%TYPE
655: := FND_API.G_MISS_NUM
656: ,p_est_quantity IN pa_budget_versions.est_quantity%TYPE
657: := FND_API.G_MISS_NUM
658: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE
659: := FND_API.G_MISS_NUM
660: ,p_est_projfunc_raw_cost IN pa_budget_versions.est_projfunc_raw_cost%TYPE
661: := FND_API.G_MISS_NUM
662: ,p_est_projfunc_burdened_cost IN pa_budget_versions.est_projfunc_burdened_cost%TYPE

Line 660: ,p_est_projfunc_raw_cost IN pa_budget_versions.est_projfunc_raw_cost%TYPE

656: ,p_est_quantity IN pa_budget_versions.est_quantity%TYPE
657: := FND_API.G_MISS_NUM
658: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE
659: := FND_API.G_MISS_NUM
660: ,p_est_projfunc_raw_cost IN pa_budget_versions.est_projfunc_raw_cost%TYPE
661: := FND_API.G_MISS_NUM
662: ,p_est_projfunc_burdened_cost IN pa_budget_versions.est_projfunc_burdened_cost%TYPE
663: := FND_API.G_MISS_NUM
664: ,p_est_projfunc_revenue IN pa_budget_versions.est_projfunc_revenue%TYPE

Line 662: ,p_est_projfunc_burdened_cost IN pa_budget_versions.est_projfunc_burdened_cost%TYPE

658: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE
659: := FND_API.G_MISS_NUM
660: ,p_est_projfunc_raw_cost IN pa_budget_versions.est_projfunc_raw_cost%TYPE
661: := FND_API.G_MISS_NUM
662: ,p_est_projfunc_burdened_cost IN pa_budget_versions.est_projfunc_burdened_cost%TYPE
663: := FND_API.G_MISS_NUM
664: ,p_est_projfunc_revenue IN pa_budget_versions.est_projfunc_revenue%TYPE
665: := FND_API.G_MISS_NUM
666: ,p_ci_id IN pa_budget_versions.ci_id%TYPE

Line 664: ,p_est_projfunc_revenue IN pa_budget_versions.est_projfunc_revenue%TYPE

660: ,p_est_projfunc_raw_cost IN pa_budget_versions.est_projfunc_raw_cost%TYPE
661: := FND_API.G_MISS_NUM
662: ,p_est_projfunc_burdened_cost IN pa_budget_versions.est_projfunc_burdened_cost%TYPE
663: := FND_API.G_MISS_NUM
664: ,p_est_projfunc_revenue IN pa_budget_versions.est_projfunc_revenue%TYPE
665: := FND_API.G_MISS_NUM
666: ,p_ci_id IN pa_budget_versions.ci_id%TYPE
667: := FND_API.G_MISS_NUM
668: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE

Line 666: ,p_ci_id IN pa_budget_versions.ci_id%TYPE

662: ,p_est_projfunc_burdened_cost IN pa_budget_versions.est_projfunc_burdened_cost%TYPE
663: := FND_API.G_MISS_NUM
664: ,p_est_projfunc_revenue IN pa_budget_versions.est_projfunc_revenue%TYPE
665: := FND_API.G_MISS_NUM
666: ,p_ci_id IN pa_budget_versions.ci_id%TYPE
667: := FND_API.G_MISS_NUM
668: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE
669: := FND_API.G_MISS_NUM
670: -- end of changes of Bug:- 2634900

Line 668: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE

664: ,p_est_projfunc_revenue IN pa_budget_versions.est_projfunc_revenue%TYPE
665: := FND_API.G_MISS_NUM
666: ,p_ci_id IN pa_budget_versions.ci_id%TYPE
667: := FND_API.G_MISS_NUM
668: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE
669: := FND_API.G_MISS_NUM
670: -- end of changes of Bug:- 2634900
671: -- Bug 3354518: start of new columns for FP-M
672: ,p_object_type_code IN pa_budget_versions.object_type_code%TYPE

Line 672: ,p_object_type_code IN pa_budget_versions.object_type_code%TYPE

668: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE
669: := FND_API.G_MISS_NUM
670: -- end of changes of Bug:- 2634900
671: -- Bug 3354518: start of new columns for FP-M
672: ,p_object_type_code IN pa_budget_versions.object_type_code%TYPE
673: := FND_API.G_MISS_CHAR
674: ,p_object_id IN pa_budget_versions.object_id%TYPE
675: := FND_API.G_MISS_NUM
676: ,p_primary_cost_forecast_flag IN pa_budget_versions.primary_cost_forecast_flag%TYPE

Line 674: ,p_object_id IN pa_budget_versions.object_id%TYPE

670: -- end of changes of Bug:- 2634900
671: -- Bug 3354518: start of new columns for FP-M
672: ,p_object_type_code IN pa_budget_versions.object_type_code%TYPE
673: := FND_API.G_MISS_CHAR
674: ,p_object_id IN pa_budget_versions.object_id%TYPE
675: := FND_API.G_MISS_NUM
676: ,p_primary_cost_forecast_flag IN pa_budget_versions.primary_cost_forecast_flag%TYPE
677: := FND_API.G_MISS_CHAR
678: ,p_primary_rev_forecast_flag IN pa_budget_versions.primary_rev_forecast_flag%TYPE

Line 676: ,p_primary_cost_forecast_flag IN pa_budget_versions.primary_cost_forecast_flag%TYPE

672: ,p_object_type_code IN pa_budget_versions.object_type_code%TYPE
673: := FND_API.G_MISS_CHAR
674: ,p_object_id IN pa_budget_versions.object_id%TYPE
675: := FND_API.G_MISS_NUM
676: ,p_primary_cost_forecast_flag IN pa_budget_versions.primary_cost_forecast_flag%TYPE
677: := FND_API.G_MISS_CHAR
678: ,p_primary_rev_forecast_flag IN pa_budget_versions.primary_rev_forecast_flag%TYPE
679: := FND_API.G_MISS_CHAR
680: ,p_rev_partially_impl_flag IN pa_budget_versions.rev_partially_impl_flag%TYPE

Line 678: ,p_primary_rev_forecast_flag IN pa_budget_versions.primary_rev_forecast_flag%TYPE

674: ,p_object_id IN pa_budget_versions.object_id%TYPE
675: := FND_API.G_MISS_NUM
676: ,p_primary_cost_forecast_flag IN pa_budget_versions.primary_cost_forecast_flag%TYPE
677: := FND_API.G_MISS_CHAR
678: ,p_primary_rev_forecast_flag IN pa_budget_versions.primary_rev_forecast_flag%TYPE
679: := FND_API.G_MISS_CHAR
680: ,p_rev_partially_impl_flag IN pa_budget_versions.rev_partially_impl_flag%TYPE
681: := FND_API.G_MISS_CHAR
682: ,p_equipment_quantity IN pa_budget_versions.equipment_quantity%TYPE

Line 680: ,p_rev_partially_impl_flag IN pa_budget_versions.rev_partially_impl_flag%TYPE

676: ,p_primary_cost_forecast_flag IN pa_budget_versions.primary_cost_forecast_flag%TYPE
677: := FND_API.G_MISS_CHAR
678: ,p_primary_rev_forecast_flag IN pa_budget_versions.primary_rev_forecast_flag%TYPE
679: := FND_API.G_MISS_CHAR
680: ,p_rev_partially_impl_flag IN pa_budget_versions.rev_partially_impl_flag%TYPE
681: := FND_API.G_MISS_CHAR
682: ,p_equipment_quantity IN pa_budget_versions.equipment_quantity%TYPE
683: := FND_API.G_MISS_NUM
684: ,p_pji_summarized_flag IN pa_budget_versions.pji_summarized_flag%TYPE

Line 682: ,p_equipment_quantity IN pa_budget_versions.equipment_quantity%TYPE

678: ,p_primary_rev_forecast_flag IN pa_budget_versions.primary_rev_forecast_flag%TYPE
679: := FND_API.G_MISS_CHAR
680: ,p_rev_partially_impl_flag IN pa_budget_versions.rev_partially_impl_flag%TYPE
681: := FND_API.G_MISS_CHAR
682: ,p_equipment_quantity IN pa_budget_versions.equipment_quantity%TYPE
683: := FND_API.G_MISS_NUM
684: ,p_pji_summarized_flag IN pa_budget_versions.pji_summarized_flag%TYPE
685: := FND_API.G_MISS_CHAR
686: ,p_wp_version_flag IN pa_budget_versions.wp_version_flag%TYPE

Line 684: ,p_pji_summarized_flag IN pa_budget_versions.pji_summarized_flag%TYPE

680: ,p_rev_partially_impl_flag IN pa_budget_versions.rev_partially_impl_flag%TYPE
681: := FND_API.G_MISS_CHAR
682: ,p_equipment_quantity IN pa_budget_versions.equipment_quantity%TYPE
683: := FND_API.G_MISS_NUM
684: ,p_pji_summarized_flag IN pa_budget_versions.pji_summarized_flag%TYPE
685: := FND_API.G_MISS_CHAR
686: ,p_wp_version_flag IN pa_budget_versions.wp_version_flag%TYPE
687: := FND_API.G_MISS_CHAR
688: ,p_current_planning_period IN pa_budget_versions.current_planning_period%TYPE

Line 686: ,p_wp_version_flag IN pa_budget_versions.wp_version_flag%TYPE

682: ,p_equipment_quantity IN pa_budget_versions.equipment_quantity%TYPE
683: := FND_API.G_MISS_NUM
684: ,p_pji_summarized_flag IN pa_budget_versions.pji_summarized_flag%TYPE
685: := FND_API.G_MISS_CHAR
686: ,p_wp_version_flag IN pa_budget_versions.wp_version_flag%TYPE
687: := FND_API.G_MISS_CHAR
688: ,p_current_planning_period IN pa_budget_versions.current_planning_period%TYPE
689: := FND_API.G_MISS_CHAR
690: ,p_period_mask_id IN pa_budget_versions.period_mask_id%TYPE

Line 688: ,p_current_planning_period IN pa_budget_versions.current_planning_period%TYPE

684: ,p_pji_summarized_flag IN pa_budget_versions.pji_summarized_flag%TYPE
685: := FND_API.G_MISS_CHAR
686: ,p_wp_version_flag IN pa_budget_versions.wp_version_flag%TYPE
687: := FND_API.G_MISS_CHAR
688: ,p_current_planning_period IN pa_budget_versions.current_planning_period%TYPE
689: := FND_API.G_MISS_CHAR
690: ,p_period_mask_id IN pa_budget_versions.period_mask_id%TYPE
691: := FND_API.G_MISS_NUM
692: ,p_last_amt_gen_date IN pa_budget_versions.last_amt_gen_date%TYPE

Line 690: ,p_period_mask_id IN pa_budget_versions.period_mask_id%TYPE

686: ,p_wp_version_flag IN pa_budget_versions.wp_version_flag%TYPE
687: := FND_API.G_MISS_CHAR
688: ,p_current_planning_period IN pa_budget_versions.current_planning_period%TYPE
689: := FND_API.G_MISS_CHAR
690: ,p_period_mask_id IN pa_budget_versions.period_mask_id%TYPE
691: := FND_API.G_MISS_NUM
692: ,p_last_amt_gen_date IN pa_budget_versions.last_amt_gen_date%TYPE
693: := FND_API.G_MISS_DATE
694: ,p_actual_amts_thru_period IN pa_budget_versions.actual_amts_thru_period%TYPE

Line 692: ,p_last_amt_gen_date IN pa_budget_versions.last_amt_gen_date%TYPE

688: ,p_current_planning_period IN pa_budget_versions.current_planning_period%TYPE
689: := FND_API.G_MISS_CHAR
690: ,p_period_mask_id IN pa_budget_versions.period_mask_id%TYPE
691: := FND_API.G_MISS_NUM
692: ,p_last_amt_gen_date IN pa_budget_versions.last_amt_gen_date%TYPE
693: := FND_API.G_MISS_DATE
694: ,p_actual_amts_thru_period IN pa_budget_versions.actual_amts_thru_period%TYPE
695: := FND_API.G_MISS_CHAR
696: -- Bug 3354518: end of new columns for FP-M

Line 694: ,p_actual_amts_thru_period IN pa_budget_versions.actual_amts_thru_period%TYPE

690: ,p_period_mask_id IN pa_budget_versions.period_mask_id%TYPE
691: := FND_API.G_MISS_NUM
692: ,p_last_amt_gen_date IN pa_budget_versions.last_amt_gen_date%TYPE
693: := FND_API.G_MISS_DATE
694: ,p_actual_amts_thru_period IN pa_budget_versions.actual_amts_thru_period%TYPE
695: := FND_API.G_MISS_CHAR
696: -- Bug 3354518: end of new columns for FP-M
697: ,p_row_id IN ROWID
698: := NULL

Line 705: UPDATE pa_budget_versions

701: BEGIN
702:
703: x_return_status := FND_API.G_RET_STS_SUCCESS;
704:
705: UPDATE pa_budget_versions
706: SET
707: record_version_number = nvl(record_version_number,0) +1
708: ,project_id = DECODE( p_project_id, FND_API.G_MISS_NUM, project_id,
709: p_project_id)

Line 936: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

932: RAISE;
933: END Update_Row;
934:
935: PROCEDURE Lock_Row
936: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
937: ,p_record_version_number IN NUMBER
938: := NULL
939: ,p_row_id IN ROWID
940: := NULL

Line 948: FROM pa_budget_versions

944: BEGIN
945: x_return_status := FND_API.G_RET_STS_SUCCESS;
946:
947: SELECT rowid into l_row_id
948: FROM pa_budget_versions
949: WHERE budget_version_id = p_budget_version_id
950: OR rowid = p_row_id
951: FOR UPDATE NOWAIT;
952:

Line 969: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

965: RAISE;
966: END Lock_Row;
967:
968: PROCEDURE Delete_Row
969: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
970: ,p_record_version_number IN NUMBER
971: := NULL
972: ,p_row_id IN ROWID
973: := NULL

Line 982: DELETE FROM pa_budget_versions

978:
979: IF (p_budget_version_id IS NOT NULL AND
980: p_budget_version_id <> FND_API.G_MISS_NUM) THEN
981:
982: DELETE FROM pa_budget_versions
983: WHERE budget_version_id = p_budget_version_id
984: AND nvl(p_record_version_number, nvl(record_version_number,0)) =
985: nvl(record_version_number,0);
986: ELSIF (p_row_id IS NOT NULL) THEN

Line 987: DELETE FROM pa_budget_versions

983: WHERE budget_version_id = p_budget_version_id
984: AND nvl(p_record_version_number, nvl(record_version_number,0)) =
985: nvl(record_version_number,0);
986: ELSIF (p_row_id IS NOT NULL) THEN
987: DELETE FROM pa_budget_versions
988: WHERE rowid = p_row_id
989: AND nvl(p_record_version_number, nvl(record_version_number,0)) =
990: nvl(record_version_number,0);
991: END IF;