APPS.CSTPSCEX dependencies on STANDARD

Line 1340: l_frozen_standard_flag number(15);

1336: i_report_option_type in number -- SCAPI: for supply chain cost reports
1337: )
1338: is
1339: l_low_level_code NUMBER(15);
1340: l_frozen_standard_flag number(15);
1341:
1342: l_stmt_num number(15);
1343: begin
1344:

Line 1447: select CCT.frozen_standard_flag

1443: IF i_cost_type_id is not null THEN
1444:
1445: l_stmt_num := 30;
1446:
1447: select CCT.frozen_standard_flag
1448: into l_frozen_standard_flag
1449: from cst_cost_types CCT
1450: where CCT.cost_type_id = i_cost_type_id;
1451:

Line 1448: into l_frozen_standard_flag

1444:
1445: l_stmt_num := 30;
1446:
1447: select CCT.frozen_standard_flag
1448: into l_frozen_standard_flag
1449: from cst_cost_types CCT
1450: where CCT.cost_type_id = i_cost_type_id;
1451:
1452: -- SCAPI: to support supply chain cost reports

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

1449: from cst_cost_types CCT
1450: where CCT.cost_type_id = i_cost_type_id;
1451:
1452: -- SCAPI: to support supply chain cost reports
1453: IF ( (l_frozen_standard_flag = 1) and (i_report_option_type <> -1 or i_report_option_type is null) ) THEN
1454:
1455: l_stmt_num := 40;
1456:
1457: delete cst_sc_low_level_codes CSLLC

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

1469: o_error_code := 1001;
1470: o_error_msg :=
1471: 'CSTPSCEX.compute_sc_low_level_codes():' ||
1472: to_char(l_stmt_num) || ':' ||
1473: 'Cannot update standard cost for ' || to_char(SQL%ROWCOUNT) ||
1474: ' items due to existing MMT transactions';
1475: END IF;
1476:
1477: END IF;