APPS.CSD_ANALYSIS_PVT dependencies on STANDARD

Line 12: /* p_api_version Standard IN param */

8: /*----------------------------------------------------------------*/
9: /* procedure name: Get_TotalActCharges */
10: /* description : procedure used to get total actual charges */
11: /* */
12: /* p_api_version Standard IN param */
13: /* p_commit Standard IN param */
14: /* p_init_msg_list Standard IN param */
15: /* p_validation_level Standard IN param */
16: /* p_repair_line_id Repair Line ID to get act charges */

Line 13: /* p_commit Standard IN param */

9: /* procedure name: Get_TotalActCharges */
10: /* description : procedure used to get total actual charges */
11: /* */
12: /* p_api_version Standard IN param */
13: /* p_commit Standard IN param */
14: /* p_init_msg_list Standard IN param */
15: /* p_validation_level Standard IN param */
16: /* p_repair_line_id Repair Line ID to get act charges */
17: /* x_charges Total MLE charges for repair line */

Line 14: /* p_init_msg_list Standard IN param */

10: /* description : procedure used to get total actual charges */
11: /* */
12: /* p_api_version Standard IN param */
13: /* p_commit Standard IN param */
14: /* p_init_msg_list Standard IN param */
15: /* p_validation_level Standard IN param */
16: /* p_repair_line_id Repair Line ID to get act charges */
17: /* x_charges Total MLE charges for repair line */
18: /* x_return_status Standard OUT param */

Line 15: /* p_validation_level Standard IN param */

11: /* */
12: /* p_api_version Standard IN param */
13: /* p_commit Standard IN param */
14: /* p_init_msg_list Standard IN param */
15: /* p_validation_level Standard IN param */
16: /* p_repair_line_id Repair Line ID to get act charges */
17: /* x_charges Total MLE charges for repair line */
18: /* x_return_status Standard OUT param */
19: /* x_msg_count Standard OUT param */

Line 18: /* x_return_status Standard OUT param */

14: /* p_init_msg_list Standard IN param */
15: /* p_validation_level Standard IN param */
16: /* p_repair_line_id Repair Line ID to get act charges */
17: /* x_charges Total MLE charges for repair line */
18: /* x_return_status Standard OUT param */
19: /* x_msg_count Standard OUT param */
20: /* x_msg_data Standard OUT param */
21: /* */
22: /*----------------------------------------------------------------*/

Line 19: /* x_msg_count Standard OUT param */

15: /* p_validation_level Standard IN param */
16: /* p_repair_line_id Repair Line ID to get act charges */
17: /* x_charges Total MLE charges for repair line */
18: /* x_return_status Standard OUT param */
19: /* x_msg_count Standard OUT param */
20: /* x_msg_data Standard OUT param */
21: /* */
22: /*----------------------------------------------------------------*/
23: PROCEDURE Get_TotalActCharges

Line 20: /* x_msg_data Standard OUT param */

16: /* p_repair_line_id Repair Line ID to get act charges */
17: /* x_charges Total MLE charges for repair line */
18: /* x_return_status Standard OUT param */
19: /* x_msg_count Standard OUT param */
20: /* x_msg_data Standard OUT param */
21: /* */
22: /*----------------------------------------------------------------*/
23: PROCEDURE Get_TotalActCharges
24: (

Line 39: -- Standard Start of API savepoint

35: IS
36: l_api_name CONSTANT VARCHAR2(30) := 'Get_TotalActCharges';
37: l_api_version CONSTANT NUMBER := 1.0;
38: BEGIN
39: -- Standard Start of API savepoint
40: SAVEPOINT Get_TotalActCharges_Pvt;
41:
42: -- Standard call to check for call compatibility.
43: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 42: -- Standard call to check for call compatibility.

38: BEGIN
39: -- Standard Start of API savepoint
40: SAVEPOINT Get_TotalActCharges_Pvt;
41:
42: -- Standard call to check for call compatibility.
43: IF NOT FND_API.Compatible_API_Call (l_api_version,
44: p_api_version,
45: l_api_name,
46: G_PKG_NAME)

Line 67: -- Standard check of p_commit.

63: --
64: -- End API Body
65: --
66:
67: -- Standard check of p_commit.
68: IF FND_API.To_Boolean( p_commit ) THEN
69: COMMIT WORK;
70: END IF;
71:

Line 72: -- Standard call to get message count and IF count is get message info.

68: IF FND_API.To_Boolean( p_commit ) THEN
69: COMMIT WORK;
70: END IF;
71:
72: -- Standard call to get message count and IF count is get message info.
73: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
74: p_data => x_msg_data );
75: EXCEPTION
76: WHEN FND_API.G_EXC_ERROR THEN

