DBA Data[Home] [Help]

APPS.CSTPUMEC dependencies on MTL_PARAMETERS

Line 797: l_orgcode mtl_parameters.organization_code%TYPE := NULL;

793: l_nonzero_shrinkage NUMBER; -- the number of such items
794:
795: -- The next three variables are used to print a warning message with the
796: -- fnd_message utilities.
797: l_orgcode mtl_parameters.organization_code%TYPE := NULL;
798: l_costtype cst_cost_types.cost_type%TYPE := NULL;
799: l_itemname mtl_system_items_kfv.concatenated_segments%TYPE;
800:
801: BEGIN

Line 1093: from mtl_parameters

1089: fnd_message.set_token('NUMBER', to_char(l_nonzero_shrinkage));
1090:
1091: select organization_code
1092: into l_orgcode
1093: from mtl_parameters
1094: where organization_id = i_org_id;
1095: fnd_message.set_token('ORG', l_orgcode);
1096:
1097: select cost_type

Line 1194: from mtl_parameters

1190:
1191: if (l_orgcode IS NULL) then
1192: select organization_code
1193: into l_orgcode
1194: from mtl_parameters
1195: where organization_id = i_org_id;
1196: end if;
1197: fnd_message.set_token('ORG', l_orgcode);
1198: