DBA Data[Home] [Help]

APPS.PSB_WS_ACCT1 dependencies on PSB_WS_POS1

Line 1072: if ((PSB_WS_POS1.g_global_worksheet_id is null) or

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

Line 1073: (PSB_WS_POS1.g_local_copy_flag is null)) then

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;

Line 1086: if ((PSB_WS_POS1.g_global_worksheet_id is not null)

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;

Line 1088: (PSB_WS_POS1.g_local_copy_flag is not null))

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;

Line 1090: l_global_worksheet_id := PSB_WS_POS1.g_global_worksheet_id;

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

Line 1091: l_local_copy_flag := PSB_WS_POS1.g_local_copy_flag;

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