Line 104: /* p_api_version Standard IN param */

100: /*----------------------------------------------------------------*/
101: /* procedure name: Get_TotalEstCharges */
102: /* description : procedure used to get total estimated charges */
103: /* */
104: /* p_api_version Standard IN param */
105: /* p_commit Standard IN param */
106: /* p_init_msg_list Standard IN param */
107: /* p_validation_level Standard IN param */
108: /* p_estimate_header_id Est Header ID to get est charges */

Line 105: /* p_commit Standard IN param */

101: /* procedure name: Get_TotalEstCharges */
102: /* description : procedure used to get total estimated charges */
103: /* */
104: /* p_api_version Standard IN param */
105: /* p_commit Standard IN param */
106: /* p_init_msg_list Standard IN param */
107: /* p_validation_level Standard IN param */
108: /* p_estimate_header_id Est Header ID to get est charges */
109: /* x_charges Total MLE charges for repair line */

Line 106: /* p_init_msg_list Standard IN param */

102: /* description : procedure used to get total estimated charges */
103: /* */
104: /* p_api_version Standard IN param */
105: /* p_commit Standard IN param */
106: /* p_init_msg_list Standard IN param */
107: /* p_validation_level Standard IN param */
108: /* p_estimate_header_id Est Header ID to get est charges */
109: /* x_charges Total MLE charges for repair line */
110: /* x_return_status Standard OUT param */

Line 107: /* p_validation_level Standard IN param */

103: /* */
104: /* p_api_version Standard IN param */
105: /* p_commit Standard IN param */
106: /* p_init_msg_list Standard IN param */
107: /* p_validation_level Standard IN param */
108: /* p_estimate_header_id Est Header ID to get est charges */
109: /* x_charges Total MLE charges for repair line */
110: /* x_return_status Standard OUT param */
111: /* x_msg_count Standard OUT param */

Line 110: /* x_return_status Standard OUT param */

106: /* p_init_msg_list Standard IN param */
107: /* p_validation_level Standard IN param */
108: /* p_estimate_header_id Est Header ID to get est charges */
109: /* x_charges Total MLE charges for repair line */
110: /* x_return_status Standard OUT param */
111: /* x_msg_count Standard OUT param */
112: /* x_msg_data Standard OUT param */
113: /* */
114: /*----------------------------------------------------------------*/

Line 111: /* x_msg_count Standard OUT param */

107: /* p_validation_level Standard IN param */
108: /* p_estimate_header_id Est Header ID to get est charges */
109: /* x_charges Total MLE charges for repair line */
110: /* x_return_status Standard OUT param */
111: /* x_msg_count Standard OUT param */
112: /* x_msg_data Standard OUT param */
113: /* */
114: /*----------------------------------------------------------------*/
115: PROCEDURE Get_TotalEstCharges

Line 112: /* x_msg_data Standard OUT param */

