APPS.CSTPSCEX dependencies on STANDARD

Line 1296: l_frozen_standard_flag number(15);

1292: i_report_option_type in number -- SCAPI: for supply chain cost reports
1293: )
1294: is
1295: l_low_level_code NUMBER(15);
1296: l_frozen_standard_flag number(15);
1297:
1298: l_stmt_num number(15);
1299: begin
1300:

Line 1403: select CCT.frozen_standard_flag

1399: IF i_cost_type_id is not null THEN
1400:
1401: l_stmt_num := 30;
1402:
1403: select CCT.frozen_standard_flag
1404: into l_frozen_standard_flag
1405: from cst_cost_types CCT
1406: where CCT.cost_type_id = i_cost_type_id;
1407:

Line 1404: into l_frozen_standard_flag

1400:
1401: l_stmt_num := 30;
1402:
1403: select CCT.frozen_standard_flag
1404: into l_frozen_standard_flag
1405: from cst_cost_types CCT
1406: where CCT.cost_type_id = i_cost_type_id;
1407:
1408: -- SCAPI: to support supply chain cost reports

Line 1409: IF ( (l_frozen_standard_flag = 1) and (i_report_option_type <> -1 or i_report_option_type is null) ) THEN

1405: from cst_cost_types CCT
1406: where CCT.cost_type_id = i_cost_type_id;
1407:
1408: -- SCAPI: to support supply chain cost reports
1409: IF ( (l_frozen_standard_flag = 1) and (i_report_option_type <> -1 or i_report_option_type is null) ) THEN
1410:
1411: l_stmt_num := 40;
1412:
1413: delete cst_sc_low_level_codes CSLLC

Line 1429: 'Cannot update standard cost for ' || to_char(SQL%ROWCOUNT) ||

1425: o_error_code := 1001;
1426: o_error_msg :=
1427: 'CSTPSCEX.compute_sc_low_level_codes():' ||
1428: to_char(l_stmt_num) || ':' ||
1429: 'Cannot update standard cost for ' || to_char(SQL%ROWCOUNT) ||
1430: ' items due to existing MMT transactions';
1431: END IF;
1432:
1433: END IF;