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_PROJECT_CHECK_PVT dependencies on PA_INTERFACE_UTILS_PUB

Line 39: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

35: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
36: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
37: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
38: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
39: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
40: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
41: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
42: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43: --Project Structure changes done for bug 2765115

Line 40: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

36: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
37: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
38: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
39: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
40: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
41: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
42: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43: --Project Structure changes done for bug 2765115
44: , p_structure_type IN VARCHAR2 := 'FINANCIAL'

Line 41: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

37: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
38: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
39: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
40: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
41: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
42: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43: --Project Structure changes done for bug 2765115
44: , p_structure_type IN VARCHAR2 := 'FINANCIAL'
45: , p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 42: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

38: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
39: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
40: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
41: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
42: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43: --Project Structure changes done for bug 2765115
44: , p_structure_type IN VARCHAR2 := 'FINANCIAL'
45: , p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
46: --END Project Structure changes done for bug 2765115

Line 45: , p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

41: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
42: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43: --Project Structure changes done for bug 2765115
44: , p_structure_type IN VARCHAR2 := 'FINANCIAL'
45: , p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
46: --END Project Structure changes done for bug 2765115
47: , p_delete_task_ok_flag OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
48:
49: PROCEDURE Check_Add_Subtask_OK_Pvt

Line 55: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

51: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
52: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
53: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
54: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
55: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
56: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
58: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
59: , p_add_subtask_ok_flag OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 56: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

52: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
53: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
54: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
55: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
56: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
58: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
59: , p_add_subtask_ok_flag OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
60:

Line 57: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

53: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
54: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
55: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
56: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
58: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
59: , p_add_subtask_ok_flag OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
60:
61: PROCEDURE Check_Unique_Task_Ref_Pvt

Line 58: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

54: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
55: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
56: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
58: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
59: , p_add_subtask_ok_flag OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
60:
61: PROCEDURE Check_Unique_Task_Ref_Pvt
62: (p_api_version_number IN NUMBER

Line 67: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

63: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
64: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
65: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
66: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
67: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
68: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
69: , p_pm_task_reference IN VARCHAR2
70: , p_unique_task_ref_flag OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
71:

Line 68: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

64: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
65: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
66: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
67: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
68: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
69: , p_pm_task_reference IN VARCHAR2
70: , p_unique_task_ref_flag OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
71:
72: PROCEDURE Check_Unique_Project_Ref_Pvt

Line 88: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

84: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
85: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
86: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
87: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
88: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
89: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
90: , p_delete_project_ok_flag OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
91:
92: PROCEDURE Check_Change_Parent_OK_Pvt

Line 89: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

85: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
86: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
87: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
88: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
89: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
90: , p_delete_project_ok_flag OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
91:
92: PROCEDURE Check_Change_Parent_OK_Pvt
93: (p_api_version_number IN NUMBER

Line 98: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

94: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
95: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
96: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
97: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
98: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
99: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
100: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
101: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
102: , p_new_parent_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 99: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

95: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
96: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
97: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
98: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
99: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
100: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
101: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
102: , p_new_parent_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
103: , p_pm_new_parent_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 100: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

96: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
97: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
98: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
99: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
100: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
101: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
102: , p_new_parent_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
103: , p_pm_new_parent_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
104: , p_change_parent_ok_flag OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 101: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

97: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
98: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
99: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
100: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
101: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
102: , p_new_parent_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
103: , p_pm_new_parent_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
104: , p_change_parent_ok_flag OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
105:

Line 102: , p_new_parent_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

98: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
99: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
100: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
101: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
102: , p_new_parent_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
103: , p_pm_new_parent_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
104: , p_change_parent_ok_flag OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
105:
106: PROCEDURE Check_Change_Proj_Org_OK_Pvt

Line 103: , p_pm_new_parent_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

99: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
100: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
101: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
102: , p_new_parent_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
103: , p_pm_new_parent_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
104: , p_change_parent_ok_flag OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
105:
106: PROCEDURE Check_Change_Proj_Org_OK_Pvt
107: (p_api_version_number IN NUMBER

Line 112: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

108: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
109: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
110: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
111: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
112: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
113: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
114: , p_change_project_org_ok_flag OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
115:
116: PROCEDURE Check_Unique_Task_Number_Pvt

Line 113: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

109: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
110: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
111: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
112: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
113: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
114: , p_change_project_org_ok_flag OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
115:
116: PROCEDURE Check_Unique_Task_Number_Pvt
117: (p_api_version_number IN NUMBER

Line 122: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

118: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
119: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
120: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
121: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
122: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
123: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
124: , p_task_number IN VARCHAR2
125: , p_unique_task_number_flag OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
126:

Line 123: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

119: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
120: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
121: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
122: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
123: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
124: , p_task_number IN VARCHAR2
125: , p_unique_task_number_flag OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
126:
127: PROCEDURE Check_Task_Numb_Change_Ok_Pvt

Line 133: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

129: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
130: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
131: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
132: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
133: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
134: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
135: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
136: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
137: , p_task_number_change_Ok_flag OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 134: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

130: , p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
131: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
132: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
133: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
134: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
135: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
136: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
137: , p_task_number_change_Ok_flag OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
138:

Line 135: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

131: , p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
132: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
133: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
134: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
135: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
136: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
137: , p_task_number_change_Ok_flag OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
138:
139: PROCEDURE Validate_billing_info_Pvt

Line 136: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

132: , p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
133: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
134: , p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
135: , p_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
136: , p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
137: , p_task_number_change_Ok_flag OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
138:
139: PROCEDURE Validate_billing_info_Pvt
140: (p_project_id IN NUMBER, -- Added for Bug 5643876