108: /* p_estimate_header_id Est Header ID to get est charges */
109: /* x_charges Total MLE charges for repair line */
110: /* x_return_status Standard OUT param */
111: /* x_msg_count Standard OUT param */
112: /* x_msg_data Standard OUT param */
113: /* */
114: /*----------------------------------------------------------------*/
115: PROCEDURE Get_TotalEstCharges
116: (

Line 131: -- Standard Start of API savepoint

127: IS
128: l_api_name CONSTANT VARCHAR2(30) := 'Get_TotalEstCharges';
129: l_api_version CONSTANT NUMBER := 1.0;
130: BEGIN
131: -- Standard Start of API savepoint
132: SAVEPOINT Get_TotalEstCharges_Pvt;
133:
134: -- Standard call to check for call compatibility.
135: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 134: -- Standard call to check for call compatibility.

130: BEGIN
131: -- Standard Start of API savepoint
132: SAVEPOINT Get_TotalEstCharges_Pvt;
133:
134: -- Standard call to check for call compatibility.
135: IF NOT FND_API.Compatible_API_Call (l_api_version,
136: p_api_version,
137: l_api_name,
138: G_PKG_NAME)

Line 159: -- Standard check of p_commit.

155: --
156: -- End API Body
157: --
158:
159: -- Standard check of p_commit.
160: IF FND_API.To_Boolean( p_commit ) THEN
161: COMMIT WORK;
162: END IF;
163:

Line 164: -- Standard call to get message count and IF count is get message info.

160: IF FND_API.To_Boolean( p_commit ) THEN
161: COMMIT WORK;
162: END IF;
163:
164: -- Standard call to get message count and IF count is get message info.
165: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
166: p_data => x_msg_data );
167: EXCEPTION
168: WHEN FND_API.G_EXC_ERROR THEN

Line 197: /* p_api_version Standard IN param */

193: /* procedure name: Compare_EstChargesAndCosts */
194: /* description : procedure used to compare estimated charges to */
195: /* estimated costs */
196: /* */
197: /* p_api_version Standard IN param */
198: /* p_commit Standard IN param */
199: /* p_init_msg_list Standard IN param */
200: /* p_validation_level Standard IN param */
201: /* p_estimate_header_id Est Header ID to get est charges */

Line 198: /* p_commit Standard IN param */

194: /* description : procedure used to compare estimated charges to */
195: /* estimated costs */
196: /* */
197: /* p_api_version Standard IN param */
198: /* p_commit Standard IN param */
199: /* p_init_msg_list Standard IN param */
200: /* p_validation_level Standard IN param */
201: /* p_estimate_header_id Est Header ID to get est charges */
202: /* p_charges Total MLE charges for estimate */

Line 199: /* p_init_msg_list Standard IN param */

195: /* estimated costs */
196: /* */
197: /* p_api_version Standard IN param */
198: /* p_commit Standard IN param */
199: /* p_init_msg_list Standard IN param */
200: /* p_validation_level Standard IN param */
201: /* p_estimate_header_id Est Header ID to get est charges */
202: /* p_charges Total MLE charges for estimate */
203: /* x_costs MLE Costs for estimate */

Line 200: /* p_validation_level Standard IN param */

196: /* */
197: /* p_api_version Standard IN param */
198: /* p_commit Standard IN param */
199: /* p_init_msg_list Standard IN param */
200: /* p_validation_level Standard IN param */
201: /* p_estimate_header_id Est Header ID to get est charges */
202: /* p_charges Total MLE charges for estimate */
203: /* x_costs MLE Costs for estimate */
204: /* x_profit MLE Profit */

Line 206: /* x_return_status Standard OUT param */

202: /* p_charges Total MLE charges for estimate */
203: /* x_costs MLE Costs for estimate */
204: /* x_profit MLE Profit */
205: /* x_profit_margin MLE Profit Margin (%) */
206: /* x_return_status Standard OUT param */
207: /* x_msg_count Standard OUT param */
208: /* x_msg_data Standard OUT param */
209: /* */
210: /*----------------------------------------------------------------*/

Line 207: /* x_msg_count Standard OUT param */

203: /* x_costs MLE Costs for estimate */
204: /* x_profit MLE Profit */
205: /* x_profit_margin MLE Profit Margin (%) */
206: /* x_return_status Standard OUT param */
207: /* x_msg_count Standard OUT param */
208: /* x_msg_data Standard OUT param */
209: /* */
210: /*----------------------------------------------------------------*/
211: PROCEDURE Compare_EstChargesAndCosts

Line 208: /* x_msg_data Standard OUT param */

204: /* x_profit MLE Profit */
205: /* x_profit_margin MLE Profit Margin (%) */
206: /* x_return_status Standard OUT param */
207: /* x_msg_count Standard OUT param */
208: /* x_msg_data Standard OUT param */
209: /* */
210: /*----------------------------------------------------------------*/
211: PROCEDURE Compare_EstChargesAndCosts
212: (

Line 230: -- Standard Start of API savepoint

226: IS
227: l_api_name CONSTANT VARCHAR2(30) := 'Compare_EstChargesAndCosts';
228: l_api_version CONSTANT NUMBER := 1.0;
229: BEGIN
230: -- Standard Start of API savepoint
231: SAVEPOINT Compare_EstChargesAndCosts_Pvt;
232:
233: -- Standard call to check for call compatibility.
234: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 233: -- Standard call to check for call compatibility.

229: BEGIN
230: -- Standard Start of API savepoint
231: SAVEPOINT Compare_EstChargesAndCosts_Pvt;
232:
233: -- Standard call to check for call compatibility.
234: IF NOT FND_API.Compatible_API_Call (l_api_version,
235: p_api_version,
236: l_api_name,
237: G_PKG_NAME)

Line 258: -- Standard check of p_commit.

254: --
255: -- End API Body
256: --
257:
258: -- Standard check of p_commit.
259: IF FND_API.To_Boolean( p_commit ) THEN
260: COMMIT WORK;
261: END IF;
262:

Line 263: -- Standard call to get message count and IF count is get message info.

259: IF FND_API.To_Boolean( p_commit ) THEN
260: COMMIT WORK;
261: END IF;
262:
263: -- Standard call to get message count and IF count is get message info.
264: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
265: p_data => x_msg_data );
266: EXCEPTION
267: WHEN FND_API.G_EXC_ERROR THEN

Line 296: /* p_api_version Standard IN param */

292: /* procedure name: Compare_ActChargesAndCosts */
293: /* description : procedure used to compare actual charges to */
294: /* actual costs */
295: /* */
296: /* p_api_version Standard IN param */
297: /* p_commit Standard IN param */
298: /* p_init_msg_list Standard IN param */
299: /* p_validation_level Standard IN param */
300: /* p_repair_line_id Repair Line ID to get act charges */

Line 297: /* p_commit Standard IN param */

293: /* description : procedure used to compare actual charges to */
294: /* actual costs */
295: /* */
296: /* p_api_version Standard IN param */
297: /* p_commit Standard IN param */
298: /* p_init_msg_list Standard IN param */
299: /* p_validation_level Standard IN param */
300: /* p_repair_line_id Repair Line ID to get act charges */
301: /* p_charges Total MLE charges for actuals */

Line 298: /* p_init_msg_list Standard IN param */

294: /* actual costs */
295: /* */
296: /* p_api_version Standard IN param */
297: /* p_commit Standard IN param */
298: /* p_init_msg_list Standard IN param */
299: /* p_validation_level Standard IN param */
300: /* p_repair_line_id Repair Line ID to get act charges */
301: /* p_charges Total MLE charges for actuals */
302: /* x_costs MLE Costs for estimate */

Line 299: /* p_validation_level Standard IN param */

295: /* */
296: /* p_api_version Standard IN param */
297: /* p_commit Standard IN param */
298: /* p_init_msg_list Standard IN param */
299: /* p_validation_level Standard IN param */
300: /* p_repair_line_id Repair Line ID to get act charges */
301: /* p_charges Total MLE charges for actuals */
302: /* x_costs MLE Costs for estimate */
303: /* x_profit MLE Profit */

Line 305: /* x_return_status Standard OUT param */

301: /* p_charges Total MLE charges for actuals */
302: /* x_costs MLE Costs for estimate */
303: /* x_profit MLE Profit */
304: /* x_profit_margin MLE Profit Margin (%) */
305: /* x_return_status Standard OUT param */
306: /* x_msg_count Standard OUT param */
307: /* x_msg_data Standard OUT param */
308: /* */
309: /*----------------------------------------------------------------*/

