APPS.CSD_COST_ANALYSIS_PVT dependencies on CSD_COST_ANALYSIS_UTIL

Line 55: x_costs OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE)

51: x_msg_data OUT NOCOPY VARCHAR2,
52: p_repair_estimate_id IN NUMBER,
53: p_organization_id IN NUMBER,
54: p_ro_currency_code IN VARCHAR2,
55: x_costs OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE)
56:
57: IS
58:
59: --Cursor to get total cost for an estimate line, group by MLE.

Line 147: IF NOT (CSD_COST_ANALYSIS_UTIL.Validate_CostingEnabled(p_organization_id))

143: END IF;
144:
145: -- IF not costing enabled then throw exception
146:
147: IF NOT (CSD_COST_ANALYSIS_UTIL.Validate_CostingEnabled(p_organization_id))
148: THEN
149:
150: -- Throw error
151:

Line 351: x_charges OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE)

347: x_msg_count OUT NOCOPY NUMBER,
348: x_msg_data OUT NOCOPY VARCHAR2,
349: p_repair_estimate_id IN NUMBER,
350: p_ro_currency_code IN VARCHAR2,
351: x_charges OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE)
352: IS
353: --Cursor to get teh line count for an estimate header.
354: CURSOR cur_getEstLineCount(p_repair_Estimate_id NUMBER)
355: IS

Line 603: x_charges OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE,

599: x_msg_data OUT NOCOPY VARCHAR2,
600: p_repair_estimate_id IN NUMBER,
601: p_organization_id IN NUMBER,
602: p_ro_currency_code IN VARCHAR2,
603: x_charges OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE,
604: x_costs OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE,
605: x_profit OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE,
606: x_profit_margin OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE)
607: IS

Line 604: x_costs OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE,

600: p_repair_estimate_id IN NUMBER,
601: p_organization_id IN NUMBER,
602: p_ro_currency_code IN VARCHAR2,
603: x_charges OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE,
604: x_costs OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE,
605: x_profit OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE,
606: x_profit_margin OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE)
607: IS
608: l_api_name CONSTANT VARCHAR2(30) := 'Compare_EstChargesAndCosts';

Line 605: x_profit OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE,

601: p_organization_id IN NUMBER,
602: p_ro_currency_code IN VARCHAR2,
603: x_charges OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE,
604: x_costs OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE,
605: x_profit OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE,
606: x_profit_margin OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE)
607: IS
608: l_api_name CONSTANT VARCHAR2(30) := 'Compare_EstChargesAndCosts';
609: l_api_version CONSTANT NUMBER := 1.0;

Line 606: x_profit_margin OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE)

602: p_ro_currency_code IN VARCHAR2,
603: x_charges OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE,
604: x_costs OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE,
605: x_profit OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE,
606: x_profit_margin OUT NOCOPY CSD_COST_ANALYSIS_UTIL.MLE_TOTALS_REC_TYPE)
607: IS
608: l_api_name CONSTANT VARCHAR2(30) := 'Compare_EstChargesAndCosts';
609: l_api_version CONSTANT NUMBER := 1.0;
610:

Line 721: CSD_COST_ANALYSIS_UTIL.Compare_MLETotals(p_api_version => p_api_version,

717: END IF;
718:
719: --Compare charges and costs amount and return the profit and percent profit.
720:
721: CSD_COST_ANALYSIS_UTIL.Compare_MLETotals(p_api_version => p_api_version,
722: p_commit => p_commit,
723: p_init_msg_list => p_init_msg_list,
724: p_validation_level => p_validation_level,
725: p_mle_totals_basis => x_costs,

Line 948: IF (CSD_COST_ANALYSIS_UTIL.Validate_CostingEnabled(p_organization_id))

944: END IF;
945:
946: --Check if costing enabled
947:
948: IF (CSD_COST_ANALYSIS_UTIL.Validate_CostingEnabled(p_organization_id))
949: THEN
950:
951: -- Get item cost
952:

Line 1002: l_cost_currency_code := CSD_COST_ANALYSIS_UTIL.get_GLCurrencyCode(p_organization_id);

998: FND_MSG_PUB.ADD;
999: --END IF;
1000: RAISE FND_API.G_EXC_ERROR;
1001: END IF;
1002: l_cost_currency_code := CSD_COST_ANALYSIS_UTIL.get_GLCurrencyCode(p_organization_id);
1003:
1004: --do the conversion if currency codes differ.
1005:
1006: IF (p_currency_code <> l_cost_currency_code)

Line 1008: CSD_COST_ANALYSIS_UTIL.Convert_CurrencyAmount(p_api_version => p_api_version,

1004: --do the conversion if currency codes differ.
1005:
1006: IF (p_currency_code <> l_cost_currency_code)
1007: THEN
1008: CSD_COST_ANALYSIS_UTIL.Convert_CurrencyAmount(p_api_version => p_api_version,
1009: p_commit => p_commit,
1010: p_init_msg_list => p_init_msg_list,
1011: p_validation_level => p_validation_level,
1012: p_from_currency => l_cost_currency_code,

Line 1225: IF (CSD_COST_ANALYSIS_UTIL.Validate_CostingEnabled(p_organization_id))

1221: END IF;
1222:
1223: --Check if costing enabled
1224:
1225: IF (CSD_COST_ANALYSIS_UTIL.Validate_CostingEnabled(p_organization_id))
1226: THEN
1227:
1228: --Check if the resource id was passed. If so, then get the resource cost
1229: If p_bom_resource_id is not null THEN

Line 1293: l_cost_currency_code := CSD_COST_ANALYSIS_UTIL.get_GLCurrencyCode(p_organization_id);

1289: RAISE FND_API.G_EXC_ERROR;
1290: END IF;
1291: CLOSE cur_getItemCost;
1292: END IF;
1293: l_cost_currency_code := CSD_COST_ANALYSIS_UTIL.get_GLCurrencyCode(p_organization_id);
1294:
1295: --do the conversion if currency codes differ.
1296:
1297: IF (p_currency_code <> l_cost_currency_code)

Line 1299: CSD_COST_ANALYSIS_UTIL.Convert_CurrencyAmount(p_api_version => p_api_version,

1295: --do the conversion if currency codes differ.
1296:
1297: IF (p_currency_code <> l_cost_currency_code)
1298: THEN
1299: CSD_COST_ANALYSIS_UTIL.Convert_CurrencyAmount(p_api_version => p_api_version,
1300: p_commit => p_commit,
1301: p_init_msg_list => p_init_msg_list,
1302: p_validation_level => p_validation_level,
1303: p_from_currency => l_cost_currency_code,