3773: x_msg_count OUT NOCOPY NUMBER,
3774: x_msg_data OUT NOCOPY VARCHAR2
3775: ) is
3776:
3777: l_wms_org mtl_parameters.wms_enabled_flag%type;
3778: l_def_cost_grp_id mtl_parameters.default_cost_group_id%type;
3779:
3780: l_acct_period_id number;
3781:
3774: x_msg_data OUT NOCOPY VARCHAR2
3775: ) is
3776:
3777: l_wms_org mtl_parameters.wms_enabled_flag%type;
3778: l_def_cost_grp_id mtl_parameters.default_cost_group_id%type;
3779:
3780: l_acct_period_id number;
3781:
3782: l_err_code number;
3796: SELECT wms_enabled_flag,
3797: default_cost_group_id
3798: INTO l_wms_org,
3799: l_def_cost_grp_id
3800: FROM mtl_parameters
3801: WHERE organization_id = p_txn_org_id;
3802: --End additions to fix bug #2828376--
3803:
3804: l_stmt_num := 20;