Line 306: /* x_msg_count Standard OUT param */

302: /* x_costs MLE Costs for estimate */
303: /* x_profit MLE Profit */
304: /* x_profit_margin MLE Profit Margin (%) */
305: /* x_return_status Standard OUT param */
306: /* x_msg_count Standard OUT param */
307: /* x_msg_data Standard OUT param */
308: /* */
309: /*----------------------------------------------------------------*/
310: PROCEDURE Compare_ActChargesAndCosts

Line 307: /* x_msg_data Standard OUT param */

303: /* x_profit MLE Profit */
304: /* x_profit_margin MLE Profit Margin (%) */
305: /* x_return_status Standard OUT param */
306: /* x_msg_count Standard OUT param */
307: /* x_msg_data Standard OUT param */
308: /* */
309: /*----------------------------------------------------------------*/
310: PROCEDURE Compare_ActChargesAndCosts
311: (

Line 329: -- Standard Start of API savepoint

325: IS
326: l_api_name CONSTANT VARCHAR2(30) := 'Compare_ActChargesAndCosts';
327: l_api_version CONSTANT NUMBER := 1.0;
328: BEGIN
329: -- Standard Start of API savepoint
330: SAVEPOINT Compare_ActChargesAndCosts_Pvt;
331:
332: -- Standard call to check for call compatibility.
333: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 332: -- Standard call to check for call compatibility.

328: BEGIN
329: -- Standard Start of API savepoint
330: SAVEPOINT Compare_ActChargesAndCosts_Pvt;
331:
332: -- Standard call to check for call compatibility.
333: IF NOT FND_API.Compatible_API_Call (l_api_version,
334: p_api_version,
335: l_api_name,
336: G_PKG_NAME)

Line 357: -- Standard check of p_commit.

353: --
354: -- End API Body
355: --
356:
357: -- Standard check of p_commit.
358: IF FND_API.To_Boolean( p_commit ) THEN
359: COMMIT WORK;
360: END IF;
361:

Line 362: -- Standard call to get message count and IF count is get message info.

358: IF FND_API.To_Boolean( p_commit ) THEN
359: COMMIT WORK;
360: END IF;
361:
362: -- Standard call to get message count and IF count is get message info.
363: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
364: p_data => x_msg_data );
365: EXCEPTION
366: WHEN FND_API.G_EXC_ERROR THEN

Line 395: /* p_api_version Standard IN param */

391: /* procedure name: Compare_ActChargesAndCosts */
392: /* description : procedure used to compare actual charges to */
393: /* actual costs */
394: /* */
395: /* p_api_version Standard IN param */
396: /* p_commit Standard IN param */
397: /* p_init_msg_list Standard IN param */
398: /* p_validation_level Standard IN param */
399: /* p_repair_line_id Repair Line ID to get act charges */

Line 396: /* p_commit Standard IN param */

392: /* description : procedure used to compare actual charges to */
393: /* actual costs */
394: /* */
395: /* p_api_version Standard IN param */
396: /* p_commit Standard IN param */
397: /* p_init_msg_list Standard IN param */
398: /* p_validation_level Standard IN param */
399: /* p_repair_line_id Repair Line ID to get act charges */
400: /* p_charges Total MLE charges for actuals */

Line 397: /* p_init_msg_list Standard IN param */

393: /* actual costs */
394: /* */
395: /* p_api_version Standard IN param */
396: /* p_commit Standard IN param */
397: /* p_init_msg_list Standard IN param */
398: /* p_validation_level Standard IN param */
399: /* p_repair_line_id Repair Line ID to get act charges */
400: /* p_charges Total MLE charges for actuals */
401: /* x_costs MLE Costs for estimate */

Line 398: /* p_validation_level Standard IN param */

394: /* */
395: /* p_api_version Standard IN param */
396: /* p_commit Standard IN param */
397: /* p_init_msg_list Standard IN param */
398: /* p_validation_level Standard IN param */
399: /* p_repair_line_id Repair Line ID to get act charges */
400: /* p_charges Total MLE charges for actuals */
401: /* x_costs MLE Costs for estimate */
402: /* x_profit MLE Profit */

