1068: end if;
1069:
1070: /* Bug 3458191: Change condition since global_worksheet_id and
1071: local_copy_flag have cached.
1072: if ((PSB_WS_POS1.g_global_worksheet_id is null) or
1073: (PSB_WS_POS1.g_local_copy_flag is null)) then
1074: begin
1075:
1076: for c_WS_Rec in c_WS loop
1069:
1070: /* Bug 3458191: Change condition since global_worksheet_id and
1071: local_copy_flag have cached.
1072: if ((PSB_WS_POS1.g_global_worksheet_id is null) or
1073: (PSB_WS_POS1.g_local_copy_flag is null)) then
1074: begin
1075:
1076: for c_WS_Rec in c_WS loop
1077: l_global_worksheet_id := c_WS_Rec.global_worksheet_id;
1082: else
1083: */
1084:
1085: -- Bug 3458191: New condition to replace the above ELSE condition
1086: if ((PSB_WS_POS1.g_global_worksheet_id is not null)
1087: and
1088: (PSB_WS_POS1.g_local_copy_flag is not null))
1089: then
1090: l_global_worksheet_id := PSB_WS_POS1.g_global_worksheet_id;
1084:
1085: -- Bug 3458191: New condition to replace the above ELSE condition
1086: if ((PSB_WS_POS1.g_global_worksheet_id is not null)
1087: and
1088: (PSB_WS_POS1.g_local_copy_flag is not null))
1089: then
1090: l_global_worksheet_id := PSB_WS_POS1.g_global_worksheet_id;
1091: l_local_copy_flag := PSB_WS_POS1.g_local_copy_flag;
1092: end if;
1086: if ((PSB_WS_POS1.g_global_worksheet_id is not null)
1087: and
1088: (PSB_WS_POS1.g_local_copy_flag is not null))
1089: then
1090: l_global_worksheet_id := PSB_WS_POS1.g_global_worksheet_id;
1091: l_local_copy_flag := PSB_WS_POS1.g_local_copy_flag;
1092: end if;
1093:
1094: if p_service_package_id = FND_API.G_MISS_NUM then
1087: and
1088: (PSB_WS_POS1.g_local_copy_flag is not null))
1089: then
1090: l_global_worksheet_id := PSB_WS_POS1.g_global_worksheet_id;
1091: l_local_copy_flag := PSB_WS_POS1.g_local_copy_flag;
1092: end if;
1093:
1094: if p_service_package_id = FND_API.G_MISS_NUM then
1095: begin