APPS.IBC_UTILITIES_PVT dependencies on DUAL

Line 944: dual;

940: fnd_lobs_s.NEXTVAL
941: INTO
942: x_file_id
943: FROM
944: dual;
945:
946: INSERT INTO fnd_lobs(
947: file_id
948: ,file_name

Line 1042: FROM dual;

1038:
1039: -- Getting next fnd_lobs sequence number
1040: SELECT ibc_attribute_bundles_s1.NEXTVAL
1041: INTO x_lob_file_id
1042: FROM dual;
1043:
1044: INSERT INTO IBC_ATTRIBUTE_BUNDLES(
1045: attribute_bundle_id
1046: ,attribute_bundle_data

Line 1105: dual;

1101: fnd_lobs_s.NEXTVAL
1102: INTO
1103: x_lob_file_id
1104: FROM
1105: dual;
1106:
1107: -- Reserving empty blob with meta-data
1108: INSERT INTO fnd_lobs(
1109: file_id,

Line 1168: CURSOR Check_Individual(p_user_id IN NUMBER, p_resource_id IN NUMBER) IS

1164: AND rsmember.delete_flag = 'N'
1165: AND rsextn.resource_id = rsmember.resource_id
1166: AND rsextn.user_id = p_user_id;
1167:
1168: CURSOR Check_Individual(p_user_id IN NUMBER, p_resource_id IN NUMBER) IS
1169: SELECT 'X'
1170: FROM jtf_rs_resource_extns
1171: WHERE resource_id = p_resource_id
1172: AND user_id = p_user_id;

Line 1209: OPEN Check_Individual(l_current_user_id, p_resource_id);

1205: END IF;
1206: CLOSE Check_Responsibility;
1207: END IF;
1208: ELSE
1209: OPEN Check_Individual(l_current_user_id, p_resource_id);
1210: FETCH Check_Individual INTO l_dummy;
1211: IF Check_Individual%FOUND THEN
1212: l_result := 'TRUE';
1213: END IF;

Line 1210: FETCH Check_Individual INTO l_dummy;

1206: CLOSE Check_Responsibility;
1207: END IF;
1208: ELSE
1209: OPEN Check_Individual(l_current_user_id, p_resource_id);
1210: FETCH Check_Individual INTO l_dummy;
1211: IF Check_Individual%FOUND THEN
1212: l_result := 'TRUE';
1213: END IF;
1214: CLOSE Check_Individual;

Line 1211: IF Check_Individual%FOUND THEN

1207: END IF;
1208: ELSE
1209: OPEN Check_Individual(l_current_user_id, p_resource_id);
1210: FETCH Check_Individual INTO l_dummy;
1211: IF Check_Individual%FOUND THEN
1212: l_result := 'TRUE';
1213: END IF;
1214: CLOSE Check_Individual;
1215: END IF;

Line 1214: CLOSE Check_Individual;

1210: FETCH Check_Individual INTO l_dummy;
1211: IF Check_Individual%FOUND THEN
1212: l_result := 'TRUE';
1213: END IF;
1214: CLOSE Check_Individual;
1215: END IF;
1216: END IF;
1217: RETURN l_result;
1218: END Check_Current_User;

Line 1531: dual;

1527: -- Getting next fnd_lobs sequence number
1528: SELECT
1529: fnd_lobs_s.NEXTVAL INTO x_file_id
1530: FROM
1531: dual;
1532:
1533: INSERT INTO fnd_lobs(
1534: file_id
1535: ,file_name