Line 404: /* x_return_status Standard OUT param */

400: /* p_charges Total MLE charges for actuals */
401: /* x_costs MLE Costs for estimate */
402: /* x_profit MLE Profit */
403: /* x_profit_margin MLE Profit Margin (%) */
404: /* x_return_status Standard OUT param */
405: /* x_msg_count Standard OUT param */
406: /* x_msg_data Standard OUT param */
407: /* */
408: /*----------------------------------------------------------------*/

Line 405: /* x_msg_count Standard OUT param */

401: /* x_costs MLE Costs for estimate */
402: /* x_profit MLE Profit */
403: /* x_profit_margin MLE Profit Margin (%) */
404: /* x_return_status Standard OUT param */
405: /* x_msg_count Standard OUT param */
406: /* x_msg_data Standard OUT param */
407: /* */
408: /*----------------------------------------------------------------*/
409: PROCEDURE Compare_EstAndActCharges

Line 406: /* x_msg_data Standard OUT param */

402: /* x_profit MLE Profit */
403: /* x_profit_margin MLE Profit Margin (%) */
404: /* x_return_status Standard OUT param */
405: /* x_msg_count Standard OUT param */
406: /* x_msg_data Standard OUT param */
407: /* */
408: /*----------------------------------------------------------------*/
409: PROCEDURE Compare_EstAndActCharges
410: (

Line 429: -- Standard Start of API savepoint

425: IS
426: l_api_name CONSTANT VARCHAR2(30) := 'Compare_EstAndActCharges';
427: l_api_version CONSTANT NUMBER := 1.0;
428: BEGIN
429: -- Standard Start of API savepoint
430: SAVEPOINT Compare_EstAndActCharges_Pvt;
431:
432: -- Standard call to check for call compatibility.
433: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 432: -- Standard call to check for call compatibility.

428: BEGIN
429: -- Standard Start of API savepoint
430: SAVEPOINT Compare_EstAndActCharges_Pvt;
431:
432: -- Standard call to check for call compatibility.
433: IF NOT FND_API.Compatible_API_Call (l_api_version,
434: p_api_version,
435: l_api_name,
436: G_PKG_NAME)

Line 457: -- Standard check of p_commit.

453: --
454: -- End API Body
455: --
456:
457: -- Standard check of p_commit.
458: IF FND_API.To_Boolean( p_commit ) THEN
459: COMMIT WORK;
460: END IF;
461:

Line 462: -- Standard call to get message count and IF count is get message info.

458: IF FND_API.To_Boolean( p_commit ) THEN
459: COMMIT WORK;
460: END IF;
461:
462: -- Standard call to get message count and IF count is get message info.
463: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
464: p_data => x_msg_data );
465: EXCEPTION
466: WHEN FND_API.G_EXC_ERROR THEN

Line 496: /* p_api_version Standard IN param */

492: /* description : procedure used get item cost, extended cost, */
493: /* profit, and profit margin (%) */
494: /* for an inventory item */
495: /* */
496: /* p_api_version Standard IN param */
497: /* p_commit Standard IN param */
498: /* p_init_msg_list Standard IN param */
499: /* p_validation_level Standard IN param */
500: /* p_inventory_item_id Inventory Item ID */

Line 497: /* p_commit Standard IN param */

493: /* profit, and profit margin (%) */
494: /* for an inventory item */
495: /* */
496: /* p_api_version Standard IN param */
497: /* p_commit Standard IN param */
498: /* p_init_msg_list Standard IN param */
499: /* p_validation_level Standard IN param */
500: /* p_inventory_item_id Inventory Item ID */
501: /* p_quantity Quantity of Inventory Items */

Line 498: /* p_init_msg_list Standard IN param */

494: /* for an inventory item */
495: /* */
496: /* p_api_version Standard IN param */
497: /* p_commit Standard IN param */
498: /* p_init_msg_list Standard IN param */
499: /* p_validation_level Standard IN param */
500: /* p_inventory_item_id Inventory Item ID */
501: /* p_quantity Quantity of Inventory Items */
502: /* p_organization_id Inventory Organization ID */

Line 499: /* p_validation_level Standard IN param */

495: /* */
496: /* p_api_version Standard IN param */
497: /* p_commit Standard IN param */
498: /* p_init_msg_list Standard IN param */
499: /* p_validation_level Standard IN param */
500: /* p_inventory_item_id Inventory Item ID */
501: /* p_quantity Quantity of Inventory Items */
502: /* p_organization_id Inventory Organization ID */
503: /* p_charge_amt Total Charge Amt to compare to */

Line 509: /* x_return_status Standard OUT param */

505: /* x_item_cost Item cost of Inv Item */
506: /* x_total_cost Extended cost of Inv Item */
507: /* x_profit x_total_cost - p_charge_amt */
508: /* x_profit_margin x_profit*100/x_item_cost */
509: /* x_return_status Standard OUT param */
510: /* x_msg_count Standard OUT param */
511: /* x_msg_data Standard OUT param */
512: /* */
513: /*----------------------------------------------------------------*/

Line 510: /* x_msg_count Standard OUT param */

506: /* x_total_cost Extended cost of Inv Item */
507: /* x_profit x_total_cost - p_charge_amt */
508: /* x_profit_margin x_profit*100/x_item_cost */
509: /* x_return_status Standard OUT param */
510: /* x_msg_count Standard OUT param */
511: /* x_msg_data Standard OUT param */
512: /* */
513: /*----------------------------------------------------------------*/
514: PROCEDURE Get_InvItemCostAnalysis

Line 511: /* x_msg_data Standard OUT param */

507: /* x_profit x_total_cost - p_charge_amt */
508: /* x_profit_margin x_profit*100/x_item_cost */
509: /* x_return_status Standard OUT param */
510: /* x_msg_count Standard OUT param */
511: /* x_msg_data Standard OUT param */
512: /* */
513: /*----------------------------------------------------------------*/
514: PROCEDURE Get_InvItemCostAnalysis
515: (

Line 537: -- Standard Start of API savepoint

533: IS
534: l_api_name CONSTANT VARCHAR2(30) := 'Get_InvItemCostAnalysis';
535: l_api_version CONSTANT NUMBER := 1.0;
536: BEGIN
537: -- Standard Start of API savepoint
538: SAVEPOINT Get_InvItemCostAnalysis_Pvt;
539:
540: -- Standard call to check for call compatibility.
541: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 540: -- Standard call to check for call compatibility.

536: BEGIN
537: -- Standard Start of API savepoint
538: SAVEPOINT Get_InvItemCostAnalysis_Pvt;
539:
540: -- Standard call to check for call compatibility.
541: IF NOT FND_API.Compatible_API_Call (l_api_version,
542: p_api_version,
543: l_api_name,
544: G_PKG_NAME)

Line 565: -- Standard check of p_commit.

561: --
562: -- End API Body
563: --
564:
565: -- Standard check of p_commit.
566: IF FND_API.To_Boolean( p_commit ) THEN
567: COMMIT WORK;
568: END IF;
569:

Line 570: -- Standard call to get message count and IF count is get message info.

566: IF FND_API.To_Boolean( p_commit ) THEN
567: COMMIT WORK;
568: END IF;
569:
570: -- Standard call to get message count and IF count is get message info.
571: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
572: p_data => x_msg_data );
573: EXCEPTION
574: WHEN FND_API.G_EXC_ERROR THEN

Line 604: /* p_api_version Standard IN param */

600: /* description : procedure used get item cost, extended cost, */
601: /* profit, and profit margin (%) */
602: /* for a bom resource */
603: /* */
604: /* p_api_version Standard IN param */
605: /* p_commit Standard IN param */
606: /* p_init_msg_list Standard IN param */
607: /* p_validation_level Standard IN param */
608: /* p_bom_resource_id BOM Resource ID */

Line 605: /* p_commit Standard IN param */

