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_CUSTOMERS_CONTACTS_UTILS dependencies on FND_API

Line 9: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

5: -- API name : Check_Customer_Name_Or_Id
6: -- Type : Utility
7: -- Pre-reqs : None.
8: -- Parameters :
9: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
10: -- p_customer_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
11: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
12: -- x_customer_id OUT NUMBER Required
13: -- x_return_status OUT VARCHAR2 Required

Line 10: -- p_customer_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

6: -- Type : Utility
7: -- Pre-reqs : None.
8: -- Parameters :
9: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
10: -- p_customer_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
11: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
12: -- x_customer_id OUT NUMBER Required
13: -- x_return_status OUT VARCHAR2 Required
14: -- x_error_msg_code OUT VARCHAR2 Required

Line 17: ( p_customer_id IN NUMBER := FND_API.G_MISS_NUM

13: -- x_return_status OUT VARCHAR2 Required
14: -- x_error_msg_code OUT VARCHAR2 Required
15:
16: PROCEDURE CHECK_CUSTOMER_NAME_OR_ID
17: ( p_customer_id IN NUMBER := FND_API.G_MISS_NUM
18: ,p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR
19: ,p_check_id_flag IN VARCHAR2 := 'A'
20: ,x_customer_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
21: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 18: ,p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR

14: -- x_error_msg_code OUT VARCHAR2 Required
15:
16: PROCEDURE CHECK_CUSTOMER_NAME_OR_ID
17: ( p_customer_id IN NUMBER := FND_API.G_MISS_NUM
18: ,p_customer_name IN VARCHAR2 := FND_API.G_MISS_CHAR
19: ,p_check_id_flag IN VARCHAR2 := 'A'
20: ,x_customer_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
21: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
22: ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 30: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

26: -- API name : Check_Customer_Number_Or_Id
27: -- Type : Utility
28: -- Pre-reqs : None.
29: -- Parameters :
30: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
31: -- p_customer_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
32: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
33: -- x_customer_id OUT NUMBER Required
34: -- x_return_status OUT VARCHAR2 Required

Line 31: -- p_customer_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

27: -- Type : Utility
28: -- Pre-reqs : None.
29: -- Parameters :
30: -- p_customer_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
31: -- p_customer_number IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
32: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
33: -- x_customer_id OUT NUMBER Required
34: -- x_return_status OUT VARCHAR2 Required
35: -- x_error_msg_code OUT VARCHAR2 Required

Line 38: ( p_customer_id IN NUMBER := FND_API.G_MISS_NUM

34: -- x_return_status OUT VARCHAR2 Required
35: -- x_error_msg_code OUT VARCHAR2 Required
36:
37: PROCEDURE CHECK_CUSTOMER_NUMBER_OR_ID
38: ( p_customer_id IN NUMBER := FND_API.G_MISS_NUM
39: ,p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR
40: ,p_check_id_flag IN VARCHAR2 := 'A'
41: ,x_customer_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
42: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 39: ,p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR

35: -- x_error_msg_code OUT VARCHAR2 Required
36:
37: PROCEDURE CHECK_CUSTOMER_NUMBER_OR_ID
38: ( p_customer_id IN NUMBER := FND_API.G_MISS_NUM
39: ,p_customer_number IN VARCHAR2 := FND_API.G_MISS_CHAR
40: ,p_check_id_flag IN VARCHAR2 := 'A'
41: ,x_customer_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
42: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
43: ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 52: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

48: -- Type : Utility
49: -- Pre-reqs : None.
50: -- Parameters :
51: -- p_customer_id IN NUMBER Required
52: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
53: -- p_bill_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
54: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
55: -- x_bill_to_address_id OUT NUMBER Optional
56: -- x_return_status OUT VARCHAR2 Required

Line 53: -- p_bill_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

49: -- Pre-reqs : None.
50: -- Parameters :
51: -- p_customer_id IN NUMBER Required
52: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
53: -- p_bill_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
54: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
55: -- x_bill_to_address_id OUT NUMBER Optional
56: -- x_return_status OUT VARCHAR2 Required
57: -- x_error_msg_code OUT VARCHAR2 Required

Line 61: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM

57: -- x_error_msg_code OUT VARCHAR2 Required
58:
59: PROCEDURE CHECK_BILL_SITE_NAME_OR_ID
60: ( p_customer_id IN NUMBER
61: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
62: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
63: ,p_check_id_flag IN VARCHAR2 := 'A'
64: ,x_bill_to_address_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
65: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 62: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR

58:
59: PROCEDURE CHECK_BILL_SITE_NAME_OR_ID
60: ( p_customer_id IN NUMBER
61: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
62: ,p_bill_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
63: ,p_check_id_flag IN VARCHAR2 := 'A'
64: ,x_bill_to_address_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
65: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
66: ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 75: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

71: -- Type : Utility
72: -- Pre-reqs : None.
73: -- Parameters :
74: -- p_customer_id IN NUMBER Required
75: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
76: -- p_work_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
77: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
78: -- x_ship_to_address_id OUT NUMBER Optional
79: -- x_return_status OUT VARCHAR2 Required

Line 76: -- p_work_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

72: -- Pre-reqs : None.
73: -- Parameters :
74: -- p_customer_id IN NUMBER Required
75: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
76: -- p_work_site_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
77: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
78: -- x_ship_to_address_id OUT NUMBER Optional
79: -- x_return_status OUT VARCHAR2 Required
80: -- x_error_msg_code OUT VARCHAR2 Required

Line 84: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM

80: -- x_error_msg_code OUT VARCHAR2 Required
81:
82: PROCEDURE CHECK_WORK_SITE_NAME_OR_ID
83: ( p_customer_id IN NUMBER
84: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
85: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
86: ,p_check_id_flag IN VARCHAR2 := 'A'
87: ,x_ship_to_address_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
88: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 85: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR

81:
82: PROCEDURE CHECK_WORK_SITE_NAME_OR_ID
83: ( p_customer_id IN NUMBER
84: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
85: ,p_work_site_name IN VARCHAR2 := FND_API.G_MISS_CHAR
86: ,p_check_id_flag IN VARCHAR2 := 'A'
87: ,x_ship_to_address_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
88: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
89: ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 97: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

93: -- API name : Check_Receiver_Proj_Name_Or_Id
94: -- Type : Utility
95: -- Pre-reqs : None.
96: -- Parameters :
97: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
98: -- p_receiver_project_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
99: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
100: -- x_receiver_task_id OUT NUMBER Optional
101: -- x_return_status OUT VARCHAR2 Required

Line 98: -- p_receiver_project_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

94: -- Type : Utility
95: -- Pre-reqs : None.
96: -- Parameters :
97: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
98: -- p_receiver_project_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
99: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
100: -- x_receiver_task_id OUT NUMBER Optional
101: -- x_return_status OUT VARCHAR2 Required
102: -- x_error_msg_code OUT VARCHAR2 Required

Line 105: ( p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM

101: -- x_return_status OUT VARCHAR2 Required
102: -- x_error_msg_code OUT VARCHAR2 Required
103:
104: PROCEDURE CHECK_RECEIVER_PROJ_NAME_OR_ID
105: ( p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
106: ,p_receiver_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
107: ,p_check_id_flag IN VARCHAR2 := 'A'
108: ,x_receiver_task_id OUT NUMBER
109: ,x_return_status OUT VARCHAR2

Line 106: ,p_receiver_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR

102: -- x_error_msg_code OUT VARCHAR2 Required
103:
104: PROCEDURE CHECK_RECEIVER_PROJ_NAME_OR_ID
105: ( p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
106: ,p_receiver_project_name IN VARCHAR2 := FND_API.G_MISS_CHAR
107: ,p_check_id_flag IN VARCHAR2 := 'A'
108: ,x_receiver_task_id OUT NUMBER
109: ,x_return_status OUT VARCHAR2
110: ,x_error_msg_code OUT VARCHAR2

Line 120: -- p_contact_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

116: -- Pre-reqs : None.
117: -- Parameters :
118: -- p_customer_id IN NUMBER Required
119: -- p_project_contact_type_code IN VARCHAR2 Required
120: -- p_contact_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
121: -- p_contact_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
122: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
123: -- x_contact_id OUT NUMBER Required
124: -- x_return_status OUT VARCHAR2 Required

Line 121: -- p_contact_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

117: -- Parameters :
118: -- p_customer_id IN NUMBER Required
119: -- p_project_contact_type_code IN VARCHAR2 Required
120: -- p_contact_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
121: -- p_contact_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
122: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
123: -- x_contact_id OUT NUMBER Required
124: -- x_return_status OUT VARCHAR2 Required
125: -- x_error_msg_code OUT VARCHAR2 Required

Line 130: ,p_contact_id IN NUMBER := FND_API.G_MISS_NUM

126:
127: PROCEDURE CHECK_CONTACT_NAME_OR_ID
128: ( p_customer_id IN NUMBER
129: ,p_project_contact_type_code IN VARCHAR2
130: ,p_contact_id IN NUMBER := FND_API.G_MISS_NUM
131: ,p_contact_name IN VARCHAR2 := FND_API.G_MISS_CHAR
132: ,p_check_id_flag IN VARCHAR2 := 'A'
133: ,p_address_id IN NUMBER := NULL -- Added for Bug 2964227
134: ,x_contact_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 131: ,p_contact_name IN VARCHAR2 := FND_API.G_MISS_CHAR

127: PROCEDURE CHECK_CONTACT_NAME_OR_ID
128: ( p_customer_id IN NUMBER
129: ,p_project_contact_type_code IN VARCHAR2
130: ,p_contact_id IN NUMBER := FND_API.G_MISS_NUM
131: ,p_contact_name IN VARCHAR2 := FND_API.G_MISS_CHAR
132: ,p_check_id_flag IN VARCHAR2 := 'A'
133: ,p_address_id IN NUMBER := NULL -- Added for Bug 2964227
134: ,x_contact_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
135: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 144: -- p_project_contact_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

140: -- API name : Check_Contact_Typ_Name_Or_Code
141: -- Type : Utility
142: -- Pre-reqs : None.
143: -- Parameters :
144: -- p_project_contact_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
145: -- p_project_contact_type_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
146: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
147: -- x_project_contact_type_code OUT VARCHAR2 Required
148: -- x_return_status OUT VARCHAR2 Required

Line 145: -- p_project_contact_type_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

141: -- Type : Utility
142: -- Pre-reqs : None.
143: -- Parameters :
144: -- p_project_contact_type_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
145: -- p_project_contact_type_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
146: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
147: -- x_project_contact_type_code OUT VARCHAR2 Required
148: -- x_return_status OUT VARCHAR2 Required
149: -- x_error_msg_code OUT VARCHAR2 Required

Line 152: ( p_project_contact_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR

148: -- x_return_status OUT VARCHAR2 Required
149: -- x_error_msg_code OUT VARCHAR2 Required
150:
151: PROCEDURE CHECK_CONTACT_TYP_NAME_OR_CODE
152: ( p_project_contact_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
153: ,p_project_contact_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR
154: ,p_check_id_flag IN VARCHAR2 := 'A'
155: ,x_project_contact_type_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
156: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 153: ,p_project_contact_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR

149: -- x_error_msg_code OUT VARCHAR2 Required
150:
151: PROCEDURE CHECK_CONTACT_TYP_NAME_OR_CODE
152: ( p_project_contact_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
153: ,p_project_contact_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR
154: ,p_check_id_flag IN VARCHAR2 := 'A'
155: ,x_project_contact_type_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
156: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
157: ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 237: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

233: -- Type : Utility
234: -- Pre-reqs : None.
235: -- Parameters :
236: -- p_customer_bill_split IN NUMBER Required
237: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
238: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
239: -- x_return_status OUT VARCHAR2 Required
240: -- x_error_msg_code OUT VARCHAR2 Required
241:

Line 238: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

234: -- Pre-reqs : None.
235: -- Parameters :
236: -- p_customer_bill_split IN NUMBER Required
237: -- p_bill_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
238: -- p_ship_to_address_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
239: -- x_return_status OUT VARCHAR2 Required
240: -- x_error_msg_code OUT VARCHAR2 Required
241:
242: PROCEDURE CHECK_BILL_WORK_SITES_REQUIRED

Line 244: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM

240: -- x_error_msg_code OUT VARCHAR2 Required
241:
242: PROCEDURE CHECK_BILL_WORK_SITES_REQUIRED
243: ( p_customer_bill_split IN NUMBER
244: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
245: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
246: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
247: ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
248: );

Line 245: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM

241:
242: PROCEDURE CHECK_BILL_WORK_SITES_REQUIRED
243: ( p_customer_bill_split IN NUMBER
244: ,p_bill_to_address_id IN NUMBER := FND_API.G_MISS_NUM
245: ,p_ship_to_address_id IN NUMBER := FND_API.G_MISS_NUM
246: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
247: ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
248: );
249:

Line 277: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

273: -- Pre-reqs : None.
274: -- Parameters :
275: -- p_project_id IN NUMBER Required
276: -- p_customer_id IN NUMBER Required
277: -- p_receiver_task_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
278: -- x_bill_another_project_flag OUT VARCHAR2 Required
279: -- x_return_status OUT VARCHAR2 Required
280: -- x_error_msg_code OUT VARCHAR2 Required
281:

Line 285: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM

281:
282: PROCEDURE CHECK_RECEIVER_PROJ_ENTERABLE
283: ( p_project_id IN NUMBER
284: ,p_customer_id IN NUMBER
285: ,p_receiver_task_id IN NUMBER := FND_API.G_MISS_NUM
286: ,x_bill_another_project_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
287: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
288: ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
289: );

Line 297: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

293: -- Type : Utility
294: -- Pre-reqs : None.
295: -- Parameters :
296: -- p_project_id IN NUMBER Required
297: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
298: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
299: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
300: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
301: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'

Line 298: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

294: -- Pre-reqs : None.
295: -- Parameters :
296: -- p_project_id IN NUMBER Required
297: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
298: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
299: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
300: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
301: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
302: -- x_return_status OUT VARCHAR2 Required

Line 299: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE

295: -- Parameters :
296: -- p_project_id IN NUMBER Required
297: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
298: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
299: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
300: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
301: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
302: -- x_return_status OUT VARCHAR2 Required
303: -- x_error_msg_code OUT VARCHAR2 Required

Line 300: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM

296: -- p_project_id IN NUMBER Required
297: -- p_inv_currency_code IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
298: -- p_inv_rate_type IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
299: -- p_inv_rate_date IN DATE Optional Default = FND_API.G_MISS_DATE
300: -- p_inv_exchange_rate IN NUMBER Optional Default = FND_API.G_MISS_NUM
301: -- p_allow_user_rate_type_flag IN VARCHAR2 Required Default = 'N'
302: -- x_return_status OUT VARCHAR2 Required
303: -- x_error_msg_code OUT VARCHAR2 Required
304:

Line 307: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR

303: -- x_error_msg_code OUT VARCHAR2 Required
304:
305: PROCEDURE CHECK_INVOICE_CURRENCY_INFO
306: ( p_project_id IN NUMBER
307: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
308: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
309: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
310: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
311: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'

Line 308: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR

304:
305: PROCEDURE CHECK_INVOICE_CURRENCY_INFO
306: ( p_project_id IN NUMBER
307: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
308: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
309: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
310: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
311: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
312: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 309: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE

305: PROCEDURE CHECK_INVOICE_CURRENCY_INFO
306: ( p_project_id IN NUMBER
307: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
308: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
309: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
310: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
311: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
312: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
313: ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 310: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM

306: ( p_project_id IN NUMBER
307: ,p_inv_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR
308: ,p_inv_rate_type IN VARCHAR2 := FND_API.G_MISS_CHAR
309: ,p_inv_rate_date IN DATE := FND_API.G_MISS_DATE
310: ,p_inv_exchange_rate IN NUMBER := FND_API.G_MISS_NUM
311: ,p_allow_user_rate_type_flag IN VARCHAR2 := 'N'
312: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
313: ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
314: );

Line 406: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

402: -- x_highst_contr_cust_id NUMBER N Customer ID of the highest contribution customer
403:
404: PROCEDURE Get_Highest_Contr_Fed_Cust(
405: p_api_version IN NUMBER := 1.0
406: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
407: , p_commit IN VARCHAR2 := FND_API.G_FALSE
408: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
409: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
410: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 407: , p_commit IN VARCHAR2 := FND_API.G_FALSE

403:
404: PROCEDURE Get_Highest_Contr_Fed_Cust(
405: p_api_version IN NUMBER := 1.0
406: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
407: , p_commit IN VARCHAR2 := FND_API.G_FALSE
408: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
409: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
410: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
411: , p_debug_mode IN VARCHAR2 := 'N'

Line 408: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE

404: PROCEDURE Get_Highest_Contr_Fed_Cust(
405: p_api_version IN NUMBER := 1.0
406: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
407: , p_commit IN VARCHAR2 := FND_API.G_FALSE
408: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
409: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
410: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
411: , p_debug_mode IN VARCHAR2 := 'N'
412: , p_project_id IN NUMBER

Line 409: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

405: p_api_version IN NUMBER := 1.0
406: , p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
407: , p_commit IN VARCHAR2 := FND_API.G_FALSE
408: , p_validate_only IN VARCHAR2 := FND_API.G_TRUE
409: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
410: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
411: , p_debug_mode IN VARCHAR2 := 'N'
412: , p_project_id IN NUMBER
413: , x_highst_contr_cust_id OUT NOCOPY NUMBER