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_LINES_PKG dependencies on PA_BUDGET_LINES

Line 24: ( p_resource_assignment_id IN pa_budget_lines.resource_assignment_id%TYPE

20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PA_FP_BUDGET_LINES_PKG';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pafpbltb.pls';
22:
23: PROCEDURE Insert_Row
24: ( p_resource_assignment_id IN pa_budget_lines.resource_assignment_id%TYPE
25: := FND_API.G_MISS_NUM
26: ,p_start_date IN pa_budget_lines.start_date%TYPE
27: := FND_API.G_MISS_DATE
28: ,p_end_date IN pa_budget_lines.end_date%TYPE

Line 26: ,p_start_date IN pa_budget_lines.start_date%TYPE

22:
23: PROCEDURE Insert_Row
24: ( p_resource_assignment_id IN pa_budget_lines.resource_assignment_id%TYPE
25: := FND_API.G_MISS_NUM
26: ,p_start_date IN pa_budget_lines.start_date%TYPE
27: := FND_API.G_MISS_DATE
28: ,p_end_date IN pa_budget_lines.end_date%TYPE
29: := FND_API.G_MISS_DATE
30: ,p_period_name IN pa_budget_lines.period_name%TYPE

Line 28: ,p_end_date IN pa_budget_lines.end_date%TYPE

24: ( p_resource_assignment_id IN pa_budget_lines.resource_assignment_id%TYPE
25: := FND_API.G_MISS_NUM
26: ,p_start_date IN pa_budget_lines.start_date%TYPE
27: := FND_API.G_MISS_DATE
28: ,p_end_date IN pa_budget_lines.end_date%TYPE
29: := FND_API.G_MISS_DATE
30: ,p_period_name IN pa_budget_lines.period_name%TYPE
31: := FND_API.G_MISS_CHAR
32: ,p_quantity IN pa_budget_lines.quantity%TYPE

Line 30: ,p_period_name IN pa_budget_lines.period_name%TYPE

26: ,p_start_date IN pa_budget_lines.start_date%TYPE
27: := FND_API.G_MISS_DATE
28: ,p_end_date IN pa_budget_lines.end_date%TYPE
29: := FND_API.G_MISS_DATE
30: ,p_period_name IN pa_budget_lines.period_name%TYPE
31: := FND_API.G_MISS_CHAR
32: ,p_quantity IN pa_budget_lines.quantity%TYPE
33: := FND_API.G_MISS_NUM
34: ,p_raw_cost IN pa_budget_lines.raw_cost%TYPE

Line 32: ,p_quantity IN pa_budget_lines.quantity%TYPE

28: ,p_end_date IN pa_budget_lines.end_date%TYPE
29: := FND_API.G_MISS_DATE
30: ,p_period_name IN pa_budget_lines.period_name%TYPE
31: := FND_API.G_MISS_CHAR
32: ,p_quantity IN pa_budget_lines.quantity%TYPE
33: := FND_API.G_MISS_NUM
34: ,p_raw_cost IN pa_budget_lines.raw_cost%TYPE
35: := FND_API.G_MISS_NUM
36: ,p_burdened_cost IN pa_budget_lines.burdened_cost%TYPE

Line 34: ,p_raw_cost IN pa_budget_lines.raw_cost%TYPE

30: ,p_period_name IN pa_budget_lines.period_name%TYPE
31: := FND_API.G_MISS_CHAR
32: ,p_quantity IN pa_budget_lines.quantity%TYPE
33: := FND_API.G_MISS_NUM
34: ,p_raw_cost IN pa_budget_lines.raw_cost%TYPE
35: := FND_API.G_MISS_NUM
36: ,p_burdened_cost IN pa_budget_lines.burdened_cost%TYPE
37: := FND_API.G_MISS_NUM
38: ,p_revenue IN pa_budget_lines.revenue%TYPE

Line 36: ,p_burdened_cost IN pa_budget_lines.burdened_cost%TYPE

32: ,p_quantity IN pa_budget_lines.quantity%TYPE
33: := FND_API.G_MISS_NUM
34: ,p_raw_cost IN pa_budget_lines.raw_cost%TYPE
35: := FND_API.G_MISS_NUM
36: ,p_burdened_cost IN pa_budget_lines.burdened_cost%TYPE
37: := FND_API.G_MISS_NUM
38: ,p_revenue IN pa_budget_lines.revenue%TYPE
39: := FND_API.G_MISS_NUM
40: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE

Line 38: ,p_revenue IN pa_budget_lines.revenue%TYPE

34: ,p_raw_cost IN pa_budget_lines.raw_cost%TYPE
35: := FND_API.G_MISS_NUM
36: ,p_burdened_cost IN pa_budget_lines.burdened_cost%TYPE
37: := FND_API.G_MISS_NUM
38: ,p_revenue IN pa_budget_lines.revenue%TYPE
39: := FND_API.G_MISS_NUM
40: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE
41: := FND_API.G_MISS_CHAR
42: ,p_description IN pa_budget_lines.description%TYPE

Line 40: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE

36: ,p_burdened_cost IN pa_budget_lines.burdened_cost%TYPE
37: := FND_API.G_MISS_NUM
38: ,p_revenue IN pa_budget_lines.revenue%TYPE
39: := FND_API.G_MISS_NUM
40: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE
41: := FND_API.G_MISS_CHAR
42: ,p_description IN pa_budget_lines.description%TYPE
43: := FND_API.G_MISS_CHAR
44: ,p_attribute_category IN pa_budget_lines.attribute_category%TYPE

Line 42: ,p_description IN pa_budget_lines.description%TYPE

38: ,p_revenue IN pa_budget_lines.revenue%TYPE
39: := FND_API.G_MISS_NUM
40: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE
41: := FND_API.G_MISS_CHAR
42: ,p_description IN pa_budget_lines.description%TYPE
43: := FND_API.G_MISS_CHAR
44: ,p_attribute_category IN pa_budget_lines.attribute_category%TYPE
45: := FND_API.G_MISS_CHAR
46: ,p_attribute1 IN pa_budget_lines.attribute1%TYPE

Line 44: ,p_attribute_category IN pa_budget_lines.attribute_category%TYPE

40: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE
41: := FND_API.G_MISS_CHAR
42: ,p_description IN pa_budget_lines.description%TYPE
43: := FND_API.G_MISS_CHAR
44: ,p_attribute_category IN pa_budget_lines.attribute_category%TYPE
45: := FND_API.G_MISS_CHAR
46: ,p_attribute1 IN pa_budget_lines.attribute1%TYPE
47: := FND_API.G_MISS_CHAR
48: ,p_attribute2 IN pa_budget_lines.attribute2%TYPE

Line 46: ,p_attribute1 IN pa_budget_lines.attribute1%TYPE

42: ,p_description IN pa_budget_lines.description%TYPE
43: := FND_API.G_MISS_CHAR
44: ,p_attribute_category IN pa_budget_lines.attribute_category%TYPE
45: := FND_API.G_MISS_CHAR
46: ,p_attribute1 IN pa_budget_lines.attribute1%TYPE
47: := FND_API.G_MISS_CHAR
48: ,p_attribute2 IN pa_budget_lines.attribute2%TYPE
49: := FND_API.G_MISS_CHAR
50: ,p_attribute3 IN pa_budget_lines.attribute3%TYPE

Line 48: ,p_attribute2 IN pa_budget_lines.attribute2%TYPE

44: ,p_attribute_category IN pa_budget_lines.attribute_category%TYPE
45: := FND_API.G_MISS_CHAR
46: ,p_attribute1 IN pa_budget_lines.attribute1%TYPE
47: := FND_API.G_MISS_CHAR
48: ,p_attribute2 IN pa_budget_lines.attribute2%TYPE
49: := FND_API.G_MISS_CHAR
50: ,p_attribute3 IN pa_budget_lines.attribute3%TYPE
51: := FND_API.G_MISS_CHAR
52: ,p_attribute4 IN pa_budget_lines.attribute4%TYPE

Line 50: ,p_attribute3 IN pa_budget_lines.attribute3%TYPE

46: ,p_attribute1 IN pa_budget_lines.attribute1%TYPE
47: := FND_API.G_MISS_CHAR
48: ,p_attribute2 IN pa_budget_lines.attribute2%TYPE
49: := FND_API.G_MISS_CHAR
50: ,p_attribute3 IN pa_budget_lines.attribute3%TYPE
51: := FND_API.G_MISS_CHAR
52: ,p_attribute4 IN pa_budget_lines.attribute4%TYPE
53: := FND_API.G_MISS_CHAR
54: ,p_attribute5 IN pa_budget_lines.attribute5%TYPE

Line 52: ,p_attribute4 IN pa_budget_lines.attribute4%TYPE

48: ,p_attribute2 IN pa_budget_lines.attribute2%TYPE
49: := FND_API.G_MISS_CHAR
50: ,p_attribute3 IN pa_budget_lines.attribute3%TYPE
51: := FND_API.G_MISS_CHAR
52: ,p_attribute4 IN pa_budget_lines.attribute4%TYPE
53: := FND_API.G_MISS_CHAR
54: ,p_attribute5 IN pa_budget_lines.attribute5%TYPE
55: := FND_API.G_MISS_CHAR
56: ,p_attribute6 IN pa_budget_lines.attribute6%TYPE

Line 54: ,p_attribute5 IN pa_budget_lines.attribute5%TYPE

50: ,p_attribute3 IN pa_budget_lines.attribute3%TYPE
51: := FND_API.G_MISS_CHAR
52: ,p_attribute4 IN pa_budget_lines.attribute4%TYPE
53: := FND_API.G_MISS_CHAR
54: ,p_attribute5 IN pa_budget_lines.attribute5%TYPE
55: := FND_API.G_MISS_CHAR
56: ,p_attribute6 IN pa_budget_lines.attribute6%TYPE
57: := FND_API.G_MISS_CHAR
58: ,p_attribute7 IN pa_budget_lines.attribute7%TYPE

Line 56: ,p_attribute6 IN pa_budget_lines.attribute6%TYPE

52: ,p_attribute4 IN pa_budget_lines.attribute4%TYPE
53: := FND_API.G_MISS_CHAR
54: ,p_attribute5 IN pa_budget_lines.attribute5%TYPE
55: := FND_API.G_MISS_CHAR
56: ,p_attribute6 IN pa_budget_lines.attribute6%TYPE
57: := FND_API.G_MISS_CHAR
58: ,p_attribute7 IN pa_budget_lines.attribute7%TYPE
59: := FND_API.G_MISS_CHAR
60: ,p_attribute8 IN pa_budget_lines.attribute8%TYPE

Line 58: ,p_attribute7 IN pa_budget_lines.attribute7%TYPE

54: ,p_attribute5 IN pa_budget_lines.attribute5%TYPE
55: := FND_API.G_MISS_CHAR
56: ,p_attribute6 IN pa_budget_lines.attribute6%TYPE
57: := FND_API.G_MISS_CHAR
58: ,p_attribute7 IN pa_budget_lines.attribute7%TYPE
59: := FND_API.G_MISS_CHAR
60: ,p_attribute8 IN pa_budget_lines.attribute8%TYPE
61: := FND_API.G_MISS_CHAR
62: ,p_attribute9 IN pa_budget_lines.attribute9%TYPE

Line 60: ,p_attribute8 IN pa_budget_lines.attribute8%TYPE

56: ,p_attribute6 IN pa_budget_lines.attribute6%TYPE
57: := FND_API.G_MISS_CHAR
58: ,p_attribute7 IN pa_budget_lines.attribute7%TYPE
59: := FND_API.G_MISS_CHAR
60: ,p_attribute8 IN pa_budget_lines.attribute8%TYPE
61: := FND_API.G_MISS_CHAR
62: ,p_attribute9 IN pa_budget_lines.attribute9%TYPE
63: := FND_API.G_MISS_CHAR
64: ,p_attribute10 IN pa_budget_lines.attribute10%TYPE

Line 62: ,p_attribute9 IN pa_budget_lines.attribute9%TYPE

58: ,p_attribute7 IN pa_budget_lines.attribute7%TYPE
59: := FND_API.G_MISS_CHAR
60: ,p_attribute8 IN pa_budget_lines.attribute8%TYPE
61: := FND_API.G_MISS_CHAR
62: ,p_attribute9 IN pa_budget_lines.attribute9%TYPE
63: := FND_API.G_MISS_CHAR
64: ,p_attribute10 IN pa_budget_lines.attribute10%TYPE
65: := FND_API.G_MISS_CHAR
66: ,p_attribute11 IN pa_budget_lines.attribute11%TYPE

Line 64: ,p_attribute10 IN pa_budget_lines.attribute10%TYPE

60: ,p_attribute8 IN pa_budget_lines.attribute8%TYPE
61: := FND_API.G_MISS_CHAR
62: ,p_attribute9 IN pa_budget_lines.attribute9%TYPE
63: := FND_API.G_MISS_CHAR
64: ,p_attribute10 IN pa_budget_lines.attribute10%TYPE
65: := FND_API.G_MISS_CHAR
66: ,p_attribute11 IN pa_budget_lines.attribute11%TYPE
67: := FND_API.G_MISS_CHAR
68: ,p_attribute12 IN pa_budget_lines.attribute12%TYPE

Line 66: ,p_attribute11 IN pa_budget_lines.attribute11%TYPE

62: ,p_attribute9 IN pa_budget_lines.attribute9%TYPE
63: := FND_API.G_MISS_CHAR
64: ,p_attribute10 IN pa_budget_lines.attribute10%TYPE
65: := FND_API.G_MISS_CHAR
66: ,p_attribute11 IN pa_budget_lines.attribute11%TYPE
67: := FND_API.G_MISS_CHAR
68: ,p_attribute12 IN pa_budget_lines.attribute12%TYPE
69: := FND_API.G_MISS_CHAR
70: ,p_attribute13 IN pa_budget_lines.attribute13%TYPE

Line 68: ,p_attribute12 IN pa_budget_lines.attribute12%TYPE

64: ,p_attribute10 IN pa_budget_lines.attribute10%TYPE
65: := FND_API.G_MISS_CHAR
66: ,p_attribute11 IN pa_budget_lines.attribute11%TYPE
67: := FND_API.G_MISS_CHAR
68: ,p_attribute12 IN pa_budget_lines.attribute12%TYPE
69: := FND_API.G_MISS_CHAR
70: ,p_attribute13 IN pa_budget_lines.attribute13%TYPE
71: := FND_API.G_MISS_CHAR
72: ,p_attribute14 IN pa_budget_lines.attribute14%TYPE

Line 70: ,p_attribute13 IN pa_budget_lines.attribute13%TYPE

66: ,p_attribute11 IN pa_budget_lines.attribute11%TYPE
67: := FND_API.G_MISS_CHAR
68: ,p_attribute12 IN pa_budget_lines.attribute12%TYPE
69: := FND_API.G_MISS_CHAR
70: ,p_attribute13 IN pa_budget_lines.attribute13%TYPE
71: := FND_API.G_MISS_CHAR
72: ,p_attribute14 IN pa_budget_lines.attribute14%TYPE
73: := FND_API.G_MISS_CHAR
74: ,p_attribute15 IN pa_budget_lines.attribute15%TYPE

Line 72: ,p_attribute14 IN pa_budget_lines.attribute14%TYPE

68: ,p_attribute12 IN pa_budget_lines.attribute12%TYPE
69: := FND_API.G_MISS_CHAR
70: ,p_attribute13 IN pa_budget_lines.attribute13%TYPE
71: := FND_API.G_MISS_CHAR
72: ,p_attribute14 IN pa_budget_lines.attribute14%TYPE
73: := FND_API.G_MISS_CHAR
74: ,p_attribute15 IN pa_budget_lines.attribute15%TYPE
75: := FND_API.G_MISS_CHAR
76: ,p_raw_cost_source IN pa_budget_lines.raw_cost_source%TYPE

Line 74: ,p_attribute15 IN pa_budget_lines.attribute15%TYPE

70: ,p_attribute13 IN pa_budget_lines.attribute13%TYPE
71: := FND_API.G_MISS_CHAR
72: ,p_attribute14 IN pa_budget_lines.attribute14%TYPE
73: := FND_API.G_MISS_CHAR
74: ,p_attribute15 IN pa_budget_lines.attribute15%TYPE
75: := FND_API.G_MISS_CHAR
76: ,p_raw_cost_source IN pa_budget_lines.raw_cost_source%TYPE
77: := FND_API.G_MISS_CHAR
78: ,p_burdened_cost_source IN pa_budget_lines.burdened_cost_source%TYPE

Line 76: ,p_raw_cost_source IN pa_budget_lines.raw_cost_source%TYPE

72: ,p_attribute14 IN pa_budget_lines.attribute14%TYPE
73: := FND_API.G_MISS_CHAR
74: ,p_attribute15 IN pa_budget_lines.attribute15%TYPE
75: := FND_API.G_MISS_CHAR
76: ,p_raw_cost_source IN pa_budget_lines.raw_cost_source%TYPE
77: := FND_API.G_MISS_CHAR
78: ,p_burdened_cost_source IN pa_budget_lines.burdened_cost_source%TYPE
79: := FND_API.G_MISS_CHAR
80: ,p_quantity_source IN pa_budget_lines.quantity_source%TYPE

Line 78: ,p_burdened_cost_source IN pa_budget_lines.burdened_cost_source%TYPE

74: ,p_attribute15 IN pa_budget_lines.attribute15%TYPE
75: := FND_API.G_MISS_CHAR
76: ,p_raw_cost_source IN pa_budget_lines.raw_cost_source%TYPE
77: := FND_API.G_MISS_CHAR
78: ,p_burdened_cost_source IN pa_budget_lines.burdened_cost_source%TYPE
79: := FND_API.G_MISS_CHAR
80: ,p_quantity_source IN pa_budget_lines.quantity_source%TYPE
81: := FND_API.G_MISS_CHAR
82: ,p_revenue_source IN pa_budget_lines.revenue_source%TYPE

Line 80: ,p_quantity_source IN pa_budget_lines.quantity_source%TYPE

76: ,p_raw_cost_source IN pa_budget_lines.raw_cost_source%TYPE
77: := FND_API.G_MISS_CHAR
78: ,p_burdened_cost_source IN pa_budget_lines.burdened_cost_source%TYPE
79: := FND_API.G_MISS_CHAR
80: ,p_quantity_source IN pa_budget_lines.quantity_source%TYPE
81: := FND_API.G_MISS_CHAR
82: ,p_revenue_source IN pa_budget_lines.revenue_source%TYPE
83: := FND_API.G_MISS_CHAR
84: ,p_pm_product_code IN pa_budget_lines.pm_product_code%TYPE

Line 82: ,p_revenue_source IN pa_budget_lines.revenue_source%TYPE

78: ,p_burdened_cost_source IN pa_budget_lines.burdened_cost_source%TYPE
79: := FND_API.G_MISS_CHAR
80: ,p_quantity_source IN pa_budget_lines.quantity_source%TYPE
81: := FND_API.G_MISS_CHAR
82: ,p_revenue_source IN pa_budget_lines.revenue_source%TYPE
83: := FND_API.G_MISS_CHAR
84: ,p_pm_product_code IN pa_budget_lines.pm_product_code%TYPE
85: := FND_API.G_MISS_CHAR
86: ,p_pm_budget_line_reference IN pa_budget_lines.pm_budget_line_reference%TYPE

Line 84: ,p_pm_product_code IN pa_budget_lines.pm_product_code%TYPE

80: ,p_quantity_source IN pa_budget_lines.quantity_source%TYPE
81: := FND_API.G_MISS_CHAR
82: ,p_revenue_source IN pa_budget_lines.revenue_source%TYPE
83: := FND_API.G_MISS_CHAR
84: ,p_pm_product_code IN pa_budget_lines.pm_product_code%TYPE
85: := FND_API.G_MISS_CHAR
86: ,p_pm_budget_line_reference IN pa_budget_lines.pm_budget_line_reference%TYPE
87: := FND_API.G_MISS_CHAR
88: ,p_cost_rejection_code IN pa_budget_lines.cost_rejection_code%TYPE

Line 86: ,p_pm_budget_line_reference IN pa_budget_lines.pm_budget_line_reference%TYPE

82: ,p_revenue_source IN pa_budget_lines.revenue_source%TYPE
83: := FND_API.G_MISS_CHAR
84: ,p_pm_product_code IN pa_budget_lines.pm_product_code%TYPE
85: := FND_API.G_MISS_CHAR
86: ,p_pm_budget_line_reference IN pa_budget_lines.pm_budget_line_reference%TYPE
87: := FND_API.G_MISS_CHAR
88: ,p_cost_rejection_code IN pa_budget_lines.cost_rejection_code%TYPE
89: := FND_API.G_MISS_CHAR
90: ,p_revenue_rejection_code IN pa_budget_lines.revenue_rejection_code%TYPE

Line 88: ,p_cost_rejection_code IN pa_budget_lines.cost_rejection_code%TYPE

84: ,p_pm_product_code IN pa_budget_lines.pm_product_code%TYPE
85: := FND_API.G_MISS_CHAR
86: ,p_pm_budget_line_reference IN pa_budget_lines.pm_budget_line_reference%TYPE
87: := FND_API.G_MISS_CHAR
88: ,p_cost_rejection_code IN pa_budget_lines.cost_rejection_code%TYPE
89: := FND_API.G_MISS_CHAR
90: ,p_revenue_rejection_code IN pa_budget_lines.revenue_rejection_code%TYPE
91: := FND_API.G_MISS_CHAR
92: ,p_burden_rejection_code IN pa_budget_lines.burden_rejection_code%TYPE

Line 90: ,p_revenue_rejection_code IN pa_budget_lines.revenue_rejection_code%TYPE

86: ,p_pm_budget_line_reference IN pa_budget_lines.pm_budget_line_reference%TYPE
87: := FND_API.G_MISS_CHAR
88: ,p_cost_rejection_code IN pa_budget_lines.cost_rejection_code%TYPE
89: := FND_API.G_MISS_CHAR
90: ,p_revenue_rejection_code IN pa_budget_lines.revenue_rejection_code%TYPE
91: := FND_API.G_MISS_CHAR
92: ,p_burden_rejection_code IN pa_budget_lines.burden_rejection_code%TYPE
93: := FND_API.G_MISS_CHAR
94: ,p_other_rejection_code IN pa_budget_lines.other_rejection_code%TYPE

Line 92: ,p_burden_rejection_code IN pa_budget_lines.burden_rejection_code%TYPE

88: ,p_cost_rejection_code IN pa_budget_lines.cost_rejection_code%TYPE
89: := FND_API.G_MISS_CHAR
90: ,p_revenue_rejection_code IN pa_budget_lines.revenue_rejection_code%TYPE
91: := FND_API.G_MISS_CHAR
92: ,p_burden_rejection_code IN pa_budget_lines.burden_rejection_code%TYPE
93: := FND_API.G_MISS_CHAR
94: ,p_other_rejection_code IN pa_budget_lines.other_rejection_code%TYPE
95: := FND_API.G_MISS_CHAR
96: ,p_code_combination_id IN pa_budget_lines.code_combination_id%TYPE

Line 94: ,p_other_rejection_code IN pa_budget_lines.other_rejection_code%TYPE

90: ,p_revenue_rejection_code IN pa_budget_lines.revenue_rejection_code%TYPE
91: := FND_API.G_MISS_CHAR
92: ,p_burden_rejection_code IN pa_budget_lines.burden_rejection_code%TYPE
93: := FND_API.G_MISS_CHAR
94: ,p_other_rejection_code IN pa_budget_lines.other_rejection_code%TYPE
95: := FND_API.G_MISS_CHAR
96: ,p_code_combination_id IN pa_budget_lines.code_combination_id%TYPE
97: := FND_API.G_MISS_NUM
98: ,p_ccid_gen_status_code IN pa_budget_lines.ccid_gen_status_code%TYPE

Line 96: ,p_code_combination_id IN pa_budget_lines.code_combination_id%TYPE

92: ,p_burden_rejection_code IN pa_budget_lines.burden_rejection_code%TYPE
93: := FND_API.G_MISS_CHAR
94: ,p_other_rejection_code IN pa_budget_lines.other_rejection_code%TYPE
95: := FND_API.G_MISS_CHAR
96: ,p_code_combination_id IN pa_budget_lines.code_combination_id%TYPE
97: := FND_API.G_MISS_NUM
98: ,p_ccid_gen_status_code IN pa_budget_lines.ccid_gen_status_code%TYPE
99: := FND_API.G_MISS_CHAR
100: ,p_ccid_gen_rej_message IN pa_budget_lines.ccid_gen_rej_message%TYPE

Line 98: ,p_ccid_gen_status_code IN pa_budget_lines.ccid_gen_status_code%TYPE

94: ,p_other_rejection_code IN pa_budget_lines.other_rejection_code%TYPE
95: := FND_API.G_MISS_CHAR
96: ,p_code_combination_id IN pa_budget_lines.code_combination_id%TYPE
97: := FND_API.G_MISS_NUM
98: ,p_ccid_gen_status_code IN pa_budget_lines.ccid_gen_status_code%TYPE
99: := FND_API.G_MISS_CHAR
100: ,p_ccid_gen_rej_message IN pa_budget_lines.ccid_gen_rej_message%TYPE
101: := FND_API.G_MISS_CHAR
102: ,p_request_id IN pa_budget_lines.request_id%TYPE

Line 100: ,p_ccid_gen_rej_message IN pa_budget_lines.ccid_gen_rej_message%TYPE

96: ,p_code_combination_id IN pa_budget_lines.code_combination_id%TYPE
97: := FND_API.G_MISS_NUM
98: ,p_ccid_gen_status_code IN pa_budget_lines.ccid_gen_status_code%TYPE
99: := FND_API.G_MISS_CHAR
100: ,p_ccid_gen_rej_message IN pa_budget_lines.ccid_gen_rej_message%TYPE
101: := FND_API.G_MISS_CHAR
102: ,p_request_id IN pa_budget_lines.request_id%TYPE
103: := FND_API.G_MISS_NUM
104: ,p_borrowed_revenue IN pa_budget_lines.borrowed_revenue%TYPE

Line 102: ,p_request_id IN pa_budget_lines.request_id%TYPE

98: ,p_ccid_gen_status_code IN pa_budget_lines.ccid_gen_status_code%TYPE
99: := FND_API.G_MISS_CHAR
100: ,p_ccid_gen_rej_message IN pa_budget_lines.ccid_gen_rej_message%TYPE
101: := FND_API.G_MISS_CHAR
102: ,p_request_id IN pa_budget_lines.request_id%TYPE
103: := FND_API.G_MISS_NUM
104: ,p_borrowed_revenue IN pa_budget_lines.borrowed_revenue%TYPE
105: := FND_API.G_MISS_NUM
106: ,p_tp_revenue_in IN pa_budget_lines.tp_revenue_in%TYPE

Line 104: ,p_borrowed_revenue IN pa_budget_lines.borrowed_revenue%TYPE

100: ,p_ccid_gen_rej_message IN pa_budget_lines.ccid_gen_rej_message%TYPE
101: := FND_API.G_MISS_CHAR
102: ,p_request_id IN pa_budget_lines.request_id%TYPE
103: := FND_API.G_MISS_NUM
104: ,p_borrowed_revenue IN pa_budget_lines.borrowed_revenue%TYPE
105: := FND_API.G_MISS_NUM
106: ,p_tp_revenue_in IN pa_budget_lines.tp_revenue_in%TYPE
107: := FND_API.G_MISS_NUM
108: ,p_tp_revenue_out IN pa_budget_lines.tp_revenue_out%TYPE

Line 106: ,p_tp_revenue_in IN pa_budget_lines.tp_revenue_in%TYPE

102: ,p_request_id IN pa_budget_lines.request_id%TYPE
103: := FND_API.G_MISS_NUM
104: ,p_borrowed_revenue IN pa_budget_lines.borrowed_revenue%TYPE
105: := FND_API.G_MISS_NUM
106: ,p_tp_revenue_in IN pa_budget_lines.tp_revenue_in%TYPE
107: := FND_API.G_MISS_NUM
108: ,p_tp_revenue_out IN pa_budget_lines.tp_revenue_out%TYPE
109: := FND_API.G_MISS_NUM
110: ,p_revenue_adj IN pa_budget_lines.revenue_adj%TYPE

Line 108: ,p_tp_revenue_out IN pa_budget_lines.tp_revenue_out%TYPE

104: ,p_borrowed_revenue IN pa_budget_lines.borrowed_revenue%TYPE
105: := FND_API.G_MISS_NUM
106: ,p_tp_revenue_in IN pa_budget_lines.tp_revenue_in%TYPE
107: := FND_API.G_MISS_NUM
108: ,p_tp_revenue_out IN pa_budget_lines.tp_revenue_out%TYPE
109: := FND_API.G_MISS_NUM
110: ,p_revenue_adj IN pa_budget_lines.revenue_adj%TYPE
111: := FND_API.G_MISS_NUM
112: ,p_lent_resource_cost IN pa_budget_lines.lent_resource_cost%TYPE

Line 110: ,p_revenue_adj IN pa_budget_lines.revenue_adj%TYPE

106: ,p_tp_revenue_in IN pa_budget_lines.tp_revenue_in%TYPE
107: := FND_API.G_MISS_NUM
108: ,p_tp_revenue_out IN pa_budget_lines.tp_revenue_out%TYPE
109: := FND_API.G_MISS_NUM
110: ,p_revenue_adj IN pa_budget_lines.revenue_adj%TYPE
111: := FND_API.G_MISS_NUM
112: ,p_lent_resource_cost IN pa_budget_lines.lent_resource_cost%TYPE
113: := FND_API.G_MISS_NUM
114: ,p_tp_cost_in IN pa_budget_lines.tp_cost_in%TYPE

Line 112: ,p_lent_resource_cost IN pa_budget_lines.lent_resource_cost%TYPE

108: ,p_tp_revenue_out IN pa_budget_lines.tp_revenue_out%TYPE
109: := FND_API.G_MISS_NUM
110: ,p_revenue_adj IN pa_budget_lines.revenue_adj%TYPE
111: := FND_API.G_MISS_NUM
112: ,p_lent_resource_cost IN pa_budget_lines.lent_resource_cost%TYPE
113: := FND_API.G_MISS_NUM
114: ,p_tp_cost_in IN pa_budget_lines.tp_cost_in%TYPE
115: := FND_API.G_MISS_NUM
116: ,p_tp_cost_out IN pa_budget_lines.tp_cost_out%TYPE

Line 114: ,p_tp_cost_in IN pa_budget_lines.tp_cost_in%TYPE

110: ,p_revenue_adj IN pa_budget_lines.revenue_adj%TYPE
111: := FND_API.G_MISS_NUM
112: ,p_lent_resource_cost IN pa_budget_lines.lent_resource_cost%TYPE
113: := FND_API.G_MISS_NUM
114: ,p_tp_cost_in IN pa_budget_lines.tp_cost_in%TYPE
115: := FND_API.G_MISS_NUM
116: ,p_tp_cost_out IN pa_budget_lines.tp_cost_out%TYPE
117: := FND_API.G_MISS_NUM
118: ,p_cost_adj IN pa_budget_lines.cost_adj%TYPE

Line 116: ,p_tp_cost_out IN pa_budget_lines.tp_cost_out%TYPE

112: ,p_lent_resource_cost IN pa_budget_lines.lent_resource_cost%TYPE
113: := FND_API.G_MISS_NUM
114: ,p_tp_cost_in IN pa_budget_lines.tp_cost_in%TYPE
115: := FND_API.G_MISS_NUM
116: ,p_tp_cost_out IN pa_budget_lines.tp_cost_out%TYPE
117: := FND_API.G_MISS_NUM
118: ,p_cost_adj IN pa_budget_lines.cost_adj%TYPE
119: := FND_API.G_MISS_NUM
120: ,p_unassigned_time_cost IN pa_budget_lines.unassigned_time_cost%TYPE

Line 118: ,p_cost_adj IN pa_budget_lines.cost_adj%TYPE

114: ,p_tp_cost_in IN pa_budget_lines.tp_cost_in%TYPE
115: := FND_API.G_MISS_NUM
116: ,p_tp_cost_out IN pa_budget_lines.tp_cost_out%TYPE
117: := FND_API.G_MISS_NUM
118: ,p_cost_adj IN pa_budget_lines.cost_adj%TYPE
119: := FND_API.G_MISS_NUM
120: ,p_unassigned_time_cost IN pa_budget_lines.unassigned_time_cost%TYPE
121: := FND_API.G_MISS_NUM
122: ,p_utilization_percent IN pa_budget_lines.utilization_percent%TYPE

Line 120: ,p_unassigned_time_cost IN pa_budget_lines.unassigned_time_cost%TYPE

116: ,p_tp_cost_out IN pa_budget_lines.tp_cost_out%TYPE
117: := FND_API.G_MISS_NUM
118: ,p_cost_adj IN pa_budget_lines.cost_adj%TYPE
119: := FND_API.G_MISS_NUM
120: ,p_unassigned_time_cost IN pa_budget_lines.unassigned_time_cost%TYPE
121: := FND_API.G_MISS_NUM
122: ,p_utilization_percent IN pa_budget_lines.utilization_percent%TYPE
123: := FND_API.G_MISS_NUM
124: ,p_utilization_hours IN pa_budget_lines.utilization_hours%TYPE

Line 122: ,p_utilization_percent IN pa_budget_lines.utilization_percent%TYPE

118: ,p_cost_adj IN pa_budget_lines.cost_adj%TYPE
119: := FND_API.G_MISS_NUM
120: ,p_unassigned_time_cost IN pa_budget_lines.unassigned_time_cost%TYPE
121: := FND_API.G_MISS_NUM
122: ,p_utilization_percent IN pa_budget_lines.utilization_percent%TYPE
123: := FND_API.G_MISS_NUM
124: ,p_utilization_hours IN pa_budget_lines.utilization_hours%TYPE
125: := FND_API.G_MISS_NUM
126: ,p_utilization_adj IN pa_budget_lines.utilization_adj%TYPE

Line 124: ,p_utilization_hours IN pa_budget_lines.utilization_hours%TYPE

120: ,p_unassigned_time_cost IN pa_budget_lines.unassigned_time_cost%TYPE
121: := FND_API.G_MISS_NUM
122: ,p_utilization_percent IN pa_budget_lines.utilization_percent%TYPE
123: := FND_API.G_MISS_NUM
124: ,p_utilization_hours IN pa_budget_lines.utilization_hours%TYPE
125: := FND_API.G_MISS_NUM
126: ,p_utilization_adj IN pa_budget_lines.utilization_adj%TYPE
127: := FND_API.G_MISS_NUM
128: ,p_capacity IN pa_budget_lines.capacity%TYPE

Line 126: ,p_utilization_adj IN pa_budget_lines.utilization_adj%TYPE

122: ,p_utilization_percent IN pa_budget_lines.utilization_percent%TYPE
123: := FND_API.G_MISS_NUM
124: ,p_utilization_hours IN pa_budget_lines.utilization_hours%TYPE
125: := FND_API.G_MISS_NUM
126: ,p_utilization_adj IN pa_budget_lines.utilization_adj%TYPE
127: := FND_API.G_MISS_NUM
128: ,p_capacity IN pa_budget_lines.capacity%TYPE
129: := FND_API.G_MISS_NUM
130: ,p_head_count IN pa_budget_lines.head_count%TYPE

Line 128: ,p_capacity IN pa_budget_lines.capacity%TYPE

124: ,p_utilization_hours IN pa_budget_lines.utilization_hours%TYPE
125: := FND_API.G_MISS_NUM
126: ,p_utilization_adj IN pa_budget_lines.utilization_adj%TYPE
127: := FND_API.G_MISS_NUM
128: ,p_capacity IN pa_budget_lines.capacity%TYPE
129: := FND_API.G_MISS_NUM
130: ,p_head_count IN pa_budget_lines.head_count%TYPE
131: := FND_API.G_MISS_NUM
132: ,p_head_count_adj IN pa_budget_lines.head_count_adj%TYPE

Line 130: ,p_head_count IN pa_budget_lines.head_count%TYPE

126: ,p_utilization_adj IN pa_budget_lines.utilization_adj%TYPE
127: := FND_API.G_MISS_NUM
128: ,p_capacity IN pa_budget_lines.capacity%TYPE
129: := FND_API.G_MISS_NUM
130: ,p_head_count IN pa_budget_lines.head_count%TYPE
131: := FND_API.G_MISS_NUM
132: ,p_head_count_adj IN pa_budget_lines.head_count_adj%TYPE
133: := FND_API.G_MISS_NUM,
134: p_projfunc_currency_code in pa_budget_lines.projfunc_currency_code%type := FND_API.G_MISS_CHAR,

Line 132: ,p_head_count_adj IN pa_budget_lines.head_count_adj%TYPE

128: ,p_capacity IN pa_budget_lines.capacity%TYPE
129: := FND_API.G_MISS_NUM
130: ,p_head_count IN pa_budget_lines.head_count%TYPE
131: := FND_API.G_MISS_NUM
132: ,p_head_count_adj IN pa_budget_lines.head_count_adj%TYPE
133: := FND_API.G_MISS_NUM,
134: p_projfunc_currency_code in pa_budget_lines.projfunc_currency_code%type := FND_API.G_MISS_CHAR,
135: p_projfunc_cost_rate_type in pa_budget_lines.projfunc_cost_rate_type%type := FND_API.G_MISS_CHAR,
136: p_projfunc_cost_exchange_rate in pa_budget_lines.projfunc_cost_exchange_rate%type := FND_API.G_MISS_NUM,

Line 134: p_projfunc_currency_code in pa_budget_lines.projfunc_currency_code%type := FND_API.G_MISS_CHAR,

130: ,p_head_count IN pa_budget_lines.head_count%TYPE
131: := FND_API.G_MISS_NUM
132: ,p_head_count_adj IN pa_budget_lines.head_count_adj%TYPE
133: := FND_API.G_MISS_NUM,
134: p_projfunc_currency_code in pa_budget_lines.projfunc_currency_code%type := FND_API.G_MISS_CHAR,
135: p_projfunc_cost_rate_type in pa_budget_lines.projfunc_cost_rate_type%type := FND_API.G_MISS_CHAR,
136: p_projfunc_cost_exchange_rate in pa_budget_lines.projfunc_cost_exchange_rate%type := FND_API.G_MISS_NUM,
137: p_projfunc_cost_rate_date_type in pa_budget_lines.projfunc_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
138: p_projfunc_cost_rate_date in pa_budget_lines.projfunc_cost_rate_date%type := FND_API.G_MISS_DATE,

Line 135: p_projfunc_cost_rate_type in pa_budget_lines.projfunc_cost_rate_type%type := FND_API.G_MISS_CHAR,

131: := FND_API.G_MISS_NUM
132: ,p_head_count_adj IN pa_budget_lines.head_count_adj%TYPE
133: := FND_API.G_MISS_NUM,
134: p_projfunc_currency_code in pa_budget_lines.projfunc_currency_code%type := FND_API.G_MISS_CHAR,
135: p_projfunc_cost_rate_type in pa_budget_lines.projfunc_cost_rate_type%type := FND_API.G_MISS_CHAR,
136: p_projfunc_cost_exchange_rate in pa_budget_lines.projfunc_cost_exchange_rate%type := FND_API.G_MISS_NUM,
137: p_projfunc_cost_rate_date_type in pa_budget_lines.projfunc_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
138: p_projfunc_cost_rate_date in pa_budget_lines.projfunc_cost_rate_date%type := FND_API.G_MISS_DATE,
139: p_projfunc_rev_rate_type in pa_budget_lines.projfunc_rev_rate_type%type := FND_API.G_MISS_CHAR,

Line 136: p_projfunc_cost_exchange_rate in pa_budget_lines.projfunc_cost_exchange_rate%type := FND_API.G_MISS_NUM,

132: ,p_head_count_adj IN pa_budget_lines.head_count_adj%TYPE
133: := FND_API.G_MISS_NUM,
134: p_projfunc_currency_code in pa_budget_lines.projfunc_currency_code%type := FND_API.G_MISS_CHAR,
135: p_projfunc_cost_rate_type in pa_budget_lines.projfunc_cost_rate_type%type := FND_API.G_MISS_CHAR,
136: p_projfunc_cost_exchange_rate in pa_budget_lines.projfunc_cost_exchange_rate%type := FND_API.G_MISS_NUM,
137: p_projfunc_cost_rate_date_type in pa_budget_lines.projfunc_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
138: p_projfunc_cost_rate_date in pa_budget_lines.projfunc_cost_rate_date%type := FND_API.G_MISS_DATE,
139: p_projfunc_rev_rate_type in pa_budget_lines.projfunc_rev_rate_type%type := FND_API.G_MISS_CHAR,
140: p_projfunc_rev_rate_date_type in pa_budget_lines.projfunc_rev_rate_date_type%type := FND_API.G_MISS_CHAR,

Line 137: p_projfunc_cost_rate_date_type in pa_budget_lines.projfunc_cost_rate_date_type%type := FND_API.G_MISS_CHAR,

133: := FND_API.G_MISS_NUM,
134: p_projfunc_currency_code in pa_budget_lines.projfunc_currency_code%type := FND_API.G_MISS_CHAR,
135: p_projfunc_cost_rate_type in pa_budget_lines.projfunc_cost_rate_type%type := FND_API.G_MISS_CHAR,
136: p_projfunc_cost_exchange_rate in pa_budget_lines.projfunc_cost_exchange_rate%type := FND_API.G_MISS_NUM,
137: p_projfunc_cost_rate_date_type in pa_budget_lines.projfunc_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
138: p_projfunc_cost_rate_date in pa_budget_lines.projfunc_cost_rate_date%type := FND_API.G_MISS_DATE,
139: p_projfunc_rev_rate_type in pa_budget_lines.projfunc_rev_rate_type%type := FND_API.G_MISS_CHAR,
140: p_projfunc_rev_rate_date_type in pa_budget_lines.projfunc_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
141: p_projfunc_rev_exchange_rate in pa_budget_lines.projfunc_rev_exchange_rate%type := FND_API.G_MISS_NUM,

Line 138: p_projfunc_cost_rate_date in pa_budget_lines.projfunc_cost_rate_date%type := FND_API.G_MISS_DATE,

134: p_projfunc_currency_code in pa_budget_lines.projfunc_currency_code%type := FND_API.G_MISS_CHAR,
135: p_projfunc_cost_rate_type in pa_budget_lines.projfunc_cost_rate_type%type := FND_API.G_MISS_CHAR,
136: p_projfunc_cost_exchange_rate in pa_budget_lines.projfunc_cost_exchange_rate%type := FND_API.G_MISS_NUM,
137: p_projfunc_cost_rate_date_type in pa_budget_lines.projfunc_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
138: p_projfunc_cost_rate_date in pa_budget_lines.projfunc_cost_rate_date%type := FND_API.G_MISS_DATE,
139: p_projfunc_rev_rate_type in pa_budget_lines.projfunc_rev_rate_type%type := FND_API.G_MISS_CHAR,
140: p_projfunc_rev_rate_date_type in pa_budget_lines.projfunc_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
141: p_projfunc_rev_exchange_rate in pa_budget_lines.projfunc_rev_exchange_rate%type := FND_API.G_MISS_NUM,
142: p_projfunc_rev_rate_date in pa_budget_lines.projfunc_rev_rate_date%type := FND_API.G_MISS_DATE,

Line 139: p_projfunc_rev_rate_type in pa_budget_lines.projfunc_rev_rate_type%type := FND_API.G_MISS_CHAR,

135: p_projfunc_cost_rate_type in pa_budget_lines.projfunc_cost_rate_type%type := FND_API.G_MISS_CHAR,
136: p_projfunc_cost_exchange_rate in pa_budget_lines.projfunc_cost_exchange_rate%type := FND_API.G_MISS_NUM,
137: p_projfunc_cost_rate_date_type in pa_budget_lines.projfunc_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
138: p_projfunc_cost_rate_date in pa_budget_lines.projfunc_cost_rate_date%type := FND_API.G_MISS_DATE,
139: p_projfunc_rev_rate_type in pa_budget_lines.projfunc_rev_rate_type%type := FND_API.G_MISS_CHAR,
140: p_projfunc_rev_rate_date_type in pa_budget_lines.projfunc_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
141: p_projfunc_rev_exchange_rate in pa_budget_lines.projfunc_rev_exchange_rate%type := FND_API.G_MISS_NUM,
142: p_projfunc_rev_rate_date in pa_budget_lines.projfunc_rev_rate_date%type := FND_API.G_MISS_DATE,
143: p_project_currency_code in pa_budget_lines.project_currency_code%type := FND_API.G_MISS_CHAR,

Line 140: p_projfunc_rev_rate_date_type in pa_budget_lines.projfunc_rev_rate_date_type%type := FND_API.G_MISS_CHAR,

136: p_projfunc_cost_exchange_rate in pa_budget_lines.projfunc_cost_exchange_rate%type := FND_API.G_MISS_NUM,
137: p_projfunc_cost_rate_date_type in pa_budget_lines.projfunc_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
138: p_projfunc_cost_rate_date in pa_budget_lines.projfunc_cost_rate_date%type := FND_API.G_MISS_DATE,
139: p_projfunc_rev_rate_type in pa_budget_lines.projfunc_rev_rate_type%type := FND_API.G_MISS_CHAR,
140: p_projfunc_rev_rate_date_type in pa_budget_lines.projfunc_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
141: p_projfunc_rev_exchange_rate in pa_budget_lines.projfunc_rev_exchange_rate%type := FND_API.G_MISS_NUM,
142: p_projfunc_rev_rate_date in pa_budget_lines.projfunc_rev_rate_date%type := FND_API.G_MISS_DATE,
143: p_project_currency_code in pa_budget_lines.project_currency_code%type := FND_API.G_MISS_CHAR,
144: p_project_cost_rate_type in pa_budget_lines.project_cost_rate_type%type := FND_API.G_MISS_CHAR,

Line 141: p_projfunc_rev_exchange_rate in pa_budget_lines.projfunc_rev_exchange_rate%type := FND_API.G_MISS_NUM,

137: p_projfunc_cost_rate_date_type in pa_budget_lines.projfunc_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
138: p_projfunc_cost_rate_date in pa_budget_lines.projfunc_cost_rate_date%type := FND_API.G_MISS_DATE,
139: p_projfunc_rev_rate_type in pa_budget_lines.projfunc_rev_rate_type%type := FND_API.G_MISS_CHAR,
140: p_projfunc_rev_rate_date_type in pa_budget_lines.projfunc_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
141: p_projfunc_rev_exchange_rate in pa_budget_lines.projfunc_rev_exchange_rate%type := FND_API.G_MISS_NUM,
142: p_projfunc_rev_rate_date in pa_budget_lines.projfunc_rev_rate_date%type := FND_API.G_MISS_DATE,
143: p_project_currency_code in pa_budget_lines.project_currency_code%type := FND_API.G_MISS_CHAR,
144: p_project_cost_rate_type in pa_budget_lines.project_cost_rate_type%type := FND_API.G_MISS_CHAR,
145: p_project_cost_exchange_rate in pa_budget_lines.project_cost_exchange_rate%type := FND_API.G_MISS_NUM,

Line 142: p_projfunc_rev_rate_date in pa_budget_lines.projfunc_rev_rate_date%type := FND_API.G_MISS_DATE,

138: p_projfunc_cost_rate_date in pa_budget_lines.projfunc_cost_rate_date%type := FND_API.G_MISS_DATE,
139: p_projfunc_rev_rate_type in pa_budget_lines.projfunc_rev_rate_type%type := FND_API.G_MISS_CHAR,
140: p_projfunc_rev_rate_date_type in pa_budget_lines.projfunc_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
141: p_projfunc_rev_exchange_rate in pa_budget_lines.projfunc_rev_exchange_rate%type := FND_API.G_MISS_NUM,
142: p_projfunc_rev_rate_date in pa_budget_lines.projfunc_rev_rate_date%type := FND_API.G_MISS_DATE,
143: p_project_currency_code in pa_budget_lines.project_currency_code%type := FND_API.G_MISS_CHAR,
144: p_project_cost_rate_type in pa_budget_lines.project_cost_rate_type%type := FND_API.G_MISS_CHAR,
145: p_project_cost_exchange_rate in pa_budget_lines.project_cost_exchange_rate%type := FND_API.G_MISS_NUM,
146: p_project_cost_rate_date_type in pa_budget_lines.project_cost_rate_date_type%type := FND_API.G_MISS_CHAR,

Line 143: p_project_currency_code in pa_budget_lines.project_currency_code%type := FND_API.G_MISS_CHAR,

139: p_projfunc_rev_rate_type in pa_budget_lines.projfunc_rev_rate_type%type := FND_API.G_MISS_CHAR,
140: p_projfunc_rev_rate_date_type in pa_budget_lines.projfunc_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
141: p_projfunc_rev_exchange_rate in pa_budget_lines.projfunc_rev_exchange_rate%type := FND_API.G_MISS_NUM,
142: p_projfunc_rev_rate_date in pa_budget_lines.projfunc_rev_rate_date%type := FND_API.G_MISS_DATE,
143: p_project_currency_code in pa_budget_lines.project_currency_code%type := FND_API.G_MISS_CHAR,
144: p_project_cost_rate_type in pa_budget_lines.project_cost_rate_type%type := FND_API.G_MISS_CHAR,
145: p_project_cost_exchange_rate in pa_budget_lines.project_cost_exchange_rate%type := FND_API.G_MISS_NUM,
146: p_project_cost_rate_date_type in pa_budget_lines.project_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
147: p_project_cost_rate_date in pa_budget_lines.project_cost_rate_date%type := FND_API.G_MISS_DATE,

Line 144: p_project_cost_rate_type in pa_budget_lines.project_cost_rate_type%type := FND_API.G_MISS_CHAR,

140: p_projfunc_rev_rate_date_type in pa_budget_lines.projfunc_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
141: p_projfunc_rev_exchange_rate in pa_budget_lines.projfunc_rev_exchange_rate%type := FND_API.G_MISS_NUM,
142: p_projfunc_rev_rate_date in pa_budget_lines.projfunc_rev_rate_date%type := FND_API.G_MISS_DATE,
143: p_project_currency_code in pa_budget_lines.project_currency_code%type := FND_API.G_MISS_CHAR,
144: p_project_cost_rate_type in pa_budget_lines.project_cost_rate_type%type := FND_API.G_MISS_CHAR,
145: p_project_cost_exchange_rate in pa_budget_lines.project_cost_exchange_rate%type := FND_API.G_MISS_NUM,
146: p_project_cost_rate_date_type in pa_budget_lines.project_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
147: p_project_cost_rate_date in pa_budget_lines.project_cost_rate_date%type := FND_API.G_MISS_DATE,
148: p_project_raw_cost in pa_budget_lines.project_raw_cost%type := FND_API.G_MISS_NUM,

Line 145: p_project_cost_exchange_rate in pa_budget_lines.project_cost_exchange_rate%type := FND_API.G_MISS_NUM,

141: p_projfunc_rev_exchange_rate in pa_budget_lines.projfunc_rev_exchange_rate%type := FND_API.G_MISS_NUM,
142: p_projfunc_rev_rate_date in pa_budget_lines.projfunc_rev_rate_date%type := FND_API.G_MISS_DATE,
143: p_project_currency_code in pa_budget_lines.project_currency_code%type := FND_API.G_MISS_CHAR,
144: p_project_cost_rate_type in pa_budget_lines.project_cost_rate_type%type := FND_API.G_MISS_CHAR,
145: p_project_cost_exchange_rate in pa_budget_lines.project_cost_exchange_rate%type := FND_API.G_MISS_NUM,
146: p_project_cost_rate_date_type in pa_budget_lines.project_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
147: p_project_cost_rate_date in pa_budget_lines.project_cost_rate_date%type := FND_API.G_MISS_DATE,
148: p_project_raw_cost in pa_budget_lines.project_raw_cost%type := FND_API.G_MISS_NUM,
149: p_project_burdened_cost in pa_budget_lines.project_burdened_cost%type := FND_API.G_MISS_NUM,

Line 146: p_project_cost_rate_date_type in pa_budget_lines.project_cost_rate_date_type%type := FND_API.G_MISS_CHAR,

142: p_projfunc_rev_rate_date in pa_budget_lines.projfunc_rev_rate_date%type := FND_API.G_MISS_DATE,
143: p_project_currency_code in pa_budget_lines.project_currency_code%type := FND_API.G_MISS_CHAR,
144: p_project_cost_rate_type in pa_budget_lines.project_cost_rate_type%type := FND_API.G_MISS_CHAR,
145: p_project_cost_exchange_rate in pa_budget_lines.project_cost_exchange_rate%type := FND_API.G_MISS_NUM,
146: p_project_cost_rate_date_type in pa_budget_lines.project_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
147: p_project_cost_rate_date in pa_budget_lines.project_cost_rate_date%type := FND_API.G_MISS_DATE,
148: p_project_raw_cost in pa_budget_lines.project_raw_cost%type := FND_API.G_MISS_NUM,
149: p_project_burdened_cost in pa_budget_lines.project_burdened_cost%type := FND_API.G_MISS_NUM,
150: p_project_revenue in pa_budget_lines.project_revenue%type := FND_API.G_MISS_NUM,

Line 147: p_project_cost_rate_date in pa_budget_lines.project_cost_rate_date%type := FND_API.G_MISS_DATE,

143: p_project_currency_code in pa_budget_lines.project_currency_code%type := FND_API.G_MISS_CHAR,
144: p_project_cost_rate_type in pa_budget_lines.project_cost_rate_type%type := FND_API.G_MISS_CHAR,
145: p_project_cost_exchange_rate in pa_budget_lines.project_cost_exchange_rate%type := FND_API.G_MISS_NUM,
146: p_project_cost_rate_date_type in pa_budget_lines.project_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
147: p_project_cost_rate_date in pa_budget_lines.project_cost_rate_date%type := FND_API.G_MISS_DATE,
148: p_project_raw_cost in pa_budget_lines.project_raw_cost%type := FND_API.G_MISS_NUM,
149: p_project_burdened_cost in pa_budget_lines.project_burdened_cost%type := FND_API.G_MISS_NUM,
150: p_project_revenue in pa_budget_lines.project_revenue%type := FND_API.G_MISS_NUM,
151: p_txn_raw_cost in pa_budget_lines.txn_raw_cost%type := FND_API.G_MISS_NUM,

Line 148: p_project_raw_cost in pa_budget_lines.project_raw_cost%type := FND_API.G_MISS_NUM,

144: p_project_cost_rate_type in pa_budget_lines.project_cost_rate_type%type := FND_API.G_MISS_CHAR,
145: p_project_cost_exchange_rate in pa_budget_lines.project_cost_exchange_rate%type := FND_API.G_MISS_NUM,
146: p_project_cost_rate_date_type in pa_budget_lines.project_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
147: p_project_cost_rate_date in pa_budget_lines.project_cost_rate_date%type := FND_API.G_MISS_DATE,
148: p_project_raw_cost in pa_budget_lines.project_raw_cost%type := FND_API.G_MISS_NUM,
149: p_project_burdened_cost in pa_budget_lines.project_burdened_cost%type := FND_API.G_MISS_NUM,
150: p_project_revenue in pa_budget_lines.project_revenue%type := FND_API.G_MISS_NUM,
151: p_txn_raw_cost in pa_budget_lines.txn_raw_cost%type := FND_API.G_MISS_NUM,
152: p_txn_burdened_cost in pa_budget_lines.txn_burdened_cost%type := FND_API.G_MISS_NUM,

Line 149: p_project_burdened_cost in pa_budget_lines.project_burdened_cost%type := FND_API.G_MISS_NUM,

145: p_project_cost_exchange_rate in pa_budget_lines.project_cost_exchange_rate%type := FND_API.G_MISS_NUM,
146: p_project_cost_rate_date_type in pa_budget_lines.project_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
147: p_project_cost_rate_date in pa_budget_lines.project_cost_rate_date%type := FND_API.G_MISS_DATE,
148: p_project_raw_cost in pa_budget_lines.project_raw_cost%type := FND_API.G_MISS_NUM,
149: p_project_burdened_cost in pa_budget_lines.project_burdened_cost%type := FND_API.G_MISS_NUM,
150: p_project_revenue in pa_budget_lines.project_revenue%type := FND_API.G_MISS_NUM,
151: p_txn_raw_cost in pa_budget_lines.txn_raw_cost%type := FND_API.G_MISS_NUM,
152: p_txn_burdened_cost in pa_budget_lines.txn_burdened_cost%type := FND_API.G_MISS_NUM,
153: p_txn_revenue in pa_budget_lines.txn_revenue%type := FND_API.G_MISS_NUM,

Line 150: p_project_revenue in pa_budget_lines.project_revenue%type := FND_API.G_MISS_NUM,

146: p_project_cost_rate_date_type in pa_budget_lines.project_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
147: p_project_cost_rate_date in pa_budget_lines.project_cost_rate_date%type := FND_API.G_MISS_DATE,
148: p_project_raw_cost in pa_budget_lines.project_raw_cost%type := FND_API.G_MISS_NUM,
149: p_project_burdened_cost in pa_budget_lines.project_burdened_cost%type := FND_API.G_MISS_NUM,
150: p_project_revenue in pa_budget_lines.project_revenue%type := FND_API.G_MISS_NUM,
151: p_txn_raw_cost in pa_budget_lines.txn_raw_cost%type := FND_API.G_MISS_NUM,
152: p_txn_burdened_cost in pa_budget_lines.txn_burdened_cost%type := FND_API.G_MISS_NUM,
153: p_txn_revenue in pa_budget_lines.txn_revenue%type := FND_API.G_MISS_NUM,
154: p_txn_currency_code in pa_budget_lines.txn_currency_code%type := FND_API.G_MISS_CHAR,

Line 151: p_txn_raw_cost in pa_budget_lines.txn_raw_cost%type := FND_API.G_MISS_NUM,

147: p_project_cost_rate_date in pa_budget_lines.project_cost_rate_date%type := FND_API.G_MISS_DATE,
148: p_project_raw_cost in pa_budget_lines.project_raw_cost%type := FND_API.G_MISS_NUM,
149: p_project_burdened_cost in pa_budget_lines.project_burdened_cost%type := FND_API.G_MISS_NUM,
150: p_project_revenue in pa_budget_lines.project_revenue%type := FND_API.G_MISS_NUM,
151: p_txn_raw_cost in pa_budget_lines.txn_raw_cost%type := FND_API.G_MISS_NUM,
152: p_txn_burdened_cost in pa_budget_lines.txn_burdened_cost%type := FND_API.G_MISS_NUM,
153: p_txn_revenue in pa_budget_lines.txn_revenue%type := FND_API.G_MISS_NUM,
154: p_txn_currency_code in pa_budget_lines.txn_currency_code%type := FND_API.G_MISS_CHAR,
155: p_bucketing_period_code in pa_budget_lines.bucketing_period_code%type := FND_API.G_MISS_CHAR,

Line 152: p_txn_burdened_cost in pa_budget_lines.txn_burdened_cost%type := FND_API.G_MISS_NUM,

148: p_project_raw_cost in pa_budget_lines.project_raw_cost%type := FND_API.G_MISS_NUM,
149: p_project_burdened_cost in pa_budget_lines.project_burdened_cost%type := FND_API.G_MISS_NUM,
150: p_project_revenue in pa_budget_lines.project_revenue%type := FND_API.G_MISS_NUM,
151: p_txn_raw_cost in pa_budget_lines.txn_raw_cost%type := FND_API.G_MISS_NUM,
152: p_txn_burdened_cost in pa_budget_lines.txn_burdened_cost%type := FND_API.G_MISS_NUM,
153: p_txn_revenue in pa_budget_lines.txn_revenue%type := FND_API.G_MISS_NUM,
154: p_txn_currency_code in pa_budget_lines.txn_currency_code%type := FND_API.G_MISS_CHAR,
155: p_bucketing_period_code in pa_budget_lines.bucketing_period_code%type := FND_API.G_MISS_CHAR,
156: p_project_rev_rate_type in pa_budget_lines.project_rev_rate_type%type := FND_API.G_MISS_CHAR,

Line 153: p_txn_revenue in pa_budget_lines.txn_revenue%type := FND_API.G_MISS_NUM,

149: p_project_burdened_cost in pa_budget_lines.project_burdened_cost%type := FND_API.G_MISS_NUM,
150: p_project_revenue in pa_budget_lines.project_revenue%type := FND_API.G_MISS_NUM,
151: p_txn_raw_cost in pa_budget_lines.txn_raw_cost%type := FND_API.G_MISS_NUM,
152: p_txn_burdened_cost in pa_budget_lines.txn_burdened_cost%type := FND_API.G_MISS_NUM,
153: p_txn_revenue in pa_budget_lines.txn_revenue%type := FND_API.G_MISS_NUM,
154: p_txn_currency_code in pa_budget_lines.txn_currency_code%type := FND_API.G_MISS_CHAR,
155: p_bucketing_period_code in pa_budget_lines.bucketing_period_code%type := FND_API.G_MISS_CHAR,
156: p_project_rev_rate_type in pa_budget_lines.project_rev_rate_type%type := FND_API.G_MISS_CHAR,
157: p_project_rev_exchange_rate in pa_budget_lines.project_rev_exchange_rate%type := FND_API.G_MISS_NUM,

Line 154: p_txn_currency_code in pa_budget_lines.txn_currency_code%type := FND_API.G_MISS_CHAR,

150: p_project_revenue in pa_budget_lines.project_revenue%type := FND_API.G_MISS_NUM,
151: p_txn_raw_cost in pa_budget_lines.txn_raw_cost%type := FND_API.G_MISS_NUM,
152: p_txn_burdened_cost in pa_budget_lines.txn_burdened_cost%type := FND_API.G_MISS_NUM,
153: p_txn_revenue in pa_budget_lines.txn_revenue%type := FND_API.G_MISS_NUM,
154: p_txn_currency_code in pa_budget_lines.txn_currency_code%type := FND_API.G_MISS_CHAR,
155: p_bucketing_period_code in pa_budget_lines.bucketing_period_code%type := FND_API.G_MISS_CHAR,
156: p_project_rev_rate_type in pa_budget_lines.project_rev_rate_type%type := FND_API.G_MISS_CHAR,
157: p_project_rev_exchange_rate in pa_budget_lines.project_rev_exchange_rate%type := FND_API.G_MISS_NUM,
158: p_project_rev_rate_date_type in pa_budget_lines.project_rev_rate_date_type%type := FND_API.G_MISS_CHAR,

Line 155: p_bucketing_period_code in pa_budget_lines.bucketing_period_code%type := FND_API.G_MISS_CHAR,

151: p_txn_raw_cost in pa_budget_lines.txn_raw_cost%type := FND_API.G_MISS_NUM,
152: p_txn_burdened_cost in pa_budget_lines.txn_burdened_cost%type := FND_API.G_MISS_NUM,
153: p_txn_revenue in pa_budget_lines.txn_revenue%type := FND_API.G_MISS_NUM,
154: p_txn_currency_code in pa_budget_lines.txn_currency_code%type := FND_API.G_MISS_CHAR,
155: p_bucketing_period_code in pa_budget_lines.bucketing_period_code%type := FND_API.G_MISS_CHAR,
156: p_project_rev_rate_type in pa_budget_lines.project_rev_rate_type%type := FND_API.G_MISS_CHAR,
157: p_project_rev_exchange_rate in pa_budget_lines.project_rev_exchange_rate%type := FND_API.G_MISS_NUM,
158: p_project_rev_rate_date_type in pa_budget_lines.project_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
159: p_project_rev_rate_date in pa_budget_lines.project_rev_rate_date%type := FND_API.G_MISS_DATE,

Line 156: p_project_rev_rate_type in pa_budget_lines.project_rev_rate_type%type := FND_API.G_MISS_CHAR,

152: p_txn_burdened_cost in pa_budget_lines.txn_burdened_cost%type := FND_API.G_MISS_NUM,
153: p_txn_revenue in pa_budget_lines.txn_revenue%type := FND_API.G_MISS_NUM,
154: p_txn_currency_code in pa_budget_lines.txn_currency_code%type := FND_API.G_MISS_CHAR,
155: p_bucketing_period_code in pa_budget_lines.bucketing_period_code%type := FND_API.G_MISS_CHAR,
156: p_project_rev_rate_type in pa_budget_lines.project_rev_rate_type%type := FND_API.G_MISS_CHAR,
157: p_project_rev_exchange_rate in pa_budget_lines.project_rev_exchange_rate%type := FND_API.G_MISS_NUM,
158: p_project_rev_rate_date_type in pa_budget_lines.project_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
159: p_project_rev_rate_date in pa_budget_lines.project_rev_rate_date%type := FND_API.G_MISS_DATE,
160: px_budget_line_id IN OUT NOCOPY pa_budget_lines.budget_line_id%type, --File.Sql.39 bug 4440895

Line 157: p_project_rev_exchange_rate in pa_budget_lines.project_rev_exchange_rate%type := FND_API.G_MISS_NUM,

153: p_txn_revenue in pa_budget_lines.txn_revenue%type := FND_API.G_MISS_NUM,
154: p_txn_currency_code in pa_budget_lines.txn_currency_code%type := FND_API.G_MISS_CHAR,
155: p_bucketing_period_code in pa_budget_lines.bucketing_period_code%type := FND_API.G_MISS_CHAR,
156: p_project_rev_rate_type in pa_budget_lines.project_rev_rate_type%type := FND_API.G_MISS_CHAR,
157: p_project_rev_exchange_rate in pa_budget_lines.project_rev_exchange_rate%type := FND_API.G_MISS_NUM,
158: p_project_rev_rate_date_type in pa_budget_lines.project_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
159: p_project_rev_rate_date in pa_budget_lines.project_rev_rate_date%type := FND_API.G_MISS_DATE,
160: px_budget_line_id IN OUT NOCOPY pa_budget_lines.budget_line_id%type, --File.Sql.39 bug 4440895
161: p_budget_version_id in pa_budget_lines.budget_version_id%type := FND_API.G_MISS_NUM,

Line 158: p_project_rev_rate_date_type in pa_budget_lines.project_rev_rate_date_type%type := FND_API.G_MISS_CHAR,

154: p_txn_currency_code in pa_budget_lines.txn_currency_code%type := FND_API.G_MISS_CHAR,
155: p_bucketing_period_code in pa_budget_lines.bucketing_period_code%type := FND_API.G_MISS_CHAR,
156: p_project_rev_rate_type in pa_budget_lines.project_rev_rate_type%type := FND_API.G_MISS_CHAR,
157: p_project_rev_exchange_rate in pa_budget_lines.project_rev_exchange_rate%type := FND_API.G_MISS_NUM,
158: p_project_rev_rate_date_type in pa_budget_lines.project_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
159: p_project_rev_rate_date in pa_budget_lines.project_rev_rate_date%type := FND_API.G_MISS_DATE,
160: px_budget_line_id IN OUT NOCOPY pa_budget_lines.budget_line_id%type, --File.Sql.39 bug 4440895
161: p_budget_version_id in pa_budget_lines.budget_version_id%type := FND_API.G_MISS_NUM,
162: -- Bug Fix: 4569365. Removed MRC code.

Line 159: p_project_rev_rate_date in pa_budget_lines.project_rev_rate_date%type := FND_API.G_MISS_DATE,

155: p_bucketing_period_code in pa_budget_lines.bucketing_period_code%type := FND_API.G_MISS_CHAR,
156: p_project_rev_rate_type in pa_budget_lines.project_rev_rate_type%type := FND_API.G_MISS_CHAR,
157: p_project_rev_exchange_rate in pa_budget_lines.project_rev_exchange_rate%type := FND_API.G_MISS_NUM,
158: p_project_rev_rate_date_type in pa_budget_lines.project_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
159: p_project_rev_rate_date in pa_budget_lines.project_rev_rate_date%type := FND_API.G_MISS_DATE,
160: px_budget_line_id IN OUT NOCOPY pa_budget_lines.budget_line_id%type, --File.Sql.39 bug 4440895
161: p_budget_version_id in pa_budget_lines.budget_version_id%type := FND_API.G_MISS_NUM,
162: -- Bug Fix: 4569365. Removed MRC code.
163: -- p_mrc_flag in VARCHAR2 -- FP Build4 changes

Line 160: px_budget_line_id IN OUT NOCOPY pa_budget_lines.budget_line_id%type, --File.Sql.39 bug 4440895

156: p_project_rev_rate_type in pa_budget_lines.project_rev_rate_type%type := FND_API.G_MISS_CHAR,
157: p_project_rev_exchange_rate in pa_budget_lines.project_rev_exchange_rate%type := FND_API.G_MISS_NUM,
158: p_project_rev_rate_date_type in pa_budget_lines.project_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
159: p_project_rev_rate_date in pa_budget_lines.project_rev_rate_date%type := FND_API.G_MISS_DATE,
160: px_budget_line_id IN OUT NOCOPY pa_budget_lines.budget_line_id%type, --File.Sql.39 bug 4440895
161: p_budget_version_id in pa_budget_lines.budget_version_id%type := FND_API.G_MISS_NUM,
162: -- Bug Fix: 4569365. Removed MRC code.
163: -- p_mrc_flag in VARCHAR2 -- FP Build4 changes
164: x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895

Line 161: p_budget_version_id in pa_budget_lines.budget_version_id%type := FND_API.G_MISS_NUM,

157: p_project_rev_exchange_rate in pa_budget_lines.project_rev_exchange_rate%type := FND_API.G_MISS_NUM,
158: p_project_rev_rate_date_type in pa_budget_lines.project_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
159: p_project_rev_rate_date in pa_budget_lines.project_rev_rate_date%type := FND_API.G_MISS_DATE,
160: px_budget_line_id IN OUT NOCOPY pa_budget_lines.budget_line_id%type, --File.Sql.39 bug 4440895
161: p_budget_version_id in pa_budget_lines.budget_version_id%type := FND_API.G_MISS_NUM,
162: -- Bug Fix: 4569365. Removed MRC code.
163: -- p_mrc_flag in VARCHAR2 -- FP Build4 changes
164: x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
165: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 172: CURSOR C2 IS SELECT pa_budget_lines_s.nextval from sys.dual;

168: l_msg_count NUMBER := 0;
169: l_msg_data VARCHAR2(2000);
170: l_return_status VARCHAR2(2000);
171:
172: CURSOR C2 IS SELECT pa_budget_lines_s.nextval from sys.dual;
173: BEGIN
174: x_return_status := FND_API.G_RET_STS_SUCCESS;
175:
176: IF (px_budget_line_id IS NULL) OR

Line 184: INSERT INTO pa_budget_lines(

180: CLOSE C2;
181: END IF;
182:
183:
184: INSERT INTO pa_budget_lines(
185: resource_assignment_id
186: ,start_date
187: ,last_update_date
188: ,last_updated_by

Line 429: ( p_resource_assignment_id IN pa_budget_lines.resource_assignment_id%TYPE

425: RAISE;
426: End Insert_Row;
427:
428: PROCEDURE Update_Row
429: ( p_resource_assignment_id IN pa_budget_lines.resource_assignment_id%TYPE
430: := FND_API.G_MISS_NUM
431: ,p_start_date IN pa_budget_lines.start_date%TYPE
432: := FND_API.G_MISS_DATE
433: ,p_end_date IN pa_budget_lines.end_date%TYPE

Line 431: ,p_start_date IN pa_budget_lines.start_date%TYPE

427:
428: PROCEDURE Update_Row
429: ( p_resource_assignment_id IN pa_budget_lines.resource_assignment_id%TYPE
430: := FND_API.G_MISS_NUM
431: ,p_start_date IN pa_budget_lines.start_date%TYPE
432: := FND_API.G_MISS_DATE
433: ,p_end_date IN pa_budget_lines.end_date%TYPE
434: := FND_API.G_MISS_DATE
435: ,p_period_name IN pa_budget_lines.period_name%TYPE

Line 433: ,p_end_date IN pa_budget_lines.end_date%TYPE

429: ( p_resource_assignment_id IN pa_budget_lines.resource_assignment_id%TYPE
430: := FND_API.G_MISS_NUM
431: ,p_start_date IN pa_budget_lines.start_date%TYPE
432: := FND_API.G_MISS_DATE
433: ,p_end_date IN pa_budget_lines.end_date%TYPE
434: := FND_API.G_MISS_DATE
435: ,p_period_name IN pa_budget_lines.period_name%TYPE
436: := FND_API.G_MISS_CHAR
437: ,p_quantity IN pa_budget_lines.quantity%TYPE

Line 435: ,p_period_name IN pa_budget_lines.period_name%TYPE

431: ,p_start_date IN pa_budget_lines.start_date%TYPE
432: := FND_API.G_MISS_DATE
433: ,p_end_date IN pa_budget_lines.end_date%TYPE
434: := FND_API.G_MISS_DATE
435: ,p_period_name IN pa_budget_lines.period_name%TYPE
436: := FND_API.G_MISS_CHAR
437: ,p_quantity IN pa_budget_lines.quantity%TYPE
438: := FND_API.G_MISS_NUM
439: ,p_raw_cost IN pa_budget_lines.raw_cost%TYPE

Line 437: ,p_quantity IN pa_budget_lines.quantity%TYPE

433: ,p_end_date IN pa_budget_lines.end_date%TYPE
434: := FND_API.G_MISS_DATE
435: ,p_period_name IN pa_budget_lines.period_name%TYPE
436: := FND_API.G_MISS_CHAR
437: ,p_quantity IN pa_budget_lines.quantity%TYPE
438: := FND_API.G_MISS_NUM
439: ,p_raw_cost IN pa_budget_lines.raw_cost%TYPE
440: := FND_API.G_MISS_NUM
441: ,p_burdened_cost IN pa_budget_lines.burdened_cost%TYPE

Line 439: ,p_raw_cost IN pa_budget_lines.raw_cost%TYPE

435: ,p_period_name IN pa_budget_lines.period_name%TYPE
436: := FND_API.G_MISS_CHAR
437: ,p_quantity IN pa_budget_lines.quantity%TYPE
438: := FND_API.G_MISS_NUM
439: ,p_raw_cost IN pa_budget_lines.raw_cost%TYPE
440: := FND_API.G_MISS_NUM
441: ,p_burdened_cost IN pa_budget_lines.burdened_cost%TYPE
442: := FND_API.G_MISS_NUM
443: ,p_revenue IN pa_budget_lines.revenue%TYPE

Line 441: ,p_burdened_cost IN pa_budget_lines.burdened_cost%TYPE

437: ,p_quantity IN pa_budget_lines.quantity%TYPE
438: := FND_API.G_MISS_NUM
439: ,p_raw_cost IN pa_budget_lines.raw_cost%TYPE
440: := FND_API.G_MISS_NUM
441: ,p_burdened_cost IN pa_budget_lines.burdened_cost%TYPE
442: := FND_API.G_MISS_NUM
443: ,p_revenue IN pa_budget_lines.revenue%TYPE
444: := FND_API.G_MISS_NUM
445: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE

Line 443: ,p_revenue IN pa_budget_lines.revenue%TYPE

439: ,p_raw_cost IN pa_budget_lines.raw_cost%TYPE
440: := FND_API.G_MISS_NUM
441: ,p_burdened_cost IN pa_budget_lines.burdened_cost%TYPE
442: := FND_API.G_MISS_NUM
443: ,p_revenue IN pa_budget_lines.revenue%TYPE
444: := FND_API.G_MISS_NUM
445: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE
446: := FND_API.G_MISS_CHAR
447: ,p_description IN pa_budget_lines.description%TYPE

Line 445: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE

441: ,p_burdened_cost IN pa_budget_lines.burdened_cost%TYPE
442: := FND_API.G_MISS_NUM
443: ,p_revenue IN pa_budget_lines.revenue%TYPE
444: := FND_API.G_MISS_NUM
445: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE
446: := FND_API.G_MISS_CHAR
447: ,p_description IN pa_budget_lines.description%TYPE
448: := FND_API.G_MISS_CHAR
449: ,p_attribute_category IN pa_budget_lines.attribute_category%TYPE

Line 447: ,p_description IN pa_budget_lines.description%TYPE

443: ,p_revenue IN pa_budget_lines.revenue%TYPE
444: := FND_API.G_MISS_NUM
445: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE
446: := FND_API.G_MISS_CHAR
447: ,p_description IN pa_budget_lines.description%TYPE
448: := FND_API.G_MISS_CHAR
449: ,p_attribute_category IN pa_budget_lines.attribute_category%TYPE
450: := FND_API.G_MISS_CHAR
451: ,p_attribute1 IN pa_budget_lines.attribute1%TYPE

Line 449: ,p_attribute_category IN pa_budget_lines.attribute_category%TYPE

445: ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE
446: := FND_API.G_MISS_CHAR
447: ,p_description IN pa_budget_lines.description%TYPE
448: := FND_API.G_MISS_CHAR
449: ,p_attribute_category IN pa_budget_lines.attribute_category%TYPE
450: := FND_API.G_MISS_CHAR
451: ,p_attribute1 IN pa_budget_lines.attribute1%TYPE
452: := FND_API.G_MISS_CHAR
453: ,p_attribute2 IN pa_budget_lines.attribute2%TYPE

Line 451: ,p_attribute1 IN pa_budget_lines.attribute1%TYPE

447: ,p_description IN pa_budget_lines.description%TYPE
448: := FND_API.G_MISS_CHAR
449: ,p_attribute_category IN pa_budget_lines.attribute_category%TYPE
450: := FND_API.G_MISS_CHAR
451: ,p_attribute1 IN pa_budget_lines.attribute1%TYPE
452: := FND_API.G_MISS_CHAR
453: ,p_attribute2 IN pa_budget_lines.attribute2%TYPE
454: := FND_API.G_MISS_CHAR
455: ,p_attribute3 IN pa_budget_lines.attribute3%TYPE

Line 453: ,p_attribute2 IN pa_budget_lines.attribute2%TYPE

449: ,p_attribute_category IN pa_budget_lines.attribute_category%TYPE
450: := FND_API.G_MISS_CHAR
451: ,p_attribute1 IN pa_budget_lines.attribute1%TYPE
452: := FND_API.G_MISS_CHAR
453: ,p_attribute2 IN pa_budget_lines.attribute2%TYPE
454: := FND_API.G_MISS_CHAR
455: ,p_attribute3 IN pa_budget_lines.attribute3%TYPE
456: := FND_API.G_MISS_CHAR
457: ,p_attribute4 IN pa_budget_lines.attribute4%TYPE

Line 455: ,p_attribute3 IN pa_budget_lines.attribute3%TYPE

451: ,p_attribute1 IN pa_budget_lines.attribute1%TYPE
452: := FND_API.G_MISS_CHAR
453: ,p_attribute2 IN pa_budget_lines.attribute2%TYPE
454: := FND_API.G_MISS_CHAR
455: ,p_attribute3 IN pa_budget_lines.attribute3%TYPE
456: := FND_API.G_MISS_CHAR
457: ,p_attribute4 IN pa_budget_lines.attribute4%TYPE
458: := FND_API.G_MISS_CHAR
459: ,p_attribute5 IN pa_budget_lines.attribute5%TYPE

Line 457: ,p_attribute4 IN pa_budget_lines.attribute4%TYPE

453: ,p_attribute2 IN pa_budget_lines.attribute2%TYPE
454: := FND_API.G_MISS_CHAR
455: ,p_attribute3 IN pa_budget_lines.attribute3%TYPE
456: := FND_API.G_MISS_CHAR
457: ,p_attribute4 IN pa_budget_lines.attribute4%TYPE
458: := FND_API.G_MISS_CHAR
459: ,p_attribute5 IN pa_budget_lines.attribute5%TYPE
460: := FND_API.G_MISS_CHAR
461: ,p_attribute6 IN pa_budget_lines.attribute6%TYPE

Line 459: ,p_attribute5 IN pa_budget_lines.attribute5%TYPE

455: ,p_attribute3 IN pa_budget_lines.attribute3%TYPE
456: := FND_API.G_MISS_CHAR
457: ,p_attribute4 IN pa_budget_lines.attribute4%TYPE
458: := FND_API.G_MISS_CHAR
459: ,p_attribute5 IN pa_budget_lines.attribute5%TYPE
460: := FND_API.G_MISS_CHAR
461: ,p_attribute6 IN pa_budget_lines.attribute6%TYPE
462: := FND_API.G_MISS_CHAR
463: ,p_attribute7 IN pa_budget_lines.attribute7%TYPE

Line 461: ,p_attribute6 IN pa_budget_lines.attribute6%TYPE

457: ,p_attribute4 IN pa_budget_lines.attribute4%TYPE
458: := FND_API.G_MISS_CHAR
459: ,p_attribute5 IN pa_budget_lines.attribute5%TYPE
460: := FND_API.G_MISS_CHAR
461: ,p_attribute6 IN pa_budget_lines.attribute6%TYPE
462: := FND_API.G_MISS_CHAR
463: ,p_attribute7 IN pa_budget_lines.attribute7%TYPE
464: := FND_API.G_MISS_CHAR
465: ,p_attribute8 IN pa_budget_lines.attribute8%TYPE

Line 463: ,p_attribute7 IN pa_budget_lines.attribute7%TYPE

459: ,p_attribute5 IN pa_budget_lines.attribute5%TYPE
460: := FND_API.G_MISS_CHAR
461: ,p_attribute6 IN pa_budget_lines.attribute6%TYPE
462: := FND_API.G_MISS_CHAR
463: ,p_attribute7 IN pa_budget_lines.attribute7%TYPE
464: := FND_API.G_MISS_CHAR
465: ,p_attribute8 IN pa_budget_lines.attribute8%TYPE
466: := FND_API.G_MISS_CHAR
467: ,p_attribute9 IN pa_budget_lines.attribute9%TYPE

Line 465: ,p_attribute8 IN pa_budget_lines.attribute8%TYPE

461: ,p_attribute6 IN pa_budget_lines.attribute6%TYPE
462: := FND_API.G_MISS_CHAR
463: ,p_attribute7 IN pa_budget_lines.attribute7%TYPE
464: := FND_API.G_MISS_CHAR
465: ,p_attribute8 IN pa_budget_lines.attribute8%TYPE
466: := FND_API.G_MISS_CHAR
467: ,p_attribute9 IN pa_budget_lines.attribute9%TYPE
468: := FND_API.G_MISS_CHAR
469: ,p_attribute10 IN pa_budget_lines.attribute10%TYPE

Line 467: ,p_attribute9 IN pa_budget_lines.attribute9%TYPE

463: ,p_attribute7 IN pa_budget_lines.attribute7%TYPE
464: := FND_API.G_MISS_CHAR
465: ,p_attribute8 IN pa_budget_lines.attribute8%TYPE
466: := FND_API.G_MISS_CHAR
467: ,p_attribute9 IN pa_budget_lines.attribute9%TYPE
468: := FND_API.G_MISS_CHAR
469: ,p_attribute10 IN pa_budget_lines.attribute10%TYPE
470: := FND_API.G_MISS_CHAR
471: ,p_attribute11 IN pa_budget_lines.attribute11%TYPE

Line 469: ,p_attribute10 IN pa_budget_lines.attribute10%TYPE

465: ,p_attribute8 IN pa_budget_lines.attribute8%TYPE
466: := FND_API.G_MISS_CHAR
467: ,p_attribute9 IN pa_budget_lines.attribute9%TYPE
468: := FND_API.G_MISS_CHAR
469: ,p_attribute10 IN pa_budget_lines.attribute10%TYPE
470: := FND_API.G_MISS_CHAR
471: ,p_attribute11 IN pa_budget_lines.attribute11%TYPE
472: := FND_API.G_MISS_CHAR
473: ,p_attribute12 IN pa_budget_lines.attribute12%TYPE

Line 471: ,p_attribute11 IN pa_budget_lines.attribute11%TYPE

467: ,p_attribute9 IN pa_budget_lines.attribute9%TYPE
468: := FND_API.G_MISS_CHAR
469: ,p_attribute10 IN pa_budget_lines.attribute10%TYPE
470: := FND_API.G_MISS_CHAR
471: ,p_attribute11 IN pa_budget_lines.attribute11%TYPE
472: := FND_API.G_MISS_CHAR
473: ,p_attribute12 IN pa_budget_lines.attribute12%TYPE
474: := FND_API.G_MISS_CHAR
475: ,p_attribute13 IN pa_budget_lines.attribute13%TYPE

Line 473: ,p_attribute12 IN pa_budget_lines.attribute12%TYPE

469: ,p_attribute10 IN pa_budget_lines.attribute10%TYPE
470: := FND_API.G_MISS_CHAR
471: ,p_attribute11 IN pa_budget_lines.attribute11%TYPE
472: := FND_API.G_MISS_CHAR
473: ,p_attribute12 IN pa_budget_lines.attribute12%TYPE
474: := FND_API.G_MISS_CHAR
475: ,p_attribute13 IN pa_budget_lines.attribute13%TYPE
476: := FND_API.G_MISS_CHAR
477: ,p_attribute14 IN pa_budget_lines.attribute14%TYPE

Line 475: ,p_attribute13 IN pa_budget_lines.attribute13%TYPE

471: ,p_attribute11 IN pa_budget_lines.attribute11%TYPE
472: := FND_API.G_MISS_CHAR
473: ,p_attribute12 IN pa_budget_lines.attribute12%TYPE
474: := FND_API.G_MISS_CHAR
475: ,p_attribute13 IN pa_budget_lines.attribute13%TYPE
476: := FND_API.G_MISS_CHAR
477: ,p_attribute14 IN pa_budget_lines.attribute14%TYPE
478: := FND_API.G_MISS_CHAR
479: ,p_attribute15 IN pa_budget_lines.attribute15%TYPE

Line 477: ,p_attribute14 IN pa_budget_lines.attribute14%TYPE

473: ,p_attribute12 IN pa_budget_lines.attribute12%TYPE
474: := FND_API.G_MISS_CHAR
475: ,p_attribute13 IN pa_budget_lines.attribute13%TYPE
476: := FND_API.G_MISS_CHAR
477: ,p_attribute14 IN pa_budget_lines.attribute14%TYPE
478: := FND_API.G_MISS_CHAR
479: ,p_attribute15 IN pa_budget_lines.attribute15%TYPE
480: := FND_API.G_MISS_CHAR
481: ,p_raw_cost_source IN pa_budget_lines.raw_cost_source%TYPE

Line 479: ,p_attribute15 IN pa_budget_lines.attribute15%TYPE

475: ,p_attribute13 IN pa_budget_lines.attribute13%TYPE
476: := FND_API.G_MISS_CHAR
477: ,p_attribute14 IN pa_budget_lines.attribute14%TYPE
478: := FND_API.G_MISS_CHAR
479: ,p_attribute15 IN pa_budget_lines.attribute15%TYPE
480: := FND_API.G_MISS_CHAR
481: ,p_raw_cost_source IN pa_budget_lines.raw_cost_source%TYPE
482: := FND_API.G_MISS_CHAR
483: ,p_burdened_cost_source IN pa_budget_lines.burdened_cost_source%TYPE

Line 481: ,p_raw_cost_source IN pa_budget_lines.raw_cost_source%TYPE

477: ,p_attribute14 IN pa_budget_lines.attribute14%TYPE
478: := FND_API.G_MISS_CHAR
479: ,p_attribute15 IN pa_budget_lines.attribute15%TYPE
480: := FND_API.G_MISS_CHAR
481: ,p_raw_cost_source IN pa_budget_lines.raw_cost_source%TYPE
482: := FND_API.G_MISS_CHAR
483: ,p_burdened_cost_source IN pa_budget_lines.burdened_cost_source%TYPE
484: := FND_API.G_MISS_CHAR
485: ,p_quantity_source IN pa_budget_lines.quantity_source%TYPE

Line 483: ,p_burdened_cost_source IN pa_budget_lines.burdened_cost_source%TYPE

479: ,p_attribute15 IN pa_budget_lines.attribute15%TYPE
480: := FND_API.G_MISS_CHAR
481: ,p_raw_cost_source IN pa_budget_lines.raw_cost_source%TYPE
482: := FND_API.G_MISS_CHAR
483: ,p_burdened_cost_source IN pa_budget_lines.burdened_cost_source%TYPE
484: := FND_API.G_MISS_CHAR
485: ,p_quantity_source IN pa_budget_lines.quantity_source%TYPE
486: := FND_API.G_MISS_CHAR
487: ,p_revenue_source IN pa_budget_lines.revenue_source%TYPE

Line 485: ,p_quantity_source IN pa_budget_lines.quantity_source%TYPE

481: ,p_raw_cost_source IN pa_budget_lines.raw_cost_source%TYPE
482: := FND_API.G_MISS_CHAR
483: ,p_burdened_cost_source IN pa_budget_lines.burdened_cost_source%TYPE
484: := FND_API.G_MISS_CHAR
485: ,p_quantity_source IN pa_budget_lines.quantity_source%TYPE
486: := FND_API.G_MISS_CHAR
487: ,p_revenue_source IN pa_budget_lines.revenue_source%TYPE
488: := FND_API.G_MISS_CHAR
489: ,p_pm_product_code IN pa_budget_lines.pm_product_code%TYPE

Line 487: ,p_revenue_source IN pa_budget_lines.revenue_source%TYPE

483: ,p_burdened_cost_source IN pa_budget_lines.burdened_cost_source%TYPE
484: := FND_API.G_MISS_CHAR
485: ,p_quantity_source IN pa_budget_lines.quantity_source%TYPE
486: := FND_API.G_MISS_CHAR
487: ,p_revenue_source IN pa_budget_lines.revenue_source%TYPE
488: := FND_API.G_MISS_CHAR
489: ,p_pm_product_code IN pa_budget_lines.pm_product_code%TYPE
490: := FND_API.G_MISS_CHAR
491: ,p_pm_budget_line_reference IN pa_budget_lines.pm_budget_line_reference%TYPE

Line 489: ,p_pm_product_code IN pa_budget_lines.pm_product_code%TYPE

485: ,p_quantity_source IN pa_budget_lines.quantity_source%TYPE
486: := FND_API.G_MISS_CHAR
487: ,p_revenue_source IN pa_budget_lines.revenue_source%TYPE
488: := FND_API.G_MISS_CHAR
489: ,p_pm_product_code IN pa_budget_lines.pm_product_code%TYPE
490: := FND_API.G_MISS_CHAR
491: ,p_pm_budget_line_reference IN pa_budget_lines.pm_budget_line_reference%TYPE
492: := FND_API.G_MISS_CHAR
493: ,p_cost_rejection_code IN pa_budget_lines.cost_rejection_code%TYPE

Line 491: ,p_pm_budget_line_reference IN pa_budget_lines.pm_budget_line_reference%TYPE

487: ,p_revenue_source IN pa_budget_lines.revenue_source%TYPE
488: := FND_API.G_MISS_CHAR
489: ,p_pm_product_code IN pa_budget_lines.pm_product_code%TYPE
490: := FND_API.G_MISS_CHAR
491: ,p_pm_budget_line_reference IN pa_budget_lines.pm_budget_line_reference%TYPE
492: := FND_API.G_MISS_CHAR
493: ,p_cost_rejection_code IN pa_budget_lines.cost_rejection_code%TYPE
494: := FND_API.G_MISS_CHAR
495: ,p_revenue_rejection_code IN pa_budget_lines.revenue_rejection_code%TYPE

Line 493: ,p_cost_rejection_code IN pa_budget_lines.cost_rejection_code%TYPE

489: ,p_pm_product_code IN pa_budget_lines.pm_product_code%TYPE
490: := FND_API.G_MISS_CHAR
491: ,p_pm_budget_line_reference IN pa_budget_lines.pm_budget_line_reference%TYPE
492: := FND_API.G_MISS_CHAR
493: ,p_cost_rejection_code IN pa_budget_lines.cost_rejection_code%TYPE
494: := FND_API.G_MISS_CHAR
495: ,p_revenue_rejection_code IN pa_budget_lines.revenue_rejection_code%TYPE
496: := FND_API.G_MISS_CHAR
497: ,p_burden_rejection_code IN pa_budget_lines.burden_rejection_code%TYPE

Line 495: ,p_revenue_rejection_code IN pa_budget_lines.revenue_rejection_code%TYPE

491: ,p_pm_budget_line_reference IN pa_budget_lines.pm_budget_line_reference%TYPE
492: := FND_API.G_MISS_CHAR
493: ,p_cost_rejection_code IN pa_budget_lines.cost_rejection_code%TYPE
494: := FND_API.G_MISS_CHAR
495: ,p_revenue_rejection_code IN pa_budget_lines.revenue_rejection_code%TYPE
496: := FND_API.G_MISS_CHAR
497: ,p_burden_rejection_code IN pa_budget_lines.burden_rejection_code%TYPE
498: := FND_API.G_MISS_CHAR
499: ,p_other_rejection_code IN pa_budget_lines.other_rejection_code%TYPE

Line 497: ,p_burden_rejection_code IN pa_budget_lines.burden_rejection_code%TYPE

493: ,p_cost_rejection_code IN pa_budget_lines.cost_rejection_code%TYPE
494: := FND_API.G_MISS_CHAR
495: ,p_revenue_rejection_code IN pa_budget_lines.revenue_rejection_code%TYPE
496: := FND_API.G_MISS_CHAR
497: ,p_burden_rejection_code IN pa_budget_lines.burden_rejection_code%TYPE
498: := FND_API.G_MISS_CHAR
499: ,p_other_rejection_code IN pa_budget_lines.other_rejection_code%TYPE
500: := FND_API.G_MISS_CHAR
501: ,p_code_combination_id IN pa_budget_lines.code_combination_id%TYPE

Line 499: ,p_other_rejection_code IN pa_budget_lines.other_rejection_code%TYPE

495: ,p_revenue_rejection_code IN pa_budget_lines.revenue_rejection_code%TYPE
496: := FND_API.G_MISS_CHAR
497: ,p_burden_rejection_code IN pa_budget_lines.burden_rejection_code%TYPE
498: := FND_API.G_MISS_CHAR
499: ,p_other_rejection_code IN pa_budget_lines.other_rejection_code%TYPE
500: := FND_API.G_MISS_CHAR
501: ,p_code_combination_id IN pa_budget_lines.code_combination_id%TYPE
502: := FND_API.G_MISS_NUM
503: ,p_ccid_gen_status_code IN pa_budget_lines.ccid_gen_status_code%TYPE

Line 501: ,p_code_combination_id IN pa_budget_lines.code_combination_id%TYPE

497: ,p_burden_rejection_code IN pa_budget_lines.burden_rejection_code%TYPE
498: := FND_API.G_MISS_CHAR
499: ,p_other_rejection_code IN pa_budget_lines.other_rejection_code%TYPE
500: := FND_API.G_MISS_CHAR
501: ,p_code_combination_id IN pa_budget_lines.code_combination_id%TYPE
502: := FND_API.G_MISS_NUM
503: ,p_ccid_gen_status_code IN pa_budget_lines.ccid_gen_status_code%TYPE
504: := FND_API.G_MISS_CHAR
505: ,p_ccid_gen_rej_message IN pa_budget_lines.ccid_gen_rej_message%TYPE

Line 503: ,p_ccid_gen_status_code IN pa_budget_lines.ccid_gen_status_code%TYPE

499: ,p_other_rejection_code IN pa_budget_lines.other_rejection_code%TYPE
500: := FND_API.G_MISS_CHAR
501: ,p_code_combination_id IN pa_budget_lines.code_combination_id%TYPE
502: := FND_API.G_MISS_NUM
503: ,p_ccid_gen_status_code IN pa_budget_lines.ccid_gen_status_code%TYPE
504: := FND_API.G_MISS_CHAR
505: ,p_ccid_gen_rej_message IN pa_budget_lines.ccid_gen_rej_message%TYPE
506: := FND_API.G_MISS_CHAR
507: ,p_request_id IN pa_budget_lines.request_id%TYPE

Line 505: ,p_ccid_gen_rej_message IN pa_budget_lines.ccid_gen_rej_message%TYPE

501: ,p_code_combination_id IN pa_budget_lines.code_combination_id%TYPE
502: := FND_API.G_MISS_NUM
503: ,p_ccid_gen_status_code IN pa_budget_lines.ccid_gen_status_code%TYPE
504: := FND_API.G_MISS_CHAR
505: ,p_ccid_gen_rej_message IN pa_budget_lines.ccid_gen_rej_message%TYPE
506: := FND_API.G_MISS_CHAR
507: ,p_request_id IN pa_budget_lines.request_id%TYPE
508: := FND_API.G_MISS_NUM
509: ,p_borrowed_revenue IN pa_budget_lines.borrowed_revenue%TYPE

Line 507: ,p_request_id IN pa_budget_lines.request_id%TYPE

503: ,p_ccid_gen_status_code IN pa_budget_lines.ccid_gen_status_code%TYPE
504: := FND_API.G_MISS_CHAR
505: ,p_ccid_gen_rej_message IN pa_budget_lines.ccid_gen_rej_message%TYPE
506: := FND_API.G_MISS_CHAR
507: ,p_request_id IN pa_budget_lines.request_id%TYPE
508: := FND_API.G_MISS_NUM
509: ,p_borrowed_revenue IN pa_budget_lines.borrowed_revenue%TYPE
510: := FND_API.G_MISS_NUM
511: ,p_tp_revenue_in IN pa_budget_lines.tp_revenue_in%TYPE

Line 509: ,p_borrowed_revenue IN pa_budget_lines.borrowed_revenue%TYPE

505: ,p_ccid_gen_rej_message IN pa_budget_lines.ccid_gen_rej_message%TYPE
506: := FND_API.G_MISS_CHAR
507: ,p_request_id IN pa_budget_lines.request_id%TYPE
508: := FND_API.G_MISS_NUM
509: ,p_borrowed_revenue IN pa_budget_lines.borrowed_revenue%TYPE
510: := FND_API.G_MISS_NUM
511: ,p_tp_revenue_in IN pa_budget_lines.tp_revenue_in%TYPE
512: := FND_API.G_MISS_NUM
513: ,p_tp_revenue_out IN pa_budget_lines.tp_revenue_out%TYPE

Line 511: ,p_tp_revenue_in IN pa_budget_lines.tp_revenue_in%TYPE

507: ,p_request_id IN pa_budget_lines.request_id%TYPE
508: := FND_API.G_MISS_NUM
509: ,p_borrowed_revenue IN pa_budget_lines.borrowed_revenue%TYPE
510: := FND_API.G_MISS_NUM
511: ,p_tp_revenue_in IN pa_budget_lines.tp_revenue_in%TYPE
512: := FND_API.G_MISS_NUM
513: ,p_tp_revenue_out IN pa_budget_lines.tp_revenue_out%TYPE
514: := FND_API.G_MISS_NUM
515: ,p_revenue_adj IN pa_budget_lines.revenue_adj%TYPE

Line 513: ,p_tp_revenue_out IN pa_budget_lines.tp_revenue_out%TYPE

509: ,p_borrowed_revenue IN pa_budget_lines.borrowed_revenue%TYPE
510: := FND_API.G_MISS_NUM
511: ,p_tp_revenue_in IN pa_budget_lines.tp_revenue_in%TYPE
512: := FND_API.G_MISS_NUM
513: ,p_tp_revenue_out IN pa_budget_lines.tp_revenue_out%TYPE
514: := FND_API.G_MISS_NUM
515: ,p_revenue_adj IN pa_budget_lines.revenue_adj%TYPE
516: := FND_API.G_MISS_NUM
517: ,p_lent_resource_cost IN pa_budget_lines.lent_resource_cost%TYPE

Line 515: ,p_revenue_adj IN pa_budget_lines.revenue_adj%TYPE

511: ,p_tp_revenue_in IN pa_budget_lines.tp_revenue_in%TYPE
512: := FND_API.G_MISS_NUM
513: ,p_tp_revenue_out IN pa_budget_lines.tp_revenue_out%TYPE
514: := FND_API.G_MISS_NUM
515: ,p_revenue_adj IN pa_budget_lines.revenue_adj%TYPE
516: := FND_API.G_MISS_NUM
517: ,p_lent_resource_cost IN pa_budget_lines.lent_resource_cost%TYPE
518: := FND_API.G_MISS_NUM
519: ,p_tp_cost_in IN pa_budget_lines.tp_cost_in%TYPE

Line 517: ,p_lent_resource_cost IN pa_budget_lines.lent_resource_cost%TYPE

513: ,p_tp_revenue_out IN pa_budget_lines.tp_revenue_out%TYPE
514: := FND_API.G_MISS_NUM
515: ,p_revenue_adj IN pa_budget_lines.revenue_adj%TYPE
516: := FND_API.G_MISS_NUM
517: ,p_lent_resource_cost IN pa_budget_lines.lent_resource_cost%TYPE
518: := FND_API.G_MISS_NUM
519: ,p_tp_cost_in IN pa_budget_lines.tp_cost_in%TYPE
520: := FND_API.G_MISS_NUM
521: ,p_tp_cost_out IN pa_budget_lines.tp_cost_out%TYPE

Line 519: ,p_tp_cost_in IN pa_budget_lines.tp_cost_in%TYPE

515: ,p_revenue_adj IN pa_budget_lines.revenue_adj%TYPE
516: := FND_API.G_MISS_NUM
517: ,p_lent_resource_cost IN pa_budget_lines.lent_resource_cost%TYPE
518: := FND_API.G_MISS_NUM
519: ,p_tp_cost_in IN pa_budget_lines.tp_cost_in%TYPE
520: := FND_API.G_MISS_NUM
521: ,p_tp_cost_out IN pa_budget_lines.tp_cost_out%TYPE
522: := FND_API.G_MISS_NUM
523: ,p_cost_adj IN pa_budget_lines.cost_adj%TYPE

Line 521: ,p_tp_cost_out IN pa_budget_lines.tp_cost_out%TYPE

517: ,p_lent_resource_cost IN pa_budget_lines.lent_resource_cost%TYPE
518: := FND_API.G_MISS_NUM
519: ,p_tp_cost_in IN pa_budget_lines.tp_cost_in%TYPE
520: := FND_API.G_MISS_NUM
521: ,p_tp_cost_out IN pa_budget_lines.tp_cost_out%TYPE
522: := FND_API.G_MISS_NUM
523: ,p_cost_adj IN pa_budget_lines.cost_adj%TYPE
524: := FND_API.G_MISS_NUM
525: ,p_unassigned_time_cost IN pa_budget_lines.unassigned_time_cost%TYPE

Line 523: ,p_cost_adj IN pa_budget_lines.cost_adj%TYPE

519: ,p_tp_cost_in IN pa_budget_lines.tp_cost_in%TYPE
520: := FND_API.G_MISS_NUM
521: ,p_tp_cost_out IN pa_budget_lines.tp_cost_out%TYPE
522: := FND_API.G_MISS_NUM
523: ,p_cost_adj IN pa_budget_lines.cost_adj%TYPE
524: := FND_API.G_MISS_NUM
525: ,p_unassigned_time_cost IN pa_budget_lines.unassigned_time_cost%TYPE
526: := FND_API.G_MISS_NUM
527: ,p_utilization_percent IN pa_budget_lines.utilization_percent%TYPE

Line 525: ,p_unassigned_time_cost IN pa_budget_lines.unassigned_time_cost%TYPE

521: ,p_tp_cost_out IN pa_budget_lines.tp_cost_out%TYPE
522: := FND_API.G_MISS_NUM
523: ,p_cost_adj IN pa_budget_lines.cost_adj%TYPE
524: := FND_API.G_MISS_NUM
525: ,p_unassigned_time_cost IN pa_budget_lines.unassigned_time_cost%TYPE
526: := FND_API.G_MISS_NUM
527: ,p_utilization_percent IN pa_budget_lines.utilization_percent%TYPE
528: := FND_API.G_MISS_NUM
529: ,p_utilization_hours IN pa_budget_lines.utilization_hours%TYPE

Line 527: ,p_utilization_percent IN pa_budget_lines.utilization_percent%TYPE

523: ,p_cost_adj IN pa_budget_lines.cost_adj%TYPE
524: := FND_API.G_MISS_NUM
525: ,p_unassigned_time_cost IN pa_budget_lines.unassigned_time_cost%TYPE
526: := FND_API.G_MISS_NUM
527: ,p_utilization_percent IN pa_budget_lines.utilization_percent%TYPE
528: := FND_API.G_MISS_NUM
529: ,p_utilization_hours IN pa_budget_lines.utilization_hours%TYPE
530: := FND_API.G_MISS_NUM
531: ,p_utilization_adj IN pa_budget_lines.utilization_adj%TYPE

Line 529: ,p_utilization_hours IN pa_budget_lines.utilization_hours%TYPE

525: ,p_unassigned_time_cost IN pa_budget_lines.unassigned_time_cost%TYPE
526: := FND_API.G_MISS_NUM
527: ,p_utilization_percent IN pa_budget_lines.utilization_percent%TYPE
528: := FND_API.G_MISS_NUM
529: ,p_utilization_hours IN pa_budget_lines.utilization_hours%TYPE
530: := FND_API.G_MISS_NUM
531: ,p_utilization_adj IN pa_budget_lines.utilization_adj%TYPE
532: := FND_API.G_MISS_NUM
533: ,p_capacity IN pa_budget_lines.capacity%TYPE

Line 531: ,p_utilization_adj IN pa_budget_lines.utilization_adj%TYPE

527: ,p_utilization_percent IN pa_budget_lines.utilization_percent%TYPE
528: := FND_API.G_MISS_NUM
529: ,p_utilization_hours IN pa_budget_lines.utilization_hours%TYPE
530: := FND_API.G_MISS_NUM
531: ,p_utilization_adj IN pa_budget_lines.utilization_adj%TYPE
532: := FND_API.G_MISS_NUM
533: ,p_capacity IN pa_budget_lines.capacity%TYPE
534: := FND_API.G_MISS_NUM
535: ,p_head_count IN pa_budget_lines.head_count%TYPE

Line 533: ,p_capacity IN pa_budget_lines.capacity%TYPE

529: ,p_utilization_hours IN pa_budget_lines.utilization_hours%TYPE
530: := FND_API.G_MISS_NUM
531: ,p_utilization_adj IN pa_budget_lines.utilization_adj%TYPE
532: := FND_API.G_MISS_NUM
533: ,p_capacity IN pa_budget_lines.capacity%TYPE
534: := FND_API.G_MISS_NUM
535: ,p_head_count IN pa_budget_lines.head_count%TYPE
536: := FND_API.G_MISS_NUM
537: ,p_head_count_adj IN pa_budget_lines.head_count_adj%TYPE

Line 535: ,p_head_count IN pa_budget_lines.head_count%TYPE

531: ,p_utilization_adj IN pa_budget_lines.utilization_adj%TYPE
532: := FND_API.G_MISS_NUM
533: ,p_capacity IN pa_budget_lines.capacity%TYPE
534: := FND_API.G_MISS_NUM
535: ,p_head_count IN pa_budget_lines.head_count%TYPE
536: := FND_API.G_MISS_NUM
537: ,p_head_count_adj IN pa_budget_lines.head_count_adj%TYPE
538: := FND_API.G_MISS_NUM,
539: p_projfunc_currency_code in pa_budget_lines.projfunc_currency_code%type := FND_API.G_MISS_CHAR,

Line 537: ,p_head_count_adj IN pa_budget_lines.head_count_adj%TYPE

533: ,p_capacity IN pa_budget_lines.capacity%TYPE
534: := FND_API.G_MISS_NUM
535: ,p_head_count IN pa_budget_lines.head_count%TYPE
536: := FND_API.G_MISS_NUM
537: ,p_head_count_adj IN pa_budget_lines.head_count_adj%TYPE
538: := FND_API.G_MISS_NUM,
539: p_projfunc_currency_code in pa_budget_lines.projfunc_currency_code%type := FND_API.G_MISS_CHAR,
540: p_projfunc_cost_rate_type in pa_budget_lines.projfunc_cost_rate_type%type := FND_API.G_MISS_CHAR,
541: p_projfunc_cost_exchange_rate in pa_budget_lines.projfunc_cost_exchange_rate%type := FND_API.G_MISS_NUM,

Line 539: p_projfunc_currency_code in pa_budget_lines.projfunc_currency_code%type := FND_API.G_MISS_CHAR,

535: ,p_head_count IN pa_budget_lines.head_count%TYPE
536: := FND_API.G_MISS_NUM
537: ,p_head_count_adj IN pa_budget_lines.head_count_adj%TYPE
538: := FND_API.G_MISS_NUM,
539: p_projfunc_currency_code in pa_budget_lines.projfunc_currency_code%type := FND_API.G_MISS_CHAR,
540: p_projfunc_cost_rate_type in pa_budget_lines.projfunc_cost_rate_type%type := FND_API.G_MISS_CHAR,
541: p_projfunc_cost_exchange_rate in pa_budget_lines.projfunc_cost_exchange_rate%type := FND_API.G_MISS_NUM,
542: p_projfunc_cost_rate_date_type in pa_budget_lines.projfunc_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
543: p_projfunc_cost_rate_date in pa_budget_lines.projfunc_cost_rate_date%type := FND_API.G_MISS_DATE,

Line 540: p_projfunc_cost_rate_type in pa_budget_lines.projfunc_cost_rate_type%type := FND_API.G_MISS_CHAR,

536: := FND_API.G_MISS_NUM
537: ,p_head_count_adj IN pa_budget_lines.head_count_adj%TYPE
538: := FND_API.G_MISS_NUM,
539: p_projfunc_currency_code in pa_budget_lines.projfunc_currency_code%type := FND_API.G_MISS_CHAR,
540: p_projfunc_cost_rate_type in pa_budget_lines.projfunc_cost_rate_type%type := FND_API.G_MISS_CHAR,
541: p_projfunc_cost_exchange_rate in pa_budget_lines.projfunc_cost_exchange_rate%type := FND_API.G_MISS_NUM,
542: p_projfunc_cost_rate_date_type in pa_budget_lines.projfunc_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
543: p_projfunc_cost_rate_date in pa_budget_lines.projfunc_cost_rate_date%type := FND_API.G_MISS_DATE,
544: p_projfunc_rev_rate_type in pa_budget_lines.projfunc_rev_rate_type%type := FND_API.G_MISS_CHAR,

Line 541: p_projfunc_cost_exchange_rate in pa_budget_lines.projfunc_cost_exchange_rate%type := FND_API.G_MISS_NUM,

537: ,p_head_count_adj IN pa_budget_lines.head_count_adj%TYPE
538: := FND_API.G_MISS_NUM,
539: p_projfunc_currency_code in pa_budget_lines.projfunc_currency_code%type := FND_API.G_MISS_CHAR,
540: p_projfunc_cost_rate_type in pa_budget_lines.projfunc_cost_rate_type%type := FND_API.G_MISS_CHAR,
541: p_projfunc_cost_exchange_rate in pa_budget_lines.projfunc_cost_exchange_rate%type := FND_API.G_MISS_NUM,
542: p_projfunc_cost_rate_date_type in pa_budget_lines.projfunc_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
543: p_projfunc_cost_rate_date in pa_budget_lines.projfunc_cost_rate_date%type := FND_API.G_MISS_DATE,
544: p_projfunc_rev_rate_type in pa_budget_lines.projfunc_rev_rate_type%type := FND_API.G_MISS_CHAR,
545: p_projfunc_rev_rate_date_type in pa_budget_lines.projfunc_rev_rate_date_type%type := FND_API.G_MISS_CHAR,

Line 542: p_projfunc_cost_rate_date_type in pa_budget_lines.projfunc_cost_rate_date_type%type := FND_API.G_MISS_CHAR,

538: := FND_API.G_MISS_NUM,
539: p_projfunc_currency_code in pa_budget_lines.projfunc_currency_code%type := FND_API.G_MISS_CHAR,
540: p_projfunc_cost_rate_type in pa_budget_lines.projfunc_cost_rate_type%type := FND_API.G_MISS_CHAR,
541: p_projfunc_cost_exchange_rate in pa_budget_lines.projfunc_cost_exchange_rate%type := FND_API.G_MISS_NUM,
542: p_projfunc_cost_rate_date_type in pa_budget_lines.projfunc_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
543: p_projfunc_cost_rate_date in pa_budget_lines.projfunc_cost_rate_date%type := FND_API.G_MISS_DATE,
544: p_projfunc_rev_rate_type in pa_budget_lines.projfunc_rev_rate_type%type := FND_API.G_MISS_CHAR,
545: p_projfunc_rev_rate_date_type in pa_budget_lines.projfunc_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
546: p_projfunc_rev_exchange_rate in pa_budget_lines.projfunc_rev_exchange_rate%type := FND_API.G_MISS_NUM,

Line 543: p_projfunc_cost_rate_date in pa_budget_lines.projfunc_cost_rate_date%type := FND_API.G_MISS_DATE,

539: p_projfunc_currency_code in pa_budget_lines.projfunc_currency_code%type := FND_API.G_MISS_CHAR,
540: p_projfunc_cost_rate_type in pa_budget_lines.projfunc_cost_rate_type%type := FND_API.G_MISS_CHAR,
541: p_projfunc_cost_exchange_rate in pa_budget_lines.projfunc_cost_exchange_rate%type := FND_API.G_MISS_NUM,
542: p_projfunc_cost_rate_date_type in pa_budget_lines.projfunc_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
543: p_projfunc_cost_rate_date in pa_budget_lines.projfunc_cost_rate_date%type := FND_API.G_MISS_DATE,
544: p_projfunc_rev_rate_type in pa_budget_lines.projfunc_rev_rate_type%type := FND_API.G_MISS_CHAR,
545: p_projfunc_rev_rate_date_type in pa_budget_lines.projfunc_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
546: p_projfunc_rev_exchange_rate in pa_budget_lines.projfunc_rev_exchange_rate%type := FND_API.G_MISS_NUM,
547: p_projfunc_rev_rate_date in pa_budget_lines.projfunc_rev_rate_date%type := FND_API.G_MISS_DATE,

Line 544: p_projfunc_rev_rate_type in pa_budget_lines.projfunc_rev_rate_type%type := FND_API.G_MISS_CHAR,

540: p_projfunc_cost_rate_type in pa_budget_lines.projfunc_cost_rate_type%type := FND_API.G_MISS_CHAR,
541: p_projfunc_cost_exchange_rate in pa_budget_lines.projfunc_cost_exchange_rate%type := FND_API.G_MISS_NUM,
542: p_projfunc_cost_rate_date_type in pa_budget_lines.projfunc_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
543: p_projfunc_cost_rate_date in pa_budget_lines.projfunc_cost_rate_date%type := FND_API.G_MISS_DATE,
544: p_projfunc_rev_rate_type in pa_budget_lines.projfunc_rev_rate_type%type := FND_API.G_MISS_CHAR,
545: p_projfunc_rev_rate_date_type in pa_budget_lines.projfunc_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
546: p_projfunc_rev_exchange_rate in pa_budget_lines.projfunc_rev_exchange_rate%type := FND_API.G_MISS_NUM,
547: p_projfunc_rev_rate_date in pa_budget_lines.projfunc_rev_rate_date%type := FND_API.G_MISS_DATE,
548: p_project_currency_code in pa_budget_lines.project_currency_code%type := FND_API.G_MISS_CHAR,

Line 545: p_projfunc_rev_rate_date_type in pa_budget_lines.projfunc_rev_rate_date_type%type := FND_API.G_MISS_CHAR,

541: p_projfunc_cost_exchange_rate in pa_budget_lines.projfunc_cost_exchange_rate%type := FND_API.G_MISS_NUM,
542: p_projfunc_cost_rate_date_type in pa_budget_lines.projfunc_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
543: p_projfunc_cost_rate_date in pa_budget_lines.projfunc_cost_rate_date%type := FND_API.G_MISS_DATE,
544: p_projfunc_rev_rate_type in pa_budget_lines.projfunc_rev_rate_type%type := FND_API.G_MISS_CHAR,
545: p_projfunc_rev_rate_date_type in pa_budget_lines.projfunc_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
546: p_projfunc_rev_exchange_rate in pa_budget_lines.projfunc_rev_exchange_rate%type := FND_API.G_MISS_NUM,
547: p_projfunc_rev_rate_date in pa_budget_lines.projfunc_rev_rate_date%type := FND_API.G_MISS_DATE,
548: p_project_currency_code in pa_budget_lines.project_currency_code%type := FND_API.G_MISS_CHAR,
549: p_project_cost_rate_type in pa_budget_lines.project_cost_rate_type%type := FND_API.G_MISS_CHAR,

Line 546: p_projfunc_rev_exchange_rate in pa_budget_lines.projfunc_rev_exchange_rate%type := FND_API.G_MISS_NUM,

542: p_projfunc_cost_rate_date_type in pa_budget_lines.projfunc_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
543: p_projfunc_cost_rate_date in pa_budget_lines.projfunc_cost_rate_date%type := FND_API.G_MISS_DATE,
544: p_projfunc_rev_rate_type in pa_budget_lines.projfunc_rev_rate_type%type := FND_API.G_MISS_CHAR,
545: p_projfunc_rev_rate_date_type in pa_budget_lines.projfunc_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
546: p_projfunc_rev_exchange_rate in pa_budget_lines.projfunc_rev_exchange_rate%type := FND_API.G_MISS_NUM,
547: p_projfunc_rev_rate_date in pa_budget_lines.projfunc_rev_rate_date%type := FND_API.G_MISS_DATE,
548: p_project_currency_code in pa_budget_lines.project_currency_code%type := FND_API.G_MISS_CHAR,
549: p_project_cost_rate_type in pa_budget_lines.project_cost_rate_type%type := FND_API.G_MISS_CHAR,
550: p_project_cost_exchange_rate in pa_budget_lines.project_cost_exchange_rate%type := FND_API.G_MISS_NUM,

Line 547: p_projfunc_rev_rate_date in pa_budget_lines.projfunc_rev_rate_date%type := FND_API.G_MISS_DATE,

543: p_projfunc_cost_rate_date in pa_budget_lines.projfunc_cost_rate_date%type := FND_API.G_MISS_DATE,
544: p_projfunc_rev_rate_type in pa_budget_lines.projfunc_rev_rate_type%type := FND_API.G_MISS_CHAR,
545: p_projfunc_rev_rate_date_type in pa_budget_lines.projfunc_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
546: p_projfunc_rev_exchange_rate in pa_budget_lines.projfunc_rev_exchange_rate%type := FND_API.G_MISS_NUM,
547: p_projfunc_rev_rate_date in pa_budget_lines.projfunc_rev_rate_date%type := FND_API.G_MISS_DATE,
548: p_project_currency_code in pa_budget_lines.project_currency_code%type := FND_API.G_MISS_CHAR,
549: p_project_cost_rate_type in pa_budget_lines.project_cost_rate_type%type := FND_API.G_MISS_CHAR,
550: p_project_cost_exchange_rate in pa_budget_lines.project_cost_exchange_rate%type := FND_API.G_MISS_NUM,
551: p_project_cost_rate_date_type in pa_budget_lines.project_cost_rate_date_type%type := FND_API.G_MISS_CHAR,

Line 548: p_project_currency_code in pa_budget_lines.project_currency_code%type := FND_API.G_MISS_CHAR,

544: p_projfunc_rev_rate_type in pa_budget_lines.projfunc_rev_rate_type%type := FND_API.G_MISS_CHAR,
545: p_projfunc_rev_rate_date_type in pa_budget_lines.projfunc_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
546: p_projfunc_rev_exchange_rate in pa_budget_lines.projfunc_rev_exchange_rate%type := FND_API.G_MISS_NUM,
547: p_projfunc_rev_rate_date in pa_budget_lines.projfunc_rev_rate_date%type := FND_API.G_MISS_DATE,
548: p_project_currency_code in pa_budget_lines.project_currency_code%type := FND_API.G_MISS_CHAR,
549: p_project_cost_rate_type in pa_budget_lines.project_cost_rate_type%type := FND_API.G_MISS_CHAR,
550: p_project_cost_exchange_rate in pa_budget_lines.project_cost_exchange_rate%type := FND_API.G_MISS_NUM,
551: p_project_cost_rate_date_type in pa_budget_lines.project_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
552: p_project_cost_rate_date in pa_budget_lines.project_cost_rate_date%type := FND_API.G_MISS_DATE,

Line 549: p_project_cost_rate_type in pa_budget_lines.project_cost_rate_type%type := FND_API.G_MISS_CHAR,

545: p_projfunc_rev_rate_date_type in pa_budget_lines.projfunc_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
546: p_projfunc_rev_exchange_rate in pa_budget_lines.projfunc_rev_exchange_rate%type := FND_API.G_MISS_NUM,
547: p_projfunc_rev_rate_date in pa_budget_lines.projfunc_rev_rate_date%type := FND_API.G_MISS_DATE,
548: p_project_currency_code in pa_budget_lines.project_currency_code%type := FND_API.G_MISS_CHAR,
549: p_project_cost_rate_type in pa_budget_lines.project_cost_rate_type%type := FND_API.G_MISS_CHAR,
550: p_project_cost_exchange_rate in pa_budget_lines.project_cost_exchange_rate%type := FND_API.G_MISS_NUM,
551: p_project_cost_rate_date_type in pa_budget_lines.project_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
552: p_project_cost_rate_date in pa_budget_lines.project_cost_rate_date%type := FND_API.G_MISS_DATE,
553: p_project_raw_cost in pa_budget_lines.project_raw_cost%type := FND_API.G_MISS_NUM,

Line 550: p_project_cost_exchange_rate in pa_budget_lines.project_cost_exchange_rate%type := FND_API.G_MISS_NUM,

546: p_projfunc_rev_exchange_rate in pa_budget_lines.projfunc_rev_exchange_rate%type := FND_API.G_MISS_NUM,
547: p_projfunc_rev_rate_date in pa_budget_lines.projfunc_rev_rate_date%type := FND_API.G_MISS_DATE,
548: p_project_currency_code in pa_budget_lines.project_currency_code%type := FND_API.G_MISS_CHAR,
549: p_project_cost_rate_type in pa_budget_lines.project_cost_rate_type%type := FND_API.G_MISS_CHAR,
550: p_project_cost_exchange_rate in pa_budget_lines.project_cost_exchange_rate%type := FND_API.G_MISS_NUM,
551: p_project_cost_rate_date_type in pa_budget_lines.project_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
552: p_project_cost_rate_date in pa_budget_lines.project_cost_rate_date%type := FND_API.G_MISS_DATE,
553: p_project_raw_cost in pa_budget_lines.project_raw_cost%type := FND_API.G_MISS_NUM,
554: p_project_burdened_cost in pa_budget_lines.project_burdened_cost%type := FND_API.G_MISS_NUM,

Line 551: p_project_cost_rate_date_type in pa_budget_lines.project_cost_rate_date_type%type := FND_API.G_MISS_CHAR,

547: p_projfunc_rev_rate_date in pa_budget_lines.projfunc_rev_rate_date%type := FND_API.G_MISS_DATE,
548: p_project_currency_code in pa_budget_lines.project_currency_code%type := FND_API.G_MISS_CHAR,
549: p_project_cost_rate_type in pa_budget_lines.project_cost_rate_type%type := FND_API.G_MISS_CHAR,
550: p_project_cost_exchange_rate in pa_budget_lines.project_cost_exchange_rate%type := FND_API.G_MISS_NUM,
551: p_project_cost_rate_date_type in pa_budget_lines.project_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
552: p_project_cost_rate_date in pa_budget_lines.project_cost_rate_date%type := FND_API.G_MISS_DATE,
553: p_project_raw_cost in pa_budget_lines.project_raw_cost%type := FND_API.G_MISS_NUM,
554: p_project_burdened_cost in pa_budget_lines.project_burdened_cost%type := FND_API.G_MISS_NUM,
555: p_project_revenue in pa_budget_lines.project_revenue%type := FND_API.G_MISS_NUM,

Line 552: p_project_cost_rate_date in pa_budget_lines.project_cost_rate_date%type := FND_API.G_MISS_DATE,

548: p_project_currency_code in pa_budget_lines.project_currency_code%type := FND_API.G_MISS_CHAR,
549: p_project_cost_rate_type in pa_budget_lines.project_cost_rate_type%type := FND_API.G_MISS_CHAR,
550: p_project_cost_exchange_rate in pa_budget_lines.project_cost_exchange_rate%type := FND_API.G_MISS_NUM,
551: p_project_cost_rate_date_type in pa_budget_lines.project_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
552: p_project_cost_rate_date in pa_budget_lines.project_cost_rate_date%type := FND_API.G_MISS_DATE,
553: p_project_raw_cost in pa_budget_lines.project_raw_cost%type := FND_API.G_MISS_NUM,
554: p_project_burdened_cost in pa_budget_lines.project_burdened_cost%type := FND_API.G_MISS_NUM,
555: p_project_revenue in pa_budget_lines.project_revenue%type := FND_API.G_MISS_NUM,
556: p_txn_raw_cost in pa_budget_lines.txn_raw_cost%type := FND_API.G_MISS_NUM,

Line 553: p_project_raw_cost in pa_budget_lines.project_raw_cost%type := FND_API.G_MISS_NUM,

549: p_project_cost_rate_type in pa_budget_lines.project_cost_rate_type%type := FND_API.G_MISS_CHAR,
550: p_project_cost_exchange_rate in pa_budget_lines.project_cost_exchange_rate%type := FND_API.G_MISS_NUM,
551: p_project_cost_rate_date_type in pa_budget_lines.project_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
552: p_project_cost_rate_date in pa_budget_lines.project_cost_rate_date%type := FND_API.G_MISS_DATE,
553: p_project_raw_cost in pa_budget_lines.project_raw_cost%type := FND_API.G_MISS_NUM,
554: p_project_burdened_cost in pa_budget_lines.project_burdened_cost%type := FND_API.G_MISS_NUM,
555: p_project_revenue in pa_budget_lines.project_revenue%type := FND_API.G_MISS_NUM,
556: p_txn_raw_cost in pa_budget_lines.txn_raw_cost%type := FND_API.G_MISS_NUM,
557: p_txn_burdened_cost in pa_budget_lines.txn_burdened_cost%type := FND_API.G_MISS_NUM,

Line 554: p_project_burdened_cost in pa_budget_lines.project_burdened_cost%type := FND_API.G_MISS_NUM,

550: p_project_cost_exchange_rate in pa_budget_lines.project_cost_exchange_rate%type := FND_API.G_MISS_NUM,
551: p_project_cost_rate_date_type in pa_budget_lines.project_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
552: p_project_cost_rate_date in pa_budget_lines.project_cost_rate_date%type := FND_API.G_MISS_DATE,
553: p_project_raw_cost in pa_budget_lines.project_raw_cost%type := FND_API.G_MISS_NUM,
554: p_project_burdened_cost in pa_budget_lines.project_burdened_cost%type := FND_API.G_MISS_NUM,
555: p_project_revenue in pa_budget_lines.project_revenue%type := FND_API.G_MISS_NUM,
556: p_txn_raw_cost in pa_budget_lines.txn_raw_cost%type := FND_API.G_MISS_NUM,
557: p_txn_burdened_cost in pa_budget_lines.txn_burdened_cost%type := FND_API.G_MISS_NUM,
558: p_txn_revenue in pa_budget_lines.txn_revenue%type := FND_API.G_MISS_NUM,

Line 555: p_project_revenue in pa_budget_lines.project_revenue%type := FND_API.G_MISS_NUM,

551: p_project_cost_rate_date_type in pa_budget_lines.project_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
552: p_project_cost_rate_date in pa_budget_lines.project_cost_rate_date%type := FND_API.G_MISS_DATE,
553: p_project_raw_cost in pa_budget_lines.project_raw_cost%type := FND_API.G_MISS_NUM,
554: p_project_burdened_cost in pa_budget_lines.project_burdened_cost%type := FND_API.G_MISS_NUM,
555: p_project_revenue in pa_budget_lines.project_revenue%type := FND_API.G_MISS_NUM,
556: p_txn_raw_cost in pa_budget_lines.txn_raw_cost%type := FND_API.G_MISS_NUM,
557: p_txn_burdened_cost in pa_budget_lines.txn_burdened_cost%type := FND_API.G_MISS_NUM,
558: p_txn_revenue in pa_budget_lines.txn_revenue%type := FND_API.G_MISS_NUM,
559: p_txn_currency_code in pa_budget_lines.txn_currency_code%type := FND_API.G_MISS_CHAR,

Line 556: p_txn_raw_cost in pa_budget_lines.txn_raw_cost%type := FND_API.G_MISS_NUM,

552: p_project_cost_rate_date in pa_budget_lines.project_cost_rate_date%type := FND_API.G_MISS_DATE,
553: p_project_raw_cost in pa_budget_lines.project_raw_cost%type := FND_API.G_MISS_NUM,
554: p_project_burdened_cost in pa_budget_lines.project_burdened_cost%type := FND_API.G_MISS_NUM,
555: p_project_revenue in pa_budget_lines.project_revenue%type := FND_API.G_MISS_NUM,
556: p_txn_raw_cost in pa_budget_lines.txn_raw_cost%type := FND_API.G_MISS_NUM,
557: p_txn_burdened_cost in pa_budget_lines.txn_burdened_cost%type := FND_API.G_MISS_NUM,
558: p_txn_revenue in pa_budget_lines.txn_revenue%type := FND_API.G_MISS_NUM,
559: p_txn_currency_code in pa_budget_lines.txn_currency_code%type := FND_API.G_MISS_CHAR,
560: p_bucketing_period_code in pa_budget_lines.bucketing_period_code%type := FND_API.G_MISS_CHAR,

Line 557: p_txn_burdened_cost in pa_budget_lines.txn_burdened_cost%type := FND_API.G_MISS_NUM,

553: p_project_raw_cost in pa_budget_lines.project_raw_cost%type := FND_API.G_MISS_NUM,
554: p_project_burdened_cost in pa_budget_lines.project_burdened_cost%type := FND_API.G_MISS_NUM,
555: p_project_revenue in pa_budget_lines.project_revenue%type := FND_API.G_MISS_NUM,
556: p_txn_raw_cost in pa_budget_lines.txn_raw_cost%type := FND_API.G_MISS_NUM,
557: p_txn_burdened_cost in pa_budget_lines.txn_burdened_cost%type := FND_API.G_MISS_NUM,
558: p_txn_revenue in pa_budget_lines.txn_revenue%type := FND_API.G_MISS_NUM,
559: p_txn_currency_code in pa_budget_lines.txn_currency_code%type := FND_API.G_MISS_CHAR,
560: p_bucketing_period_code in pa_budget_lines.bucketing_period_code%type := FND_API.G_MISS_CHAR,
561: p_project_rev_rate_type in pa_budget_lines.project_rev_rate_type%type := FND_API.G_MISS_CHAR,

Line 558: p_txn_revenue in pa_budget_lines.txn_revenue%type := FND_API.G_MISS_NUM,

554: p_project_burdened_cost in pa_budget_lines.project_burdened_cost%type := FND_API.G_MISS_NUM,
555: p_project_revenue in pa_budget_lines.project_revenue%type := FND_API.G_MISS_NUM,
556: p_txn_raw_cost in pa_budget_lines.txn_raw_cost%type := FND_API.G_MISS_NUM,
557: p_txn_burdened_cost in pa_budget_lines.txn_burdened_cost%type := FND_API.G_MISS_NUM,
558: p_txn_revenue in pa_budget_lines.txn_revenue%type := FND_API.G_MISS_NUM,
559: p_txn_currency_code in pa_budget_lines.txn_currency_code%type := FND_API.G_MISS_CHAR,
560: p_bucketing_period_code in pa_budget_lines.bucketing_period_code%type := FND_API.G_MISS_CHAR,
561: p_project_rev_rate_type in pa_budget_lines.project_rev_rate_type%type := FND_API.G_MISS_CHAR,
562: p_project_rev_exchange_rate in pa_budget_lines.project_rev_exchange_rate%type := FND_API.G_MISS_NUM,

Line 559: p_txn_currency_code in pa_budget_lines.txn_currency_code%type := FND_API.G_MISS_CHAR,

555: p_project_revenue in pa_budget_lines.project_revenue%type := FND_API.G_MISS_NUM,
556: p_txn_raw_cost in pa_budget_lines.txn_raw_cost%type := FND_API.G_MISS_NUM,
557: p_txn_burdened_cost in pa_budget_lines.txn_burdened_cost%type := FND_API.G_MISS_NUM,
558: p_txn_revenue in pa_budget_lines.txn_revenue%type := FND_API.G_MISS_NUM,
559: p_txn_currency_code in pa_budget_lines.txn_currency_code%type := FND_API.G_MISS_CHAR,
560: p_bucketing_period_code in pa_budget_lines.bucketing_period_code%type := FND_API.G_MISS_CHAR,
561: p_project_rev_rate_type in pa_budget_lines.project_rev_rate_type%type := FND_API.G_MISS_CHAR,
562: p_project_rev_exchange_rate in pa_budget_lines.project_rev_exchange_rate%type := FND_API.G_MISS_NUM,
563: p_project_rev_rate_date_type in pa_budget_lines.project_rev_rate_date_type%type := FND_API.G_MISS_CHAR,

Line 560: p_bucketing_period_code in pa_budget_lines.bucketing_period_code%type := FND_API.G_MISS_CHAR,

556: p_txn_raw_cost in pa_budget_lines.txn_raw_cost%type := FND_API.G_MISS_NUM,
557: p_txn_burdened_cost in pa_budget_lines.txn_burdened_cost%type := FND_API.G_MISS_NUM,
558: p_txn_revenue in pa_budget_lines.txn_revenue%type := FND_API.G_MISS_NUM,
559: p_txn_currency_code in pa_budget_lines.txn_currency_code%type := FND_API.G_MISS_CHAR,
560: p_bucketing_period_code in pa_budget_lines.bucketing_period_code%type := FND_API.G_MISS_CHAR,
561: p_project_rev_rate_type in pa_budget_lines.project_rev_rate_type%type := FND_API.G_MISS_CHAR,
562: p_project_rev_exchange_rate in pa_budget_lines.project_rev_exchange_rate%type := FND_API.G_MISS_NUM,
563: p_project_rev_rate_date_type in pa_budget_lines.project_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
564: p_project_rev_rate_date in pa_budget_lines.project_rev_rate_date%type := FND_API.G_MISS_DATE,

Line 561: p_project_rev_rate_type in pa_budget_lines.project_rev_rate_type%type := FND_API.G_MISS_CHAR,

557: p_txn_burdened_cost in pa_budget_lines.txn_burdened_cost%type := FND_API.G_MISS_NUM,
558: p_txn_revenue in pa_budget_lines.txn_revenue%type := FND_API.G_MISS_NUM,
559: p_txn_currency_code in pa_budget_lines.txn_currency_code%type := FND_API.G_MISS_CHAR,
560: p_bucketing_period_code in pa_budget_lines.bucketing_period_code%type := FND_API.G_MISS_CHAR,
561: p_project_rev_rate_type in pa_budget_lines.project_rev_rate_type%type := FND_API.G_MISS_CHAR,
562: p_project_rev_exchange_rate in pa_budget_lines.project_rev_exchange_rate%type := FND_API.G_MISS_NUM,
563: p_project_rev_rate_date_type in pa_budget_lines.project_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
564: p_project_rev_rate_date in pa_budget_lines.project_rev_rate_date%type := FND_API.G_MISS_DATE,
565: p_budget_line_id in pa_budget_lines.budget_line_id%type := FND_API.G_MISS_NUM,

Line 562: p_project_rev_exchange_rate in pa_budget_lines.project_rev_exchange_rate%type := FND_API.G_MISS_NUM,

558: p_txn_revenue in pa_budget_lines.txn_revenue%type := FND_API.G_MISS_NUM,
559: p_txn_currency_code in pa_budget_lines.txn_currency_code%type := FND_API.G_MISS_CHAR,
560: p_bucketing_period_code in pa_budget_lines.bucketing_period_code%type := FND_API.G_MISS_CHAR,
561: p_project_rev_rate_type in pa_budget_lines.project_rev_rate_type%type := FND_API.G_MISS_CHAR,
562: p_project_rev_exchange_rate in pa_budget_lines.project_rev_exchange_rate%type := FND_API.G_MISS_NUM,
563: p_project_rev_rate_date_type in pa_budget_lines.project_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
564: p_project_rev_rate_date in pa_budget_lines.project_rev_rate_date%type := FND_API.G_MISS_DATE,
565: p_budget_line_id in pa_budget_lines.budget_line_id%type := FND_API.G_MISS_NUM,
566: p_budget_version_id in pa_budget_lines.budget_version_id%type := FND_API.G_MISS_NUM,

Line 563: p_project_rev_rate_date_type in pa_budget_lines.project_rev_rate_date_type%type := FND_API.G_MISS_CHAR,

559: p_txn_currency_code in pa_budget_lines.txn_currency_code%type := FND_API.G_MISS_CHAR,
560: p_bucketing_period_code in pa_budget_lines.bucketing_period_code%type := FND_API.G_MISS_CHAR,
561: p_project_rev_rate_type in pa_budget_lines.project_rev_rate_type%type := FND_API.G_MISS_CHAR,
562: p_project_rev_exchange_rate in pa_budget_lines.project_rev_exchange_rate%type := FND_API.G_MISS_NUM,
563: p_project_rev_rate_date_type in pa_budget_lines.project_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
564: p_project_rev_rate_date in pa_budget_lines.project_rev_rate_date%type := FND_API.G_MISS_DATE,
565: p_budget_line_id in pa_budget_lines.budget_line_id%type := FND_API.G_MISS_NUM,
566: p_budget_version_id in pa_budget_lines.budget_version_id%type := FND_API.G_MISS_NUM,
567: -- Bug Fix: 4569365. Removed MRC code.

Line 564: p_project_rev_rate_date in pa_budget_lines.project_rev_rate_date%type := FND_API.G_MISS_DATE,

560: p_bucketing_period_code in pa_budget_lines.bucketing_period_code%type := FND_API.G_MISS_CHAR,
561: p_project_rev_rate_type in pa_budget_lines.project_rev_rate_type%type := FND_API.G_MISS_CHAR,
562: p_project_rev_exchange_rate in pa_budget_lines.project_rev_exchange_rate%type := FND_API.G_MISS_NUM,
563: p_project_rev_rate_date_type in pa_budget_lines.project_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
564: p_project_rev_rate_date in pa_budget_lines.project_rev_rate_date%type := FND_API.G_MISS_DATE,
565: p_budget_line_id in pa_budget_lines.budget_line_id%type := FND_API.G_MISS_NUM,
566: p_budget_version_id in pa_budget_lines.budget_version_id%type := FND_API.G_MISS_NUM,
567: -- Bug Fix: 4569365. Removed MRC code.
568: -- p_mrc_flag in VARCHAR2 -- FP Build 4 Changes

Line 565: p_budget_line_id in pa_budget_lines.budget_line_id%type := FND_API.G_MISS_NUM,

561: p_project_rev_rate_type in pa_budget_lines.project_rev_rate_type%type := FND_API.G_MISS_CHAR,
562: p_project_rev_exchange_rate in pa_budget_lines.project_rev_exchange_rate%type := FND_API.G_MISS_NUM,
563: p_project_rev_rate_date_type in pa_budget_lines.project_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
564: p_project_rev_rate_date in pa_budget_lines.project_rev_rate_date%type := FND_API.G_MISS_DATE,
565: p_budget_line_id in pa_budget_lines.budget_line_id%type := FND_API.G_MISS_NUM,
566: p_budget_version_id in pa_budget_lines.budget_version_id%type := FND_API.G_MISS_NUM,
567: -- Bug Fix: 4569365. Removed MRC code.
568: -- p_mrc_flag in VARCHAR2 -- FP Build 4 Changes
569: p_row_id IN ROWID

Line 566: p_budget_version_id in pa_budget_lines.budget_version_id%type := FND_API.G_MISS_NUM,

562: p_project_rev_exchange_rate in pa_budget_lines.project_rev_exchange_rate%type := FND_API.G_MISS_NUM,
563: p_project_rev_rate_date_type in pa_budget_lines.project_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
564: p_project_rev_rate_date in pa_budget_lines.project_rev_rate_date%type := FND_API.G_MISS_DATE,
565: p_budget_line_id in pa_budget_lines.budget_line_id%type := FND_API.G_MISS_NUM,
566: p_budget_version_id in pa_budget_lines.budget_version_id%type := FND_API.G_MISS_NUM,
567: -- Bug Fix: 4569365. Removed MRC code.
568: -- p_mrc_flag in VARCHAR2 -- FP Build 4 Changes
569: p_row_id IN ROWID
570: := NULL

Line 577: UPDATE pa_budget_lines

573: l_msg_count NUMBER := 0;
574: l_msg_data VARCHAR2(2000);
575: l_return_status VARCHAR2(2000);
576: BEGIN
577: UPDATE pa_budget_lines
578: SET
579: start_date = DECODE( p_start_date, FND_API.G_MISS_DATE, start_date,
580: p_start_date)
581: ,last_update_date = sysdate

Line 817: ( p_resource_assignment_id IN pa_budget_lines.resource_assignment_id%TYPE

813: RAISE;
814: END Update_Row;
815:
816: PROCEDURE Lock_Row
817: ( p_resource_assignment_id IN pa_budget_lines.resource_assignment_id%TYPE
818: := FND_API.G_MISS_NUM
819: ,p_start_date IN pa_budget_lines.start_date%TYPE
820: := FND_API.G_MISS_DATE
821: ,p_row_id IN ROWID

Line 819: ,p_start_date IN pa_budget_lines.start_date%TYPE

815:
816: PROCEDURE Lock_Row
817: ( p_resource_assignment_id IN pa_budget_lines.resource_assignment_id%TYPE
818: := FND_API.G_MISS_NUM
819: ,p_start_date IN pa_budget_lines.start_date%TYPE
820: := FND_API.G_MISS_DATE
821: ,p_row_id IN ROWID
822: := NULL
823: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 829: FROM pa_budget_lines

825: l_row_id ROWID;
826:
827: BEGIN
828: SELECT rowid into l_row_id
829: FROM pa_budget_lines
830: WHERE resource_assignment_id = p_resource_assignment_id
831: AND start_date = p_start_date
832: FOR UPDATE NOWAIT;
833: EXCEPTION

Line 844: ( p_budget_line_id IN pa_budget_lines.budget_line_id%TYPE

840: RAISE;
841: END Lock_Row;
842:
843: PROCEDURE Delete_Row
844: ( p_budget_line_id IN pa_budget_lines.budget_line_id%TYPE
845: ,p_row_id IN ROWID
846: -- Bug Fix: 4569365. Removed MRC code.
847: -- ,p_mrc_flag IN VARCHAR2
848: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 856: DELETE FROM PA_BUDGET_LINES

852: l_return_status VARCHAR2(2000);
853: BEGIN
854: x_return_status := FND_API.G_RET_STS_SUCCESS;
855: IF (p_budget_line_id IS NOT NULL) THEN
856: DELETE FROM PA_BUDGET_LINES
857: WHERE budget_line_id = p_budget_line_id;
858: ELSIF (p_row_id IS NOT NULL) THEN
859: DELETE FROM PA_BUDGET_LINES
860: WHERE rowid = p_row_id;

Line 859: DELETE FROM PA_BUDGET_LINES

855: IF (p_budget_line_id IS NOT NULL) THEN
856: DELETE FROM PA_BUDGET_LINES
857: WHERE budget_line_id = p_budget_line_id;
858: ELSIF (p_row_id IS NOT NULL) THEN
859: DELETE FROM PA_BUDGET_LINES
860: WHERE rowid = p_row_id;
861: END IF;
862:
863: IF (SQL%NOTFOUND) THEN