601: /* profit, and profit margin (%) */
602: /* for a bom resource */
603: /* */
604: /* p_api_version Standard IN param */
605: /* p_commit Standard IN param */
606: /* p_init_msg_list Standard IN param */
607: /* p_validation_level Standard IN param */
608: /* p_bom_resource_id BOM Resource ID */
609: /* p_quantity Quantity of resource */

Line 606: /* p_init_msg_list Standard IN param */

602: /* for a bom resource */
603: /* */
604: /* p_api_version Standard IN param */
605: /* p_commit Standard IN param */
606: /* p_init_msg_list Standard IN param */
607: /* p_validation_level Standard IN param */
608: /* p_bom_resource_id BOM Resource ID */
609: /* p_quantity Quantity of resource */
610: /* p_organization_id Inventory Organization ID */

Line 607: /* p_validation_level Standard IN param */

603: /* */
604: /* p_api_version Standard IN param */
605: /* p_commit Standard IN param */
606: /* p_init_msg_list Standard IN param */
607: /* p_validation_level Standard IN param */
608: /* p_bom_resource_id BOM Resource ID */
609: /* p_quantity Quantity of resource */
610: /* p_organization_id Inventory Organization ID */
611: /* p_charge_amt Total Charge Amt to compare to */

Line 617: /* x_return_status Standard OUT param */

613: /* x_item_cost Resource rate of BOM resource */
614: /* x_total_cost Extended cost of Resource */
615: /* x_profit x_total_cost - p_charge_amt */
616: /* x_profit_margin x_profit*100/x_item_cost */
617: /* x_return_status Standard OUT param */
618: /* x_msg_count Standard OUT param */
619: /* x_msg_data Standard OUT param */
620: /* */
621: /*----------------------------------------------------------------*/

Line 618: /* x_msg_count Standard OUT param */

614: /* x_total_cost Extended cost of Resource */
615: /* x_profit x_total_cost - p_charge_amt */
616: /* x_profit_margin x_profit*100/x_item_cost */
617: /* x_return_status Standard OUT param */
618: /* x_msg_count Standard OUT param */
619: /* x_msg_data Standard OUT param */
620: /* */
621: /*----------------------------------------------------------------*/
622: PROCEDURE Get_ResItemCostAnalysis

Line 619: /* x_msg_data Standard OUT param */

615: /* x_profit x_total_cost - p_charge_amt */
616: /* x_profit_margin x_profit*100/x_item_cost */
617: /* x_return_status Standard OUT param */
618: /* x_msg_count Standard OUT param */
619: /* x_msg_data Standard OUT param */
620: /* */
621: /*----------------------------------------------------------------*/
622: PROCEDURE Get_ResItemCostAnalysis
623: (

Line 645: -- Standard Start of API savepoint

641: IS
642: l_api_name CONSTANT VARCHAR2(30) := 'Get_ResItemCostAnalysis';
643: l_api_version CONSTANT NUMBER := 1.0;
644: BEGIN
645: -- Standard Start of API savepoint
646: SAVEPOINT Get_ResItemCostAnalysis_Pvt;
647:
648: -- Standard call to check for call compatibility.
649: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 648: -- Standard call to check for call compatibility.

644: BEGIN
645: -- Standard Start of API savepoint
646: SAVEPOINT Get_ResItemCostAnalysis_Pvt;
647:
648: -- Standard call to check for call compatibility.
649: IF NOT FND_API.Compatible_API_Call (l_api_version,
650: p_api_version,
651: l_api_name,
652: G_PKG_NAME)

Line 673: -- Standard check of p_commit.

669: --
670: -- End API Body
671: --
672:
673: -- Standard check of p_commit.
674: IF FND_API.To_Boolean( p_commit ) THEN
675: COMMIT WORK;
676: END IF;
677:

Line 678: -- Standard call to get message count and IF count is get message info.

674: IF FND_API.To_Boolean( p_commit ) THEN
675: COMMIT WORK;
676: END IF;
677:
678: -- Standard call to get message count and IF count is get message info.
679: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
680: p_data => x_msg_data );
681: EXCEPTION
682: WHEN FND_API.G_EXC_ERROR THEN