[Home] [Help]
1028: --bug:5364225 When copying across orgs, wip supply type will be copied from
1029: --component/component operation. If Default Wip Values profile is set to Yes, then
1030: --supply subinventory and supply locator will be defaulted from item otherwise they
1031: --will be nulled out. When copying within same org, the values will be copied from comp/comp operation.
1032: FND_PROFILE.GET('BOM:DEFAULT_WIP_VALUES', l_default_wip_params);
1033:
1034: -- reset from_sequence_id to common_bill_sequence_id
1035: sql_stmt_num := 10;
1036:
6820: x_item_rev_tbl(l_index), x_item_rev_id_tbl(l_index),
6821: x_item_rev_lbl_tbl(l_index), x_item_exists_tbl(l_index)
6822: FROM org_access_view oav
6823: WHERE oav.organization_id = x_org_list_tbl(l_index)
6824: AND oav.responsibility_id = fnd_profile.value('RESP_ID')
6825: AND oav.resp_application_id = fnd_profile.value('RESP_APPL_ID');
6826: l_index := x_org_list_tbl.next(l_index);
6827: x_return_status := fnd_api.G_RET_STS_SUCCESS;
6828: EXCEPTION
6821: x_item_rev_lbl_tbl(l_index), x_item_exists_tbl(l_index)
6822: FROM org_access_view oav
6823: WHERE oav.organization_id = x_org_list_tbl(l_index)
6824: AND oav.responsibility_id = fnd_profile.value('RESP_ID')
6825: AND oav.resp_application_id = fnd_profile.value('RESP_APPL_ID');
6826: l_index := x_org_list_tbl.next(l_index);
6827: x_return_status := fnd_api.G_RET_STS_SUCCESS;
6828: EXCEPTION
6829: WHEN NO_DATA_FOUND THEN
7388: WHERE bcb.bill_sequence_id = p_bill_seq_id;
7389: BEGIN
7390: SAVEPOINT begin_revised_item_bill_copy;
7391:
7392: FND_PROFILE.GET('BOM:DEFAULT_WIP_VALUES', l_default_wip_params);
7393:
7394: -- reset from_sequence_id to common_bill_sequence_id
7395: sql_stmt_num := 10;
7396: